Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMAccounts & CustomersRFM Customer Segmentation

SpreadsheetAccounts & CustomersFree

RFM Customer Segmentation

Score every customer on recency, frequency and spend, label them Champions to Lost and see where your revenue is at risk.

Shown with sample data

Colour

RFM Customer Segmentation

Score every customer on recency, frequency and spend, label them Champions to Lost and see where your revenue is at risk.

Customers
14
Champions’ share of revenue
48%
Revenue from at-risk customers
$4,600
Win these back first
Repeat customer rate
86%
Median days since last order
67
Revenue by RFM segment
  • Champions$7,520
  • Loyal$2,540
  • Promising$640
  • New$85
  • At risk$3,480
  • Can’t lose them$1,120
  • Lost$210
Customers by segment
  • Champions321%
  • At risk321%
  • Loyal214%
  • Promising214%
  • Lost214%
  • New17%
  • Other17%

How to use it

  1. 1Export customers from your store or CRM with first order date, last order date, number of orders and total spend.
  2. 2Paste them into the Customers sheet; recency, scores and segments calculate automatically.
  3. 3Adjust the score thresholds on the Settings sheet so each score holds a sensible share of customers for your business.
  4. 4Read the Segments sheet to see customers and revenue in each segment and the recommended action.
  5. 5Export each segment to your email tool and run the matching campaign.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

RFM is the quickest way to find your best customers and the ones about to leave, using data you already have. Paste in each customer’s last order date, number of orders and total spend; the sheet calculates days since the last order from today, turns each measure into a 1–5 score using thresholds you control on the Settings sheet, combines them into an RFM code and assigns a segment such as Champions, Loyal, Promising, At risk or Lost, with revenue and a recommended action for every segment.

Who it’s for

  • Targeting email and SMS campaigns by segment
  • Finding high-value customers who have gone quiet
  • Planning loyalty, win-back and VIP programmes
  • Quarterly customer base health checks

What’s included

  • Customers sheet: One row per customer with scores and segment.
  • Segments sheet: Customers, revenue and the action for each segment.
  • Settings sheet: Score thresholds for recency, frequency and spend.

How to use it

  1. 1Export customers from your store or CRM with first order date, last order date, number of orders and total spend.
  2. 2Paste them into the Customers sheet; recency, scores and segments calculate automatically.
  3. 3Adjust the score thresholds on the Settings sheet so each score holds a sensible share of customers for your business.
  4. 4Read the Segments sheet to see customers and revenue in each segment and the recommended action.
  5. 5Export each segment to your email tool and run the matching campaign.

Tips

  • Set thresholds from your own data: a coffee subscription and a furniture store have very different normal purchase gaps. Aim for roughly a fifth of customers in each recency score.
  • Act on At risk and Can’t lose them first. They have proven they will buy, and a win-back offer costs far less than a new customer.
  • Do not discount to Champions by reflex. Early access, recognition and referral invitations often work better and protect margin.
  • Rerun the analysis monthly or quarterly and track how many customers move up or down a segment.

Questions

What is RFM analysis?

A way to segment customers by three behaviours: Recency (how recently they bought), Frequency (how often they buy) and Monetary value (how much they spend). Each is scored 1–5 and the combination identifies groups such as loyal high spenders, new customers and lapsing customers.

How are RFM scores calculated?

Each measure is compared with thresholds. In this template a customer who bought within 30 days gets a recency score of 5; one who placed 10 or more orders gets a frequency score of 5; and so on. Change the thresholds on the Settings sheet; the scores and segments update immediately.

What do the RFM segments mean?

Champions bought recently, often and spend the most. Loyal customers buy often. Promising and New customers bought recently but not often yet. At risk customers used to buy often but have not recently. Can’t lose them were frequent customers who have gone quiet for a long time. Lost customers bought rarely and long ago.

How often should I update RFM segments?

Monthly for most online stores, quarterly for businesses with long purchase cycles. Recency is calculated from today, so scores change even if no new orders arrive.

Related searchesrfm analysisrfm segmentation excelcustomer segmentation templaterecency frequency monetarycustomer value analysisat risk customers

Details

Format
Spreadsheet
Category
Accounts & Customers
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounts & CustomersFree

RFM Customer Segmentation

Score every customer on recency, frequency and spend, label them Champions to Lost and see where your revenue is at risk.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Accounts & Customers
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More accounts & customers templates

View all
Customer Health Scorecard2 sheets

Accounts

6

At risk

2

Revenue at risk

$134,000

Annual revenue by segment
$204k
$116k
$32k
EnterpriseMid-marketSmall business
SpreadsheetAccounts & Customers

Customer Health Scorecard

Score each account on usage, support, relationship and payments to spot churn risk early.

10 min setupPreview
Customer Contact List3 sheets

Customers

9

Lifetime revenue

$187,400

Revenue at risk

$37,100

ABCD
1CustomerContact personCityOwner
2Northwind RetailSara AliSeattleDana
3Blue Harbor CafeHana KimPortlandMia
4Oak & Pine StudioWill GrantDenverLeo
5Delta FoodsBen ColeChicagoLeo
Customers
SpreadsheetAccounts & Customers

Customer Contact List

A light CRM: every customer with owner, value, order history and an automatic segment, health and next contact.

10 min setupPreview

Customer Feedback Survey

Measure satisfaction and NPS, and learn what to improve.

Overall, how satisfied are you? *

Very satisfiedSatisfiedNeutral

How likely are you to recommend us to a friend or colleague (0–10)? *

012345678910

What did we do best?

Send feedback
FormAccounts & Customers

Customer Feedback Survey

Measure satisfaction and NPS, and learn what to improve.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ