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
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
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions