Performance · XLSX

Annual media plan 2026-2027

A form for protecting the annual budget: a monthly grid for eight channels with formulas for results, goals for quarters, a plan-fact sheet for each month, seasonality coefficients and a pre-written scenario in case the budget is cut.

mediaplan-godovoy-2026.xlsx · 12 KB · CC BY 4.0
No registration, no email form, no watermarks.

How does an annual media plan differ from a quarterly one?

The annual plan solves a different problem. Kvartalny answers the question “what we are launching”, annual - to the question “how much money to give to marketing and what the company will get in return.” It is not read by a performance team, but owner or financial director, and he has other requirements: to see the entire amount at once, understand the distribution by month, know what will happen, if there is less money.

Therefore, there are five sheets in this form, and only one of them is the one “channel × month” grid, which is usually called a media plan.

  • Summary of the year. Eight channels for twelve months. Total formulas for rows and columns are hard-coded, you only need to change numbers in cells.
  • Quarters. Focus, main goal and acceptance metric each quarter plus a share of the annual budget.
  • Plan-fact. Twelve lines for the year: budget, leads, CPL in the context of plan and fact, and a column of decisions.
  • Seasonality. Demand coefficient by month and column “What is the justification” so that the figure does not hang in the air.
  • Reserve Three budget reduction scenarios with answers, which we turn off first.
Send us your file and I’ll tell you where it breaks.

If the annual budget still needs to be defended in front of management, write and I’ll tell you what numbers in this form are asked first and how to cover them.

Why does seasonality come before budget?

The most common mistake in annual plans is the even distribution of the budget across months. Twelve identical amounts mean that in high season the company undersupplied the volume and overpaid for the auction when it was low. Moreover there is nothing to justify such a distribution: it was taken from the division of the annual amounts for twelve.

In the form, the seasonality sheet is first filled out, and the budget grid is obtained as “basic amount per channel × month coefficient”. Then to the question “why is there twice as much in November as in July” there is an answer from own data, and not from feelings.

the “Reserve” sheet is the one for which everything is done

The budget is almost always cut. Difference between calm and panicky shorthand for whether the script is written in advance. When is the decision accepted in the moment, the first to go under the knife is usually what is easiest measure and the worst thing to lose: a working performance. And turn off you need to do it in reverse order - starting with tests that have not yet paid off.

The three lines on this form cover three real-world scenarios. Filled out for Twenty minutes saves a week of arguing.

what to do next

The annual plan sets the framework, but specific launches live within it. If you need details on channels, hypotheses and creatives, take it media plan template - he designed for a quarter and is linked to this form along the lines of channels. If there is a separate event within the year, it has its own logic and its own phases, for there is this media plan for the event. The offline part of the budget - radio, outdoor advertising, the press - is considered differently, via GRP and OTS, and a separate form for it: offline advertising media plan.

To verify the target values of CPL and CAC by niche are useful CPL benchmarks in B2B and unit economics calculator.

Frequently asked questions
How does an annual media plan differ from a quarterly one?
The quarterly one answers the question “what are we launching”, the annual one answers the question “how much money to give to marketing and what the company will receive in return.” The annual report is read by the owner or financial director, so it contains a monthly grid, quarters with acceptance metrics and a scenario in case of budget cuts, but there are no creative ideas or hypotheses.
How to distribute the annual budget by month?
Not equally. First, the seasonality coefficient is calculated for each month - from Wordstat for the main request for 2-3 years or from your own sales statistics. Next, the base amount for the channel is multiplied by the monthly coefficient. Then the question “why is there twice as much in November as in July” has an answer from the data.
What to write in the media plan for 2026-2027 if the budget has not yet been approved?
Fill out the form based on the goals, not the amount. First, the “Quarters” sheet: why each quarter is needed and by what metric it is accepted. Then three budget scenarios on the “Reserve” sheet - basic, minus 25% and minus 50%. It is easier to defend a plan that already has an answer to the question “what if there is less money.”
What channels should be included in the annual media plan?
The form contains eight lines for the practice of the Russian Federation: search and YAN in Yandex Direct, VK Ads, Telegram Ads, sponsored placements in Telegram, influencers, SEO and content, email and CRM. The lines are adjusted to suit you, but more than eight channels in the annual plan usually means that none of them will accumulate statistics.
Related Templates
Next

The template does not close the task - let's talk

If the template doesn’t fit your niche, or you need someone to match it, which will lead to the result - there is form and Telegram at /contact. I answer during business hours.