This project analyzes digital marketing campaigns to optimize ROI and overall performance by examining key metrics such as:
- Conversion Rates
- Acquisition Costs
- Return on Investment (ROI)
The analysis covers various channels, campaign types, and audience segments to explore:
- Temporal Trends
- Geographical Influences
- Audience Behavior
The goal is to identify success factors that can be leveraged to enhance future marketing strategies.
- Python (Pandas, NumPy, Matplotlib, Seaborn)
The analysis includes an Exploratory Data Analysis (EDA) process done with Pandas, Matplotlib, and Seaborn to derive meaningful insights from the marketing campaign data. Key EDA steps included:
- Pandas: Data cleaning, transformation, and aggregation of key metrics like conversion rates, acquisition costs, and ROI.
- Matplotlib & Seaborn: Data visualization to highlight trends, correlations, and geographical performance, including time-series graphs, heatmaps, and distribution plots.
- While campaigns generally performed well, improvements are needed in acquisition cost management.
- Content should engage users and encourage conversions through stronger Calls to Action (CTA).
- Reevaluate targeting efforts to ensure the audience is likely to convert.
- The target audience skews toward women aged 25-34, highlighting the demographic's strong engagement.
- Non-English-speaking segments show high conversion rates, reflecting successful localization strategies.
- While English has the highest average conversion rate, performance is consistent across all languages, with variable acquisition costs.
- Social Media ranks highest in engagement, followed by Influencer ≈ Email > Display ≈ Search.
- Social media generates nearly 50% of total ROI, though email campaigns offer strong competition at lower acquisition costs.
- There's a positive correlation between clicks and impressions across channels, but impressions cap at ~100,000 without one channel significantly outperforming others.
- 30-day campaigns are the most preferred, while 60-day campaigns show potential but require better marketing efforts.
- Conversion rates dip in February and November, despite higher engagement, highlighting the need for better CTAs during these periods.
- Seasonal engagement peaks in May-June and October-November present opportunities for high-impact campaigns.
- Cities like Houston (highest acquisition costs) and New York (highest average acquisition cost) may provide growth opportunities but require careful ROI assessment.
- Dallas and Chicago demonstrate lower acquisition costs and higher ROI, indicating good campaign performance.
- San Francisco and New York, despite being significant markets, show lower returns. Reevaluate strategies in these regions.
-
Refine Targeting: Focus on improving targeting strategies to reduce acquisition costs, especially for segments with high ROI potential. Extend campaign duration for better lead nurturing, particularly in high engagement months like April and July.
-
Enhance Localization: Continue successful localization for non-English-speaking markets and refine content to improve conversion efficiency across all languages.
-
Focus on High-Impact Channels: Prioritize Social Media and Influencer Marketing due to high engagement and ROI. Don't neglect Email, which consistently provides good returns at lower costs.
-
Optimize Seasonal Campaigns: Strengthen CTAs and content during underperforming months like February and November to increase conversions.
This analysis offers valuable insights into optimizing marketing efforts across channels, audiences, and geographies, leading to better performance and sustained growth. The actionable recommendations provide a clear pathway to improving campaign success and ROI.