Syntha Lab RU

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.

Advertising and customer acquisition For whom: Brand managers, heads of marketing and CFOs who put together an annual acquisition budget and want to see its return by month.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Annual marketing budget₽1,200,000The 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,980How 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%22The VAT rate of your country: revenue for the calculation is taken ex-VAT; 22% for Russia, check for the item.
Returns and non-redemption%20The share of the ordered that does not stay with the buyer: it reduces revenue. The example value is illustrative.
Gross margin%60The share of ex-VAT revenue left after the cost of goods. The example value is illustrative.
Variable costs per order beyond goods%22The 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%20Advertising does not buy an order the same day: part of the decisions is made later. The example value is illustrative.

How it is calculated

StepFormula
Channel budgetbudget × channel share
Orderschannel budget ÷ cost of an order; the sum over channels
Revenueorders × average order ÷ (1 + VAT) × (1 − returns)
Margin and resultrevenue × (gross margin − variable costs); result = margin − budget
By monthbudget 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 ₽
Budget by channel and month, ₽
Heat map: 6×12; min 3,600, max 45kJanJanFebFebMarMarAprAprMayMayJunJunJulJulAugAugSepSepOctOctNovNovDecDecMessenger seedingMessenger seeding9,000Messenger seeding / Jan: 9,0009,000Messenger seeding / Feb: 9,00014.4kMessenger seeding / Mar: 14.4k14.4kMessenger seeding / Apr: 14.4k10.8kMessenger seeding / May: 10.8k7,200Messenger seeding / Jun: 7,2005,400Messenger seeding / Jul: 5,40014.4kMessenger seeding / Aug: 14.4k25.2kMessenger seeding / Sep: 25.2k25.2kMessenger seeding / Oct: 25.2k27kMessenger seeding / Nov: 27k18kMessenger seeding / Dec: 18kBloggersBloggers12kBloggers / Jan: 12k12kBloggers / Feb: 12k19.2kBloggers / Mar: 19.2k19.2kBloggers / Apr: 19.2k14.4kBloggers / May: 14.4k9,600Bloggers / Jun: 9,6007,200Bloggers / Jul: 7,20019.2kBloggers / Aug: 19.2k33.6kBloggers / Sep: 33.6k33.6kBloggers / Oct: 33.6k36kBloggers / Nov: 36k24kBloggers / Dec: 24kTargeted adsTargeted ads15kTargeted ads / Jan: 15k15kTargeted ads / Feb: 15k24kTargeted ads / Mar: 24k24kTargeted ads / Apr: 24k18kTargeted ads / May: 18k12kTargeted ads / Jun: 12k9,000Targeted ads / Jul: 9,00024kTargeted ads / Aug: 24k42kTargeted ads / Sep: 42k42kTargeted ads / Oct: 42k45kTargeted ads / Nov: 45k30kTargeted ads / Dec: 30kSearch and contextual adsSearch andcontextual ads9,000Search and contextual ads / Jan: 9,0009,000Search and contextual ads / Feb: 9,00014.4kSearch and contextual ads / Mar: 14.4k14.4kSearch and contextual ads / Apr: 14.4k10.8kSearch and contextual ads / May: 10.8k7,200Search and contextual ads / Jun: 7,2005,400Search and contextual ads / Jul: 5,40014.4kSearch and contextual ads / Aug: 14.4k25.2kSearch and contextual ads / Sep: 25.2k25.2kSearch and contextual ads / Oct: 25.2k27kSearch and contextual ads / Nov: 27k18kSearch and contextual ads / Dec: 18kOn-platform adsOn-platform ads9,000On-platform ads / Jan: 9,0009,000On-platform ads / Feb: 9,00014.4kOn-platform ads / Mar: 14.4k14.4kOn-platform ads / Apr: 14.4k10.8kOn-platform ads / May: 10.8k7,200On-platform ads / Jun: 7,2005,400On-platform ads / Jul: 5,40014.4kOn-platform ads / Aug: 14.4k25.2kOn-platform ads / Sep: 25.2k25.2kOn-platform ads / Oct: 25.2k27kOn-platform ads / Nov: 27k18kOn-platform ads / Dec: 18kCRM: mailings and repeat ordersCRM: mailings andrepeat orders6,000CRM: mailings and repeat orders / Jan: 6,0006,000CRM: mailings and repeat orders / Feb: 6,0009,600CRM: mailings and repeat orders / Mar: 9,6009,600CRM: mailings and repeat orders / Apr: 9,6007,200CRM: mailings and repeat orders / May: 7,2004,800CRM: mailings and repeat orders / Jun: 4,8003,600CRM: mailings and repeat orders / Jul: 3,6009,600CRM: mailings and repeat orders / Aug: 9,60016.8kCRM: mailings and repeat orders / Sep: 16.8k16.8kCRM: mailings and repeat orders / Oct: 16.8k18kCRM: mailings and repeat orders / Nov: 18k12kCRM: mailings and repeat orders / Dec: 12kMonth of the year
  • 3,600 … 45k ₽
Data as a table
JanFebMarAprMayJunJulAugSepOctNovDec
Messenger seeding9,0009,00014.4k14.4k10.8k7,2005,40014.4k25.2k25.2k27k18k
Bloggers12k12k19.2k19.2k14.4k9,6007,20019.2k33.6k33.6k36k24k
Targeted ads15k15k24k24k18k12k9,00024k42k42k45k30k
Search and contextual ads9,0009,00014.4k14.4k10.8k7,2005,40014.4k25.2k25.2k27k18k
On-platform ads9,0009,00014.4k14.4k10.8k7,2005,40014.4k25.2k25.2k27k18k
CRM: mailings and repeat orders6,0006,0009,6009,6007,2004,8003,6009,60016.8k16.8k18k12k
Cumulative margin and cumulative budget, ₽
Line chart: Cumulative margin: 90.7k → 2.22m; Cumulative budget: 60k → 1.2m0500k1m2m2m3mJanMarMayJulSepNovDecCumulative margin, Jan: 90.7kCumulative margin, Feb: 204kCumulative margin, Mar: 372kCumulative margin, Apr: 553kCumulative margin, May: 698kCumulative margin, Jun: 798kCumulative margin, Jul: 871kCumulative margin, Aug: 1.03mCumulative margin, Sep: 1.32mCumulative margin, Oct: 1.64mCumulative margin, Nov: 1.97mCumulative margin, Dec: 2.22mCumulative budget, Jan: 60kCumulative budget, Feb: 120kCumulative budget, Mar: 216kCumulative budget, Apr: 312kCumulative budget, May: 384kCumulative budget, Jun: 432kCumulative budget, Jul: 468kCumulative budget, Aug: 564kCumulative budget, Sep: 732kCumulative budget, Oct: 900kCumulative budget, Nov: 1.08mCumulative budget, Dec: 1.2m₽Month of the year
  • Cumulative margin
  • Cumulative budget
Data as a table
Month of the yearCumulative marginCumulative budget
Jan90.7k60k
Feb204k120k
Mar372k216k
Apr553k312k
May698k384k
Jun798k432k
Jul871k468k
Aug1.03m564k
Sep1.32m732k
Oct1.64m900k
Nov1.97m1.08m
Dec2.22m1.2m

Channels: budget and orders

ChannelBudget shareBudgetCost of an orderOrders
Messenger seeding15 %180,000 ₽2,400 ₽75
Bloggers20 %240,000 ₽3,000 ₽80
Targeted ads25 %300,000 ₽2,000 ₽150
Search and contextual ads15 %180,000 ₽1,500 ₽120
On-platform ads15 %180,000 ₽1,100 ₽164
CRM: mailings and repeat orders10 %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.

Terms used

Calculate on your data →