Category performance
Shows revenue by product category using native bar or pie charts.
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
Compare categories on revenue
Coming soonBlu builds a step
About this recipe
When to use it
Total revenue growth can hide a category quietly declining while another compensates. This tracks revenue and units by category with period comparison and a momentum score per category, so the real winners and losers show up.
What it delivers
Tracks revenue and units sold by product category, with period-over-period comparison and a momentum score highlighting categories gaining or losing share.
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 revenue by product category using native bar or pie charts.”
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.
- 01Compare categories on revenueCreate an Insights report called "Category Performance". Series A: Event "Placed order", aggregation: Sum of "total_price", unit: $, label: "Revenue" Series B: Event "Placed order", aggregation: Sum of items count (number of line items per order), label: "Units Sold" Series C: Computed: Series A / Series B, unit: $, label: "AOV per Category" Breakdown: By product category: extracted from Placed order.items (each line item carries product_id; resolve to category via the Products record-object). Top 12 categories, group remainder as "Other". Time range: Last 30 days Compare: Previous period (prior 30 days) AND year-over-year (same 30 days last year) Chart type: Treemap sized by Series A revenue, color-coded by YoY % change (green = growing, red = declining) Annotations: - For each category, label with: revenue, % share of total, MoM change, YoY change. - Flag categories with declining revenue AND declining units (true demand softening). - Flag categories with rising units but flat revenue (price/discount erosion). - Highlight the top 3 momentum categories (highest YoY growth combined with >5% share). Taxonomy notes: - Placed order.items is flattened (product_id, title, quantity, price, sku). Category lookup goes through the Products record-object. - "product_category" is not a property on Placed order: it's a derived join.
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 /product-category-performance 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 ChaudharyReturn rate by categoryShows which product categories get returned most, and which ones have got worse since last quarter.View recipe 