Household Panel Data Interpreter

Example output

Household panel read — Brightleaf cold-brew coffee, 52 weeks (Numerator, US)

Headline
This is a shrinking-but-more-loyal buyer base — fewer households are buying Brightleaf at all, but the ones who do are buying more often and coming back more reliably. That combination usually points to a trial or acquisition problem, not a product or satisfaction problem.

What the numbers show
- Penetration fell from 4.8% to 4.2% of households — roughly a 12.5% relative decline in how many households bought Brightleaf even once this year. This is the number that should worry leadership most, because penetration is typically the hardest metric to rebuild once it slips — it means fewer new households are trying the brand.
- Repeat rate climbed from 34% to 38% — of the households who did buy, a larger share came back for a second purchase. This is a genuinely healthy signal: it suggests the product itself is not driving people away once tried.
- Buying rate rose from 2.6 to 3.1 purchases per buyer per year — your existing buyers are buying more often, not just repeating once. Combined with the repeat-rate gain, this tells you retained buyers are becoming more loyal, not less.

The diagnosis
Put together, this is not a story about people trying Brightleaf and being disappointed — repeat and frequency both improved, which is the opposite of what a satisfaction problem looks like. This is much more likely an acquisition or trial problem: either fewer new households are discovering or trying the brand, or a group of former buyers has stopped buying entirely for a reason unrelated to product experience — a distribution change, a price change, or a shift in where they shop.

What this data alone cannot tell you
- Whether the penetration decline is concentrated in lapsed former buyers (people who used to buy Brightleaf and stopped) or in never-tried households (people who were never exposed to it) — these need different fixes: win-back for the former, trial-driving distribution or sampling for the latter. Panel data can usually split this out with a buyer-flow or gain-loss analysis if your provider offers it — worth requesting as a follow-up cut.
- Whether the penetration drop tracks a specific event — a distribution loss at a retailer, a price increase, a promotional pullback — since the 52-week window alone doesn't show you when in the year the decline happened without a sub-period breakout.
- Whether competitors gained the households you lost, or the category itself contracted — this needs a category-level penetration comparison, not just your own brand's numbers.

Follow-up questions to chase
1. Request a sub-period (quarterly) breakout of penetration to find when in the year the decline concentrated — that timing likely points to the cause.
2. Ask your panel provider for a buyer-flow or gain-loss cut to separate lapsed buyers from never-tried households.
3. Pull your own distribution and pricing history for the same period to check for a self-inflicted cause before assuming a competitive or category story.

Leadership-ready summary
Brightleaf's household base shrank about 12.5% this year, but the buyers who remain are more loyal than a year ago — repeat rate and purchase frequency both improved. This points to an acquisition problem, not a satisfaction problem: something is stopping new or lapsed households from trying or coming back to Brightleaf, while the product itself is retaining the buyers it does reach. The next step is isolating whether this is a trial gap or a win-back opportunity, which needs one more data pull before we recommend a fix.

Want me to draft the specific data request to send your panel provider for the buyer-flow cut?