Recency, Frequency and Monetary from a Raw Order Log
This lesson is part of the course
In this lesson
You turn 24 raw orders into the RFM base table: last order date, days since the last order, and orders and revenue in the last 12 months for each customer.
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
- Recency, Frequency and Monetary from a Raw Order Log Locked
- Quintile Scores: PERCENTILE Cut-offs and PERCENTRANK Locked
- From Scores to Segments: Champions, At Risk & Co. Locked
- Segment Size vs Revenue Share Locked
- Standardising Variables with z-Scores Locked
- k-Means on RFM: One Iteration by Hand Locked
- Choosing k: Within-Cluster Sum of Squares and the Elbow Locked
- Segment Profiles and Targeted Campaign Economics Locked