Data from Google Ads and Meta Ads was seamlessly integrated into Google Sheets, with Google Scripts and App Scripts automating data collection, processing, and updating. This automated workflow ensures real-time data accuracy and efficiency. The data was then aggregated and visualized in Looker Studio, where an interactive dashboard was built to provide comprehensive insights into campaign performance. The dashboard consolidates key metrics from both platforms, enabling easy comparison and analysis across different campaigns, ad sets, and audience segments, empowering marketers to make informed, data-driven optimizations.

📌 Google Ads Metrics: Tracks impressions, clicks, CTR, and engagement by campaign.

📌 Meta Ads Metrics: Monitors reach, impressions, clicks, and CTR by campaign.

📌 Time Analysis: Displays metrics trends over time for both platforms.

📌 Campaign Filter: Allows filtering by marketing campaign name for detailed analysis.

📌 Performance Overview: Provides a summary of performance metrics by campaign group.

📌 Enhanced Campaign Insights: Gain a clear understanding of ad performance across Google and Meta.

📌 Optimized Ad Spend: Identify high-performing campaigns and adjust strategies accordingly.

📌 Detailed Analysis: Track metrics over time to understand trends and campaign effectiveness.

📌 Improved Reporting: Easily compare and analyze performance metrics between platforms.

📌 Informed Decision-Making: Make data-driven decisions to enhance marketing strategies.

📌 Looker Studio

📌 Google Scripts

📌 Google Sheets

📌 PowerMyAnalytics

📌 App Scripts

📌 Digital Marketing Managers: They can use the dashboard to oversee the performance of ad campaigns across multiple platforms. It provides them with critical insights into KPIs like impressions, clicks, CTR, and conversions, helping them optimize budgets, refine targeting strategies, and drive better overall campaign performance for university outreach.

📌 Advertising Analysts: With access to detailed metrics and visualizations, analysts can dive deep into campaign data to identify trends, assess audience engagement, and evaluate the effectiveness of different ad creatives. The dashboard helps them uncover opportunities for optimization and present actionable insights to stakeholders.

📌 University Marketing Teams: These teams benefit from understanding how their digital ads are resonating with prospective students. The dashboard provides clear metrics on reach, engagement, and conversions, allowing them to fine-tune their messaging and strategies for student recruitment campaigns.

📌 Campaign Strategists: Strategists can leverage the dashboard to monitor campaign performance in real-time, ensuring that the campaign objectives—such as increasing student inquiries or boosting enrollment—are being met. It helps them align marketing efforts with the university’s goals, making data-driven adjustments to enhance the effectiveness of future campaigns.

📌 Campaign Performance Tracking: Monitor and compare ad performance across Meta and Google Ads.

📌 Optimization: Adjust marketing strategies based on detailed metrics and trends.

📌 Reporting: Generate comprehensive reports on ad performance for stakeholders.

📌 Trend Analysis: Analyze metrics over time to identify successful campaigns and areas for improvement.