Cincinnati CPG Edge is independent Kroger news and analysis for CPG brands.
No spin. No agenda. Just the insight to sell smarter and make all of us better vendors.

CPG Business 101, Lesson 7: Promotion math: baseline, lift, ROI

CPG BUSINESS 101 |  LESSON 7 OF 15

Promotion math: baseline, lift, ROI

A promotion is judged on the units it adds, not the units it sells. Many of the units sold on deal would have sold anyway, and you pay the allowance on every one of them. This lesson shows how to tell a promotion that makes money from one that only moves volume.

1. Baseline, lift and the units you would have sold anyway

Baseline is what the item sells in a normal week without a deal. Lift is the extra on top. You pay the allowance on baseline units too, so they are a cost with no gain. And when shoppers stock up, sales can dip after the deal ends.

Does this promotion pay?

Weekly units across all stores. Your gross profit per unit is before the allowance.

WORKED EXAMPLE

Baseline 1,000 units a week for 4 weeks = 4,000 units that would have sold anyway. An 80% lift adds 3,200, minus a 15% dip = 2,720 truly extra units.

Those earn $3,264 of gross profit. The allowance is paid on all 7,200 units: $5,400. ROI is −40%. It would take about a 278% lift just to break even.

THE TAKEAWAY

ROI = (extra gross profit − promotion cost) ÷ promotion cost. Always ask what lift you need to break even before you set the allowance, and check last year's history (Promotion history calculator).

UNITS FIRST, DOLLARS SECOND

Promotions are built to move volume. Read them in units.

A promotion is there to drive volume, bring in new buyers and households, and get people to try the item. A lower price means fewer dollars per unit, so dollar sales will always understate what the event did. One of the most common mistakes is judging a promotion on dollar sales.

Example: a buy one, get one free offer cuts the price per unit in half. Units have to double, a 100% lift, just for dollar sales to match a normal week. Anything less looks like a loss in dollars even when the event pulled in a wave of new shoppers.

WHEN YOU ARE LOOKING AT
READ IT IN
The promotion weeks
Units, lift over baseline, new households and trial
Whether the promotion paid
Extra gross profit vs the promotion cost (the ROI above)
The weeks after the promotion
Units and repeat buyers: did the new shoppers come back?
The everyday business, share and category reviews
Dollars and units side by side (Lesson 11)
2. Buying volume: when promotion hides the real problem

When everyday sales start to slip, the fastest fix is another promotion. Total volume holds, the period report looks fine, and the problem goes quiet. Underneath, the baseline keeps sliding: what the item sells at its regular price, to shoppers who choose it without a deal.

Each year it takes deeper or more frequent deals to hold the same number, and that funding cannot last forever. This is borrowed volume. It masks a brand that is aging, losing ground to newer brands, or falling behind as diets and trends move on, and it delays the work that would actually fix it.

What it costs to stand still

Hold total volume flat for three years while the baseline slips. Watch how much of it you end up buying.

WORKED EXAMPLE

A brand holds 200,000 units a year. Today 160,000 sell at regular price and 40,000 on promotion. The baseline slips 8% a year, so by year 3 only 135,424 units sell without a deal.

To keep the total at 200,000, promoted units climb from 40,000 to 64,576, and at $1.00 a unit, promotion spending rises from $40,000 to $64,576 a year. That is $157,376 over three years just to stand still, and the brand is weaker at the end than at the start.

Signs you are buying your volume

Baseline down, total flatRegular-price velocity falls year over year while total units hold.
More of the volume on dealThe share of units sold on promotion rises every year.
Deeper deals, same liftIt takes a bigger discount or more events to get the response you used to get.
Fewer new householdsPromotions bring back the same shoppers instead of new ones. That is a household problem, not a volume problem (Lesson 12).

THE TAKEAWAY

Promotion can introduce a brand to new shoppers. It cannot keep them. Category Managers read the baseline whether you show it or not, and a shrinking baseline is what puts items on the cut list.

Report baseline and promoted volume separately every period. Fix the reason shoppers are leaving: innovation, a renovated product or package, the right price and pack size, a real reason to buy. Then use promotion to drive trial of the fix, not to prop up the decline.

Common mistakes

WATCH FOR THESE

1. Calling every unit sold on deal a promotion unit.
2. Ignoring the dip after the deal when shoppers stocked up.
3. Running deep allowances on items that barely lift.
4. Judging a promotion on dollar sales instead of units and lift.
5. Judging a promotion only by volume, never by profit.
6. Propping up a slipping baseline with promotion instead of fixing why shoppers are leaving.

Quick check

Three questions. Tap an answer to see why.

1. Baseline is 500 units a week and the deal week sells 900. What is the lift?

(900 − 500) ÷ 500 = 80%.

2. You pay a $0.50 allowance on 900 units, 500 of which were baseline. How much went to units that would have sold anyway?

500 baseline units × $0.50 = $250 paid for no extra sales.

3. Which promotion is better?

Volume is not profit. Judge promotions on the extra profit against the cost.

Try it with your own numbers

WHAT SHOULD WE TEACH NEXT?

This book is built for all of us. Tell us what you wish someone had taught you: info@cincinnaticpgedge.com.

From Cincinnati CPG Edge, keeping you in the Kroger know.