PromptSharp › Prompt Library › CPG › Due-to bridge: explain exactly why volume moved
Due-to bridge: explain exactly why volume moved
Quarterly business review: the volume decomposition is done, but leadership needs the driver story — not the spreadsheet.
The prompt — copy and run it
You are a CPG insights analyst writing the driver narrative for a volume due-to (decomposition) analysis. I will paste the decomposition outputs and context. Produce: A) A ranked DRIVER TABLE — columns: driver (distribution, velocity, base price, promotion, mix, new items, lost items), volume impact as given, direction, and a one-line plain-English explanation a non-analyst executive can read. B) A 5-sentence NARRATIVE that leads with the single biggest driver, quantifies it from my numbers, and labels each driver structural (e.g., distribution losses) vs temporary (e.g., promo timing). C) THREE follow-up cuts to run next (by retailer, pack size, or region) and what each would confirm or kill. Data and context: [PASTE DUE-TO OUTPUT: driver names + volume or dollar impacts, period, geography, brand vs category trend] 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
Due-to outputs are where most category managers stall: the math is done but the story is not. A ranked driver table plus a structural-vs-temporary split turns decomposition arithmetic into the one sentence leadership remembers — and the follow-up cuts keep the analysis honest instead of cherry-picked.
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?
Quarterly business review: the volume decomposition is done, but leadership needs the driver story — not the spreadsheet.
Why does this prompt work?
Due-to outputs are where most category managers stall: the math is done but the story is not. A ranked driver table plus a structural-vs-temporary split turns decomposition arithmetic into the one sentence leadership remembers — and the follow-up cuts keep the analysis honest instead of cherry-picked.
Related CPG prompts
Velocity vs distribution: is this growth real?
Your brand is up and someone wants to plan against it. Before they do, you need to know whether growth is quality (velocity-led) o…
Trade promo post-mortem that tells the truth
The event is over and the lift number looks good in the deck. Did the promotion actually pay, or did it just buy volume forward?…
Price-pack architecture read: what did the price change teach you?
Pricing moved — yours or a competitor's — and volume responded. Turn the response into a price-pack architecture insight before th…
Category review skeleton: retailer-first, brand-last
The annual category review is due. You have the data; you need the structure and the story a merchant will actually engage with.…
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