Lesson 3 of 10

Segment a portfolio with RFM

Transform recency, frequency and value into explainable business rules.

30 minSQL Data Analyst

By the end of this lesson

  • Calculate R, F and M
  • Document thresholds
  • Preserve customers without purchases

SQL Essentials

Unlock this lesson and continue the path.

Segment a portfolio with RFM is part of the complete programme: 38 lessons, 62 verifiable exercises and 8 published guided projects.

  • Complete content with explained examples
  • SQL simulator and expected result
  • Detailed answer, common mistakes and challenge
View SQL EssentialsI already have access
Six-month access, one-time payment and no automatic renewal.