wowprompt

Year-over-year sales comparison adjusted for festival date shifts

Compares this year's sales with last year's when festivals such as Diwali, Eid, Holi or Raksha Bandhan fell on different dates, by lining up days around each festival rather than calendar dates, so growth is not overstated or understated. Use it for October and November reviews, festive campaign reports and monthly targets that straddle a moving festival.

A side-by-side table of daily sales aligned by days from the festival, a calendar versus aligned growth comparison, and a short note on what the adjustment changes
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Daily sales for both years: [paste as date, sales value, orders]
  • Festivals in the window and their dates each year: [e.g. Diwali 1 November last year, 20 October this year]
  • Other differences between the years: [e.g. sale started earlier, one extra weekend, new store opened]
  • Reporting window: [e.g. October and November, or 30 days before to 10 days after Diwali]
  • Measure that matters most: [sales value, orders, or average order value]

Task

Show how much growth is real once the festival dates are lined up.

Method

  1. Calendar view: compare the same calendar dates in both years.
  2. Aligned view: label every day by days before or after the festival (D-30 to D+10) and compare like with like.
  3. Weekday check: note where aligned days fall on different weekdays and whether weekends shift the result.
  4. Separate the festival window from the rest of the period so a shift does not distort the whole month.

Output format

  1. | Day relative to festival | Date last year | Sales last year | Date this year | Sales this year | Change % |
  2. | View | Last year total | This year total | Growth % | for the calendar and aligned views.
  3. A chart description: two lines on the aligned day axis, with the festival day marked.
  4. Three sentences for a manager on what the true growth is and why the calendar figure differs.

Rules

  • Do not guess festival dates; use only those given, and ask if one is missing.
  • Keep both views visible; never report only the more flattering one.
  • Flag any day with missing data rather than filling it in.
year over year comparisonfestival date shiftlike for like salesdiwali sales analysisseasonal sales comparisoncalendar adjustment

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