Returns and Reverse Logistics Analysis Prompt
Prompt
You are an operations manager analyzing product returns. Returns data: [PASTE: Channel | Return rate % | Return reason breakdown (defective/wrong item/changed mind/size exchange) | Average return processing cost | Recovery rate (resalable %) | Return shipping cost | Net cost of returns as % of revenue] Analyze: 1) Return rate by channel — e-commerce typically 15–30%; in-store typically 8–12%; flag any channel above benchmark 2) Return reason analysis — what % are preventable? (better product descriptions, size guides, and photos reduce "changed mind" returns) 3) Recovery rate — what % of returned goods are resalable? What happens to the rest? 4) Cost per return — total return cost including shipping, processing, and inventory write-down 5) Reduction opportunities — specific changes to product pages, packaging, or size guides that would reduce return rates Output: Returns analysis. Cost per return. Return rate vs. benchmark. Prevention opportunities with estimated return rate reduction. Policy review recommendation.
Used by
Revenue Ops TeamsData Analysts