← All industries

Retail analytics consulting Know which customers carry your revenue, and which are slipping away.

In a typical online store a minority of customers brings most of the money. We find them in your order data, track whether they come back, and put the numbers that matter on one weekly dashboard.

What usually goes wrong

Revenue grows, but nobody knows from whom

Sales reports show totals by product and month. They do not show that a fifth of customers may bring three quarters of revenue, or that this group is shrinking.

Discounts go to everyone

Without segments, a retention offer reaches loyal buyers who would have bought anyway and misses those about to leave.

Repeat rate is a guess

Cohort retention is rarely tracked, so a drop in second purchases shows up months later as a revenue gap.

Ten dashboards, no answer

Platform reports, ad cabinets and spreadsheets disagree on revenue and customers. Meetings start with "which number is right?"

The numbers we put on your dashboard

MetricFormulaWhy it matters
Revenue share by RFM segmentsegment revenue ÷ total revenueShows how concentrated revenue is and which group to protect first.
Repeat purchase ratecustomers with 2+ orders ÷ active customersThe base of predictable revenue.
Cohort retention, month Nbuyers in month N ÷ cohort sizeCatches a falling second purchase months before revenue does.
Average order valuerevenue ÷ ordersSeparates "more orders" from "bigger orders".

Mini dashboard · public data

What this looks like on real orders

Built on 541,910 real transactions of a UK online retailer (UCI Online Retail II, 2010-12 to 2011-12). Your dashboard uses your data.

$508average order value
63.9%customers with 2+ orders
74.6%of revenue from the top 20% of customers
3.2%of gross sales cancelled
Revenue share by RFM segment, %
Champions49.0%
Loyal26.0%
Can't lose2.0%
At risk7.3%
Potential loyalists5.6%
Need attention1.8%
New0.2%
Promising0.3%
About to sleep1.9%
Hibernating5.9%

Source: UCI Online Retail II (Chen, 2019), sheet Year 2010-2011, CC BY 4.0; our calculation

Monthly revenue, $K
$0K
$500K
$1,000K
$1,500K
$1,452K
Dec 10$776K
Jan 11$670K
Feb 11$508K
Mar 11$690K
Apr 11$515K
May 11$740K
Jun 11$738K
Jul 11$688K
Aug 11$724K
Sep 11$1,028K
Oct 11$1,103K
Nov 11$1,452K
Dec 10Feb 11Apr 11Jun 11Aug 11Oct 11Nov 11

Source: UCI Online Retail II (Chen, 2019), sheet Year 2010-2011, CC BY 4.0; our calculation

Case study

E-commerce retention model on 500,000+ transactions

Which customers come back? A retention model on a public online-retail dataset that beats the benchmark by 9 points of AUC.

From the blog

RFM segmentation on 500K real transactions: what drives repeat revenue

We scored 4,334 customers of a real online retailer by recency, frequency and monetary value. A third of them bring three quarters of revenue. Here is the method, the numbers and what to do with each segment.

Bring one question and a sample of your data.

On a free 20-minute call we tell you what the data can answer and what it would cost.

Book a 20-min call