Finding serial returners and their net revenue after returns
The short answer
A serial returner is a customer who returns a high share of what they buy, such as more than 30% of order value. Calculate each customer's return rate and net revenue after returns, then list those above your threshold. Some still earn you money. Others cost more in handling than they bring in.
Serial returner net revenue, worked through
Why it matters
A small group of customers can account for a large share of returns, along with the freight and handling that come with them. Knowing their net revenue after returns shows which ones cost you money, which are still worth keeping close and where a policy change would pay.
The question to ask
Copy this into Lexi as written.
How to work it out
1. Total purchases and returns per customer. Add up units and value bought and returned over 12 months across online and store.
2. Calculate return rate and net revenue. Divide returned value by purchased value, then subtract returns and discounts from purchases for net revenue.
3. Flag by threshold. List customers above a 30% return rate and rank them by net revenue so profitable serial returners separate from loss-making ones.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for an apparel retailer. It flags customers who returned more than 30% of order value over a year and calculates their net revenue after returns and discounts.
- Customer A: $4,200 bought, 45% returned. Net revenue $2,000.
- Customer B: $1,600 bought, 60% returned. Net revenue $400.
- All 3,100 flagged customers: $4.4 million net revenue.
What the data shows
Serial returners still bring in $4.4 million, and many, like Customer A, are valuable.
What it means
Most high-return, high-value customers order two sizes and keep one. A stricter policy could cost more than it saves.
What to do
Offer fit help to high-value returners, and review policy only for customers like B.
Return shipping and handling are not yet included. Want me to add them?
Frequently asked questions
What return rate makes someone a serial returner?
There is no standard line. A common starting point is 30% of order value, but categories differ, so set the threshold above your normal return rate for the category. Review it as your data grows, and look at net revenue as well, since a high rate alone does not make a customer unprofitable.
Are serial returners always unprofitable?
No. A customer with a high return rate can still be profitable if they buy a lot and the items they keep carry good margin. Net revenue after returns, less handling cost where you have it, shows which ones earn their place.
Is it fair to restrict serial returners?
Decide on evidence. Check that the pattern holds over time, does not come from faulty products or sizing, and covers a meaningful share of their orders. Then apply changes to a defined group with clear rules.