Not every customer is worth the same marketing effort. Which customers are VIPs to reward, and which are at risk of churning and need re-engaging?
Marketing budgets are limited. Treating every customer the same wastes money on low-value customers and misses the ones about to churn. RFM segmentation tells a team exactly who to reward, who to win back, and who to leave alone.
Not every customer is worth the same marketing effort. This project segments customers with the classic RFM model (Recency, Frequency, Monetary value) and turns each segment into a concrete action, such as rewarding VIPs or re-engaging customers at risk of churning.
In the Power BI model, DAX calculated columns on dim_customer score recency, frequency, and monetary value from 1 to 4. The resulting R-F-M code (for example 444) links to a segment table, and the report also tracks revenue against the monthly plan.