How do I measure net revenue retention (NRR) and gross retention (GRR) with iDBQuery?
Ask iDBQuery 'What was our net revenue retention last quarter, broken into expansion, contraction, and churn?' It compares each cohort's starting and ending recurring revenue across your billing tables, returns NRR and GRR as a chart, and cites every component to its source rows.
Net revenue retention (NRR) measures how recurring revenue from an existing customer base changes over a period once you include upgrades, downgrades, and cancellations; gross retention (GRR) excludes expansion. Both are notoriously fiddly to compute by hand. iDBQuery does it from a sentence.
- You'd ask iDBQuery: 'Calculate NRR and GRR for the customers we had at the start of last quarter, with the expansion, contraction, and churn breakdown.'
- It anchors the starting cohort, compares starting vs ending MRR across your `subscriptions` and `invoices` tables, and returns a waterfall plus the two headline percentages.
- Each component is cited to source rows, so an investor deck figure like 'NRR = 114%' traces to the exact accounts that expanded or churned.
Because the calculation depends on a consistent revenue definition, you can set MRR once in the semantic layer and every retention answer stays aligned. Follow-ups work naturally: 'Which segment dragged GRR down?' or 'Show NRR trend over eight quarters.' The one live model lets you pull segment or industry attributes from a CRM export into the same answer without a pipeline. If NRR slips, the Analyst agent can investigate whether contraction or logo churn drove it and present the supporting rows.
Updated 2026-06-22