← Back to blog

Distribution Penetration: 640 Doors Authorized, 460 Scanning, a Silent 180-Door Gap

distribution penetrationACVTDPdoor countCPG analyticsretail distribution

A specialty food brand is authorized in 640 stores across six retailers. Scan data shows product moving in 460. The remaining 180 doors, 28% of the authorized universe, accepted the slotting, allocated the shelf space, and are not registering sales. At an average of $4,200 in annual revenue per scanning door, the 180-door gap represents approximately $756,000 in unrealized revenue. The brand's broker report says "we're in 640 doors." The shelf says otherwise.

McKinsey estimates that CPG brands lose 2-5% of net revenue annually to distribution voids, authorized locations where product is not present or not scanning. For a $25M brand, that is $500K to $1.25M per year. The loss does not appear on any invoice. It appears as the revenue that was structurally possible and simply did not happen.

These numbers define distribution penetration: the percentage of addressable doors that are actually carrying and selling the product. It is the denominator underneath everything else: velocity, household penetration, and trade ROI. A velocity calculation that uses total distribution as its base is wrong by exactly the percentage of doors that are authorized but not scanning. A trade spend analysis that assumes full distribution is overstating the return on every promotional dollar.

Raw door count lies. ACV% tells the truth.

Being in 30% of a retailer's stores is a very different business depending on which 30%. Three hundred doors of high-volume urban locations represent more sales potential than 300 rural low-traffic stores. The door count is the same. The revenue opportunity is not.

This is why the metric that matters is ACV%, all commodity volume percentage. ACV% measures the share of total commodity volume flowing through the stores that carry the product. A brand in 200 high-volume doors might have 45% ACV. A brand in 200 low-volume doors might have 12% ACV. Both brands are "in 200 doors." One has nearly four times the sales opportunity of the other.

NielsenIQ defines weighted distribution (ACV%) as the standard measurement for distribution quality in CPG. Unweighted door counts are useful for operational logistics: how many deliveries to schedule, how many shelf sets to manage. ACV% is useful for commercial strategy: how much of the market has access to the product.

Total Distribution Points (TDP) layers on top: the sum of ACV% across all items in the portfolio. TDP captures both breadth (how many items are distributed) and depth (how broadly each one reaches). A brand can grow TDP by adding items to existing doors or by expanding existing items to new doors. The distinction matters because the two strategies have different costs, different timelines, and different S&OP implications.

The authorized-but-not-scanning gap is the most expensive silence in CPG

A door that is authorized but not scanning represents a completed sale that generated no revenue. The brand paid the slotting fee. The buyer approved the item. The planogram includes it. And the product is either not on the shelf (out-of-stock, never set, discontinued at store level without notification) or on the shelf and not scanning (barcode issue, wrong location, scan data transmission failure).

Each scenario has a different fix. A store that was never set needs a reset visit from the broker. A store with chronic out-of-stocks needs a replenishment investigation: is the DC shipping to that location, is the store ordering, is the minimum order quantity set correctly? A store where the product is present but not scanning has a data problem: the UPC in the POS system does not match the barcode on the package, or the item is filed under the wrong category and scan data is not flowing to the brand's reporting feed.

On-shelf-availability analyses find that authorization voids, rather than true out-of-stocks, account for the large majority of on-shelf gaps in a given quarter. The voids are not random. They cluster in specific stores, specific items, and specific time windows, often around resets, new item launches, and promotional periods. The pattern is detectable if someone is tracking door-level data. At most brands under $50M, nobody is.

Slow leaks erode distribution without triggering an alarm

A brand losing two doors per month at one retailer loses 24 doors in a year. At $4,200 per door, that is $100,800 in annual revenue, not enough to trigger a quarterly review, but enough to shift the P&L over two years. The doors do not all go dark at once. One store resets and does not re-slot the item. Another drops below the reorder threshold and the DC stops shipping. A third switches to a competitor that offered a better promotional package.

These are the slow leaks. They appear as a gradual decline in scanning door count that aggregate sales data hides; same-store velocity increases can mask the door-count decline for two or three quarters. By the time the topline reflects the distribution loss, the shelf space is gone and the cost of recovery exceeds the cost of prevention by an order of magnitude.

Door Math tracks this. Four views: Door Count (current authorized vs. scanning by item and retailer), Trends (ACV% and TDP trajectory over time), Exceptions (the authorized-but-not-scanning list with store-level detail), and Scorecard (a one-page summary for the broker meeting). The tool runs on Cinderhaven Provisions, a synthetic $25M specialty food brand, 50 SKUs across 640 doors and six retailers. Two items in the demo (CHP-DG-003 and CHP-SC-007) are quietly losing doors quarter over quarter without an obvious signal. That is the pattern the tool is built to catch.

Distribution is the denominator for every other metric

Penetration means three different things, and distribution penetration is the most literal: is the product physically available for purchase? Before velocity, before household trial, before any marketing dollar can generate a return, the product has to exist on a shelf. A brand investing in awareness while 28% of its authorized doors are not scanning is spending money to drive shoppers to a shelf that is empty.

The three tools in the penetration family each answer one question. Door Math answers: are we on the shelf? Spin Rate answers: once we're there, how fast are we selling? Decompose answers: are more people buying us, or are fewer people spending more? Start with distribution. If the doors are not scanning, nothing downstream matters.

The gap report names the stores and items where revenue is missing

Lailara runs the distribution penetration analysis on client POS and authorization data, door-level scanning vs. authorization, ACV% and TDP trends, and the exception list that names the specific stores and items where revenue is authorized but not arriving. The deliverable is the gap report that goes to the broker meeting. Book a 30-minute scoping call to scope the data pull and identify where your 180-door gap is hiding.