RFM analysis tool
A free RFM calculator that scores your customers from a CSV upload is on the way. Until it’s ready, here’s how RFM analysis works, a worked RFM score, and a spreadsheet method you can run on your own order export today.
One email when it launches. No newsletter.
The formula
How an RFM score is calculated.
RFM score = Recency (1–5) · Frequency (1–5) · Monetary (1–5)
- Recency
- How recently the customer last ordered. Most recent fifth of customers scores 5.
- Frequency
- How many orders they’ve placed. Most frequent fifth scores 5.
- Monetary
- How much they’ve spent. Highest-spending fifth scores 5.
- Segments
- The 125 possible scores are grouped into named segments such as Champions, Loyal, At risk and Hibernating.
Worked example
An RFM score, step by step.
One illustrative customer. Score bands come from splitting your own customers into fifths, so they differ by store.
RecencyLast order 12 days ago: in the most recent fifth
R = 5
Frequency6 orders: in the second-highest fifth
F = 4
Monetary$640 spent: in the second-highest fifth
M = 4
SegmentHigh on all three, not quite top on frequency and spend
5-4-4 · Loyal
Use it today
RFM analysis in a spreadsheet.
Put one customer per row: column B days since last order, C number of orders, D total spend, from row 2 down. Then add these four columns and fill them down. Recency is reversed so recent customers score 5.
| Add column | Formula for row 2 |
|---|---|
| E · Recency score | =6-MAX(1,ROUNDUP(PERCENTRANK(B$2:B$5000,B2)*5,0)) |
| F · Frequency score | =MAX(1,ROUNDUP(PERCENTRANK(C$2:C$5000,C2)*5,0)) |
| G · Monetary score | =MAX(1,ROUNDUP(PERCENTRANK(D$2:D$5000,D2)*5,0)) |
| H · RFM score | =E2&"-"&F2&"-"&G2 |
Works the same in Excel and Google Sheets. Formulas in orange.
Where the simple version breaks
Where hand-built RFM falls short.
It’s a snapshot
An RFM spreadsheet is right the day you build it and drifts every day after. Customers move between segments constantly.
It only looks back
RFM describes past behavior. It doesn’t predict who will buy next or who is about to leave.
It stops at the spreadsheet
Segments are only useful once they reach your email and ad tools, and keeping those lists current by hand rarely lasts.
LiftSignals rebuilds RFM segments every night, adds predicted value and churn risk, and syncs them to your channels. Customer segmentation →
FAQ · rfm analysis tool
RFM analysis questions, answered.
What does RFM stand for?
Recency, frequency and monetary value: how recently a customer bought, how often, and how much they spent.
Why are RFM scores split into fifths?
Quintiles give each score from 1 to 5 an equal share of customers, so the scores compare customers with each other rather than with a fixed threshold.
What data do I need for RFM analysis?
One row per order with a customer identifier, order date and order total. That’s enough to compute all three scores.
When will the RFM analysis tool be available?
It’s being built. Leave your email above and we’ll write once when you can upload a CSV.
Which RFM segments matter most?
Usually Champions, to protect, and At risk or Can’t lose, to win back before they go quiet.
MORE FREE TOOLS ON THE WAY
Coming soon
CLV calculator →
Predict what a customer is worth over their lifetime.
Coming soon
Churn rate calculator →
Churn and retention rate for any period.
Coming soon
LTV:CAC calculator →
Is each customer worth what you paid for them?
Coming soon
Holdout sample size calculator →
How many customers a fair test needs.
Get RFM segments that update themselves.
LiftSignals scores RFM nightly and syncs the segments. 30 days free.