CPG Business 101, Lesson 13: Distribution: %ACV vs % of stores vs TDP
Three distribution numbers get used as if they were the same thing. They are not. % of stores selling counts doors. %ACV weighs each store by how much business it does. TDP adds it up across every item you sell. Mix them up and you will misread where you stand and what you are missing.
Two brands can both be “in a third of the stores” and have very different reach. % of stores selling counts doors: every store counts the same. %ACV weighs each store by its total sales, its all-commodity volume, so a supercenter counts for far more than a small neighborhood store. One tells you how many stores carry the item. The other tells you how much of the market's shopping happens in those stores.
Move the sliders to put the item in different stores. Each box is a store, sized by its total sales.
Twelve stores, two ways to measure them
3 large stores ($40M each), 4 medium ($20M) and 5 small ($8M). Choose where the item is carried.
WORKED EXAMPLE
The item is in all 3 large stores and 1 medium store: 4 of 12 stores, 33%. Those 4 stores do $140M of the market's $240M in total sales, so the item is at 58% ACV.
Say “we are in a third of the stores” and you undersell it. Say “we are at 58% ACV” and you describe how many shopping trips can actually find it. Flip it around, 5 small stores and nothing else, and the item is in 42% of stores but only 17% ACV: plenty of doors, not many shoppers.
| Measure | How it is calculated | The question it answers |
|---|---|---|
| % of stores selling | Stores that sold the item in the period ÷ all stores in the market. Also called numeric distribution. | How many doors is it in? |
| %ACV | Total store sales (all categories) of the stores selling the item ÷ total store sales of all stores. Also called weighted distribution. | How much of the market's shopping can find it? |
| TDP (total distribution points) | The %ACV of every item in the line, added together. Three items at 60% ACV = 180 TDP. | How much total shelf presence does the brand have? |
| Sales per point of distribution | Sales ÷ %ACV points (for a line, sales ÷ TDP). | How hard does each point of distribution work? |
The trouble: many reports and many people use ACV and % of stores as if they were the same number. They are only the same when every store is the same size. Large stores push %ACV above % of stores; small stores pull it below. Always check which one a report is showing before you quote it.
DO NOT EXPECT 100%
Very few items are in every store. Most never should be.
Full distribution is earned, and it is usually reserved for the brands and items shoppers expect to find on every shelf: the category leaders and household names a store would be questioned for not carrying. For most brands, the realistic goal is the right stores, not all of them.
Stores differ in size, shoppers, local tastes and shelf space, and a Category Manager builds each assortment for the people who shop that store. A strong item can be the right choice for some stores and the wrong one for others. Ask for every store and it signals you do not understand how the shelf is planned. Ask for the stores where your shoppers are, with the data to back it up, and you are speaking the Category Manager’s language.
STORES DOWN, ACV UP
Store count and ACV can move in opposite directions. Say an item is in 7 of the 12 stores above: 1 large, 1 medium and all 5 small. That is 58% of stores but only 42% ACV.
At the next review it is dropped from the 5 small stores and the medium store and added to the other 2 large stores. It is now in just 3 stores, 25% of the count, yet its ACV rises to 50%. Fewer doors, more of the market’s shopping. Try it with the sliders: set 1 large, 1 medium and 5 small, then 3 large and nothing else.
A falling store count is not automatically bad news. Check ACV before you report it, and check sales per store too (Lesson 12).
TDP adds up distribution across every item, size and flavor you sell. It is the best single measure of how much shelf presence a brand has, but it hides where the presence comes from. A brand can grow TDP by adding items in the same stores, or by getting its existing items into more stores. Those are very different stories.
Same shelf presence, different strength
Two brands in the same category. TDP = items × average %ACV.
Brand B has more TDP, but its items are thin on the shelf and each point of distribution earns less. In a category review, sales per point of distribution is how a Category Manager compares brands fairly, whatever their size.
THE TAKEAWAY
Know which distribution number you are looking at, and say it out loud. % of stores tells you how many doors. %ACV tells you how much of the shopping. TDP tells you how much shelf you own. Use all three and you will see gaps and opportunities a single number hides.
WATCH FOR THESE
1. Using %ACV and % of stores selling as if they were the same number.
2. Reading a TDP gain as wider reach when it came from adding items to the same stores.
3. Comparing sales across brands without adjusting for distribution.
4. Counting stores that are authorized but not selling as distribution.
5. Expecting, or promising, distribution in every store.
6. Reporting a lower store count as a loss without checking what happened to ACV.
Three questions. Tap an answer to see why.
1. An item is in 50 of 100 stores, and those 50 stores do 70% of the market's total sales. What are its % of stores and %ACV?
Half the doors, but the bigger half: 50% of stores and 70% ACV.
2. A brand has three items, each at 60% ACV. What is its TDP?
TDP adds the %ACV of every item: 60 + 60 + 60 = 180.
3. Which measure compares sales productivity fairly between a big brand and a small one?
Dividing sales by distribution points removes the effect of size and reach.
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.