wowprompt

Product return rate analysis by reason, size and courier

Breaks an online store's returns into rates by product, size, return reason and courier, finds the few causes behind most of the cost, and names a fix for each one. Use it for fashion, footwear or electronics stores where returns eat into festive season margins.

A return rate table by product, size and courier, a ranked list of return reasons with cost, and a fix plan for the top causes
The output this prompt produced, unedited.

The prompt

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

  1. Split returns into customer returns and return to origin (refused, unreachable, wrong address).
  2. Work out return rate by product, size, courier, payment mode and region.
  3. Group the free-text reasons into themes such as size too small, looks different, damaged, late.
  4. Rank causes by total cost, not by count.

Output format

  1. | Segment | Orders | Returns | Return rate | Cost |
  2. Top five causes, each with the evidence row and one fix, such as a size chart change or cash on delivery confirmation calls.
  3. 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.
return rate analysisecommerce returnsrto analysissize returnsreturn reasonsreverse logistics cost

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity