Sign in

Blog · Coverage and territory · FMCG and CPG brands

Range penetration by channel: why one SKU list fails for CPG brands

How an FMCG or CPG brand sets a SKU list per retail channel, measures range penetration per store against it, and avoids the single most common failure in distribution analytics: a void list that expects a convenience store to stock the family multipack.

By CoviragePublished 16 September 20263 min read
The short answerRange penetration is the SKUs a store sells against the SKUs it should carry, and the second half of that sentence depends on the channel. Define a SKU list per channel from what stores in that channel actually stock, measure each store against its own channel's list, and value the gaps at the store's rate. A single list across channels produces voids that small stores cannot fill and a field team that stops reading the report in a week.

The fastest way to lose a field team's trust in a distribution report is to tell them a corner shop is missing the family multipack. It is missing it because it cannot sell it, and everyone in the field knows that. The report is measuring against the wrong list. This guide sets out range penetration by channel and how to define the channel list from the brand's own data.

The measure

Per store:

Range penetration = SKUs sold ÷ SKUs on the store's channel list

The channel list is the whole difference. Against the full catalogue, every small store is under-penetrated and the list is noise. Against the channel list, every gap is a conversation the rep can have.

Defining the channel list

  1. Band stores by channel, from the store master.
  2. For each channel, the share of stores selling each SKU in the trailing quarter.
  3. The channel list is every SKU sold by more than half the channel's stores.
  4. Trade marketing may add a SKU to a channel as a labelled override, for a launch or a listing agreement.
SKU Grocery multiples Convenience Discounters
Biscuit 200g 98% 91% 88%
Biscuit 400g 94% 38% 71%
Cracker 150g 87% 62% 44%
Family multipack 76% 9% 52%

At a 50 percent threshold, the convenience list is two SKUs, the discounter list is three, the multiples list is four. A convenience store selling both its SKUs is at full range, and the report says so.

The roll-up

  1. Store by SKU: sold, void, against the channel list.
  2. Store: range penetration, gap value at the store's rate.
  3. Distributor and region: penetration by channel, gaps ranked. Assert that store sales sum to the distributor's file and distributors to reported sell-out.

reported sell-out = Σ regions = Σ distributors = Σ stores = Σ SKUs

A worked example

Two stores, two channels, the same four SKUs.

Store Channel Sold Channel list Penetration Gap value
S5001 Convenience 200g 200g, Cracker 50% $180
S5140 Multiples 200g, 400g 200g, 400g, Cracker, Multipack 50% $920

Same penetration, very different lists. S5001's one gap is a cracker. S5140's two gaps include the multipack at a store that sells the category at scale. Against a single catalogue list, S5001 would have shown three gaps, two of them absurd, and the rep would have skipped the store.

Where it goes wrong

Channel from the distributor's account type. Distributors classify stores for their own purposes. Use the brand's channel definition, on the brand's store master.

Threshold too low. At 30 percent, the convenience list gains SKUs that most convenience stores do not stock, and the gaps return. Half is the honest default.

Launches missing. A new SKU never reaches half of any channel in its first quarter. The override exists for it, labelled.

Channel lists frozen. Ranges change with seasons and listings. Recompute quarterly and keep the history.

Every month, per channel

Mapped once, the sell-out files and the store master produce penetration per store against its channel list, gaps valued and ranked, every month, reconciled to reported sell-out. Covirage builds this from the files as they are. The FMCG and CPG page describes the setup, and the distribution voids guide covers the grid this sits on.

Questions people ask

How do we define the channel list?

From your own sell-out data: for each channel, the SKUs sold by more than half the stores in that channel. That is the channel's core range. The trade marketing team can add a launch SKU as a labelled override.

What if a store is in the wrong channel?

It will show gaps it cannot fill or a range it should not have. The field marks it, the store master is corrected, and the next month's report is right. The report is how the channel data gets fixed.

How many channels?

As many as the trade team plans against: grocery multiples, convenience, discounters, cash and carry, on-trade, and so on. Too few and the lists are wrong; too many and the bands are too small to define a range.

Related reading

Coverage and territory · FMCG and CPG brands

Finding distribution voids from distributor sell-out data

How an FMCG or CPG brand finds the stores that carry the category but not its SKUs from the sell-out files distributors already send: the store-by-SKU grid, the channel-specific range, the valued void list per region and distributor, and the reconciliation to reported sell-out.

16 Sept 20263 min readData quality and reconciliation · FMCG and CPG brands

Out-of-stock per store from sell-out gaps: the SKU that stopped selling on a Tuesday

How a CPG brand infers out-of-stocks per store per SKU from daily or weekly sell-out data without shelf audits: the SKU's own sales rate at the store, the gap that is too long to be chance, the lost sales valued at that rate, the stores and SKUs where gaps recur, and why the inferred figure is a list for the field team rather than a claim against the retailer.

16 Sept 20263 min readTerritory, capacity and quota planning · FMCG and CPG brands

Promo lift per account against the account's own baseline

How a CPG brand measures the uplift from a promotion per retail account from sell-out data: the account's own pre-promo baseline, the lift during, the dip after, the net lift that remains, and the accounts where a promotion moved volume forward rather than adding it, so that trade spend goes where the lift is real.

16 Sept 20262 min readBoard and management reporting · FMCG and CPG brands

Retailer compliance chargebacks by retailer and reason: the deductions that are really a process

How a CPG brand reads its retailer chargebacks and deductions from the remittance and deduction files: chargebacks by retailer, by reason code and by distribution centre, the share that is disputable against the brand's own shipment and delivery records, the reasons that recur at one retailer and nowhere else, the cost per case shipped by retailer, and the two conversations, the brand's own logistics and the retailer's compliance team, that the split points to.

16 Sept 20263 min read