In today’s digital marketing ecosystem, data-driven decision making plays a crucial role in improving campaign performance, user engagement, and conversions. This project performs an end-to-end analysis of 400,000+ social media ad interaction events across 50 campaigns, 200 ads, and 10,000 users to uncover the key drivers of marketing success.
The primary goal of this project is to evaluate campaign efficiency, understand customer behavior, and generate actionable insights that help marketers optimize targeting, improve conversion rates, and maximize return on investment (ROI).
Marketing teams often face challenges such as:
- Poor conversion despite high impressions
- Budget wasted on low-performing campaigns
- Weak audience targeting
- Unclear ROI measurement
- No data-backed campaign optimization
This project solves these problems using marketing analytics, funnel analysis, and ROI-driven insights.
- Analyze marketing funnel performance (Impression → Click → Purchase)
- Evaluate campaign effectiveness using CTR, Conversion Rate, and ROI
- Identify high-performing campaigns and budget efficiency
- Compare platform performance (Facebook vs Instagram)
- Discover top-performing audience segments
- Analyze ad creative effectiveness (Stories, Video, Image, Carousel)
- Identify optimal campaign timing (Best Day & Time)
- Generate business recommendations for marketing optimization
The dataset simulates real-world social media marketing performance and consists of four key entities:
| Entity | Description |
|---|---|
| 👤 Users | Demographics including age, gender, country, and interests |
| 📢 Campaigns | Campaign strategy, duration, and total budget |
| 🎯 Ads | Ad creatives, platform, and targeting parameters |
| 📊 Ad Events | User interactions such as impressions, clicks, and purchases |
- 400,000+ Ad Events
- 50 Campaigns
- 200 Ads
- 10,000 Users
- Python 🐍
- Pandas
- NumPy
- Matplotlib
- Seaborn
- Exploratory Data Analysis (EDA)
- Marketing Analytics
- Impression → Click → Purchase flow
- Funnel drop and conversion efficiency
- CTR, Conversion Rate, Overall Conversion
- Best & Worst Performing Campaigns
- Purchases per dollar spent
- Budget vs ROI relationship
- Facebook vs Instagram performance
- Engagement and conversion comparison
- Age Group Analysis
- Gender Analysis
- Country Performance
- Interest Targeting
- Stories vs Image vs Video vs Carousel
- Best Day for Conversions
- Best Time for Engagement
- Daily Performance Trends
- 📌 CTR: ~11.8%
- 📌 Conversion Rate: ~5.06%
- 📌 Largest Funnel Drop: Impression → Click (~88%)
- 🏆 Best Campaign: Campaign_38_Q3
- 💰 Best ROI Campaign: Campaign_42_Summer
- 📱 Top Platform: Facebook
- 👥 Top Audience: Age 25–34, Female
- 🎨 Best Ad Format: Stories
- ⏰ Best Conversion Time: Thursday Morning
- 🌍 Top Country: United States
This analysis reveals that marketing success depends more on targeting precision, creative optimization, and timing strategy rather than simply increasing budget.
By optimizing the conversion funnel and reallocating budget toward high-performing campaigns and audience segments, businesses can significantly improve CTR, conversion rate, and overall ROI.
- Allocate more budget to high ROI campaigns
- Focus targeting on Age 25–34 and Female segment
- Increase investment in Stories ad format
- Schedule campaigns during Thursday Morning peak conversion window
- Improve ad relevance to reduce funnel drop-off
- Reallocate budget from low-performing campaigns to high-performing ones
- Continuously monitor CTR, Conversion Rate, and ROI trends
- Perform A/B testing for creatives and targeting strategies
Implementing these recommendations can potentially improve:
- 📊 CTR by 15–25%
- 📊 Conversion Rate by 10–20%
- 📊 ROI by 20–30%
- 📊 Overall Campaign Efficiency
This project demonstrates how data-driven analysis can be used to uncover key marketing insights, improve campaign efficiency, optimize targeting, and maximize ROI through actionable business recommendations.
Pratham Soni Data Analyst • Python • Marketing Analytics • Data-Driven Decision Making