Festive Demand Planning

A simple MCP prompt that queires historical data, analyzes current run rate, and prepares a plan for the upcoming festive season and highlights exactly which SKUs will need restocking

The Prompt

Paste the below prompt into Claude with BooleanMaths MCP connected. Replace {BRAND}.

mcp-prompt
Build a demand event forecast for {BRAND} using the BooleanMaths MCP.
DATA
1. list_projects to resolve the projectId.
2. get_mmm_dataset, granularity=week, userTimezone=Asia/Kolkata. Pull in
   52-week chunks — longer windows time out. Go back as far as data exists.
   Drop is_partial rows and zero-revenue weeks. State where history starts
   and how many complete annual cycles that gives me.
3. get_discount_analytics across the same period.
FIND THE EVENTS — do not assume which ones matter
4. Fit a baseline: log(revenue) ~ log(adstocked spend) + trend, on all weeks.
   Iterate: flag outlier weeks, refit excluding them, repeat until stable.
   Report the residual SD — lifts inside 1.5 SD are noise, not events.
5. Rank EVERY flagged week by lift, high and low. Do not pre-filter to
   holidays. Sale weeks, payday cycles, marketplace events, brand
   anniversaries, clearance and unexplained spikes all count. Troughs matter
   too - they show where demand or spend went missing.
6. Classify each event by its AOV signature:
   - orders lift > revenue lift  -> discount-led, volume event
   - revenue lift > orders lift  -> occasion or gifting event
   - both flat, spend down       -> self-inflicted, not a market event
   Cross-check the discount data to separate the brand's own promos from
   calendar demand. Tell me which is which.
7. Only now web-search the exact dates of the relevant calendar events for
   the next 12 months, and ask me for {BRAND}'s planned sale calendar.
   Lunar and religious dates shift year to year — check whether the shift
   moves an event into a different ISO week, or compresses the gap between
   two events.
SIZE THEM
8. Per event: peak week, and uplift vs T-1, T-3 and T-4. Flag any baseline
   week distorted by a spend change rather than real demand.
9. Segment the catalogue yourself before doing SKU work. Pull product
   metadata and derive 3-5 segments from whatever attributes actually
   differentiate this brand's range — price band, pack size, single vs
   multipack or bundle, product line, margin tier. Test which segmentation
   separates event lift most cleanly and use that one. Report lift by
   segment, not per SKU: individual SKU deltas are mostly launch and
   ad-rotation noise.
10. Build the requirement off the last-30-day run rate, apply segment
    multipliers per event, reconcile bottom-up to the top-down forecast.
OUTPUT
11. Weekly forecast table, event ranking table, and a unit requirement for
    the top 10 SKUs across each major event window.
12. Then a standalone responsive HTML report, branded to {BRAND} with
    BooleanMaths as preparer. No CDN dependencies — inline SVG/CSS charts
    only. Section 1: all events ranked, prior-year actual vs forecast.
    Section 2: per-event detail behind a dropdown.
Tell me what the data can't support rather than filling gaps with assumptions.

The Output

Activate your Marketing Data with BooleanMaths

Background

Activate your Marketing Data with BooleanMaths

Background

Activate your Marketing Data with BooleanMaths

Background

Activate your Marketing Data with BooleanMaths

Background

Activate your Marketing Data with BooleanMaths

Background