Netflix-Marketing-Campaign-Dashboard

### Netflix Marketing Campaign Performance Analysis - EMEA Region (Q2 2024)

**Executive Summary:**
Netflix’s Q2 2024 marketing campaigns in the EMEA region delivered 12.4M new subscriber sign-ups, a 15% YoY increase, but with significant variability across content types and ad platforms. Original content campaigns outperformed licensed content by 22% in ROAS (Return on Ad Spend), while TikTok drove the highest engagement rates (18%) but lowest conversion rates (2.1%). Linear TV campaigns showed the most consistent performance but suffered from high CPAs ($45.20 vs. $28.70 digital average).

**Key Findings by Segment:**
1. **Content Type Performance:**
   - **Originals (Stranger Things, The Crown):** ROAS of $3.20, CPA of $22.10, 14% engagement rate. Top-performing campaign: "Stranger Things S5" (ROAS: $3.80, 1.2M sign-ups).
   - **Licensed (Friends, The Office):** ROAS of $2.10, CPA of $35.40, 9% engagement rate. Worst-performing: "Friends Reunion" (ROAS: $1.50, CPA: $48.90).
   - **Kids (CoComelon, Bluey):** ROAS of $2.90, CPA of $18.30, 22% engagement rate. Strongest campaign: "Bluey S4" (ROAS: $3.40, 890K sign-ups).

2. **Ad Platform Performance:**
   - **TikTok:** Highest engagement (18%) but lowest conversion (2.1%). Best for brand awareness; poor for direct response.
   - **YouTube:** Balanced performance (ROAS: $2.90, CPA: $25.60, 12% engagement). Top-performing ad: "Netflix x Stranger Things" (1.5M views, 3.2% CTR).
   - **Instagram:** Strong mid-funnel performance (ROAS: $2.70, CPA: $30.10, 15% engagement). Best for influencer collaborations.
   - **Linear TV:** Highest CPA ($45.20) but most consistent (ROAS: $2.40, 11% engagement). Used for broad reach campaigns.

3. **Regional Breakdown:**
   - **Germany:** Highest ROAS ($3.10) due to strong local content (Dark S4) and YouTube dominance.
   - **France:** Lowest ROAS ($2.30) due to TikTok over-reliance and licensed content underperformance.
   - **UK:** Most balanced performance (ROAS: $2.80) with strong Instagram and YouTube campaigns.

**Underperforming Campaigns & Optimization Strategies:**
1. **"Friends Reunion" (Licensed Content):**
   - **Issue:** ROAS of $1.50, CPA of $48.90.
   - **Optimizations:**
     - Shift budget to YouTube Shorts and Instagram Reels for higher engagement.
     - Target younger demographics (18-34) who are less familiar with Friends.
     - Test shorter ad formats (15s vs. 30s) to reduce CPA.

2. **TikTok "Brand Awareness" Campaign:**
   - **Issue:** High engagement (18%) but low conversion (2.1%).
   - **Optimizations:**
     - Add strong CTAs (e.g., "Sign up now for 30 days free") and trackable links.
     - Retarget high-engagement users with conversion-focused ads on Instagram.
     - Limit spend to 20% of TikTok budget and reallocate to YouTube/Instagram.

3. **Linear TV "Netflix Originals" Campaign:**
   - **Issue:** High CPA ($45.20) despite consistent ROAS ($2.40).
   - **Optimizations:**
     - Reduce linear TV spend by 30% and increase digital spend by 20%.
     - Use linear TV for brand awareness and retarget viewers with digital ads.
     - Test programmatic TV buys for better targeting and lower CPAs.

**Q3 2024 Forecast:**
Based on Q2 trends, we project:
- **Total sign-ups:** 14.1M (14% YoY growth).
- **ROAS improvement:** 8% increase in digital campaigns, 5% in linear TV.
- **CPA reduction:** 12% decrease in digital, 8% in linear TV.
- **Key drivers:** Stronger focus on Originals, shift from TikTok to YouTube/Instagram, and programmatic TV testing.

**Recommendations:**
- Allocate 60% of budget to Originals content, 25% to Kids, and 15% to Licensed.
- Increase YouTube and Instagram spend to 40% of digital budget (up from 30%).
- Pilot programmatic TV in Germany and UK for Q3 testing.