LiftSignals is live. Every plan starts with a 30-day free trial — no credit card required. Start free →
Free tool · coming soon

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.

PREVIEW · EXAMPLE NUMBERS

Coming soon
12
6
$640
RFM score5-4-4 · Loyal

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.

01

RecencyLast order 12 days ago: in the most recent fifth

R = 5

02

Frequency6 orders: in the second-highest fifth

F = 4

03

Monetary$640 spent: in the second-highest fifth

M = 4

04

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