Media Plan Builder

BUSINESS INPUTS:
  - Total budget: $[amount] per [month/quarter/year]
  - Objective: [Awareness / Lead Gen / Sales / App Install]
  - KPI targets: [Target CPA / ROAS / CPL]
  - Timeline: [Start date - End date]
  - Geo targets: [Countries / regions / cities]
  - Previous performance data: [Yes/No — provide if available]

AUDIENCE INPUTS:
  - B2B or B2C
  - Target demographics: [Age, gender, income, education]
  - Target firmographics (B2B): [Industry, company size, job title]
  - Interests / behaviors: [Key interests]
  - Current customer profile: [Describe best customers]

COMPETITIVE INPUTS:
  - Main competitors: [List 3-5]
  - Competitive positioning: [Premium / Value / Disruptor]
  - Category maturity: [Emerging / Growing / Mature / Declining]

Search (Google + Microsoft): 35%
LinkedIn: 25%
Retargeting (Meta + Display): 15%
YouTube: 10%
Content Syndication: 10%
Reddit: 5%

Meta (Advantage+ Shopping): 35%
Google (PMax + Search): 30%
TikTok: 15%
Retargeting (Email/SMS): 10%
YouTube: 5%
Pinterest: 5%

Google Search (Local + GMB): 40%
Meta (Local Awareness + Leads): 30%
Google Display (Local): 15%
Yelp / Nextdoor: 10%
Waze Ads: 5%

Phase 1: LEARNING (Weeks 1-2) — 20% of budget
  Objective: Establish baselines, test creative, build pixel data
  Approach: Broader targeting, multiple ad variants, CBO (Campaign Budget Optimization)
  Success metric: Cost per result within 2x of target

Phase 2: OPTIMIZATION (Weeks 3-6) — 50% of budget
  Objective: Scale winners, kill losers, refine audiences
  Approach: Shift budget to top performers, narrow targeting, A/B test
  Success metric: Cost per result within 1.2x of target

Phase 3: SCALE (Weeks 7+) — 30% of budget
  Objective: Maximize volume at target efficiency
  Approach: Increase budgets 20% per week on winners, expand geo/audience
  Success metric: Maintain CPA while increasing volume 2-3x

Estimated Reach = (Budget × 1,000) / CPM / Frequency

Example:
  Budget: $10,000
  CPM: $8.00
  Target Frequency: 3x
  Reach = ($10,000 × 1,000) / $8.00 / 3 = 416,667 unique users

┌─────────────────────────────────────────────────────────────┐
│ AWARENESS (Top of Funnel)                                    │
│ Goal: Introduce brand to new audiences                       │
│ Channels: YouTube, Meta Reels, TikTok, Display, CTV         │
│ KPIs: Reach, Impressions, Video Views, Brand Lift            │
│ Budget: 20-30% of total                                      │
│ Creative: Brand story, problem awareness, social proof       │
├─────────────────────────────────────────────────────────────┤
│ CONSIDERATION (Mid-Funnel)                                   │
│ Goal: Educate and build preference                           │
│ Channels: Search, YouTube, LinkedIn, Content, Reddit         │
│ KPIs: CTR, Engagement, Content Downloads, Site Visits        │
│ Budget: 30-40% of total                                      │
│ Creative: Product demos, comparisons, testimonials, case     │
│          studies, whitepapers                                 │
├─────────────────────────────────────────────────────────────┤
│ CONVERSION (Bottom of Funnel)                                │
│ Goal: Drive purchases, signups, or leads                     │
│ Channels: Search (Brand), PMax, Meta A+SC, Retargeting       │
│ KPIs: CPA, ROAS, Conversion Rate, Revenue                   │
│ Budget: 30-40% of total                                      │
│ Creative: Offers, urgency, social proof, risk reversal       │
├─────────────────────────────────────────────────────────────┤
│ RETENTION (Post-Purchase)                                    │
│ Goal: Upsell, cross-sell, reduce churn                       │
│ Channels: Email, SMS, Display (CRM audiences)                │
│ KPIs: LTV, Repeat Purchase Rate, NPS                        │
│ Budget: 5-10% of total                                       │
│ Creative: Loyalty offers, new features, referral programs    │
└─────────────────────────────────────────────────────────────┘

# Media Plan: [Client Name]
**Prepared by:** [Name] | **Date:** [Date]
**Period:** [Start] - [End] | **Total Budget:** $[Amount]

## Executive Summary
[2-3 sentence overview of strategy and expected outcomes]

## Budget Allocation

| Channel | Monthly Budget | % of Total | Objective | Primary KPI | Target |
|---------|---------------|------------|-----------|-------------|--------|
| Google Search | $X,XXX | XX% | Conversion | CPA | $XX |
| Meta | $X,XXX | XX% | Consideration | CPC | $X.XX |
| LinkedIn | $X,XXX | XX% | Lead Gen | CPL | $XXX |
| YouTube | $X,XXX | XX% | Awareness | CPV | $0.XX |
| TikTok | $X,XXX | XX% | Awareness | CPM | $X.XX |
| **Total** | **$XX,XXX** | **100%** | | | |

## Flight Schedule

| Phase | Dates | Budget | Focus | Success Criteria |
|-------|-------|--------|-------|------------------|
| Learning | Week 1-2 | $X,XXX | Test creative, establish baselines | CPA < 2x target |
| Optimization | Week 3-6 | $X,XXX | Scale winners, refine audiences | CPA < 1.2x target |
| Scale | Week 7-12 | $X,XXX | Max volume at target efficiency | CPA at target, 3x volume |

## Projected Performance

| Metric | Monthly Projection | Quarterly Projection |
|--------|-------------------|----------------------|
| Impressions | X,XXX,XXX | XX,XXX,XXX |
| Clicks | XX,XXX | XXX,XXX |
| Conversions | XXX | X,XXX |
| Revenue | $XX,XXX | $XXX,XXX |
| ROAS | X.Xx | X.Xx |
| Blended CPA | $XX.XX | $XX.XX |

## Audience Strategy
[Describe primary, secondary, and retargeting audiences]

## Creative Strategy
[Describe creative themes, formats, and testing approach]

## Measurement & Reporting
- Weekly: [Automated dashboard + written summary]
- Monthly: [Performance review + optimization plan]
- Quarterly: [Strategic review + next quarter planning]

Channel Allocation:
  Google Search: $8,750 (35%) — Brand + non-brand, Target CPA $85
  LinkedIn: $6,250 (25%) — Sponsored Content + Lead Gen Forms, CPL $120
  Meta Retargeting: $3,750 (15%) — Website visitors + Lookalikes
  YouTube: $2,500 (10%) — 30s TrueView for product awareness
  Content/Reddit: $2,500 (10%) — Thought leadership distribution
  Microsoft Ads: $1,250 (5%) — Mirror top Google campaigns at lower CPC

Projected quarterly results:
  Impressions: 4.5M
  Clicks: 45,000
  Leads (MQLs): 280
  SQLs: 56 (20% MQL→SQL rate)
  Closed deals: 8 (15% SQL→Close rate)
  Revenue: $320,000 (avg deal $40K)
  ROAS: 4.3x