Multi-Channel Advertising Data Analytics
Budget: ₹600 – ₹1,500 INR
Marketing Analytics Project to present to team
Overview
Welcome! This assignment simulates a real-world scenario where you need to unify and analyze multi-channel advertising data.
Your mission: Transform raw advertising data from three major platforms into actionable insights through a unified data model and compelling visualizations.
Data Files
01_facebook_ads.csv - Facebook advertising metrics
02_google_ads.csv - Google Ads campaign data
03_tiktok_ads.csv - TikTok advertising engagement
Requirements
1. Data Setup
Upload all three CSV files to a cloud database of your choice
Create an additional table that unifies data from these 3 tables
2. Dashboard
Create a one-page dashboard visualizing the integrated data. Include key metrics and insights you find relevant for cross-channel performance analysis.
Deliverables
Link to live dashboard (required)
Link to video where you walk throught the dashboard and describe the choice of widgets (required)
Submission
Evaluation
We'll assess compelling visualization, technical execution, data accuracy, visualization quality, and insights generated
Overview
Welcome! This assignment simulates a real-world scenario where you need to unify and analyze multi-channel advertising data.
Your mission: Transform raw advertising data from three major platforms into actionable insights through a unified data model and compelling visualizations.
Data Files
01_facebook_ads.csv - Facebook advertising metrics
02_google_ads.csv - Google Ads campaign data
03_tiktok_ads.csv - TikTok advertising engagement
Requirements
1. Data Setup
Upload all three CSV files to a cloud database of your choice
Create an additional table that unifies data from these 3 tables
2. Dashboard
Create a one-page dashboard visualizing the integrated data. Include key metrics and insights you find relevant for cross-channel performance analysis.
Deliverables
Link to live dashboard (required)
Link to video where you walk throught the dashboard and describe the choice of widgets (required)
Submission
Evaluation
We'll assess compelling visualization, technical execution, data accuracy, visualization quality, and insights generated