Subscription churn and retained revenue · Calculation guide

Measure how much of an opening customer cohort and its recurring revenue remain.

Calculation guide

Use only the opening cohort for all entries. Cancellations and downgrades reduce gross retained MRR; upgrades count only toward net retention. Enter mutually exclusive, net period movements. Exclude new and reactivated customers.

retained = opening-churn-contraction+expansion; churn_pct = 100*lost/customers; grr = 100*(opening-churn-contraction)/opening; nrr = 100*retained/opening

Inputs

Opening subscribers

Example entry 100. Minimum 1.0. Use whole numbers.

Opening subscribers lost

Example entry 5. Use whole numbers.

Opening monthly recurring revenue

Example entry 10000 (in the selected currency).

MRR lost to cancellations

Example entry 500 (in the selected currency).

MRR lost to downgrades

Example entry 200 (in the selected currency).

MRR gained from upgrades

Example entry 300 (in the selected currency).

Worked example

InputValue
Opening subscribers100
Opening subscribers lost5
Opening monthly recurring revenue10,000
MRR lost to cancellations500
MRR lost to downgrades200
MRR gained from upgrades300
ResultValue
Closing MRR from opening cohort9,600
Customer churn rate5%
Gross revenue retention93%
Net revenue retention96%

Calculation steps

Closing MRR from opening cohort = (((Opening monthly recurring revenue − MRR lost to cancellations) − MRR lost to downgrades) + MRR gained from upgrades)

(((10,000 − 500) − 200) + 300) = 9,600

Customer churn rate = ((100 × Opening subscribers lost) ÷ Opening subscribers)

((100 × 5) ÷ 100) = 5%

Gross revenue retention = ((100 × ((Opening monthly recurring revenue − MRR lost to cancellations) − MRR lost to downgrades)) ÷ Opening monthly recurring revenue)

((100 × ((10,000 − 500) − 200)) ÷ 10,000) = 93%

Net revenue retention = ((100 × Closing MRR from opening cohort) ÷ Opening monthly recurring revenue)

((100 × 9,600) ÷ 10,000) = 96%

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening subscribers100110Customer churn rate5%4.545455%
Opening subscribers lost56Customer churn rate5%6%
Opening monthly recurring revenue10,00011,000Closing MRR from opening cohort9,60010,600
MRR lost to cancellations500550Closing MRR from opening cohort9,6009,550
MRR lost to downgrades200220Closing MRR from opening cohort9,6009,580
MRR gained from upgrades300330Closing MRR from opening cohort9,6009,630
Subscription churn and retained revenue →

Sources