Syntha Lab RU

Promo effect without a control group: a baseline from last year

Estimates how much would have sold without the promotion when there is no control group. Takes last year’s sales in the same weeks as the promotion and multiplies by the trend growth: this year’s sales outside the promotion against last year’s for the same weeks. From the baseline it gets the promotion uplift, the promotion profit and the break-even volume, and optionally takes the post-promotion dip into account and gives a single result “promotion plus dip”. It complements “Promotion payback” (it needs a known “without the promotion”) and “Difference in differences” (a control group is needed): here is a way to get “without the promotion” from last year.

Promotions: planning and evaluation For whom: Marketing, commercial teams and analysts after a promotion without a control group.

Calculate on your data →

At a glance

What question does it answer?
How much would have sold without the promotion, what the uplift is and whether the promotion made a profit, including the dip after it.
What data is needed?
Sales outside promotions this and last year for the same weeks.
How to read the result?
Compare the uplift with the break-even and check the post-promotion dip. Example on the default values: Trend growth: 1.25×; Baseline (without the promotion): 500; Promotion uplift: +260; Promotion uplift, %: +52%. The figures are illustrative: enter your own to see your result.

Why and how to reason

Without a control group “without the promotion” is taken from last year: sales in the same weeks multiplied by the trend growth outside promotions. In the example the growth is 1,000 ÷ 800 = 1.25, the baseline 500 pcs, actual 760, uplift 260 pcs (52%), but the promotion profit is −RUB 188,000: break-even needed 917 pcs.

When to use it

Apply after a promotion when there is no control group; compare the same weeks of the calendar.

How to read the result

Compare the uplift with the break-even and fill in the period after the promotion: a dip can turn a plus into a minus.

Common mistakes

The promotion is compared with the weeks before it, the post-promotion dip is ignored.

What data is needed?

  • Sales outside promotions this and last year for the same weeks.
  • Last year in the promotion period, actual, price, discount, cost.

Inputs

FieldUnitValue in the exampleMeaning
Sales before the promotion, this yearpcs1,000The weeks outside this year’s promotions that you compare with last year. The example value is illustrative.
Sales in the same weeks, last yearpcs800The same weeks of the year and the same group of goods. The example value is illustrative.
Last year’s sales in the promotion periodpcs400The weeks of the year in which this year’s promotion runs. Without last year’s promotions in those weeks. The example value is illustrative.
Actual sales in the promotion periodpcs760Sold during this year’s promotion. The example value is illustrative.
Price without discount₽4,000Excl. VAT. The example value is illustrative.
Promotion discount%25The average effective discount during the promotion. The example value is illustrative.
Unit cost₽1,800Excl. VAT. The example value is illustrative.
Sales after the promotion, this year (optional)pcs—As many weeks after the promotion as you want to check for a dip. Empty: not set.
Sales in the same weeks, last year (optional)pcs—The same weeks of the year last year. Empty: not set.

How it is calculated

StepFormula
Trend growth1,000 ÷ 800 = 1.25
Baseline400 × 1.25 = 500
Uplift760 − 500 = 260
Promotion profit760 × 1,200 ₽ − 500 × 2,200 ₽ = −188,000 ₽
Diplast year’s sales after the promotion × trend growth − actual after the promotion; loss = dip × margin without discount

Worked numbers

Default values from the app; in the interactive version you enter your own.

Trend growth
1.25×This year’s sales ÷ last year’s for the weeks outside promotions.
Baseline (without the promotion)
500Last year’s sales in the promotion period × trend growth.
Promotion uplift
+260
Promotion uplift, %
+52 %
Promotion profit
−188,000 ₽Actual × margin with discount − baseline × margin without discount.
Break-even volume
917
Break-even uplift
83.3 %
Post-promotion dip
the period after the promotion is not set
Result “promotion plus dip”
the period after the promotion is not set
Sales in the promotion period, pcs
Bar chart: Baseline 500, Actual 760, Break-even 91702004006008001,000BaselineBaselinePieces: 500500ActualActualPieces: 760760Break-evenBreak-evenPieces: 917917
Data as a table
MeasurePieces
Baseline500
Actual760
Break-even917

The promotion profit is −188,000 ₽: the uplift of 52 % does not cover the margin lost on the volume that would have sold anyway. For zero you need to sell 917 pcs, an uplift of 83.3 %.

Sales after the promotion are not set: the dip is not counted, the result may be overstated. Fill in the two fields about the period after the promotion.

What to do with the result: count the baseline for the same weeks of the year where the event calendar matches (holiday sales shift between years) and compare it with a control group when there is one.

A typical mistake: comparing the promotion with the weeks just before it (seasonality) and ignoring the post-promotion dip.

Nuances and limits

  • Comparing with the weeks just before.
  • The post-promotion dip ignored.

Terms used

Calculate on your data →