Price Position: Cheapest, Middle or Most Expensive with RANK.EQ
This lesson is part of the course
In this lesson
You rank Copperleaf Outdoor's price among all shops for each product, label the position as Cheapest, Middle or Most expensive and measure the gap to the cheapest competitor.
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