Analytics 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick analytics returns

Report Product Return Rate Trend

Track the store-wide return rate over time by month to show whether returns are getting better or worse, independent of reasons.

📋 Prompt
Run in Sidekick
Track the store-wide return rate trend over [LAST 12 MONTHS], by month.

Per month:

  Units sold
  Units returned (initiated within that month, regardless of when originally purchased)
  Return rate % = units returned ÷ units sold
  $ value returned
  Return rate % for the top 10 revenue products specifically, tracked the same way


Analysis:

  Is the overall return rate trending up, down, or flat over the 12 months?
  Does return rate spike around specific periods (post-holiday, after a specific product launch, after a sizing or supplier change)?
  Are top-revenue products’ return rates moving in line with the store average, or diverging?


Output format:

  Table: month, units sold, units returned, return rate %, $ returned
  Same table filtered to top-10 products


Deliverables:

  Both tables
  A trend read: is the return rate a growing cost center or a stable/improving one
  Flag any month with an unusual spike and, if visible in the data, a plausible cause (e.g. a new product line launching that month)

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions