PromptSharp › Prompt Library › CPG › Panel measures → growth levers: penetration or buy rate?
Panel measures → growth levers: penetration or buy rate?
Household-panel numbers are in — penetration, buy rate, frequency, trip size. Translate them into which growth lever is actually available to you.
The prompt — copy and run it
You are a shopper insights analyst decomposing brand buyer dynamics from household panel data. I will paste my panel measures vs year-ago and vs category. Produce: A) A DECOMPOSITION: is the brand's growth or decline penetration-led (more/fewer buyers) or buy-rate-led (buyers spending more/less), and within buy rate, frequency vs spend-per-trip — shown from my numbers only. B) A LEVER MAP: what each pattern means for tactics — penetration problems point to awareness, trial, and distribution; buy-rate problems point to pack sizes, purchase-cycle promotion, and loyalty — with the two tactics my specific pattern supports best. C) A 3-sentence SUMMARY plus the single biggest data gap that would change the read. My data: [PASTE: penetration, buy rate, purchase frequency, spend per trip — brand and category, current vs YA] Rules: Do not invent, estimate, or extrapolate any figure — if a number is not in the data I give you, write "not provided" and flag it. Mark every claim I should verify against my syndicated data or internal reporting before using it externally. Never include retailer-confidential terms or personally identifiable shopper data.
Why this prompt works
Penetration-vs-buy-rate is the oldest and most decision-relevant split in panel analysis, and it is still routinely skipped in favor of topline dollars. Tying each pattern to the tactics it can actually fund keeps marketing plans honest about which lever the data says is available.
Want the daily version?
The PromptSharp CPG Brief delivers prompts like this every day. Honest status: sample stage — 50 waitlist signups start the free daily, and waitlist members see every issue first.
Frequently asked
When should I use this prompt?
Household-panel numbers are in — penetration, buy rate, frequency, trip size. Translate them into which growth lever is actually available to you.
Why does this prompt work?
Penetration-vs-buy-rate is the oldest and most decision-relevant split in panel analysis, and it is still routinely skipped in favor of topline dollars. Tying each pattern to the tactics it can actually fund keeps marketing plans honest about which lever the data says is available.
Related CPG prompts
Shopper study design: hypotheses before methodology
Someone wants to commission shopper research. Before money moves, force the hypotheses and check whether existing data already ans…
Shelf-space argument builder: share of shelf vs share of sales
Reset season again — and your space ask needs merchant math (space-to-sales, days of supply), not brand enthusiasm.…
Line review prep: the merchant's ten questions
Line review in two weeks. Rehearse against the questions the merchant will actually ask — before they ask them.…
White-space map from the data you already have
Innovation planning kickoff: find the real gaps in the category before the brainstorm invents imaginary ones.…
All CPG free prompts
The PromptSharp CPG Brief page — five full free prompts plus the ladder status.
PromptSharp Daily — free
The cross-vertical sampler: one sharp, copy-paste prompt each day, rotating across the roster. See what each vertical is like before you commit to one.
Double-opt-in. Unsubscribe anytime. No spam, ever.
Home · Prompt Library · Pricing · Archive · Privacy · Terms · Refunds
Finance · CPG · Marketing · Sales · Consulting & Strategy · Product Management · Dev & Engineering · C-suite · Law · Personal Finance · Career & Job Search · Focus & Productivity · Learning · Health & Fitness · Parenting