Return Reasons Analysis From Exported Data
Find patterns that reduce returns.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Analyze these return records and tell me what to fix. Data (anonymized, columns such as SKU, reason, date, cost, customer notes): [PASTE_RETURN_DATA]. Total orders in the same period: [TOTAL_ORDERS]. Average order value and margin: [ORDER_VALUE_AND_MARGIN]. Return: 1. A summary table: return rate overall and by SKU, reason category, and cost per return including shipping and lost margin. Show formulas used. 2. The top five problems by cost, with likely root cause (listing mismatch, quality, sizing, shipping damage, expectations). 3. Evidence for each cause from customer notes (short quotes). 4. For each problem, one fix to try, how to measure it, and the target improvement. 5. SKUs I should consider changing, relisting, or removing, with reasons. 6. Caveats: small samples, mixed reasons, missing data. If the data is insufficient for a claim, say so rather than guessing. End by suggesting three new fields I should capture in the returns form to improve this analysis.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.