Marketing campaign analysis and dashboard
Budget: $30 – $250 USD
Price: $50
Time estimate: 1 - 2 hours
We are a digital marketing agency seeking a data analyst to create a Power BI dashboard to track the performance of our email and social media campaigns over the past six months. Our goal is to evaluate which campaigns drive the most customer purchases and analyze channel performance over time to fine tune our strategy for the second half of the year.
We want visuals focusing on four key areas: Return on Investment (ROI), Conversion Rates, Audience Engagement, and Channel Performance.
We need someone skilled in structuring data, creating dynamic and insightful Power BI dashboards, and providing clear documentation.
Deliverables:
1- A PowerBI desktop file (.pbix) with a professional looking dashboard (ideally 1 page) with:
- ROI by campaign
- Conversion rates by channel
- Audience engagement metrics by campaign
- Channel performance comparison
2- A dashboard creation guide (PDF) with explanations on how the dashboard was created in case we want to replicate something similar in the future.
Ideal Skills:
- Proficiency in Power BI
- Experience with marketing or campaign data analysis
- Strong DAX knowledge for KPIs and calculations
- Ability to create clear, engaging, and actionable visuals
Skills Required
Data Visualization | Excel | Power BI | Marketing Analytics | DAX | Data Cleaning | Campaign Performance Analysis | Reporting
Downloadable dataset:
https://github.com/taloc/marketing_campaign_2025/blob/main/marketing_campaign_dataset.csv
To download the file from GitHub:
- You may see: “Sorry about that, but we can’t show files that are this big right now.” but don’t worry the data is there.
- Click the download raw file button in the upper-right corner of the file preview.
- Choose a save location on your device and click "Save."
Time estimate: 1 - 2 hours
We are a digital marketing agency seeking a data analyst to create a Power BI dashboard to track the performance of our email and social media campaigns over the past six months. Our goal is to evaluate which campaigns drive the most customer purchases and analyze channel performance over time to fine tune our strategy for the second half of the year.
We want visuals focusing on four key areas: Return on Investment (ROI), Conversion Rates, Audience Engagement, and Channel Performance.
We need someone skilled in structuring data, creating dynamic and insightful Power BI dashboards, and providing clear documentation.
Deliverables:
1- A PowerBI desktop file (.pbix) with a professional looking dashboard (ideally 1 page) with:
- ROI by campaign
- Conversion rates by channel
- Audience engagement metrics by campaign
- Channel performance comparison
2- A dashboard creation guide (PDF) with explanations on how the dashboard was created in case we want to replicate something similar in the future.
Ideal Skills:
- Proficiency in Power BI
- Experience with marketing or campaign data analysis
- Strong DAX knowledge for KPIs and calculations
- Ability to create clear, engaging, and actionable visuals
Skills Required
Data Visualization | Excel | Power BI | Marketing Analytics | DAX | Data Cleaning | Campaign Performance Analysis | Reporting
Downloadable dataset:
https://github.com/taloc/marketing_campaign_2025/blob/main/marketing_campaign_dataset.csv
To download the file from GitHub:
- You may see: “Sorry about that, but we can’t show files that are this big right now.” but don’t worry the data is there.
- Click the download raw file button in the upper-right corner of the file preview.
- Choose a save location on your device and click "Save."