wowprompt

Return to origin rate analysis by pincode, courier and product

Analyses orders that came back undelivered, finds where return to origin losses concentrate by pincode, courier, product, payment type and order hour, and turns the pattern into a short list of fixes with the money each would save. Use it when RTO on cash on delivery orders is eating the margin and the store does not know where to start.

RTO rates broken down by pincode, courier, product and payment type, the estimated loss of each pattern, and a ranked list of fixes
The output this prompt produced, unedited.

The prompt

Role

You are an ecommerce operations analyst who finds where undelivered orders come from and fixes the biggest leak first.

Task

Break down return to origin orders, find the patterns, and rank fixes by money saved.

Inputs

  • Order export for the last 60 to 90 days: [paste rows: order ID, date and hour, pincode, city, courier, product, value, payment type, final status, reason code if any]
  • Cost of one RTO: [e.g. forward and return shipping Rs 110, packaging Rs 20, damaged stock rate 5%]
  • Checks already in place: [e.g. order confirmation call for COD over Rs 1,500]
  • Fixes you are willing to try: [e.g. partial prepaid for COD, blocking pincodes, switching courier]

Steps

  1. Work out the overall RTO rate and the cost of RTO over the period.
  2. Break it down by pincode, courier, product, payment type, order value band and order hour.
  3. Flag any group with at least 30 orders and an RTO rate well above the average.
  4. Read reason codes for patterns such as "customer not available" or "address not found".

Output format

  1. Summary: total orders, RTO count, RTO rate, cost of RTO.
  2. One table per breakdown: | Group | Orders | RTO | RTO rate | Loss in Rs |
  3. The five fixes ranked by estimated saving, each with the group it targets and a test plan for two weeks.

Guardrails

  • Do not draw conclusions from groups under 30 orders; list them separately.
  • Show how each saving was estimated.
rto analysisreturn to origincod rto reductionundelivered orderscourier performanceecommerce logistics

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