All articles
Data Analysis25 February 20259 min read

RFM Analysis: Customer Segmentation That Works

RFM (Recency, Frequency, Monetary) is the most practical customer segmentation model for e-commerce and service businesses. Build and use it in Google Sheets.

Tanvir Tuhin

AI Consultant & Digital Marketer, Aberdeen UK

RFM analysis is thirty years old and still one of the most powerful customer segmentation tools available. Its enduring relevance comes from its simplicity — three variables that capture the most predictive signals about customer value and future behaviour.

What RFM Measures

RFM dimensions explained

DimensionQuestionWhy It Matters
Recency (R)When did they last buy?Recent buyers are more likely to respond to offers
Frequency (F)How often do they buy?Frequent buyers have stronger brand relationships
Monetary (M)How much have they spent?High-value customers deserve premium treatment

Key Customer Segments and Actions

RFM customer segments

SegmentRFM ScoreAction
Champions555, 554Reward them, referral programme
Loyal444, 435Upsell, cross-sell, early access
At Risk255, 254Personalised win-back campaign
Lost111, 112Major discount or remove from active list
💰

The 80/20 Insight

In most businesses, the top 20% of customers (Champions + Loyal) generate 60-80% of revenue. RFM makes this visible and actionable.

RFM AnalysisCustomer SegmentationE-commerceData Analysis

Tanvir Tuhin

AI consultant, digital marketer, and study abroad mentor based in Aberdeen, UK. Founder of JJAT Education.

Work with Tanvir