Net Revenue Retention Driver Mix Calculator

Model net revenue retention (NRR) from its core drivers. Enter starting revenue, expansions, contractions, and churn to see the NRR percentage, retained dollars, and each driver’s share with an optional gap to your target.

Opening monthly recurring revenue (MRR) or ARR for the cohort in US dollars.
Upsell, cross-sell, and seat expansion booked during the period in US dollars.
Downgrades or usage reductions that shrink revenue but keep the customer active.
Recurring revenue lost to full logo churn during the period.
Optional benchmark in percent. Leave blank to skip gap analysis.

For SaaS analytics scenarios; reconcile outputs with finance systems of record before publishing investor metrics.

Examples

  • Starting revenue $900,000, expansion $210,000, contraction $75,000, churn $27,000, target 115% ⇒ NRR 112.00%, retained $1,008,000.00, gap to target −3.00 points.
  • Starting revenue $1,250,000, expansion $387,500, contraction $50,000, churn $62,500 ⇒ NRR 122.00%, retained $1,525,000.00 without a target gap.

FAQ

Should I use MRR or ARR?

Either works. Keep the time basis consistent between starting revenue and each driver so the ratios remain valid.

How do reactivations factor into NRR?

If a churned customer returns within the window, count the revenue as expansion. Long-lapsed reactivations typically enter new logo metrics instead.

What if retained revenue exceeds forecasted capacity?

Large expansions may require capacity checks. Pair this output with staffing or infrastructure models to ensure you can deliver the additional value customers purchased.

Additional Information

  • Result unit: net revenue retention percentage with supporting dollar amounts.
  • Driver shares are normalised against starting revenue to keep comparisons consistent across cohorts.
  • Gap analysis compares actual NRR to the optional target percentage you provide.

Related calculators