Media Plan Template: Layout, Excel Build Steps and a Filled-In Example
10 min read ยท 2026-10-25
A media plan template is a spreadsheet that lists every paid placement in a campaign on one line, with its channel, audience, dates, budget, buy type, KPI and owner, plus a calendar view that shows when each placement runs. It is the document your marketing lead approves, your agency or media buyer books from, and your finance partner checks spend against.
Below you will find the exact layout to build (tabs, columns and the flighting calendar), step-by-step instructions for Excel or Google Sheets, a filled-in example for a B2B product launch, who owns what and how to present the plan to stakeholders. It starts with the campaign roadmap the template supports: a 14-week path from brief to wrap report, with a milestone for each phase.
The roadmap at a glance
Goal: A quarterly paid media campaign that is planned in one approved template, launched on time across all channels, optimized weekly and closed with a wrap report. Duration: 14 weeks
Brief and objectives (Weeks 1-2)
Agree on what the campaign must achieve and for whom.
- Write a one-page brief: business goal, campaign objective, target audience, key message, total budget and dates.
- Choose one primary KPI per objective, such as cost per qualified lead for demand or reach in the target audience for awareness.
- List the constraints: brand rules, regulated claims, markets, blackout dates and creative already available.
- Get the brief signed by the marketing lead and the budget holder.
Milestone: A signed brief with objective, audience, primary KPI, total budget and campaign dates.
Audience and channel research (Weeks 2-3)
Pick channels that reach the audience at a cost the plan can carry.
- Describe the audience by job, industry, region and where they spend time, using CRM data and past campaign results.
- Shortlist channels and vendors, and ask vendors for audience size, formats, minimums and lead times.
- Pull benchmarks from your own past campaigns for the KPIs you chose.
- Decide the role of each channel: reach, consideration, conversion or retargeting.
Milestone: A shortlist of channels with the role, audience fit and expected KPI range for each one.
Budget split and flighting (Weeks 3-4)
Turn the shortlist into line items with dates and budgets.
- Split the total budget across channels according to their role, keeping a small reserve for in-flight changes.
- Set the flighting pattern for each line: continuous, flighted (on and off weeks) or pulsed around key dates.
- Estimate planned delivery per line, such as impressions, site visits or leads, from vendor quotes and benchmarks.
- Check that the total of all lines matches the approved budget exactly.
Milestone: A draft plan where every line has dates, budget, planned delivery and a KPI, and the total matches the brief.
Approval and creative (Weeks 5-6)
Lock the plan and get every asset ready on time.
- Review the plan with the marketing lead, sales lead and finance partner, then freeze version 1.0.
- Fill the creative tracker: format, size, specs, copy length and due date for every placement.
- Set up tracking: UTM parameters, conversion events and the reporting view.
- Send insertion orders or set up campaigns in each ad platform as drafts.
Milestone: Plan version 1.0 approved, insertion orders signed and all launch creative delivered to vendors.
Launch (Week 7)
Go live on every channel and confirm that tracking works.
- Launch each line on its start date and log the actual go-live in the plan.
- Check that ads are serving to the right audience, placements and regions.
- Confirm that site visits and conversions show up in analytics and the CRM within the first days.
Milestone: All week-one lines live, with tracking confirmed for each one in the reporting view.
In-flight optimization (Weeks 8-12)
Move budget toward what works while the campaign runs.
- Update actual spend and results in the plan every week.
- Compare each line with its planned KPI and flag lines that are far off.
- Shift budget from the reserve or weak lines to strong ones, and record each change with a date and reason.
- Rotate creative when frequency is high or results drop.
Milestone: A weekly report sent every Monday, with every budget change logged in the plan.
Wrap report (Weeks 13-14)
Show what the campaign delivered and what to change next time.
- Close actual spend with finance and reconcile it with vendor invoices.
- Compare planned and actual results for every line and every channel.
- Write three to five lessons and turn them into rules for the next plan.
Milestone: Wrap report presented to the marketing lead, with spend reconciled and lessons added to the template notes.
The layout: tabs and columns
Build the template as one workbook with five tabs. The Plan tab is the heart of it. Every other tab reads from it, so there is only one place to change a date or a budget.
On the Plan tab, one row equals one placement, for example LinkedIn sponsored content for operations managers in North America. Put the columns below in this order, from left to right. Then add one column per week of the campaign to the right of the last column. That calendar area is your flighting chart, sometimes called a media flowchart.
The other four tabs are: Summary (totals by channel and by month, plus one chart), Creative (one row per asset with specs, due date and status), Tracking (UTM codes and conversion events per line) and Change log (date, line, change, reason, approved by).
- Line ID and channel: a short code like SOC-01 and the channel (search, social, display, video, audio, print, out of home, sponsorship).
- Vendor or platform and placement: where the ad runs and in what format.
- Audience and targeting: who it reaches, in plain words.
- Objective and KPI: the role of the line and the one number it is judged on.
- Buy type: CPM, CPC, cost per lead or flat fee.
- Start date, end date and status: planned, booked, live, paused or ended.
- Planned budget and planned delivery: what you will spend and what you expect to get.
- Actual spend and actual results: filled in weekly once the line is live.
- Owner: the person who books and optimizes the line.
How to build it in Excel or Google Sheets
You can build the whole template in about an hour. The steps below work in Excel and Google Sheets. Menu names are given for both where they differ.
Test the template with three or four dummy rows before you share it. Change a date and a budget, and check that the calendar and the Summary tab update on their own.
- Create the five tabs and type the column headers on the Plan tab. Select the header row and freeze it with View, then Freeze Panes in Excel or View, then Freeze in Google Sheets.
- Turn the plan rows into a table with Home, then Format as Table in Excel, or use alternating colors in Google Sheets, so new rows keep the same formatting.
- Add drop-down lists for channel, buy type and status with Data, then Data Validation in Excel, or Data, then Data validation in Google Sheets.
- In the header row above the calendar columns, enter the Monday of each campaign week.
- Select the calendar cells and add a conditional formatting rule with a formula that colors a cell when the week date falls between that row's start and end date. In Excel this is under Home, then Conditional Formatting, then New Rule. In Google Sheets it is Format, then Conditional formatting, then Custom formula is.
- On the Summary tab, use SUMIFS to total planned budget and actual spend by channel and by month, then insert a bar chart of planned against actual by channel.
- Add a check cell that compares the sum of all planned budgets with the approved total and turns red when they differ.
Example: a filled-in media plan for a B2B product launch
Picture a software company launching a scheduling tool for operations managers at mid-sized manufacturers. The campaign runs ten weeks from launch, with a goal of qualified demo requests. Here are the main lines of the Plan tab, in plain words.
Notice that each line has one role and one KPI. That is what makes in-flight decisions easy: if a line misses its KPI for two weeks, the owner knows exactly what to change or where to move the money.
- SOC-01, LinkedIn sponsored content (owner: paid social manager): operations and plant managers at manufacturers in the target regions, weeks 1-10, CPM buy, role reach and consideration, KPI cost per engaged visitor. Largest share of the budget.
- SRC-01, Google Search ads (owner: search specialist): keywords on production scheduling and shift planning, weeks 1-10 continuous, CPC buy, role conversion, KPI cost per demo request.
- SPN-01, trade newsletter sponsorship (owner: content marketing manager): two dedicated sends to an industry newsletter list, weeks 2 and 6, flat fee, role reach, KPI visits to the launch page.
- DSP-01, retargeting display (owner: paid media manager): site visitors from the other lines, weeks 3-10, CPM buy, role conversion, KPI demo requests from retargeted visitors.
- AUD-01, podcast host read (owner: content marketing manager): two episodes of a manufacturing podcast, weeks 4 and 8, flat fee, role awareness, KPI visits with the podcast promo code.
- RES-01, reserve (owner: marketing lead): unassigned budget released in week 5 to the best performing line.
Who owns what
A media plan has many hands on it. Without clear owners, rows go stale and nobody knows which version the vendor booked from. Name one owner for the plan and one owner per line.
If you work with an agency, the agency planner usually owns the Plan tab and you own the brief, approvals and the budget. Write that split down at kickoff.
- Marketing lead or head of demand generation: owns the brief, approves the plan and every budget shift above an agreed size.
- Media planner or paid media manager: builds and maintains the plan, owns the change log and the weekly report.
- Channel specialists: book, launch and optimize their own lines and update actuals weekly.
- Creative lead: owns the creative tracker and delivers assets by the due dates.
- Marketing operations or analytics: sets up tracking and the reporting view, and checks data quality.
- Finance partner: confirms the budget, reviews actual spend each month and reconciles invoices at the end.
How to present the plan to stakeholders
Stakeholders do not need the full Plan tab. Build one summary slide in PowerPoint or Google Slides with four blocks: the objective and primary KPI at the top, the audience in one sentence, a bar chart of budget by channel, and a simplified flowchart with one bar per channel across the weeks.
Under the flowchart, list the two or three decisions you need, such as approving the reserve or confirming launch dates with sales. Keep the line-level detail, vendor names and buy types in the appendix or the shared workbook. During the campaign, send the same slide each week with actual spend and results added, so people learn to read it fast.
Common mistakes to avoid
- Giving every line several KPIs makes in-flight decisions vague, so assign one role and one primary KPI per line.
- Keeping several copies of the plan in email leads vendors to book from old versions, so keep one shared workbook and log every change in the Change log tab.
- Spending the whole budget at launch leaves nothing to move to winning lines, so keep a reserve line and set the date you will release it.
- Leaving tracking setup until launch week produces campaigns you cannot measure, so finish UTMs and conversion events before plan approval.
- Missing creative due dates delays whole channels, so add a creative tracker with specs and due dates for every placement.
- Reporting only platform numbers hides whether leads turn into pipeline, so pull accepted leads from the CRM into the Actual columns every week.
Frequently asked questions
What should a media plan template include?
It should include one row per placement with channel, vendor, audience, objective, KPI, buy type, dates, planned budget, planned delivery, actuals, status and owner. Add a weekly flighting calendar, a summary by channel, a creative tracker and a change log. Keep all of it in one workbook so numbers stay consistent.
How do I make a media plan in Excel?
Create a Plan tab with one row per placement and the columns listed above, then add one column per campaign week. Use conditional formatting with a formula to shade the weeks each line runs, and data validation for drop-down lists. Total budgets by channel on a Summary tab with SUMIFS and add a chart.
What is the difference between a media plan and a media schedule?
The media plan covers the whole strategy: objectives, audience, channels, budgets and KPIs. The media schedule, or flowchart, is the calendar part that shows when each placement runs. In a good template the schedule is generated from the plan rows, so they never disagree.
How often should you update a media plan?
Update actual spend and results once a week while the campaign runs, on a fixed day. Log every budget shift or date change in the change log with a reason. Do a full planned against actual review at the end for the wrap report.
Who approves a media plan?
Usually the marketing lead or the budget holder approves it, often with input from sales and finance. Approve a frozen version before you sign insertion orders. After that, agree a threshold above which budget shifts need approval again.