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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Sales before the promotion, this year | pcs | 1,000 | The weeks outside this year’s promotions that you compare with last year. The example value is illustrative. |
| Sales in the same weeks, last year | pcs | 800 | The same weeks of the year and the same group of goods. The example value is illustrative. |
| Last year’s sales in the promotion period | pcs | 400 | The 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 period | pcs | 760 | Sold during this year’s promotion. The example value is illustrative. |
| Price without discount | ₽ | 4,000 | Excl. VAT. The example value is illustrative. |
| Promotion discount | % | 25 | The average effective discount during the promotion. The example value is illustrative. |
| Unit cost | ₽ | 1,800 | Excl. 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
| Step | Formula |
|---|---|
| Trend growth | 1,000 ÷ 800 = 1.25 |
| Baseline | 400 × 1.25 = 500 |
| Uplift | 760 − 500 = 260 |
| Promotion profit | 760 × 1,200 ₽ − 500 × 2,200 ₽ = −188,000 ₽ |
| Dip | last 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
Data as a table
| Measure | Pieces |
|---|---|
| Baseline | 500 |
| Actual | 760 |
| Break-even | 917 |
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.