Customers, RFM and cohorts
See who buys, who comes back, who is slipping away and how each month’s new customers behave over time.
Open your dashboardCustomers: who buys, and how often?
The report is titled Customer Intelligence. Only the three cards at the top follow the date range: Total Customers who bought in the period, New Customers whose first-ever sale order falls in it, and Returning Customers who had bought before it.
Everything below uses each customer’s full history: RFM Segments, Top Customers by Lifetime Value, CLV by Segment, Repeat Purchase Interval, Customer Concentration, Purchase Frequency Distribution and Recency Distribution. Customer Concentration shows what share of revenue your top 10% and top 20% of customers bring in.
Repeat Purchase Interval is the one to plan around. Its average and median show the usual gap between a customer’s orders. Example: with a median of 34 days, a reminder around day 30 reaches customers just before they would normally reorder.
- Recency Distribution
- How many customers last ordered in the last 7 days, 8-14, 15-30, 31-60, 61-90 or 90+ days ago.
- Purchase Frequency Distribution
- How many customers have placed 1 order, 2, 3-5, 6-10, 11-20 or 20+.
- CLV by Segment
- Average and total spend per RFM segment, with Avg Orders and Avg Recency in days.
Registered vs Guest: who checks out without an account?
Registered vs Guest splits the period’s sale orders by whether the buyer had an account. Each side shows Customers, Orders, Revenue, Avg. Order Value, Revenue / Customer, Orders / Customer, Repeat Rate, Repeaters, New (in period) and Returning. Guest Order Share is the share of orders placed as a guest.
Repeat Rate is the share of customers with two or more orders in the selected period, so use a longer range, such as Last 90 days, for a fair read. Below the two columns are the share charts, the trends over time and Top Guest Customers, the 20 guests who spent most.
Example: if guests place 60% of orders but repeat at 4% against 18% for registered customers, test a reason to create an account after the first order, such as order tracking. If a yellow note says some orders aren’t linked to a customer record, those orders are left out of this page.
RFM Analysis: how scores are made
RFM rates customers on three things: Recency, the days since their last order; Frequency, how many orders they’ve placed; and Monetary, how much they’ve spent in total. It uses every order in your sale statuses and ignores the date range.
Each customer scores 1 to 5 on each letter, by where they rank among your customers: the top fifth scores 5 and the bottom fifth scores 1. For recency, fewer days scores higher. Customers with the same value share a score, so if most customers have one order, they share a middle frequency score. The Score column is the average of the three.
Insights recomputes RFM once a day. Click Recompute RFM to refresh it now; new results appear after a few seconds. Example: R 5, F 4, M 3 is a customer who ordered recently and often, with middling spend, and falls in Champions.
RFM segments and what to do with them
Segment Distribution and Customers per Segment show how many customers sit in each segment. Segment Breakdown gives each segment’s Avg Spend, Avg Orders and Avg Recency, and Top 20 Customers by RFM Score lists the highest scorers with their email.
The segment comes mostly from the R and F scores; M only decides Loyal and separates Hibernating from Lost. Insights checks the rules in the order below and uses the first one that fits.
Thank and reward Champions, give Can’t lose and At risk customers a personal reason to return, and don’t spend heavy discounts on Lost customers. RFM Analysis doesn’t list every customer in a segment; the top 20 table and Top Customers by Lifetime Value on Customers give you names.
- Champions
- R 4 or 5 and F 4 or 5. Bought recently and often.
- Loyal
- R 3 or more, F 3 or more and M 3 or more.
- Potential loyalist
- R 3 or more and F 3 or less. Recent, not yet regular.
- Needs attention
- R 2 and F 2 or more.
- About to sleep
- R 2 and F 1.
- Can’t lose
- R 1 and F 3 or more. Used to buy often, but not for a long time.
- At risk
- R 1 and F 2.
- Hibernating
- R 1, F 1 and M 2 or more.
- Lost
- R 1, F 1 and M 1.
Cohort Analysis: do new customers come back?
Each row is a cohort: the customers whose first sale order fell in that month, and Size is how many there were. M0 is that first month and is always 100%. M1 is the share who ordered in the next calendar month, M2 the month after, up to M12. Hover over a cell to see the number of customers and their revenue.
Revenue by Cohort shows what each cohort spent in each month, and Cohort Size Over Time shows each cohort’s size with its M1 rate. Avg Month-1 Retention averages M1 across cohorts. Cohort Analysis uses your full history and has no date controls.
Read down a column, not just along a row. If M1 falls from 22% to 12% in recent cohorts, newer customers come back less, so check what changed in how you won them. The newest cohorts have fewer columns, and the current month is still running, so its figures will rise.