Marketing campaign analysis using Excel, SQL logic, and Tableau
#Overview Analyzed multi-channel marketing campaign data to evaluate performance and optimize marketing spend.
#Tools
- Excel (data cleaning, KPI engineering, pivot analysis)
- SQL (aggregation and analysis logic)
- Tableau (dashboard visualization)
#KPIs
- CTR = Clicks / Impressions
- CPC = Cost / Clicks
- CPM = Cost × 1000 / Impressions
- ROI = Provided in dataset
#Analysis
- Channel-wise performance comparison
- ROI analysis by channel
- Cost efficiency analysis (CPC, CPM)
- Dashboard-based insights
#Files
- Excel file: cleaned dataset with KPIs
- SQL file: analytical queries used for aggregation
- Dashboard: Tableau visualization (screenshot / workbook)