Analytics · Customer · Segmentation · Rfm Scoring
Executive Summary

Executive Summary

Top-line RFM metrics: segment health, revenue concentration, and churn exposure

total_customers
500
champions_pct
17.4
at_risk_count
142
revenue_top20_pct
37.8
avg_rfm_score
8.77
lost_count
57
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.
Interpretation

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.

Visualization

Customer Segment Map

Customer count distribution across all RFM segments

Interpretation

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.

Visualization

Recency vs. Frequency Heatmap

2-D density of customers across recency and frequency score combinations

Interpretation

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.

Visualization

Revenue by Segment

Total revenue contributed by each RFM segment

Interpretation

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.

Visualization

Recency vs. Monetary Scatter

Customer scatter: recency days vs. total spend, sized by frequency, colored by segment

Interpretation

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.

Data Table

Top Customers by RFM Score

Ranked table of top 20 customers with all RFM metrics

customer_idsegmentrecency_daysfrequencymonetary_valuerfm_total_score
CUST_0002Champions1889239815
CUST_0013Champions2459307115
CUST_0024Champions1169198715
CUST_0044Champions19610233115
CUST_0062Champions17810343415
CUST_0134Champions1839230915
CUST_0187Champions2108188915
CUST_0207Champions1899236015
CUST_0235Champions6812320315
CUST_0264Champions339235515
CUST_0284Champions11710270615
CUST_0306Champions1488213715
CUST_0319Champions988218915
CUST_0331Champions2098237115
CUST_0347Champions2119302415
CUST_0368Champions2048180815
CUST_0398Champions608185715
CUST_0001Champions1648167614
CUST_0005Champions2106188914
CUST_0016Champions2829273514
Interpretation

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.

Visualization

Segment Average RFM Profiles

Average R, F, M scores per segment — shows what makes each segment distinct

Interpretation

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).

Visualization

At-Risk & Lost Customers

Customer count and average spend in at-risk, dormant, and lost segments

Interpretation

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.

Your data has more stories to tell. Run any analysis on your own data — 60+ validated R modules, interactive reports, AI insights, and PDF export. 2,000 free credits on signup.
Try Free — No Signup Sign Up Free

Report an Issue

Tell us what's wrong. You'll get a free re-run of this analysis so you can try again with different parameters. If the re-run still doesn't meet your expectations, we'll refund your credits.

Want to run this analysis on your own data? Upload CSV — Free Analysis See Pricing