Recency, Frequency, Monetary Value Model (RFM)

(Steve Calla) #1

I know it’s old school, but interested in comments from those who have built an RFM model. Since we have mysql, we couldn’t use windows functions for the quartiles, but the core logic was easy with case statements.

User Detail:

Code Snippet:


This is quite an old entry but I have built an RFM model using tier dimensions in Looker. Like you, we also run on MySQL.

(Brecht Vermeire) #3

Any code snippets you can share here @gorden? Very interested in your approach!