Numeric Distribution Vs. Weighted Distribution: When To Use Each

Numeric Distribution is the percentage of stores in a defined market that carry a particular product. Understanding how numeric distribution compares to weighted distribution is essential for aligning availability metrics with revenue and category goals.

What Numeric Distribution Tells You

Numeric distribution counts presence across outlets. It answers the question: in how many stores can a shopper find my product? Because it treats every store equally, it’s most useful for measuring breadth of reach and for operational tasks like onboarding stores or managing basic assortment coverage.

What Weighted Distribution (ACV/PCV) Tells You

Weighted distribution replaces the simple store count with a measure of store importance. Common weightings are All Commodity Volume (ACV) — sales across all categories — or Product Category Volume (PCV) — sales within the product’s category. Weighted distribution reflects sales exposure rather than just physical presence.

Key Differences In Practical Terms

• Equal Versus Proportional Value: Numeric gives each store equal weight; weighted gives each store weight proportional to its sales or category volume.
• Availability Versus Revenue Exposure: Numeric shows where a product exists; weighted shows how much of the market’s sales potential the product reaches.
• Use Case Differences: Numeric is tactical (shelf entry, coverage reporting). Weighted is strategic (revenue forecasting, trade spend optimization).

When Numeric Distribution Is The Right Choice

Choose numeric distribution when your priority is physical presence or operational rollout. Common scenarios include:

• New SKU Launches: Tracking which targeted stores have accepted and stocked the SKU.
• Assortment Compliance: Ensuring stores in a chain have the SKU in assortment lists.
• Field Team Targets: Setting store-level penetration goals for merchandising teams.

When Weighted Distribution Is Better

Weighted distribution should be used when the goal is to understand sales potential or the commercial impact of distribution gaps:

• Maximizing Revenue: Prioritize high-ACV stores to increase sales quickly.
• Trade Investment Planning: Allocate promotions where they will reach more category dollars.
• SKU Rationalization: Decide which SKUs to keep by comparing weighted exposure against sales performance.

How To Use Both Metrics Together

Most effective commercial strategies use numeric and weighted distribution in tandem. Common approaches:

• Two-Stage Goals: Use numeric distribution to establish baseline presence, then drive weighted distribution improvements in high-performing stores.
• Segmentation: Report numeric distribution for store counts per segment (rural, urban, convenience) and weighted distribution within each segment for revenue focus.
• Performance Diagnostics: If numeric distribution is high but sales are low, examine weighted distribution and on-shelf availability to find the gap.

Example Comparison

Imagine Brand A is in 60% of stores (numeric distribution) but in only 30% of national ACV (weighted distribution). That means presence is broad but skewed toward smaller stores; the brand may under-index in major high-sales outlets. Conversely, Brand B might be in 25% of stores but cover 55% ACV — presence concentrated in big-volume locations, producing stronger revenue per distribution point.

Reporting And Data Considerations

Ensure your store universe and sales weights are up-to-date. ACV requires reliable sales data (POS or syndicated data). Numeric distribution requires accurate store-assortment or merchandising confirmations. Misaligned universes or stale weighting data will produce misleading comparisons.

In short, the Numeric Distribution percentage gives you the 'how many stores' view; combine it with weighted distribution to understand 'how much of the market' those stores represent and to make better trade and assortment choices.