Numeric vs. Weighted Distribution
Numeric vs. weighted distribution is one of the most practical distinctions in CPG retail analytics. Numeric distribution is the share of stores that carry your item, counted equally regardless of store size. Weighted distribution adjusts that share by each store's all-commodity sales volume, so a 50,000-square-foot Kroger flagship counts far more than a small independent outlet.
This post breaks down how each metric is defined and calculated, shows a worked example where the two numbers diverge by 30 points, and explains which metric to reach for in which situation. It is aimed at brand managers and sales analysts working with syndicated data from SPINS, Circana, or NielsenIQ.
Numeric distribution, defined
Numeric distribution answers a simple question: what fraction of stores in a given market or channel carry your SKU? Every store counts once, regardless of whether it rings $500 a week or $50,000.
Numeric distribution formula
The numeric distribution formula is:
Numeric Distribution (%) = (Stores carrying the item / Total stores in the universe) x 100
If your oat-milk creamer is on shelf in 1,200 of the 3,000 natural grocery stores tracked by a data provider, your numeric distribution in that channel is 40%. It does not matter whether those 1,200 stores are high-volume urban flagships or low-volume rural independents. Every door gets one vote.
Numeric distribution is sometimes called "store count distribution" or simply "% stores selling." Syndicated data sources report it at the market, region, or total-US level depending on the panel.
What numeric distribution tells you
A high numeric distribution means the item is widely seeded across the store network. That matters for availability and brand visibility, and it is the metric most closely tied to what a field sales team can actually execute on. When a broker reports "we're in 80% of doors," they're quoting numeric distribution.
The limitation is obvious: a store is a store. A chain that opens 400 small-format locations in a market can inflate your numeric distribution substantially without moving proportional volume.
Weighted distribution (%ACV), defined
Weighted distribution weights each store by its share of total all-commodity volume (ACV) in the measured universe. All Commodity Volume (ACV) is the total dollar sales across all categories at a given store or set of stores. A store that generates 1% of the universe's total sales contributes 1 percentage point to your weighted distribution when it carries the item.
Weighted distribution formula
Weighted Distribution (%) = (Sum of ACV for stores carrying the item / Total ACV of the universe) x 100
Using the same oat-milk creamer: if those 1,200 stores that carry it account for $6.2 billion of the $8.0 billion in total natural grocery ACV, your weighted distribution is 77.5%. You are in 40% of doors but those doors represent 77.5% of the channel's spending power.
This metric is also written as "% ACV distribution" or "ACV-weighted distribution." The % ACV Distribution Explained post covers the exact data-provider definitions and how the numerator is constructed from panel data.
What weighted distribution tells you
Weighted distribution is the better proxy for your volume opportunity. If you add one Walmart Supercenter that accounts for 0.3% of channel ACV, your weighted distribution moves by 0.3 points even though your numeric distribution barely ticks up. The reverse is also true: seeding hundreds of small independents can look impressive on numeric distribution while barely moving the weighted number.
Because it reflects sales capacity, weighted distribution is the metric buyers and category managers tend to ask about when evaluating a brand's distribution health. It is also the foundation of Total Distribution Points (TDP), which aggregates weighted distribution across SKUs.
The key difference: store count vs. sales importance
The core distinction in numeric vs. weighted distribution comes down to what you treat as equal. Numeric distribution gives each store an equal vote. Weighted distribution allocates votes proportionally to each store's share of total retail spending.
Neither metric is wrong. They measure different things:
- Numeric distribution measures coverage breadth (how widely distributed is the item?)
- Weighted distribution measures coverage depth (how much of the market's spending power can find the item?)
- A brand with high numeric but low weighted distribution is spread thin across small accounts.
- A brand with low numeric but high weighted distribution is concentrated in a few major retailers.
| Dimension | Numeric Distribution | Weighted Distribution (%ACV) |
|---|---|---|
| What it counts | Stores carrying the item | ACV of stores carrying the item |
| Each store's weight | Equal (1 vote per store) | Proportional to store's share of total ACV |
| Best for | Field execution, door coverage | Volume opportunity, buyer conversations |
| Inflated by | Small-format expansion | One or two large anchor retailers |
| Typical range for a growing brand | 20-60% | 40-80% |
| Data source | Store panel (SPINS, Circana, NielsenIQ) | Same panel, weighted by store ACV |
A worked example: when numeric and weighted distribution diverge
Suppose a hot sauce brand, Ranger Fire, sells through the natural channel. The relevant universe is 4,000 stores with a combined ACV of $10 billion.
Ranger Fire is carried by two retailer groups:
- Group A: 600 mid-size regional health food stores. Each store averages $1.5 million in annual ACV. Total ACV for Group A = $900 million.
- Group B: 1,400 small independents and co-ops. Each averages $300,000 in annual ACV. Total ACV for Group B = $420 million.
Ranger Fire is now in 2,000 of 4,000 stores. Numeric distribution = 50%.
The combined ACV of stores carrying Ranger Fire is $900M + $420M = $1.32 billion. Weighted distribution = $1.32B / $10B = 13.2%.
That gap (50% numeric vs. 13.2% weighted) is a clear signal: Ranger Fire has broad door coverage but is almost entirely concentrated in low-volume accounts. The natural channel's high-ACV stores (think large co-ops, Whole Foods, well-capitalized regional chains) are not carrying the product. A buyer at one of those chains who asks "what's your ACV distribution?" will hear 13.2%, not 50%, and understand the brand has not yet cracked the volume-weighted tier of the market.
Now flip the scenario. Ranger Fire wins distribution at a single national natural chain with 200 stores that collectively account for $3 billion of the $10 billion universe ACV.
- Numeric distribution: (200 + 600 + 1,400) / 4,000 = 2,200 / 4,000 = 55%
- Weighted distribution: ($3B + $900M + $420M) / $10B = $4.32B / $10B = 43.2%
Adding 200 doors moved numeric distribution by only 5 points (from 50% to 55%), but weighted distribution tripled (from 13.2% to 43.2%). That chain's doors were worth 30% of total channel ACV by themselves.
When each metric matters
Use numeric distribution for field execution
When you are tracking whether your DSD network or broker force is placing the product, numeric distribution is the direct measure. A sales rep covers a route of 80 stores. Getting into 60 of those 80 is 75% numeric distribution on that route. It is countable, auditable, and tied to individual account activity.
Numeric distribution is also the right metric when you are entering a new region and need to establish any physical presence before chasing volume. Getting to 30% of doors creates the shelf presence that supports marketing and sampling activations.
Use weighted distribution for strategic prioritization
When you are deciding which accounts to invest sales resources in, weighted distribution surfaces the opportunity cost of your current gaps. If you are at 60% weighted distribution and your top competitor is at 85%, the 25-point gap is concentrated somewhere. Pulling the store-level data shows exactly which high-ACV accounts you do not yet have.
Weighted distribution is also what investors and brokers use to estimate a brand's velocity potential. A brand at 20% weighted distribution that achieves strong velocities has a clear case for expanding into the remaining 80% of ACV.
Reading them together
The most diagnostic view is the ratio of weighted to numeric distribution. A ratio near 1 (say, 55% numeric and 52% weighted) means you are proportionally distributed across store sizes. A ratio well above 1 (50% numeric, 80% weighted) means you over-index in large stores. A ratio well below 1, as in the Ranger Fire example above, means your doors are concentrated in small-volume accounts.
Harmonized syndicated data platforms like Scout surface both metrics side by side, so you can see a brand's distribution profile across markets and banners without manually stitching SPINS or Circana exports.
How distribution metrics connect to velocity and TDP
Distribution metrics become most powerful when combined with velocity (sales per point of distribution). A brand with 80% weighted distribution and strong velocity is performing well everywhere it is sold. A brand with 80% weighted distribution but weak velocity has a shelf presence problem, not a distribution problem.
Total Distribution Points (TDP) extends the weighted distribution concept across multiple SKUs. A brand's TDP is the sum of the ACV-weighted distribution for each item in its portfolio. A five-SKU brand where every SKU is at 60% weighted distribution has 300 TDP. TDP is useful for tracking portfolio-level gains and losses, especially when individual SKUs are going through distribution changes at different rates.
One important note on terminology: in some retail contexts, "weighted distribution" refers to load-balancing or freight distribution (as in trailer-hitch weight ratings). This post uses the term exclusively in its CPG retail analytics sense, where it refers to ACV-weighted store distribution. That is the standard definition used by SPINS, Circana, NielsenIQ, and category management teams across the grocery, natural, and mass channels.
Frequently asked questions
- What is numeric distribution in CPG retail?
- Numeric distribution is the percentage of stores in a given universe that carry a specific item, with every store counted equally regardless of size or sales volume. If a product is on shelf in 800 of 2,000 stores, its numeric distribution is 40%. It is also called store count distribution or % stores selling.
- What is the numeric distribution formula?
- Numeric Distribution (%) = (Number of stores carrying the item / Total stores in the universe) x 100. The denominator is the total store count for the channel, market, or geography being measured, as defined by the syndicated data provider's panel.
- What is weighted distribution and how does it differ from numeric distribution?
- Weighted distribution (also called % ACV distribution) weights each store by its share of total all-commodity volume rather than giving it an equal vote. A store that accounts for 2% of channel ACV contributes 2 points to your weighted distribution when it carries the item. Numeric distribution treats every store equally. The two metrics diverge most when your distribution is skewed toward either very large or very small stores. See % ACV Distribution Explained for a deeper treatment of how ACV weighting works.
- Why might numeric distribution be higher than weighted distribution?
- Numeric distribution exceeds weighted distribution when an item is carried mostly by small-volume stores. Many small independents, specialty shops, or low-volume outlets each add one count to the numeric tally but contribute little to total channel ACV. A brand with 60% numeric and 20% weighted distribution has wide door coverage but is largely absent from the high-volume retailers that drive the majority of category sales.
- Which distribution metric should I show a retail buyer?
- Buyers and category managers at major retailers almost always ask for weighted distribution (% ACV distribution) because it tells them how much of the relevant market's spending power can already access the product. Numeric distribution is more useful internally for tracking field-execution progress. When presenting to a buyer, lead with weighted distribution and use numeric distribution as context for physical store count.
See this on your own data
Scout gives CPG sales teams the analytics infrastructure they need — without spreadsheets.
Get a 15-min demo