CPG Business 101, Lesson 12: What is driving the change
A number without its cause is only half the story. Down 10% sounds like trouble until you learn the item lost half of its stores. Before you explain a change, or let someone else explain it for you, break it into the parts that drive it.
Your brand is down 10% in units and 11% in dollars. Bad news? Not if the retailer cut the item from half of its stores. The stores that still carry it are selling far more of it than before, and the negative number becomes a positive story: shoppers want this item, and they are buying more of it wherever they can still find it.
Every change in sales has a cause. Before you report a number, split it into what moved: the stores selling the item, the sales per store, and the price.
Split the change: stores vs sales per store
Last year vs this year, same weeks. Change the store counts to see the story flip.
WORKED EXAMPLE
Last year the item sold 100,000 units in 1,000 stores at an average of $3.99. This year it sold 90,000 units at $3.95, but in only 500 stores. Units are down 10% and dollars are down 10.9%.
Per store, the picture flips. Units per store per week rose from 1.92 to 3.46, up 80%, and dollars per store rose 78%. Losing half the stores cost 50,000 units; stronger sales in the stores that kept it won back 40,000. That is not a failing item. It is an item that earned its space and lost stores anyway, and that is the case for winning them back.
Every sales number breaks down the same way. Learn these three lines and you can explain almost any change.
| Driver | What moves it | What it tells you |
|---|---|---|
| Stores selling | New stores, cuts at a category review, voids, out-of-stocks | Reach: how many shoppers can find the item |
| %ACV and TDP | Distribution weighted by store size; TDP adds it up across all your items, sizes and flavors | How much shelf presence you have, and whether it is growing |
| Units per store per week | Shelf placement, facings, price, promotion, competition | Health: how well it sells where it is |
| Average price | Price changes, promotion depth and frequency, the mix of sizes sold | Whether a dollar change is real demand or just price |
| Households | Trial, new buyers, lapsed buyers | How many shoppers the brand reaches |
| Units per household | Loyalty, repeat, pack size, how often it is used | How much each shopper buys |
| Weeks and calendar | Period length, holiday shifts, a 53rd week | Whether you are comparing like with like |
Store data tells you where the change happened. Shopper data tells you who changed. Units can hold steady while the brand quietly loses shoppers, because the loyal ones who stay are buying more.
Split the change: shoppers vs how much they buy
Last year vs this year, same weeks.
If households are falling and buy rate is rising, you have a loyal core and a reach problem. The fix is trial: new households, not deeper deals for the shoppers you already have.
When sales go soft, the reflex is to promote. But if the decline is coming from fewer households, a deal will not fix it. Promotions mostly reach the shoppers you already have: they buy a little more, a little sooner, and the households you lost stay lost. You end up paying more and more to sell to a shrinking base.
Treat it as a brand question first: where are your households going? The retailer's shopper data can answer most of it, and your Category Manager and the retailer's insights team can help you read it. Bring your own view of the brand and the category to that conversation.
Where did they go?
QUESTIONS TO BRING TO THE DATA
1. Are households down, or is buy rate down? (The chart above.)
2. Are we losing households faster than the category?
3. Where did our lapsed households go: which brands, which retailers, or out of the category?
4. Who are our new buyers, and are they coming back for a second purchase?
5. How do our buyers compare with the category's buyers by age and life stage?
THE TAKEAWAY
You cannot promote your way out of a household problem. Fix the reason they left, then earn them back with trial: items, sizes and flavors that fit how people eat now, packaging and claims that speak to the next generation of shoppers, offers aimed at lapsed and never-tried households, sampling, and placement where new shoppers will see you.
Measure it in new households and repeat buyers, not in units sold on deal.
THE TAKEAWAY
Never report a change without its cause. Break every change into its drivers before you explain it, or before someone else explains it for you. The same number can be a warning or a win depending on what drove it.
WATCH FOR THESE
1. Reporting the total change without separating stores from sales per store.
2. Comparing periods with different store counts, weeks or holiday timing.
3. Calling dollar growth healthy when price did all the work.
4. Celebrating a higher buy rate while households quietly shrink.
5. Answering a household loss with deeper promotions instead of finding out where the shoppers went.
Three questions. Tap an answer to see why.
1. Units fell 10% after the item lost half of its stores. What happened to units per store?
Units per store = 0.90 ÷ 0.50 = 1.80, up 80%. Each remaining store sells far more.
2. In the same stores, dollars are up 6% and units are down 2%. What drove the dollars?
Units fell in the same stores, so the gain came from price.
3. Households are down 10% and units per household are up 10%. What happened to units?
0.90 × 1.10 = 0.99, so units are down about 1%, even though both drivers moved 10%.
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.