Return rate by category
Shows which product categories get returned most, and which ones have got worse since last quarter.
Authored by Sid Chaudhary
Founder & CEO at Intempt
Agentic workflow
Coming soon1 step Blu runs end to end. It drafts a plan and nothing runs until you approve it.
- 1
Rank categories by returns
Coming soonBlu builds a step
About this recipe
When to use it
Return rate creeping up in one category is easy to miss in a blended number. This breaks it down by category with previous-period comparison and flags any category whose rate is actively rising.
What it delivers
Tracks return rate by product category, compared against the previous period, with an automatic flag on categories showing a rising trend.
How you prompt this
Describe the outcome in your own words and Blu Agent maps it to this recipe, or run it by name. It drafts a plan first and nothing runs until you approve it.
Tell Blu Agent what you want
“Shows which product categories get returned most, and which ones have got worse since last quarter.”
recipe.md preview
Built from the published catalog. Blu Agent's full step prompts load in your workspace when you run it.
Inputs & outputs
What the recipe needs before it runs, and what it leaves in your workspace.
Inputs
- Nothing declared beyond an Intempt workspace. Blu asks for anything else it needs as it goes.
Outputs
How the recipe runs
Blu follows the steps in order and shows you each one before anything goes live.
- 01Rank categories by returnsCreate an Insights report called "Return Rate by Category". Series A: Event "Order fulfilled", aggregation: Count Series B: Event "Return requested", aggregation: Count Formula: (B / A) × 100, unit: %, label: "Return Rate" Breakdown: By product category: derive from Return requested.items joined to Products to find category, OR from the source order's items (Return requested carries order_id relation). Time range: Last 90 days Compare: Previous period (prior 90 days) Chart type: Bar chart sorted by total return rate descending Annotations: - Flag any category where return rate jumped >5 percentage points vs. prior period. - Surface top 5 categories by absolute return volume and top 5 by return rate (the lists are usually different and both matter). Taxonomy notes: - Return requested has items, order_id (relation), return_id, status. Items resolve to categories through the Products record object. - Note: there is no canonical "return_reason" property on Return requested. Reason analysis would require joining with Order refunded (which has a reason text field) when the return is monetized.
Install Intempt and run it
- 1
Sign up
Create a free Intempt workspace.
- 2
Connect your data
Add the sources this recipe reads from.
- 3
Ask Blu
Type /return-rate-by-category in Blu once this recipe is live there.
- 4
Review and approve
Blu builds each step and waits for your OK before anything goes live.
Related recipes
Sid ChaudharyDiscovery call qualification fieldsGenerates an AI summary for Discovery calls from meeting data using the qualification framework in the summary recipe.View recipe Sid ChaudharyPost demo nurtureKeeps a demo warm for 90 days with a playbook, a case study, an ROI calculator and a customer story, and pulls the AE in early if they bite.View recipe Sid ChaudharyTalking head from a portraitTurns a portrait still into a 5 second talking-head loop with subtle lip movement and eye contact.View recipe 