Customer analytics: segmentation and lifetime value
Customer analytics shows which customers are worth keeping, which have stopped buying and what each kind is worth after returns. You get customer segmentation on readable rules for recency, frequency and value, and customer lifetime value per acquisition cohort after acquisition cost.
RFM segments, example
Champions are 10% of customers and 41% of revenue
-
Champions
2,000£984,000
Rule: last order within 90 days, 4 or more orders and £300 or more in 12 months -
Loyal
3,400£624,000
-
New
3,000£216,000
-
At risk
4,600£408,000
-
Lapsed
7,000£168,000
Show the numbers
| Segment | Customers | Share of customers | Revenue after returns | Share of revenue |
|---|---|---|---|---|
| Champions | 2,000 | 10% | £984,000 | 41% |
| Loyal | 3,400 | 17% | £624,000 | 26% |
| New | 3,000 | 15% | £216,000 | 9% |
| At risk | 4,600 | 23% | £408,000 | 17% |
| Lapsed | 7,000 | 35% | £168,000 | 7% |
| Total | 20,000 | 100% | £2,400,000 | 100% |
What customer segmentation fixes
Cohort analysis, segments and lifetime value: what you get
A customer who cost £45 to win and sends back half of what they order has a lifetime value, and it can be below zero.
How a customer analytics project runs
- 1
Scoping
Scoping takes the order, refund and customer tables and ad spend by channel, and matches guest orders on email where your terms allow it.
- 2
Build
The segments are SQL rules in your warehouse, tested so every customer lands in one segment and revenue sums to the order system's total.
- 3
Handover
Marketing learns to rebuild a segment from its rule.
- 4
After handover
The segments refresh on a schedule, and moving a threshold, say Champions from four orders to five, is a one-line change.
How customer lifetime value misleads
In the example data, a Champion brought in £492 of revenue after returns over the year, and a Lapsed customer £24.
Customer analytics by industry
Whether a win-back email caused the orders it claims is a marketing measurement question, and a holdout answers it. Forecasting can turn the cohorts' retention curves into next quarter's repeat orders.
Questions about segments and lifetime value
What is RFM analysis?
RFM sorts customers on recency (days since the last order), frequency (orders in a set window) and monetary value (what they spent in it). A customer who ordered 40 days ago, five times this year, for £520, lands in Champions (last order within 90 days, 4 or more orders, £300 or more in 12 months).
How do you work out customer lifetime value?
It's worked out by acquisition cohort, meaning everyone whose first order fell in the same month, as cumulative contribution per customer at 3, 6, 12 and 24 months, less acquisition cost per customer.
Do you do customer segmentation for ecommerce?
Yes. Segments are built on orders after returns, so a customer who sends back most of what they buy doesn't count as a Champion, however often they order.
Can you do churn analysis for a subscription business?
Yes. Churn is read for each start-month cohort at every renewal, and where cancellations carry a reason, voluntary cancellations are split from failed payments too.
Can you build lead scoring for a B2B sales team?
Yes, on the same principle. The score is written as rules learned from past leads that did and didn't become deals, and tested on a held-back batch before your sales team uses it.
How much order history do you have?
On the call we look at where your order history lives and say which segments and cohorts it can support.