Net revenue retention by cohort
Tracks monthly cohort retention rates over time to measure ongoing customer and user engagement.
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
Track cohort revenue month by month
Coming soonBlu builds a step
About this recipe
When to use it
A single blended NRR hides whether last year's cohort or this year's is driving retention. This computes proper NRR per cohort - starting MRR plus expansion and reactivation, minus contraction and churn - from real subscription deltas.
What it delivers
Computes net revenue retention per acquisition cohort using the full formula (starting MRR + expansion + reactivation − contraction − churn), derived from real subscription_updated deltas rather than estimated.
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
“Tracks monthly cohort retention rates over time to measure ongoing customer and user engagement.”
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.
- 01Track cohort revenue month by monthCreate a Retention report called "Net Revenue Retention by Cohort". Cohort: Monthly cohort defined by month of first paid Subscription started (trial_end is null OR a follow-on after-trial Subscription started) per user. For each cohort and each month-after-cohort N (M, M+1, M+2, ... M+12), compute the dollar values for users in the cohort: - Starting MRR (cohort's recurring revenue in month N-1) = Sum of Revenue completed.amount filtered to recurring type, for cohort users - Expansion MRR = Sum of positive amount-deltas from Subscription updated events in month N for cohort users (where the post-event amount exceeds the prior amount on the same subscription_id) - Reactivation MRR = Sum of subscription_resumed.amount in month N for cohort users who had a prior Subscription canceled - Contraction MRR = Sum of negative amount-deltas from Subscription updated events (subtracted) - Churned MRR = Sum of the prior subscription amount for each Subscription canceled in month N (subtracted) - Ending MRR = Starting + Expansion + Reactivation − Contraction − Churn - NRR for cohort at month N = Ending MRR / Original cohort revenue at month M × 100, unit: % Time range: Last 12 cohort-months Breakdown: By initial Plan (the Plan on the cohort-defining Subscription started) Chart type: Multi-line chart: X axis is months-since-cohort, Y axis is NRR %; each cohort is a line. Plus a stacked bar showing the per-component decomposition for the most recent cohort. Annotations: - Add benchmarks: NRR ≥ 100% (cohort growing in revenue despite churn); ≥ 110% (top-quartile); ≥ 120% (best-in-class). - Flag any cohort whose NRR at M+6 is below 90% (revenue erosion). - Highlight the cohort with the highest M+12 NRR. - Flag whether NRR is improving across cohorts over time (cohort-quality trend). Surface the trailing 12-month blended NRR (a single headline number) and whether the cohort-level trend is improving. Taxonomy notes: - The canonical taxonomy does not have separate subscription_upgraded/_downgraded/_reactivated events. Expansion and Contraction are computed by Lovable from Subscription updated by comparing pre/post amount on the same subscription_id. Reactivation is computed as subscription_resumed (or subscription_activated) where the same customer_id had a recent Subscription canceled. - This recipe depends on Subscription updated firing reliably with sufficient detail (changed_fields, plan_items) for the delta computation. If the integration emits sparse Subscription updated, the report degrades to logo-retention only.
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 /net-revenue-retention-by-cohort 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 