Sales & marketing · Calculator companion · By K Imports
Net revenue retention: practical guide
This guide explains how to use the Count.ie net revenue retention. Measure recurring revenue retained and expanded within the original customer cohort. Follow the inputs, method and worked example below, then compare your own scenario.
Guide written .
Open the Net revenue retention calculatorWhat to prepare
- Define the event, conversion, customer and attribution period before collecting data.
- Use spend and outcomes from the same reporting window.
- Distinguish revenue, contribution profit, recurring revenue and customer lifetime assumptions.
Understand the inputs
The calculation method
NRR = (starting revenue + expansion − contraction − churn) ÷ starting revenue. Gross retention excludes expansion.
Worked example
Illustrative inputs and their result.
Example inputs
- Starting cohort recurring revenue (€)
- 100000
- Expansion revenue (€)
- 15000
- Contraction revenue (€)
- 5000
- Churned cohort revenue (€)
- 8000
Calculated example result
- Net Revenue Retention Percent
- 102%
- Gross Revenue Retention Percent
- 87%
- Ending Cohort Revenue
- €102,000.00
How to interpret the result
A marketing metric depends on its attribution and cost definitions. A favourable ratio is not proof that advertising caused every sale or that future customers will behave the same way.
Compare campaigns with the same attribution window and outcome definition. Test a lower conversion rate or shorter retention period before extrapolating a promising result.
Common mistakes to avoid
- Do not double-count a customer or conversion reported by multiple channels.
- Revenue is not the same as profit available to fund acquisition.
- Small samples and changing cohorts can produce unstable comparisons.
Assumptions and sources
Exclude new-customer revenue and use a consistent monthly or annual basis. Net retention can exceed 100%.
If your case falls outside this scope, use a more suitable calculator or contact us about an unclear method.