✏️Prompts

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