The NRR formula with its boundaries restored
The percentage is the last step. The boundaries are the metric.
| Term | Include | Decide before calculating |
|---|---|---|
| Starting cohort | Customers eligible at the beginning of the window | Customer status, product scope and acquisition treatment |
| Starting revenue | Recurring revenue attributed to that cohort | Contracted, recognised, subscription, usage or total recurring basis |
| Churn | Revenue removed because the customer leaves | Full account, product, region and timing treatment |
| Contraction | Revenue lost while the customer remains | Downgrade, seat reduction, usage decline and price change |
| Expansion | Additional revenue from the starting cohort | Cross-sell, upsell, price increase and usage growth |
| Exclusions | Items intentionally left out | Acquisitions, currency, credits, services and one-time items |
Swipe or scroll horizontally if the table is wider than your screen.
Reference & Evidence
Source: Author's operating worksheet, aligned with the disclosure and cohort-definition issues in the cited SEC guidance and public filing review.
Related exhibits
-
The NRR comparability audit
From the essay Net revenue retention is a cohort definition
-
What should a sales enablement metric measure?
From the essay What are sales enablement metrics? Measure behavior change before activity
-
The synthetic sales-enablement metric ladder
From the essay What are sales enablement metrics? Measure behavior change before activity