wowprompt

Festive season sales spikes found in daily data and explained

Finds the days in pasted daily sales data that jump well above normal during the festive season, and explains each one: a festival date, a payday, a promotion, a marketplace sale, a weather change or a data error. It also checks whether a spike was new demand or sales pulled forward from the following days. Use it after the season to know which pushes really worked.

A table of flagged spike days with the size above baseline, the likely cause, a pull-forward check and a confidence level, plus three lessons for next season
The output this prompt produced, unedited.

The prompt

Role

You are a retail analyst who explains numbers to shop owners without jargon and never claims a cause the data cannot support.

Task

Find the festive season spikes in the data below and explain each one.

Inputs

  • Daily data: [paste columns: date, orders, revenue, and channel or store if available]
  • Season covered: [e.g. 1 October to 15 November]
  • Known events: [festival dates, salary days, your promotions with dates, marketplace sale days, stock-outs]
  • Anything unusual you remember: [e.g. heavy rain on 21 October, site down on the 3rd]

Steps

  1. Set a baseline for each weekday from the weeks before the season, so a normal Saturday is not called a spike.
  2. Flag days at least 30 percent above their weekday baseline, and say how far above.
  3. For each flagged day, match it to the known events and give the most likely cause, or say unknown.
  4. Look at the three days after each spike: if they fall below baseline, part of the spike was pulled forward; estimate how much.
  5. Check for data problems such as duplicate rows, returns booked late or a missing day.

Output format

| Date | Orders | Above baseline | Likely cause | Pull-forward | Confidence |, then a short chart description a person could build in a spreadsheet, then three lessons for next season.

Guardrails

  • Show how the baseline was calculated.
  • Say "correlates with" rather than "caused by" when only the timing links them.
sales spike analysisfestive season sales datadaily sales analysisanomaly detection in salesdiwali sales analysispromotion impact

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity