Executive Summary
Top-line RFM metrics: segment health, revenue concentration, and churn exposure
Out of 500 unique customers scored, 17.4% qualify as Champions — buyers with both high recency and high frequency who are the core of long-term revenue. 142 customers (28.4%) fall into at-risk categories (At Risk, Cannot Lose Them, About To Sleep) and represent immediate winback opportunities. The top 20% of customers by combined RFM score account for 37.8% of total revenue, and 57 customers are classified as Lost with no recent activity.
Customer Segment Map
Customer count distribution across all RFM segments
The 'Loyal Customers' segment contains the largest share of customers. It accounts for 22.62% of total revenue. Segments are sized by customer count, with revenue share shown as a label — compare segment size against revenue contribution to spot under-performing large segments and over-performing small ones.
Recency vs. Frequency Heatmap
2-D density of customers across recency and frequency score combinations
The densest cluster sits at recency score 1 and frequency score 1 with 43 customers. A concentration along the diagonal (high R, high F) indicates a healthy repeat-purchase base. Large off-diagonal clusters — high F but low R — flag formerly loyal customers who have lapsed and may respond to targeted reactivation.
Revenue by Segment
Total revenue contributed by each RFM segment
The 'Champions' segment generates the most total revenue ($167,993). Compare customer count against revenue bars to identify high-value segments with disproportionate revenue per customer — these deserve VIP treatment. Segments with large customer counts but low revenue bars may be early-stage buyers that have not yet converted to high-value status.
Recency vs. Monetary Scatter
Customer scatter: recency days vs. total spend, sized by frequency, colored by segment
Each point represents one customer, placed by days since last purchase (x-axis) and total spend (y-axis). Point size reflects purchase frequency. Customers in the top-left quadrant (recent, high-spend) are Champions or Loyal; those in the bottom-right (old, lower-spend) are candidates for winback or removal from active marketing lists.
Top Customers by RFM Score
Ranked table of top 20 customers with all RFM metrics
| customer_id | segment | recency_days | frequency | monetary_value | rfm_total_score |
|---|---|---|---|---|---|
| CUST_0002 | Champions | 188 | 9 | 2398 | 15 |
| CUST_0013 | Champions | 245 | 9 | 3071 | 15 |
| CUST_0024 | Champions | 116 | 9 | 1987 | 15 |
| CUST_0044 | Champions | 196 | 10 | 2331 | 15 |
| CUST_0062 | Champions | 178 | 10 | 3434 | 15 |
| CUST_0134 | Champions | 183 | 9 | 2309 | 15 |
| CUST_0187 | Champions | 210 | 8 | 1889 | 15 |
| CUST_0207 | Champions | 189 | 9 | 2360 | 15 |
| CUST_0235 | Champions | 68 | 12 | 3203 | 15 |
| CUST_0264 | Champions | 33 | 9 | 2355 | 15 |
| CUST_0284 | Champions | 117 | 10 | 2706 | 15 |
| CUST_0306 | Champions | 148 | 8 | 2137 | 15 |
| CUST_0319 | Champions | 98 | 8 | 2189 | 15 |
| CUST_0331 | Champions | 209 | 8 | 2371 | 15 |
| CUST_0347 | Champions | 211 | 9 | 3024 | 15 |
| CUST_0368 | Champions | 204 | 8 | 1808 | 15 |
| CUST_0398 | Champions | 60 | 8 | 1857 | 15 |
| CUST_0001 | Champions | 164 | 8 | 1676 | 14 |
| CUST_0005 | Champions | 210 | 6 | 1889 | 14 |
| CUST_0016 | Champions | 282 | 9 | 2735 | 14 |
The top 20 customers by combined RFM score are listed here, ordered from highest to lowest total score. Most should fall in the Champions or Loyal Customers segments. Use this table to build a targeted VIP list for loyalty programs, personal outreach, or early-access campaigns.
Segment Average RFM Profiles
Average R, F, M scores per segment — shows what makes each segment distinct
Each bar group shows the average recency, frequency, and monetary scores for one segment, making it easy to see which single dimension defines each group. Segments with uniformly high scores on all three dimensions are your best customers; segments with one strong and two weak dimensions point to a specific intervention (e.g., high monetary but low recency suggests a targeted re-engagement offer).
At-Risk & Lost Customers
Customer count and average spend in at-risk, dormant, and lost segments
199 customers are classified in at-risk or lapsed segments. The largest group is 'Cannot Lose Them'. Average spend (shown as label) indicates the revenue exposure: a high average monetary value in 'At Risk' or 'Cannot Lose Them' means a small number of winback campaigns could recover significant revenue. 'Lost' customers with low average spend may not be worth the reactivation cost.