Media Plan Template: Fields, Examples and a Build Process

A media plan template is a spreadsheet that lists every paid placement in a campaign on its own row: channel, audience, dates, budget, buying model, KPI and owner. A calendar view shows when each placement runs. The template below gives you those fields, three worked examples and a process for filling it in. You can rebuild it in Excel or Google Sheets in under an hour.

This guide is written for marketing teams and agencies that run several campaigns at once. It treats the media plan as an operating document, not a one-time deliverable. It is approved before launch, it is checked against actual results, and every change to it is recorded.

TL;DR

• A media plan answers five decisions before launch: how much to spend, where to run, when each placement runs, what each line should deliver, and who can move money.
• One row per placement is the structure that holds up. Channel-level summaries hide the detail you need when results move.
• Build in this order: objective, audience, channel mix, budget, flighting, tracking, approval.
• Keep the template to a limited set of KPIs tied to the objective. More metrics make results harder to read, not easier.
• Separate planned figures from actuals in the same workbook, so every review compares the two.

Table of Contents

• 1. What a media plan template is for
• 2. The fields every template needs
• 3. Build a media plan in seven steps
• 4. Media plan examples by campaign goal
• 5. Calculating delivery from budget
• 6. Adapting the template for multi-channel and multi-brand work
• 7. Where spreadsheets stop working
• 8. Run the plan from one workspace
• 9. Common mistakes to avoid
• FAQ
• Sources

1. What a media plan template is for

A media plan sets out where and when a campaign will run and how much it will cost. According to Ideup’s guide to media plan templates, it is usually a spreadsheet showing which media the campaign uses, when, at what cost and how many people it should reach.

The template has two jobs.

1. Decision record. It captures the choices behind the spend, so a stakeholder can see why 40% of the budget sits on one channel and 10% on another.
2. Execution sheet. A media buyer can launch each line from it, and a finance lead can reconcile spend against it.

A media plan is not a campaign brief. The brief explains the problem, audience and message. The plan translates that brief into placements and money. If your team has no consistent brief yet, start with our guide to writing a marketing campaign brief, because a plan built on a vague brief inherits the vagueness.

2. The fields every template needs

The fields below combine the structure recommended in the Ideup template guide with the operational additions we see teams need once a plan is live.

For online campaigns, Ideup specifically recommends including UTM-tagged links so analytics can attribute orders to the plan row. That one column often decides whether reporting later takes ten minutes or two days.

The workbook structure

A single sheet becomes unwieldy after a dozen lines. A reusable workbook with four sheets scales better:

1. Inputs: total budget, CPM and CPC assumptions, frequency targets, date range.
2. Plan: one row per placement, pulling assumptions from Inputs.
3. Flowchart: a weekly calendar showing when each line runs.
4. Actuals: spend and results by line, entered weekly.

Ideup describes the same four-sheet layout, with formulas that calculate impressions from budget and CPM and people reached from impressions and frequency. Keeping assumptions in one place means a change to the CPM estimate updates every dependent line.

3. Build a media plan in seven steps

The process below runs from objective to execution. Each step produces something you enter in the template.

Step 1: Fix the objective

Write one objective that is specific and measurable, for example: “Generate 150 qualified inquiries for a new listing within four weeks.” The objective determines which channels and KPIs are relevant. If two stakeholders cannot agree on it, stop here. A plan cannot resolve a disagreement about the goal.

Step 2: Define the audience

Segment the audience by what changes your targeting and message: location, intent, life stage, existing customer status. Enter each segment once, then reference it in the plan rows. Three to four segments are usually enough for a single campaign.

Step 3: Select channels by role

Assign each channel a role rather than choosing by habit. Search captures existing demand. Paid social creates demand and reaches defined segments. Video builds familiarity. Retargeting converts people who already visited. A channel with no stated role is a candidate for removal.

Step 4: Allocate the budget

Split the total across channels according to role and expected return, then split each channel across its lines. Reserve a controlled share for testing, and write down in advance what a test must show to earn more money. Our guide to marketing budget tracking covers how to monitor planned against actual spend once the plan is live.

Step 5: Set the flighting

Flighting is the pattern of when ads run. Continuous flighting suits always-on goals such as brand awareness. Pulsed flighting, with bursts and gaps, suits seasonal offers, limited-time launches or tighter budgets. Enter start and end dates by week and let the calendar view show overlaps and gaps.

Step 6: Set up measurement

Choose a small set of KPIs per line and build tracking before launch. The WHO monitoring, evaluation and learning manual is written for public health programs, but its principle applies: KPIs should be derived from SMART objectives, with typically five to seven in total, so that results stay interpretable. For a deeper treatment, see our guide to marketing performance KPIs.

Step 7: Approve and version

Lock a version 1.0 with a named approver before any line goes live. After launch, every change goes in a change log with the date, the reason and the person who approved it. Without this, the plan and the live account drift apart within weeks.

4. Media plan examples by campaign goal

The figures below are hypothetical. They illustrate how the template works and are not benchmarks. Replace the CPM, CPC and share assumptions with your own account data.

Example A: A real estate listing launch (conversion goal)

A brokerage promotes a new listing for four weeks with a $12,000 budget. The goal is booked viewings.

The shares are 40%, 35%, 15% and 10%. Note that retargeting starts in week 2, because it needs an audience built by the first week of traffic.

Example B: An ecommerce seasonal promotion (revenue goal)

An online retailer runs a three-week promotion with a $30,000 budget. The goal is return on ad spend at a target agreed with finance.

Here the pulsed pattern applies: spend rises in the final week before the promotion ends. The plan also holds a testing share within the video line, with a written rule for what result earns more budget.

Example C: An always-on brand awareness plan

A multi-location service business runs a continuous plan, reviewed quarterly, with a monthly budget of $8,000. Lines cover video and display for reach, with reach and frequency as primary KPIs. Because the campaign is continuous, the template’s calendar shows no gaps, and the review cycle matters more than the launch date.

A real-world reference for how formal these plans become is the annual plan published by Simpleview for Visit Napa Valley. It assigns specific KPIs to each paid media component, including spend, CPM, CPV or CPC, impressions, reach and frequency, and separates in-platform from on-site measures.

5. Calculating delivery from budget

The template’s estimated delivery columns rest on simple arithmetic. Using Example A’s social line as an illustration:

• Budget: $4,800
• Assumed CPM: $12
• Impressions: $4,800 ÷ $12 × 1,000 = 400,000
• Target frequency: 3
• People reached: 400,000 ÷ 3 ≈ 133,333

If actual CPM comes in at $15, the same budget delivers 320,000 impressions and about 106,667 people. That gap is visible only if the plan stores the assumption and the Actuals sheet stores the result. Review CPM, CPC and conversion rate weekly in the first month, because early deviation is cheapest to correct.

6. Adapting the template for multi-channel and multi-brand work

A single-campaign template needs three changes once you run several brands or channel groups.

1. Add a brand and campaign column so one workbook, or one workspace, can be filtered by client.
2. Add an integration view that shows paid, owned and earned activity together. Smart Insights’ campaign planning template takes this approach, with a worksheet for reviewing paid, owned and earned channels alongside a campaign activity plan with review and sign-off details.
3. Define decision rights. Write down who may shift budget between channels, by how much and on what evidence. A simple RACI table covering media plan changes and creative sign-off removes most mid-flight delays.

The operational burden grows with the number of accounts. Our guides to multi-channel ad management and centralized campaign management describe how teams keep one source of truth across platforms. Intake discipline helps too: a standard marketing request form means every plan starts with the same information.

7. Where spreadsheets stop working

A spreadsheet handles a plan well. It handles the work around the plan less well: pulling spend from several ad accounts, routing approvals, keeping creative versions straight and reporting to several clients. Teams typically notice the limit when the Actuals sheet is updated by hand from three platforms every Monday.

That is the point at which the plan and the execution should live in one workflow.

Our perspective

A media plan fails less often because of the channel mix than because of what happens after approval. The plan says one thing, the ad accounts say another, and nobody owns the difference.

We built OppRise around that gap. Campaign planning, ad execution, reporting and approvals sit in one workflow, so the plan, the live spend and the results refer to the same campaign. Analytics connections to Google Analytics, Search Console, Meta, Google Ads, TikTok and Shopify mean actuals do not have to be retyped, and multi-brand workspaces keep each client’s plan separate.

Our view is that human approval should stay in the loop, and that the plan should be a living record rather than a file in a folder. Teams that govern the plan this way spend their time on decisions instead of reconciliation.

Brittany

8. Run the plan from one workspace

If your team manages several property or ecommerce campaigns, OppRise connects the planning steps in this guide to execution and reporting. It supports budget management, approval workflows, creative collaboration, AI-assisted campaign insights and white-label outputs, depending on plan.

Plans are billed monthly. Solo is $102.99 per month, Growth is $258.99 per month and Agency is $622.99 per month. Agency Plus has no published price. AI credits are sold separately as one-off packs: 500 credits for $76.99, 1,500 for $206.99 and 5,000 for $622.99. Compare them on the OppRise pricing page, or sign in to your workspace if you already have an account.

9. Common mistakes to avoid

• Channel-level rows only. Without placement-level rows, you cannot tell which audience or creative drove the result.
• No tracking column. If a line has no tagged link, its results will be arguable.
• Too many KPIs. Pick the few that follow from the objective and report those consistently.
• Plan and actuals in different files. Keep them in one workbook or one workspace so variance is always visible.
• No change log. An approved plan that is edited silently loses its value as a record.
• Budget rules written after the problem. Agree the shift limits and test criteria before launch.

FAQ

What should a media plan template include?

At minimum: channel, audience, format, start and end dates, budget, buying model, estimated delivery, KPI, tracking link and owner for every placement. Add a status column and actuals so the same document works after launch.

How is a media plan different from a marketing plan?

A marketing plan covers strategy across the whole mix, including product, pricing and messaging. A media plan is narrower: it specifies the paid placements, their timing and cost. The media plan implements part of the marketing plan.

How often should I update a media plan?

Compare actuals to plan weekly while a campaign is live, and revise the plan when results justify a change under your pre-agreed rules. Each revision should get a new version number and a log entry, so the approved version stays recoverable.

Should I use Excel, Google Sheets or a platform?

A spreadsheet is enough for a single campaign or a small team. When you manage several brands, pull data from multiple ad accounts or need approvals tracked, a connected platform removes the manual reconciliation. The template fields stay the same in either case.

How many channels should a media plan include?

Use as many as have a clear role and enough budget to produce readable results. Spreading a small budget across many channels leaves each line too thin to learn from.

Sources

• Media plan template: what it contains and how to build one (Ideup)
• The MEL Manual (World Health Organization, 2021)
• Visit Napa Valley FY25 annual plan (Simpleview)
• Campaign timeline and project plan template (Smart Insights)

Recommended

• Marketing Request Form: Fields, Template and Workflow
• Marketing Campaign Brief: How to Write One That Works
• Marketing Budget Tracking: A Practical System for Teams