Accounts
6
At risk
2
Revenue at risk
$134,000
Customer Health Scorecard
Score each account on usage, support, relationship and payments to spot churn risk early.
SpreadsheetAccounts & CustomersFree
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
Score every customer on recency, frequency and spend, label them Champions to Lost and see where your revenue is at risk.
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.
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.
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.
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.
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.
Download a copy
Downloads need a free account.