1. Define the opening cohort
Use customers and recurring revenue active at the beginning of one consistent period.
2. Enter lost customers
Count customers from the opening cohort that canceled or failed to renew.
3. Enter churned and contracted MRR
Separate full revenue losses from downgrades among retained customers.
4. Enter expansion MRR
Include upgrades, additional seats, or cross-sells from the opening cohort only.
5. Review the three retention views
Customer retention tracks accounts, GRR excludes expansion, and NRR includes expansion.
6. Keep new sales separate
Do not add revenue from customers acquired after the period began.