What Is Net Revenue Retention (NRR)?
Net revenue retention measures how much recurring revenue a business keeps from its existing customers over a period, after accounting for upgrades, downgrades, and cancellations. It starts with the revenue from a group of customers, then adds the expansion they bought, subtracts what they downgraded, and subtracts what churned, all expressed as a percentage of where they started. Crucially, it excludes revenue from brand-new customers, so it isolates how the existing base is performing. An NRR above 100% means the existing customers are growing on their own, even before any new sales.
How to Calculate Net Revenue Retention
NRR = (Starting Revenue + Expansion – Contraction – Churn) / Starting Revenue
Worked example, for a cohort over a year:
- Starting recurring revenue: $1,000,000
- Expansion (upgrades): $200,000
- Contraction (downgrades): $50,000
- Churned revenue: $100,000
- NRR: (1,000,000 + 200,000 – 50,000 – 100,000) / 1,000,000 = 105%
An NRR of 105% means the existing base grew 5% over the year without any new customers.
NRR in Power BI (DAX)
Replace the measures with the ones in your model:
NRR =
DIVIDE (
[Starting Revenue] + [Expansion] - [Contraction] - [Churned Revenue],
[Starting Revenue]
)Why NRR Matters
Net revenue retention is one of the strongest signals of a healthy recurring-revenue business. An NRR above 100% means the company would grow even if it never signed another new customer, because expansion within the existing base outweighs churn. That is powerful: it means growth compounds on a stable foundation rather than depending entirely on new sales. Investors watch NRR closely because it captures both retention and the ability to grow customers over time.
NRR vs Churn Rate
Churn rate and net revenue retention are related but not the same. Churn measures only what is lost. NRR nets losses against the expansion that existing customers add, so it captures the full picture of how the base is moving. A company can have meaningful churn and still post an NRR above 100% if its remaining customers are expanding fast enough to more than make up for it.
Reporting NRR From Your Data
A reliable NRR depends on tracking the revenue of each customer over time, including upgrades, downgrades, and cancellations, which usually spans a CRM and a billing or ERP system. A governed data foundation brings that together so retention is measured consistently. QuickLaunch builds that foundation across systems like Salesforce and the financial ERPs, so revenue retention ties back to the same governed data.
Frequently Asked Questions
How is net revenue retention calculated?
Take the starting recurring revenue of a group of customers, add expansion, subtract contraction and churn, and divide by the starting revenue. A base that grows to a net $1.05M from $1M has an NRR of 105%.
What is a good net revenue retention?
An NRR above 100% is strong, because it means the existing customer base grows on its own before any new sales. Many high-performing subscription businesses target well above 100%.
What is the difference between NRR and churn rate?
Churn measures only revenue lost. Net revenue retention nets that loss against the expansion existing customers add, so a company can have churn and still post an NRR above 100% if expansion outweighs it.
About the Author
