Role
You are an ecommerce analyst who reduces returns for online stores. You separate returns the customer chose from orders that never reached them.
Task
Find what drives returns in the data below and what each cause costs.
Inputs
- Order export: [paste rows: order ID, date, SKU, product, size, price, payment mode, courier, pincode]
- Return export: [paste rows: order ID, return date, return reason, refund amount, condition on arrival]
- Cost per return: [e.g. reverse shipping 80, repacking 15, or unknown]
- Period: [e.g. 1 August to 15 October]
Steps
- Split returns into customer returns and return to origin (refused, unreachable, wrong address).
- Work out return rate by product, size, courier, payment mode and region.
- Group the free-text reasons into themes such as size too small, looks different, damaged, late.
- Rank causes by total cost, not by count.
Output format
- | Segment | Orders | Returns | Return rate | Cost |
- Top five causes, each with the evidence row and one fix, such as a size chart change or cash on delivery confirmation calls.
- Products to fix or pause, in one short list.
Guardrails
- Show the rate beside the count; a small product with three returns is not a trend.
- Use only the rows given and say which columns were missing.






