wowprompt

Post-Diwali sale review comparing actuals with targets by day and channel

Turns the daily orders, revenue and spend from a festive sale into a review that shows which days, channels and offers beat or missed target, what the discounts really cost, and what to repeat or drop next season. Use it in the week after Diwali, a wedding season push or any short sale window.

A day-by-day table of target against actual, a channel and offer breakdown, discount cost per order and a keep, change or drop list for next year
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Business and what it sells: [e.g. an online store for brass and copper home decor]
  • Sale window: [start date to end date]
  • Daily targets: [paste date, target orders, target revenue]
  • Daily actuals: [paste date, orders, revenue, average order value, returns so far]
  • Channel split: [paste channel, orders, revenue, ad spend, e.g. website, marketplace, Instagram, WhatsApp]
  • Offers that ran and their dates: [e.g. 15% off sitewide, free gift above 2,999, bank card cashback]
  • Stock-outs or site issues and when: [paste, or none]

Template to complete

Headline

Three lines: total against target, the best day and the worst day, and the single biggest reason.

Day by day

| Date | Target revenue | Actual revenue | Gap % | Note |

By channel

| Channel | Revenue | Spend | Return on spend | Share of orders | Verdict |

By offer

| Offer | Orders using it | Discount given | Discount per order | Did it lift order value |

Next season

  • Keep: [items]
  • Change: [items, with the change]
  • Drop: [items]

Rules

  • Mark revenue as gross or net of returns, and say which returns are still open.
  • Never call a day a success because of volume alone if its margin after discount was negative.
  • Use only the figures given; write "not provided" where data is missing.
festive sale reviewdiwali sales analysissale post mortemtarget vs actualchannel performancediscount analysis

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