CPG Business 101, Lesson 7: 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.
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 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
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.
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.
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.
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.