ACV-weighted distribution in SPINS across multiple retailers

Why ACV-weighted distribution in SPINS is easy to miscalculate

A brand sells through Sprouts, Natural Grocers, and the KeHE / UNFI– distributed independent natural channel. The CEO asks the same question the CEO always asks: what's our distribution? The analyst pulls SPINS, exports three retailer files, and tries to add up the ACV numbers.

If the analyst sums ACV across the three cuts, they get a number that can exceed 100% — which is structurally impossible and obviously wrong, but also the natural thing to do at first. Conversely, if the analyst averages the three ACVs, they get a number that under-weights the retailers driving most of the category's dollars and over-weights the small ones.

Neither approach is right. The correct calculation is a single ACV-weighted distribution number against a unified channel denominator — and the way SPINS structures its data makes it easy to do this wrong by default.

The ACV-weighted distribution formula

ACV-weighted distribution at the channel (or multi-retailer) level follows the same definition as single-retailer ACV, just with a wider denominator:

ACV % = (sum of total category $ at stores carrying the brand, across all measured stores in the channel) ÷ (sum of total category $ across all measured stores in the channel) × 100

The key is "across all measured stores in the channel." The denominator is the universe of all stores SPINS measures in the channel — not the union of stores across the retailer cuts you pulled.

Five steps to do this correctly in SPINS:

1. Define the channel boundary first. Are you reporting in Natural channel, MULO+, Total US Multi-Outlet + Natural, or a custom retailer set? Each has a different denominator. The number you produce is meaningless without naming this. The three most common choices for natural brands: (a) Natural Channel only — the SPINS-defined universe of natural and specialty retailers; (b) the brand's own retailer set — e.g., "Sprouts + Natural Grocers + KeHE/UNFI independents" as a custom channel; or (c) MULO+ — the natural channel overlaid on conventional MULO. Each produces a meaningfully different ACV percentage for the same brand.

2. Pull the brand's sales at the channel level, not at the per-retailer level. SPINS will compute ACV against the channel denominator if you ask the right cut. Per-retailer pulls compute ACV against the per-retailer denominator, which is what creates the addition trap.

3. Cross-check with the per-retailer pulls. The channel ACV should always be ≤ the sum of weighted per-retailer ACVs (after converting to the channel basis), and ≥ the largest single per-retailer ACV. If your channel number is outside this band, something is wrong with the cut. Practically: if your biggest single-retailer ACV is 42% (say, Sprouts) and your channel ACV comes back at 38%, that's plausible. If channel ACV comes back at 55%, you've pulled against the wrong denominator.

4. Don't mix direct-scan and distributor-flow retailers without awareness. ACV at a direct-scan retailer like Sprouts and ACV at independent natural (distributor-flow estimated) are computed from different data sources with different reliability. Aggregating them at the channel level is fine — that's what the channel cut does — but reporting them as if they were equally precise is misleading. Distributor-flow ACV has more variance and is more prone to panel events (see Reading SPINS panel coverage).

5. Document the channel definition you used. Future-you and the sales team need to be able to reproduce this. "45% ACV" without a channel name is a number nobody can defend in a quarterly review. The documentation should be one sentence: "ACV across the SPINS Natural Channel definition, L12W ending [date]."

The multi-retailer ACV error: why stitching per-retailer pulls fails

The wrong approach (and the one most analysts try first when they don't have a single channel-level pull):

Summing per-retailer ACVs gives 143%, which is nonsense. The error isn't in the data — it's that ACV is a percentage of a denominator that is the same store set in each row. You can't add four percentages of the same denominator.

The correct approach: compute ACV against the unified channel denominator of $3,000K total category dollars across the four retailers:

$1,000K ÷ $3,000K = 33.3% ACV (channel-weighted)

That's the defensible number. It's lower than the simple average (35.75%) because the natural-grocers and independent-natural retailers contribute disproportionately less category dollars per unit of brand exposure.

The right answer is closer to "let SPINS compute it"

In practice, the cleanest path is to ask SPINS for the channel-level ACV directly. The portal supports custom channel definitions. If you're stitching together a custom multi-retailer view that doesn't match a standard channel, the cleanest workaround is:

• Pull dollar-level data per retailer (brand $ and category $)
• Sum both numerators and denominators at the channel level
• Compute ACV from the summed numbers, not from per-retailer ACVs

This avoids the addition trap while still letting you build custom retailer combinations.

Worked example — quarterly executive report

A wellness brand wants to report to the board:

"Our distribution in Natural Channel + MULO Sprouts + the independent natural distributors that cover our category is X%."

Step-by-step:

1. Channel definition: Sprouts + Natural Grocers + KeHE-UNFI independent natural + regional natural retailers = the brand's relevant universe. Pulled as a custom channel in SPINS.
2. Pull category $ per retailer for the relevant 12 weeks ending. Sum: $3,000K (matching the table above).
3. Pull brand $ per retailer for the same period. Sum: $1,000K.
4. Compute ACV = $1,000K ÷ $3,000K = 33.3%.
5. Report: "ACV-weighted distribution across our core natural channel set is 33.3% for the 12 weeks ending [date]. Sprouts and the long tail of regional naturals are the heaviest weighted contributors."

That's the report. It's defensible because the channel definition is named, the denominator is unified, and per-retailer detail is provided alongside the channel number.

Tracking ACV velocity: how fast is distribution growing?

ACV at a single point in time tells you where you are. ACV velocity — the week-over-week or period-over-period change in ACV — tells you how fast the brand is gaining or losing distribution. For a brand in active distribution expansion, ACV velocity is often a more important metric to watch than the absolute level.

A useful tracking table for a growth-stage brand:

The deceleration from +7 points per quarter to +1 point signals that the brand is approaching natural ACV saturation in its current channel. The strategic implication: distribution expansion as a growth driver is nearly exhausted; future growth needs to come from velocity improvement at existing doors or from new channels.

Always pair ACV velocity with store count change. ACV can technically move from projection or panel-composition changes without any real distribution change — cross-checking against absolute store count keeps you honest (see Reading SPINS panel coverage).

ACV targets by brand stage

The right ACV level to target depends on where the brand is in its distribution lifecycle. Rough benchmarks for natural channel:

These are rough benchmarks, not targets. A 30% ACV brand in a specialty supplement category might be the category leader; 30% ACV in a snack bar category could be mid-table. The benchmark that matters is your brand's ACV relative to the category leader in your SPINS channel cut — not absolute ACV relative to some abstract stage model.

Anti-patterns in ACV-weighted distribution reporting

Using per-retailer ACV to pitch new distribution. When pitching a new retailer, some brands present their ACV at existing retailers as proof of distribution health. "We're at 50% ACV at Sprouts" is meaningful to a Sprouts buyer, but "we're at 50% ACV" without naming the retailer is misleading — a Whole Foods buyer will read it as 50% of Whole Foods, which is almost certainly false. Always name the retailer alongside the ACV figure.

Comparing ACV across channels without adjusting the denominator. A brand at 35% Natural Channel ACV and 12% MULO ACV isn't necessarily "better" at natural than conventional — those are different denominators representing entirely different store universes. Natural Channel ACV measures percent of natural-channel category dollars; MULO ACV measures percent of MULO category dollars. Cross-channel ACV comparisons require labeling and context, not just the numbers.

Reporting ACV without a time stamp. ACV changes week over week as the panel updates. A 52-week ACV from last quarter's report is not the same as a 52-week ACV from this quarter's report — the ending week is different. Every ACV figure needs a period endpoint (e.g., "L12W ending April 26, 2025").

Treating ACV improvement as velocity improvement. ACV going up means the brand is in more important stores. It says nothing about how fast the product sells in those stores. A brand that gains 10 points of ACV by entering low-velocity independent natural accounts might have lower average velocity per door even as ACV rises. When presenting growth, always decompose total dollar growth into its ACV component vs. its velocity component:

Total dollar growth = (ACV change × prior velocity) + (velocity change × current ACV) + (interaction term)

The decomposition tells the strategic story: is growth coming from new doors or better performance at existing doors?

What to say when the ACV number gets challenged

"Why is your MULO ACV lower than your Natural Channel ACV?" — The denominators are different. MULO includes all conventional grocery, drug, and mass retailers. A brand concentrated in natural channel will always have lower MULO ACV than Natural Channel ACV, not because it has fewer stores but because the MULO denominator is much larger and dominated by conventional retailers where the brand may not be distributed at all.

"Your ACV went up but your sales went down — what happened?" — Classic new-door quality problem. New-door additions that were lower- volume accounts (low category rate) lifted ACV but didn't add much actual sales. Velocity at those doors may also be below the brand average. Decompose: if new doors average $22/store/week while existing doors average $58/store/week, the new-door cohort is diluting the velocity average even as it lifts the distribution metric.

"Why can't I just add up the SPINS ACV numbers I see in the reports?" — Because each row's ACV is computed against that row's retailer denominator. Adding rows adds apples and oranges. Use the channel-level pull or sum brand$ and category$ raw before dividing.

Doing this in Scout

Scout reports ACV columns straight from the SPINS extracts at whatever channel cut your team pulls — so the channel-level ACV is the number SPINS computed, against the denominator SPINS defined. For ad-hoc multi-retailer combinations that don't match a standard channel, the same dollar-sum approach above applies — sum brand dollars and category dollars across the relevant retailer columns, divide. Scout's table view makes this a sum across rows rather than a calculation across pivot tables. The ACV velocity tracking use case — plotting ACV over time alongside store count — is a standard view in Scout's distribution-trend surface.

Summary + further reading

• ACV is a percentage of a denominator. Adding per-retailer ACVs produces meaningless numbers because the denominators differ.
• The correct multi-retailer ACV is computed against the unified channel denominator: sum brand $ across retailers, sum category $ across retailers, divide.
• Always name the channel definition when reporting an ACV number — "33.3% ACV in our natural-channel relevant universe, L12W ending [date]" is defensible; "33.3% ACV" alone is not.
• ACV velocity (change per period) often matters more than absolute level for a growth-stage brand; track it alongside store count to separate real door gains from panel-composition changes.
• Decompose dollar growth into ACV change vs. velocity change — the two imply very different strategic responses.

Related: What is ACV? · Reading SPINS panel coverage