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.

Frequently asked

Related CPG prompts