Marketing & Advertising
Customer Churn Calculator
Calculate period churn, an approximate compound-equivalent monthly churn rate, ending customer count, and net customer growth. The customer movement view reconciles retained customers, losses, and additions so that a positive ending balance cannot conceal weak retention.
Period customer churn-
Approximate monthly churn-
Ending customer count-
Net customer growth-
Decision view
Customer-base movement through the period
Customer-base movement through the periodThe opening cohort separates into retained and lost customers, while new customers enter independently before the ending population is reconciled.
Exact scenario comparisonCustomers lost in period changes while all other entered assumptions remain constant.
| Customers lost in period | Period customer churn | Approximate monthly churn | Ending customer count | Net customer growth |
|---|
How to use Customer Churn Calculator
- Enter customers active at the start of the period and customers from that opening population who were lost under one documented cancellation rule. Lost opening-cohort customers cannot exceed the opening count.
- Enter newly added customers and the period length in months; exclude reactivations or classify them consistently.
- Read gross churn beside ending customer count and net growth, then investigate churn by cohort, plan, tenure, reason, and value.
Calculator guide
Understanding Customer Churn Calculator
Customer churn measures how much of the opening customer base was lost during a defined period. New customers are shown separately because acquisition can make the ending count rise even while the original cohort is deteriorating.
Calculation method
How the calculation works
Limit recognized losses to the opening cohort, divide those losses by the opening count, derive the compound-equivalent monthly rate from surviving customers, and reconcile the ending count with additions. Limit recognized losses to the opening cohort, divide those losses by the opening count, derive the compound-equivalent monthly rate from surviving customers, and reconcile the ending count with additions.
Diagnostic framework
Turn a churn rate into an action plan
A churn total becomes useful only after the business identifies when, why, and where customers leave.
Record a consistent churn effective date and reason taxonomy before comparing teams, plans, or time periods.
Worked situations
Practical examples
- Starting with 12,000 customers and losing 720 produces 6% customer churn for the three-month period.
- The compound-equivalent monthly churn is approximately 2.041%, not simply 6% divided by three.
- Adding 1,100 new customers produces 12,380 ending customers and 3.167% net growth even though 720 opening customers were lost.
Better inputs
Useful tips
- Freeze the opening cohort and follow its members through the whole period; do not add mid-period acquisitions to the churn denominator.
- Separate voluntary cancellation, failed payment, contract expiry, migration, fraud removal, and account consolidation because remedies differ.
- Pair logo churn with revenue churn, gross-margin churn, expansion, contraction, and retention by customer value.
Before relying on the result
Limitations and common mistakes
- The monthly equivalent assumes a constant compound loss rate and may not reflect a churn spike concentrated at renewal or onboarding.
- One aggregate rate hides tenure, product, contract, geography, acquisition-source, and customer-value differences.
- The calculation caps an entered loss above the opening cohort at the opening count to prevent an invalid negative-survival calculation. Treat that cap as a source-data warning, then reconcile identities and cohort scope before using the result.
- The calculation cannot resolve inconsistent identities, pauses, reactivations, mergers, duplicate accounts, or changing activity definitions.
Reference
Key terms
- Opening cohort
- Customers active at the beginning of the measurement period under the chosen identity rule.
- Customer churn
- Lost opening-cohort customers divided by customers in the opening cohort.
- Monthly equivalent churn
- Constant monthly compound loss rate that would produce the entered period churn.
- Net customer growth
- Ending customers minus opening customers, divided by opening customers.
Important note
Calculated from the entered campaign values. Validate attribution, incrementality, lag, margin, and observed source data before making decisions.
Frequently asked questions
Can customer count grow while churn is high?
Yes. Acquisition can exceed losses, producing net growth while the opening cohort still churns rapidly.
Should new customers be included in the churn denominator?
Not in this opening-cohort calculation. They enter the ending-count reconciliation separately.
Is monthly churn equal to period churn divided by months?
Only as a rough linear approximation. The calculator uses the constant compound monthly rate implied by period survival.
Should reactivated customers count as new?
Choose and document a rule. Many teams report reactivation separately so acquisition and retention remain interpretable.