Detecting Price Changes: Day-over-Day %, Change Flags and Change Counts
This lesson is part of the course
In this lesson
You turn two weeks of scraped competitor prices into day-over-day changes, flag every change, count how often each competitor reprices and chart the price history.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Matching Products Across Shops: Normalised Match Keys and the Match Rate Locked
- The Price Index: Our Price ÷ Average Competitor Price × 100 Locked
- Price Position: Cheapest, Middle or Most Expensive with RANK.EQ Locked
- Detecting Price Changes: Day-over-Day %, Change Flags and Change Counts Locked
- Promotion Detection: Big Drops That Rebound Within N Days Locked
- Estimating Price Elasticity from Your Own Price Changes: Log-Log SLOPE Locked
- A Repricing Rule: Beat the Lowest Competitor by 1 %, Never Below the Margin Floor Locked
- Capstone: a Price Monitoring Dashboard with Alerts, a Ranked Bar Chart and Conditional Formatting Locked