This Excel-based project evaluates the effectiveness of different marketing campaigns using key performance metrics and visual dashboards.
📊 Key Metrics Analyzed
- ROI by Campaign and Channel
- Conversion Rates
- Click-Through Rates (CTR)
- Revenue vs Budget Analysis
- Budget Allocation Distribution
📈 Visualizations
-
Bar Chart: ROI by Campaign
-
Bar Chart: ROI by Channel
-
Bar Chart: CTR by Channel
-
Bar Chart: Conversion Rate by Campaign
-
Pie Chart: Budget Distribution by Campaign
-
Line Chart: Revenue vs. Budget by Campaign
Screenshot
🧩 Tools & Techniques
- Microsoft Excel
- Pivot Tables
- Data Cleaning
- ROI and Performance Metrics Calculation
- Data Visualization
✅ Key Insights
- The Holiday Promo campaign had the highest revenue and conversions.
- Email consistently outperformed in ROI across campaigns.
- Back to School campaign had efficient spending with good CTR and ROI.
📁 Files Included
- marketing-campaign-analysis.xlsx (Excel workbook with all pivot tables and charts)
- Dashboard-marketing-campaign.png
- README.md
📌 About This Project
This is part of my Data Analytics Portfolio and demonstrates my ability to:
- Analyze marketing effectiveness
- Build actionable KPIs
- Create compelling dashboards to guide decision-making