RFM Segmentation Tool
Analyze customer behavior using Recency, Frequency, and Monetary scoring
Drop your CSV file here or click to browse
Accepts .CSV files
RFM Analysis is a customer segmentation technique based on three behavioral metrics. It uses the Simplified Approach: each metric is scored 1-5 via quintiles, then Frequency and Monetary are averaged into an FM Score, which is combined with the Recency score to assign each customer to one of 12 segments.
R - Recency
How recently a customer made a purchase. Measured in days since last order. Lower is better (score 5).
F - Frequency
How often a customer purchases. Measured by total number of orders. Higher is better (score 5).
M - Monetary
How much a customer spends. Measured by total lifetime spend. Higher is better (score 5).
View all 12 segment definitions
| Segment | R Score | FM Score | Description |
|---|
File RequirementsUpload a CSV file with the following columns (column names are matched flexibly):
customer_idnameemaillast_purchase_datephonenum_purchasestotal_spendRFM Customer Segmentation Dashboard
Segment Distribution
RFM Analysis is a customer segmentation technique based on three behavioral metrics. It uses the Simplified Approach: each metric is scored 1-5 via quintiles, then Frequency and Monetary are averaged into an FM Score, which is combined with the Recency score to assign each customer to one of 12 segments.
- R — Recency: How recently a customer made a purchase. Measured in days since last order. Lower is better (score 5).
- F — Frequency: How often a customer purchases. Measured by total number of orders. Higher is better (score 5).
- M — Monetary: How much a customer spends. Measured by total lifetime spend. Higher is better (score 5).
| Segment | R Score | FM Score | Description |
|---|
| Customer ID ▲▼ | Name ▲▼ | Email ▲▼ | R ▲▼ | F ▲▼ | M ▲▼ | RFM Score ▲▼ | Segment ▲▼ |
|---|