Free media plan template: what to include and how to use it

A useful media plan template should do more than divide a budget between channels. It should connect the campaign objective to the audiences, tactics, flighting, KPIs and delivery controls that determine whether the plan can actually work.

Many templates fail because they are designed to look complete rather than to support decisions. They contain dozens of columns, colour-coded tabs and impressive charts, but they do not explain why a channel receives its share of budget or how the agency will respond when actual delivery moves away from the plan. The best template is simple enough to maintain and detailed enough for another planner to understand without a handover meeting.

The sections every media plan needs

1. Campaign summary

Begin with the campaign name, client, market, start and end dates, total budget and owner. Add the version or approval status if the template will circulate between several stakeholders. This section should answer the basic operational questions immediately. A planner should not need to search through the workbook to confirm whether the budget includes fees, which currency is being used or which dates the plan covers.

2. Objective and KPI framework

Write the commercial objective in plain language, then translate it into measurable media KPIs. 'Increase awareness' is not enough. The plan should specify the reach, frequency, completed views, brand-lift measure or other outcome that will indicate progress.

For a performance campaign, include the conversion event, target CPA, ROAS or lead volume. Where different channels play different roles, assign a primary KPI to each line rather than averaging everything into one blended number.

3. Audience definitions

Include the audience name, motivation, media behaviour and targetable platform proxy. This prevents personas from becoming descriptive slides that disappear when the campaigns are built.

For example, a B2B decision-maker persona might map to job titles and seniority on LinkedIn, high-intent queries on Google and a first-party lookalike audience on Meta. Record those mappings in the plan so the strategy and activation remain connected - the same principle behind Medusa's audience personas.

4. Channel and tactic allocation

Each row should represent a decision that can be activated and measured. Useful fields include channel, platform, tactic, audience, funnel role, budget, percentage of total budget, pricing model and rationale.

The rationale is essential. A split of 40% search, 30% social, 20% video and 10% testing may be reasonable, but the plan should explain what objective, audience cost or historic evidence produced it. Without that explanation, the allocation is difficult to defend and impossible to learn from later.

5. Flighting

Add the dates and weekly weight for each line. A quarterly total does not show whether the spend should be flat, front-loaded, pulsed around a retail moment or held back until creative and tracking are stable.

The flighting section becomes the basis for planned-to-date calculations. If the template only contains total budget, a campaign that should spend heavily in week one may appear to be overspending when it is actually following the approved shape.

6. Measurement and tracking

Record the conversion events, attribution settings, naming taxonomy, required pixels, UTMs and reporting cadence. This turns measurement from a late implementation task into part of the plan.

Include a named owner for each dependency. 'Analytics team' is not an owner. A person or role should be responsible for confirming that the event fires, the platform receives it and the campaign can be reported at the planned level.

7. Planned versus actual delivery

A working template should continue after launch. Add actual spend, expected spend to date, variance, required daily spend and projected final spend. The same structure can be used for impressions, conversions and other key delivery metrics. This is the difference between a planning document and a planning system. The approved allocation becomes the baseline against which the campaign is managed.

Recommended template columns

Avoid adding columns simply because another agency uses them. Every field should support a planning, activation or optimisation decision. A narrow template the team updates consistently is more valuable than a comprehensive workbook that becomes obsolete after approval.

How to use the template step by step

1. Extract the objective, audience, market, KPIs and budget from the brief. Do not begin splitting money until missing inputs are resolved.
2. Define the audiences and map them to buyable segments.
3. Select channels based on the role they play in the customer journey, the audience's reachability and historic response.
4. Allocate enough budget for each chosen channel to produce meaningful delivery.
5. Shape the flight around demand, creative, seasonality and learning periods.

Before sign-off, ask a planner who was not involved to review the file. They should be able to explain the allocation, identify the primary KPI for every line and understand how actuals will be monitored. If the logic only makes sense with verbal context, the template is incomplete.

The limitations of a spreadsheet template

A template is a strong starting point, but it still relies on manual data entry, careful formula management and disciplined version control. The more clients, channels and markets the agency manages, the more time is spent maintaining the structure rather than improving the plan.

Medusa uses the same core planning fields but automates more of the workflow. It can extract the brief, draft personas, recommend a cross-channel allocation and turn the approved plan into a live pacing baseline using connected platform data. That makes the template useful both as a standalone resource and as a bridge to a more structured planning platform.

Download the template - or automate the workflow

Use the template structure above to standardise the immediate process. When manual updates, versioning and pacing begin to consume more time than the planning itself, upload the next client brief to Medusa and create the plan in one live workspace.