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.

Frequently asked

Related CPG prompts