Finding serial returners and their net revenue after returns
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?
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.
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.