How to Measure Promotion Effectiveness: The KPIs Every Commercial Team Should Track

How to Measure Promotion Effectiveness: The KPIs Every Commercial Team Should Track

In short: Promotion effectiveness measures how much incremental sell-out a promotion generates compared with what would have sold anyway (the baseline), and at what cost. The core formula is Incremental volume = Promo sell-out − Baseline sell-out, and Uplift = Promo sell-out ÷ Baseline sell-out. A complete evaluation also checks stock coverage, the post-promotion dip, cannibalization and promotional ROI.

Promotions are one of the biggest growth levers for consumer brands — and often one of the largest trade-spend budgets.

Yet many commercial teams still evaluate them using a single question:

"Did sales increase during the promotion?"

That question alone rarely tells the whole story. A promotion can generate impressive sell-out while destroying margin, creating stock-outs or simply pulling forward sales that would have happened anyway.

The brands that consistently improve commercial performance measure promotions differently. This guide covers the 8 KPIs they use, with formulas and a complete worked example.

---

Why Measuring Promotion Effectiveness Is Difficult

A promotion changes several variables at the same time:

• Sales increase
• Distribution sometimes improves (extra facings, secondary placements)
• Retailers build additional stock before the event
• Consumers stock up, then buy less afterwards
• Competitors react

Without the right analysis, it is almost impossible to know what actually created the performance. That's why commercial teams need more than a weekly sell-out report — they need context.

---

Promotion Effectiveness KPIs at a Glance

---

KPI #1 — Baseline Sales

Every promotion KPI depends on a reliable baseline: the sell-out you would have achieved without the promotion.

Baseline = average weekly sell-out over the last 8–13 non-promotional weeks, for the same SKU at the same retailer.

Looking only at promotional volume is misleading. Imagine two promotions both generating 600 units:

• SKU A normally sells 500 units per week
• SKU B normally sells 120 units per week

Total sales are identical, but SKU B generated 480 incremental units versus only 100 for SKU A.

Common baseline pitfalls:

• Including previous promo weeks in the average inflates the baseline and understates uplift.
• Ignoring seasonality: for seasonal categories, compare with the same ISO weeks last year, adjusted for the underlying trend.
• Ignoring stock-outs: weeks with zero stock depress the baseline artificially.

---

KPI #2 — Promotion Uplift

Promotion uplift = Promo-period sell-out ÷ Baseline sell-out (for the same number of weeks).

Rules of thumb in many consumer durable and FMCG categories:

• Below 1.3x: the mechanic or visibility probably did not work.
• 1.5x – 3x: a solid promotion.
• Above 4x: strong — but check stock coverage and the post-promo dip before celebrating.

---

KPI #3 — Incremental Volume

Uplift is a ratio; incremental volume is what pays the bills.

Incremental volume = Promo-period sell-out − (Baseline × number of promo weeks)

A 5x uplift on a SKU selling 10 units a week creates 40 extra units. A 1.8x uplift on a SKU selling 400 units a week creates 320. Rank promotions on incremental volume (and value), not only on uplift.

---

KPI #4 — Promotion ROI

Promo ROI = (Incremental units × Unit margin − Promotion cost) ÷ Promotion cost

Promotion cost includes the discount funded by the brand, retailer fees (leaflet, end-cap, listing fees) and any extra logistics.

Example: 1,350 incremental units × €12 margin = €16,200. Promotion cost = €9,000. ROI = (16,200 − 9,000) ÷ 9,000 = 80%.

A negative ROI does not automatically mean the promotion should be dropped (it may recruit new shoppers or defend shelf space) — but it should be a conscious decision.

---

KPI #5 — Stock Coverage During Promotion

Nothing is more frustrating than investing heavily in a promotion that runs out of stock halfway through. Every missed sale reduces ROI.

Required stock = Baseline × Expected uplift × Promo weeks. Compare it with retailer stock (store + warehouse) at the start of the promotion.

Monitor during and after the event:

• Coverage % (stock available vs required)
• Stock-out weeks
• Missing units
• Estimated lost sales

See our guide on how to detect stock-out risks for the weeks-of-stock method.

---

KPI #6 — Post-Promotion Dip

Consumers who stock up during a promotion buy less afterwards.

Post-promo dip = (Baseline − Average sell-out in the 2–4 weeks after the promo) × number of weeks

Subtract the dip from incremental volume to get the net incremental volume. A promotion showing +1,000 units during the event and −600 units in the following month really created only 400 units.

---

KPI #7 — Cannibalization

A promotion on one SKU often reduces sales of similar SKUs in your own range (another colour, another size, the previous model).

Cannibalization = Sum of (Baseline − Actual sell-out) of sister SKUs during the promo weeks

Analyse promotions at category or brand level, not only at SKU level, to see the true net effect.

---

KPI #8 — Promotion Frequency

More promotions do not automatically generate more growth. Over-promoted products train shoppers to wait for discounts and erode the baseline.

Promo frequency = Promo weeks ÷ Total weeks over the last 52 weeks. Compare the number of promotional operations this year versus last year, by retailer and by brand.

Questions to ask:

• Which SKUs are over-promoted?
• Which products receive too little support?
• Which retailers rely too heavily on discounts?
• Which promotions should not be repeated?

---

Worked Example: Evaluating a 3-Week Promotion

A toaster sells a baseline of 300 units/week at a retailer. It runs a 3-week leaflet promotion.

Conclusion: the promotion worked (2.5x, 900 net units), but a stock-out in week 3 probably cost 150–200 extra units. Next time: increase the pre-promo order.

---

KPI #9 (Bonus) — Promotion Contribution to Growth

One of the biggest mistakes is assuming all growth comes from promotions. Growth can come from:

• Better distribution and new listings
• Improved stock availability
• Organic demand and price positioning
• Promotions

Split year-on-year growth into these drivers to know how much is truly promotion-led — and whether a year with fewer operations explains a decline.

---

Common Mistakes When Measuring Promotions

Many teams still rely on Excel reports comparing only current week vs last year. This ignores:

• Baseline evolution and promo weeks polluting the baseline
• Stock availability and lost sales
• Distribution changes
• ISO-week misalignment between years (week 1 does not start on the same date)
• The post-promo dip and cannibalization

The result: decisions based on incomplete information. We explain why spreadsheets struggle with this in Excel vs Retail Analytics Software.

---

How Sell-Out Copilot Helps

Sell-Out Copilot automatically analyzes every promotion using sell-out, stock and promotional history:

• Baseline and uplift per SKU, retailer and operation
• Promotion contribution to growth
• Number of promotional operations vs last year, by retailer, brand and category
• Stock coverage, stock-out weeks and missing units during the promo
• Weekly promotion performance reports by email

Instead of spending hours building Excel reports, teams immediately know which promotions created value, which failed, and which should be repeated.

---

FAQ

What is a good promotion uplift? It depends on the category and mechanic, but 1.5x to 3x is a solid result for most consumer products. Always look at net incremental volume, not uplift alone.

How do you calculate baseline sales? Average weekly sell-out over the last 8–13 weeks without promotion and without stock-outs, for the same SKU and retailer, adjusted for seasonality if needed.

What is the difference between uplift and incremental volume? Uplift is a ratio (promo sales ÷ baseline). Incremental volume is the absolute number of extra units (promo sales − baseline). A high uplift on a small SKU can create fewer extra units than a modest uplift on a best-seller.

How do you measure promotion ROI? (Incremental units × unit margin − promotion cost) ÷ promotion cost. Include discount funding, retailer fees and logistics in the cost.

Should I use sell-in or sell-out to measure promotions? Sell-out. Sell-in reflects retailer stock building before the event, not consumer demand. See Sell-In vs Sell-Out.

---

Conclusion

Successful promotions are not measured by sales volume alone. The best commercial teams ask:

• Was the uplift incremental?
• Did stock support demand?
• Did we just pull sales forward?
• Did it pay back?
• Should this promotion be repeated?

With the right KPIs, promotions become a measurable growth engine — not a guessing game.