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 12: What is driving the change

CPG BUSINESS 101 |  LESSON 12 OF 15

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.

1. The same number, two very different stories

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.

2. The driver tree

Every sales number breaks down the same way. Learn these three lines and you can explain almost any change.

Dollars= Units × Average price
Units, the store view= Stores selling × Units per store per week × Weeks
Units, the shopper view= Households × Units per household
DriverWhat moves itWhat it tells you
Stores sellingNew stores, cuts at a category review, voids, out-of-stocksReach: how many shoppers can find the item
%ACV and TDPDistribution weighted by store size; TDP adds it up across all your items, sizes and flavorsHow much shelf presence you have, and whether it is growing
Units per store per weekShelf placement, facings, price, promotion, competitionHealth: how well it sells where it is
Average pricePrice changes, promotion depth and frequency, the mix of sizes soldWhether a dollar change is real demand or just price
HouseholdsTrial, new buyers, lapsed buyersHow many shoppers the brand reaches
Units per householdLoyalty, repeat, pack size, how often it is usedHow much each shopper buys
Weeks and calendarPeriod length, holiday shifts, a 53rd weekWhether you are comparing like with like
3. The shopper side: households and buy rate

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.

4. A household problem is not a volume problem

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?

To a competing brandA newer or better-positioned brand in the same set is winning them. Look at who picked up the households you lost.
To the store brandThe price gap grew too wide for what your brand offers. Check your gap to private label over time.
To another retailerThey still buy your brand, just somewhere else. Compare your trend at this retailer with your trend across the market.
Out of the categoryDiets and habits moved on, and fewer households buy the category at all. Check category households, not only yours.
Aging outYour loyal buyers are older and buying less, and younger households are not replacing them. Compare the age and life stage of new and lapsed buyers.
They cannot find itVoids, out-of-stocks or a weak shelf position. Rule out distribution before you blame the shopper (Lesson 3).

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.

5. Turn the number into the story
Fewer stores, stronger per storeA distribution story. Show the sales per store and make the case to win the stores back.
Same stores, weaker per storeA real demand problem. Look at price gaps, shelf position, competition and promotion.
Fewer households, higher buy rateA loyal core with shrinking reach. Invest in trial.
Dollars up, units downPrice did the work. Ask how long shoppers will keep paying it.
Growing, but slower than the categoryGrowth with a share loss (Lesson 11). Fair share is the bar.
More items, same totalNew items taking sales from your own items. Check what each item adds.

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.

Common mistakes

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.

Quick check

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%.

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.