Monthly recurring revenue trend
Shows recurring revenue by plan over the last 12 months, with the month on month change and how each month compares with the same month last year.
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
Chart MRR by plan each month
Coming soonBlu builds a step
About this recipe
When to use it
One blended MRR line hides whether growth is coming from your entry plan or your enterprise tier. This breaks MRR down by plan with growth rate and net-new MRR overlaid, so the real growth driver is visible.
What it delivers
Tracks MRR over time broken down by plan tier, with month-over-month growth rate and a net-new MRR overlay layered on top.
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 recurring revenue by plan over the last 12 months, with the month on month change and how each month compares with the same month last year.”
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.
- 01Chart MRR by plan each monthCreate an Insights report called "Monthly Recurring Revenue Trend". Series A: Event "Revenue completed" where type indicates a recurring payment (or "Invoice paid" if Invoice paid is the canonical recurring revenue marker in this workspace), aggregation: Sum of "amount" property, unit: $, label: "MRR" - For Revenue completed, filter by type indicating subscription/recurring revenue. - For Invoice paid as fallback, aggregate amount_paid_cents and divide by 100 to get $. Series B: Computed: month-over-month MRR delta (current month MRR − previous month MRR), unit: $, label: "Net New MRR" Time granularity: Monthly Breakdown for Series A: By Plan: for Revenue completed users, the Plan comes from their Subscription started event (most recent active subscription). Render as stacked area. Time range: Last 12 months Compare: Year-over-year (same month previous year, dotted overlay) Chart type: Stacked area chart for Series A with Series B as a secondary line Annotations: - Add the absolute MRR figure for the most recent month as a callout. - Add the month-over-month growth rate (%) and the trailing 3-month average growth rate. - Flag any month where net new MRR went negative (contraction). - Highlight any plan tier whose share of MRR shifted by more than 5 percentage points YoY. Taxonomy notes: - Revenue completed has amount, customer_id, type, source: use type to filter for recurring revenue. - Invoice paid (Stripe) has amount_paid_cents: use as primary if Revenue completed type-discrimination is not configured. - Plan comes from Subscription started: join to user's most-recent active subscription to attribute the MRR. - "subscription_payment" as an event does not exist in the canonical taxonomy.
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 /mrr-trend 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 