Promotion Detection: Big Drops That Rebound Within N Days
This lesson is part of the course
In this lesson
You separate competitor C's temporary promotions from a permanent price cut: flag drops beyond a threshold, test whether the price returns to its old level within N days using OFFSET, then count the promos and measure their depth.
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