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
- Sheet columns: | Date | Time | Competitor | Channel | Product | List price | Selling price | Effective price after offers | Offer type | Stock status | Notes |
- A formula description for effective price and discount percentage.
- The daily check routine in numbered steps, sized to the time available.
- If a log is pasted: deepest discount per competitor, the day prices dropped, offers that repeated, products that went out of stock.
- 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






