To create a media plan, you set one clear objective, define who you need to reach, fix a budget, pick the channels that do each job, schedule when ads run, and give every line a KPI with a number attached. Then you decide how you will measure results before a single dollar is spent.
This guide walks through each step with the maths that links them, a worked $24,000 launch example (the same maths works in any currency) and a media plan template you can copy into Google Sheets or Excel. New to the field? Start with our Media Planning Playbook for beginners and keep the digital media planning glossary open.
Key takeaways
- Work in this order: objective, audience, budget, channel mix, flighting, KPIs and targets, measurement.
- Check every budget with: budget = (reach × frequency ÷ 1,000) × CPM.
- Give every channel one job and one primary KPI. A line with three KPIs has none.
- Hold back 5 to 10% of budget as a test reserve and move money weekly by agreed rules.
What is a digital media plan?
A digital media plan is a document that sets out which audiences you will reach, on which digital channels, with which ad formats, on which dates, with how much budget, and against which KPI targets. It turns a marketing objective into a spend schedule that a team can buy, track and optimise line by line.
What are the steps to create a media plan?
The steps are: 1) set the business and media objective, 2) define and size the target audience, 3) set the budget and check it against reach goals, 4) choose the channel mix, 5) schedule the flights, 6) assign a KPI and target to each line, 7) set up measurement, 8) agree optimisation rules before launch.
Step 1: How do you set the objective of a media plan?
Start from the business goal, convert it into a marketing goal, then into a media objective you can measure. For example: grow sunscreen revenue 20% (business), win 15,000 new customers (marketing), reach 25% of urban women aged 22 to 40 at least three times and drive 1,700 online purchases (media).
- Awareness: measured by reach, frequency, CPM and brand lift.
- Consideration: measured by views, cost per view and engaged visits.
- Conversion: measured by CPA, CPL, ROAS and conversion rate.
A launch plan usually has all three in different proportions. Write the primary objective as one sentence at the top of the plan. If a line does not serve that sentence, cut it.
Step 2: How do you define the target audience?
Define a primary audience by who buys, not who you wish would buy: age, gender, location, life stage and a behaviour or intent signal. Then size it, because audience size decides how much reach is realistic. Add a secondary audience only if budget remains after covering the primary one properly.
Use three layers: a core audience (example: women aged 22 to 40 in the top eight Indian metros), a signal layer (interests, in-market segments, search intent, customer lists) and a retargeting pool (site visitors and video viewers from the last 30 to 90 days).
Get the audience size from platform tools. Google’s Reach Planner forecasts reach, frequency and CPM for YouTube plans of up to 92 days, and Meta Ads Manager shows an estimated audience size as you build targeting. That number becomes the denominator for your reach percentage.
Step 3: How do you set the budget for a media plan?
Set a top-down number from what the business can afford, then check it bottom-up against the reach, frequency and conversions you need. Formula: budget = (target reach × average frequency ÷ 1,000) × CPM. If the two numbers disagree, change the reach goal, the frequency, the audience or the budget until they match.
Formula: Budget = (Target reach × Average frequency ÷ 1,000) × CPM
Example: your audience is 12 million people. You want to reach 25% of them (3 million) an average of 3 times on video at an expected CPM of $1.20. Impressions needed = 3,000,000 × 3 = 9,000,000. Budget = (9,000,000 ÷ 1,000) × $1.20 = $10,800.
If finance approves only $7,200 for video, you can reach fewer people (2 million at frequency 3), accept frequency 2, or find a cheaper format. Run these scenarios in seconds with our free reach and frequency calculator. For performance lines, work backwards from CPA: 1,000 purchases at a $4.80 target CPA needs $4,800.
For context, Gartner’s 2025 CMO Spend Survey put marketing budgets at 7.7% of company revenue, with paid media taking 30.6% of that. Its sample was mostly large Western companies, so treat it as a reference point, not a rule.
Step 4: How do you choose the right channel mix?
Give each channel one job based on what it does best and where your audience spends time. Video and social reach new people cheaply, search and retargeting capture people already looking, and creators add trust. Put 50 to 70% of budget behind your primary objective and split the rest across supporting roles and a small test reserve.
| Channel | Best job in the plan | Primary KPI |
|---|---|---|
| YouTube video reach formats | Awareness at scale | Unique reach, frequency, CPM |
| Meta Reels, Stories, Feed | Awareness to conversion | CPM, cost per ThruPlay, CPA |
| Google Search | Capture existing demand | CPC, conversion rate, CPA |
| Programmatic display and CTV | Extra reach across sites and apps | Viewable reach, CPM |
| Creator partnerships | Trust and reusable content | Engagement rate |
| Retargeting | Close the sale | CPA, ROAS |
Each channel needs enough budget to matter. $24,000 spread across nine platforms gives none of them enough data to optimise.
Step 5: How do you schedule a media plan (flighting)?
Choose one of three patterns. Continuous runs at a steady weight for products bought all year. Flighting runs in bursts with gaps, which suits launches and seasonal peaks. Pulsing keeps a low always-on base with bursts on top. Put the heaviest weight just before and during the period when people actually buy.
For a launch, a proven shape is: reach-building video in weeks 1 to 4, conversion lines from week 3 (once there is a pool of viewers and site visitors to retarget), and search on throughout, because demand shows up whenever it shows up. The template below follows this shape.
Step 6: Which KPIs and targets should each line have?
Give each line one primary KPI that matches its job, then set a numeric target by dividing the line budget by an expected unit cost. Awareness lines get reach, frequency and CPM targets. Consideration lines get cost per view or engaged visit. Conversion lines get CPA or ROAS. Use your own past results first, platform forecasts second.
Formula: Target volume = Line budget ÷ Expected unit cost
Example: the Google Search line has $3,000. Past campaigns show a CPC around $0.14 and a 3.5% conversion rate. Clicks = $3,000 ÷ $0.14 = 21,429. Purchases = 21,429 × 3.5% = 750. Implied CPA = $4.00, so a target of $4.20 is realistic.
Keep KPI and target in separate columns: “CPA” is the KPI, “$4.20 or lower” is the target. Google’s reach and frequency reporting shows unique users and average frequency over 7 and 30 days, so you can track awareness targets while live.
Step 7: How will you measure the media plan?
Decide measurement before launch. Tag every link with consistent UTM parameters, confirm conversion tracking fires on each platform, set a reporting cadence, and choose one source of truth for sales. For awareness spend, plan a brand lift study or a geo holdout, because clicks will never show the full value of video.
- Build every URL with the same naming rules using our free UTM campaign builder, for example utm_campaign=sunscreen_launch_oct26.
- Test pixels, tags and server-side events before launch, not after week one.
- Platforms each claim credit for the same sale, so pick your analytics tool or order database as the referee.
- Check pacing daily, optimise weekly, and hold a mid-flight review.
Step 8: How do you optimise a media plan once it is live?
Agree the rules before launch so decisions are not made on gut feel. A simple rule set: check pacing daily, judge lines weekly only after they have enough data, move 10 to 20% of budget from the weakest to the strongest line, and release the test reserve in week 3 to whatever is beating target.
- Do not judge a conversion line before 30 to 50 conversions, or spend of two to three times its target CPA.
- If weekly frequency passes 5 while reach has stalled, widen the audience or rotate creative.
- Refresh creative when click-through rate falls by a third from its first-week level.
Media plan template: what should the table look like?
A usable media plan template has one row per line item and eight columns: channel, objective, format, targeting, budget, flight dates, KPI and target. Add a total row that matches the approved budget exactly. Below is a filled example for a $24,000 eight-week sunscreen launch that you can copy into a spreadsheet.
| Channel | Objective | Format | Targeting | Budget | Flight dates | KPI | Target |
|---|---|---|---|---|---|---|---|
| YouTube | Awareness | Bumper + skippable in-stream | Women 22 to 40, top 8 metros | $7,200 | 5 Oct to 1 Nov 2026 | Reach, frequency | 2 million at 3, CPM $1.20 |
| Meta | Consideration | 9:16 Reels, Stories | Women 22 to 40, skincare interests | $6,000 | 5 Oct to 29 Nov 2026 | Cost per ThruPlay | $0.01 or lower |
| Meta | Conversion | Carousel, Reels | Broad plus 30-day visitors | $4,800 | 19 Oct to 29 Nov 2026 | CPA | $4.80 (1,000 sales) |
| Google Search | Conversion | Responsive search ads | Brand and category keywords | $3,000 | 5 Oct to 29 Nov 2026 | CPA | $4.20 (714 sales) |
| Creators | Consideration | 6 Reels + partnership ads | Skincare creators, 50k to 300k followers | $1,800 | 12 Oct to 15 Nov 2026 | Engagement rate | 4% or higher |
| Test reserve | Best performer | TBD | TBD | $1,200 | From 19 Oct 2026 | Line KPI | Beat target by 10% |
| Total | $24,000 | 5 Oct to 29 Nov 2026 |
Paste it into a spreadsheet, swap in your own rows, and add columns for actuals and variance once live so the plan doubles as your tracker. All numbers are an example, not benchmarks.
Does the example plan actually deliver enough reach?
Check combined reach, not channel reach. When two channels reach an audience independently, combined reach = A + B − (A × B), using percentages. In the example, YouTube reaches 16.7% and Meta 11.1% of 12 million women, so combined reach is about 25.9%, which meets the 25% objective.
Formula: Combined reach % = A + B − (A × B)
- YouTube: $7,200 at $1.20 CPM = 6,000,000 impressions. At frequency 3, that is 2,000,000 people, or 16.7%.
- Meta: $6,000 at $1.80 CPM = 3,333,333 impressions. At frequency 2.5, that is 1,333,333 people, or 11.1%.
- Combined: 16.7% + 11.1% − (16.7% × 11.1%) = 25.9%.
The formula assumes random overlap. Heavy social users often see both, so true combined reach is usually a little lower. Also remember that an average frequency of 3 hides people who saw the ad once and people who saw it nine times, which is why planners care about effective frequency.
What are the most common media planning mistakes?
The most common mistakes are setting a budget without checking it against reach or CPA, spreading money across too many channels, giving lines vague KPIs, ignoring overlap between channels, launching without tested tracking, and changing the plan daily on too little data. Each one is fixable with a pre-launch checklist.
| Check before you send the plan | Why it matters |
|---|---|
| Objective is one measurable sentence | Every line can be tested against it |
| Audience sized with a platform estimate | Reach targets need a denominator |
| Budget checked with reach × frequency × CPM | Stops impossible promises |
| One KPI and one numeric target per line | Makes weekly decisions simple |
| UTMs and conversion tags tested | Week one data is usable |
| Total row equals approved budget | Finance signs off faster |
What this means for marketers and creators
For marketers and media planners
- Show the formula checks in the plan. “$10,800 buys 3 million people at frequency 3” wins more trust than a pie chart.
- Start reach lines two to three weeks before conversion lines so retargeting pools exist.
- Report planned, actual and variance every week.
For creators and small teams
- Your plan can be three lines: reach for new viewers, a boost for your best posts, and a conversion line for your product or brand deal link.
- Pitch brands with a mini plan showing reach, frequency and cost per result.
- Tag every bio and story link with UTMs so you can prove what drove clicks.
Frequently asked questions
What should a media plan include?
A media plan should include the campaign objective, the target audience and its size, total budget, channel mix, ad formats, targeting per line, flight dates, a KPI and numeric target per line, and the measurement plan. A total row matching the approved budget makes approval faster.
What is the difference between a media plan and a media strategy?
A media strategy explains the thinking: who you need to reach, what role paid media plays and why certain channels make sense. A media plan is the output: a table of line items with channels, formats, dates, budgets, KPIs and targets that a team can execute and check.
How do you make a media plan in Excel or Google Sheets?
Create one row per line item with eight columns: channel, objective, format, targeting, budget, flight dates, KPI and target. Add formula columns for impressions (budget divided by CPM, times 1,000) and expected results (budget divided by unit cost), then a total row and, once live, actuals.
How far in advance should you create a media plan?
For a campaign with a fixed launch date, start six to eight weeks ahead. That leaves time for audience sizing, budget approval, creative in the right formats and tracking tests. Reservation buys and large creator partnerships often need longer lead times, so plan those lines first.
What is the difference between media planning and media buying?
Media planning decides who to reach, where, when, how often and with how much money. Media buying executes that plan: negotiating rates, setting up campaigns and managing delivery. In small teams one person often does both, but a separate plan lets you judge whether buying delivered.
Next steps
Copy the template, replace the example rows, and test your assumptions in the reach and frequency calculator. For cost per result maths, use the ad budget and CPA calculator on our free social media tools page. For one practical media planning guide a week, join the free TechMachaw newsletter using the signup form on this page.
