PromptSharp › Prompt Library › CPG › Trade calendar × media sync: find the orphaned weeks
Trade calendar × media sync: find the orphaned weeks
The trade calendar and the media plan were built by different teams. Find the promo weeks with no media and the media weeks with no shelf support.
The prompt — copy and run it
You are an integrated commercial planner auditing trade-media alignment. I will paste the trade calendar (events, retailers, dates, support type) and the media plan (flights, channels, budgets, dates). Produce: A) A WEEK-BY-WEEK SYNC TABLE flagging: promo events with no media support, media flights with no shelf/price support behind them, and correctly synced weeks — from my two calendars only. B) A RESEQUENCING recommendation: the two or three moves with the strongest case, each with the reasoning stated (e.g., moving a flight to cover a feature week at a key retailer). C) A MEASUREMENT PLAN for the newly synced weeks so the alignment thesis gets tested, not just asserted — which comparison, which weeks, which data source. My calendars: [PASTE: trade events with dates/retailers/support, media flights with dates/channels/budgets] 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
Trade and media calendars are built in different rooms at most CPG companies, and the orphaned weeks are pure waste on both sides. A mechanical week-by-week audit is exactly the kind of unglamorous cross-referencing an LLM does perfectly — and the measurement plan keeps 'synergy' from staying a slide word.
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?
The trade calendar and the media plan were built by different teams. Find the promo weeks with no media and the media weeks with no shelf support.
Why does this prompt work?
Trade and media calendars are built in different rooms at most CPG companies, and the orphaned weeks are pure waste on both sides. A mechanical week-by-week audit is exactly the kind of unglamorous cross-referencing an LLM does perfectly — and the measurement plan keeps 'synergy' from staying a slide word.
Related CPG prompts
Creator brief for a CPG item: claims-safe and actually usable
You need creators briefed for a launch — with the claims language locked down before content gets made, not after.…
Retail media readout: platform ROAS vs what you can actually claim
The campaign wrapped and the network's dashboard says the ROAS was great. Write the readout that separates attribution from increm…
PDP rewrite: title, bullets, and search terms that convert
A product page is underperforming in retailer search. Rewrite it inside the style rules — with every claim flagged for substantiat…
So-what skeleton: slide titles that carry the argument
The analysis is finished and the deck is due. Build the skeleton where the titles alone tell the story.…
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