wowprompt

Competitor festive sale offer tracker with daily price checks

Builds a tracking sheet and a daily routine for recording competitor prices, discounts, bank offers and free gifts through a festive sale, then reads the log for patterns. Use it during Diwali, year-end or any sale season to see when rivals cut prices and how deep they go.

A tracking sheet layout with one row per product per day, a ten-minute daily check routine, and a pattern summary of competitor discounts
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Your category and products: [e.g. mid-range air fryers, 6 models]
  • Competitors to watch: [brand or store names, and the channels: own site, marketplaces, stores]
  • Sale period: [start and end dates]
  • What counts as an offer: [list price cut, coupon, bank card offer, exchange offer, free gift, free delivery]
  • Time available each day: [e.g. 15 minutes]
  • Log so far, if any: [paste rows]

Task

Set up a simple daily tracker for competitor offers during the sale, and, when a log is pasted, summarise what it shows.

Output format

  1. Sheet columns: | Date | Time | Competitor | Channel | Product | List price | Selling price | Effective price after offers | Offer type | Stock status | Notes |
  2. A formula description for effective price and discount percentage.
  3. The daily check routine in numbered steps, sized to the time available.
  4. If a log is pasted: deepest discount per competitor, the day prices dropped, offers that repeated, products that went out of stock.
  5. Three questions the findings raise for your own pricing.

Rules

  • Record only what is shown on the page at the time of checking; no estimates.
  • Keep bank and card offers separate from the base price, since not every buyer can use them.
  • Note a screenshot reference for any price you may need to prove later.
  • Do not suggest scraping tools that break a site's terms.

Example

Effective price = selling price minus coupon minus instant bank discount, for the most common card only

competitor price trackingfestive sale researchdiwali sale competitor offersprice monitoring sheetdiscount trackingcompetitor offers

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