Matching Products Across Shops: Normalised Match Keys and the Match Rate
This lesson is part of the course
In this lesson
You build normalised match keys from brand and model for Copperleaf Outdoor's catalogue and for scraped competitor listings, link each listing to our SKU with XLOOKUP and measure the match rate.
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