Competitor Price Monitoring: Price Index, Changes & Promotion Detection
Turn scraped competitor prices into decisions: match products across shops, calculate price index and price position, detect price changes and promotions, estimate elasticity from your own price tests, build a repricing rule with a margin floor and a monitoring dashboard.
The first lesson is free — no account needed.
About this course
A competitor price monitoring course that turns scraped prices into decisions for one fictional outdoor retailer, Copperleaf Outdoor, for pricing analysts, e-commerce managers and marketplace sellers. You build normalised match keys to link competitor listings to your SKUs and measure the match rate, calculate a price index against the average competitor price and a unit-weighted overall index, rank your price position with RANK.EQ, turn two weeks of scraped prices into day-over-day changes and repricing counts, separate temporary promotions from permanent cuts with a rebound test, estimate price elasticity from your own price tests with a log-log slope, build a repricing rule that beats the lowest competitor but never drops below a margin floor and finish with a dashboard and alerts. Prices are set independently from public data, never agreed with competitors. Not legal advice. The first lab is free.
Lessons
- Matching Products Across Shops: Normalised Match Keys and the Match RateFree
- The Price Index: Our Price ÷ Average Competitor Price × 100 Pro
- Price Position: Cheapest, Middle or Most Expensive with RANK.EQ Pro
- Detecting Price Changes: Day-over-Day %, Change Flags and Change Counts Pro
- Promotion Detection: Big Drops That Rebound Within N Days Pro
- Estimating Price Elasticity from Your Own Price Changes: Log-Log SLOPE Pro
- A Repricing Rule: Beat the Lowest Competitor by 1 %, Never Below the Margin Floor Pro
- Capstone: a Price Monitoring Dashboard with Alerts, a Ranked Bar Chart and Conditional Formatting Pro