Annual media plan: budget by channel and month, orders, revenue, margin after marketing, ad-cost share and payback
From the annual budget, channel shares and the cost of an order in each channel, month weights, the average order, returns, margin and the delay of the effect it spreads the budget by channels and months, counts orders, revenue ex-VAT after returns, margin after marketing, the ad-cost share, ROMI and the month when the cumulative margin covers the cumulative budget. All numbers follow from your assumptions: this is a teaching frame, not a forecast of advertising return.
At a glance
- What question does it answer?
- How to split the annual budget by channels and months, how many orders and how much revenue it gives under your assumptions, when the cumulative margin will cover the cumulative budget and what ad-cost share comes out.
- What data is needed?
- The annual budget, the channel shares and the cost of an order in each of them from your campaigns.
- How to read the result?
- Example on the default values (budget RUB 1.2 million, six channels, average order RUB 10,980 with VAT, returns 20%, margin after variable costs 38%): orders 829, average cost of an order RUB 1,448, revenue ex-VAT RUB 5.97 million, result after marketing RUB 1.07 million, ad-cost share 20.1%, ROMI 89%. Example on the default values: Annual budget: RUB 1.2 million; Orders in a year: 829; Average cost of an order: RUB 1,448; Revenue ex-VAT after returns: RUB 5.97 million. The figures are illustrative: enter your own to see your result.
Why and how to reason
A budget says nothing by itself: what matters is how many orders it will buy and how much money it will leave after all costs. The calculation runs as a chain. The budget is split across channels by shares; a channel’s budget divided by the cost of an order in it gives orders; orders × the average order ÷ (1 + VAT) × (1 − returns) give revenue ex-VAT after returns. The cost of goods and variable costs are deducted from it, the margin is left, and the margin minus the budget is the result after marketing. The ad-cost share shows what part of revenue goes on advertising, ROMI shows how much margin came back per rouble of the budget. By month the budget follows the season weights, and part of the orders arrives in the next month: advertising does not buy an order the same day. On the default values RUB 1.2 million gives 829 orders, revenue RUB 5.97 million, margin RUB 2.27 million, a result of RUB 1.07 million, the ad-cost share 20.1%.
When to use it
Use it when you put together an annual acquisition budget, agree it with finance or decide how to spread the money across channels and months. Do not use it as a forecast of return: the cost of an order in a channel changes with volume, and the calculation does not account for that. Assumptions: the cost of an order and the channel structure are constant, orders follow the budget weights, fixed costs and the batch are not deducted. For footwear and children’s the average order and returns are their own, for accessories the average order is lower but the frequency higher. Rebuild the plan monthly by the actual cost of an order.
How to read the result
Start with the ad-cost share and the result. An ad-cost share of 20.1% of revenue ex-VAT means about 20 kopecks of advertising per rouble of revenue; look at it next to the margin after variable costs (here 38%): while the ad-cost share is clearly below the margin, advertising brings money. The break-even cost of an order, at which the budget barely pays back, is RUB 2,736, while the average cost of an order is RUB 1,448: the reserve is large, but fixed costs and the batch eat it. The budget pays back in month 1; ROMI is 89%. The decision: move a share of the budget into channels with a low cost of an order, but not to zero in the others: awareness is not built by cheap orders alone.
Common mistakes
Typical mistakes: splitting the budget by shares “like everyone else” rather than by the cost of an order in your own campaigns; not deducting VAT and returns; taking the cost of an order from advertising statistics without accounting for non-redemption; taking the payback of marketing for the payback of the launch; setting month weights without the launch dates; not changing the plan when the fact has moved away from the assumptions.
What data is needed?
- The annual budget, the channel shares and the cost of an order in each of them from your campaigns.
- Month weights: seasonality and the dates of collection launches.
- The average order, VAT, returns, the gross margin, variable costs and the share of next-month orders.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Annual marketing budget | ₽ | 1,200,000 | The sum for acquisition and repeat for the year across all channels ex-VAT. Channel and month budgets are counted from it. The example value is illustrative. |
| Average order at the shelf price with VAT | ₽ | 10,980 | How much a buyer pays for an order with VAT: units per order × price. Footwear and children’s have their own. The example value is illustrative. |
| VAT rate | % | 22 | The VAT rate of your country: revenue for the calculation is taken ex-VAT; 22% for Russia, check for the item. |
| Returns and non-redemption | % | 20 | The share of the ordered that does not stay with the buyer: it reduces revenue. The example value is illustrative. |
| Gross margin | % | 60 | The share of ex-VAT revenue left after the cost of goods. The example value is illustrative. |
| Variable costs per order beyond goods | % | 22 | The platform commission, delivery, packaging and acquiring as a percentage of ex-VAT revenue. Take it from your own contracts. The example value is illustrative. |
| Share of orders arriving in the next month | % | 20 | Advertising does not buy an order the same day: part of the decisions is made later. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Channel budget | budget × channel share |
| Orders | channel budget ÷ cost of an order; the sum over channels |
| Revenue | orders × average order ÷ (1 + VAT) × (1 − returns) |
| Margin and result | revenue × (gross margin − variable costs); result = margin − budget |
| By month | budget and orders by weights; a share of orders goes to the next month; payback by cumulative sums |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Annual budget
- 1.2 m ₽
- Orders in a year
- 829
- Average cost of an order
- 1,448 ₽
- Revenue ex-VAT after returns
- 5.97 m ₽
- Margin after variable costs
- 2.27 m ₽
- Result after marketing
- 1.07 m ₽
- ROMI on margin
- 89 %
- Ad-cost share: budget to revenue ex-VAT
- 20.1 %
- Month the budget pays back (number)
- 1
- Orders needed to pay the budget back
- 439
- Margin per order before advertising
- 2,736 ₽
- Revenue tail beyond the year
- 119,324 ₽
- 3,600 … 45k ₽
Data as a table
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Messenger seeding | 9,000 | 9,000 | 14.4k | 14.4k | 10.8k | 7,200 | 5,400 | 14.4k | 25.2k | 25.2k | 27k | 18k |
| Bloggers | 12k | 12k | 19.2k | 19.2k | 14.4k | 9,600 | 7,200 | 19.2k | 33.6k | 33.6k | 36k | 24k |
| Targeted ads | 15k | 15k | 24k | 24k | 18k | 12k | 9,000 | 24k | 42k | 42k | 45k | 30k |
| Search and contextual ads | 9,000 | 9,000 | 14.4k | 14.4k | 10.8k | 7,200 | 5,400 | 14.4k | 25.2k | 25.2k | 27k | 18k |
| On-platform ads | 9,000 | 9,000 | 14.4k | 14.4k | 10.8k | 7,200 | 5,400 | 14.4k | 25.2k | 25.2k | 27k | 18k |
| CRM: mailings and repeat orders | 6,000 | 6,000 | 9,600 | 9,600 | 7,200 | 4,800 | 3,600 | 9,600 | 16.8k | 16.8k | 18k | 12k |
- Cumulative margin
- Cumulative budget
Data as a table
| Month of the year | Cumulative margin | Cumulative budget |
|---|---|---|
| Jan | 90.7k | 60k |
| Feb | 204k | 120k |
| Mar | 372k | 216k |
| Apr | 553k | 312k |
| May | 698k | 384k |
| Jun | 798k | 432k |
| Jul | 871k | 468k |
| Aug | 1.03m | 564k |
| Sep | 1.32m | 732k |
| Oct | 1.64m | 900k |
| Nov | 1.97m | 1.08m |
| Dec | 2.22m | 1.2m |
Channels: budget and orders
| Channel | Budget share | Budget | Cost of an order | Orders |
|---|---|---|---|---|
| Messenger seeding | 15 % | 180,000 ₽ | 2,400 ₽ | 75 |
| Bloggers | 20 % | 240,000 ₽ | 3,000 ₽ | 80 |
| Targeted ads | 25 % | 300,000 ₽ | 2,000 ₽ | 150 |
| Search and contextual ads | 15 % | 180,000 ₽ | 1,500 ₽ | 120 |
| On-platform ads | 15 % | 180,000 ₽ | 1,100 ₽ | 164 |
| CRM: mailings and repeat orders | 10 % | 120,000 ₽ | 500 ₽ | 240 |
Payback here is counted for advertising only: the margin after variable costs against the budget. Fixed costs, the purchase of the batch and the cost of money are not deducted: the payback of the launch will come later than the payback of marketing. The cost of an order and the channel shares have to be yours, not market “benchmarks”.
Nuances and limits
- Splitting the budget by shares “like everyone else” rather than by the cost of an order in your own campaigns.
- Not deducting returns and VAT: revenue looks higher than it is.
- Taking the payback of marketing for the payback of the launch: the batch and fixed costs stay outside the brackets.