Churn Rate Calculator
Measure customer churn for your subscription or recurring‑revenue business. This tool helps you calculate gross churn, net churn, and logo churn so you can see how cancellations and new customers shape your customer base over time.
Churn rate formulas
Churn is the rate at which customers leave your product or service. For subscription and recurring‑revenue businesses, churn is a critical metric: it shapes growth, affects cash flow, and reveals how well you retain value. The formulas in this tool focus on customer counts, giving you a clear view of how your customer base changes over a period.
1. Basic customer flow
Customer flow identity:
Ending customers =
Starting customers
+ New customers
+ Reactivated customers
+ Trial conversions
− Churned customers
If your inputs do not satisfy this identity, the calculator will highlight
the discrepancy so you can reconcile your counts.
This identity is the backbone of churn analysis. It ensures that your starting customers, new customers, reactivations, trial conversions, and churned customers add up to the ending customer count. When the identity doesn’t hold, it usually means some events are missing or misclassified.
2. Gross churn rate
Gross churn rate (%) =
(Churned customers ÷ Starting customers) × 100
Gross churn rate focuses purely on customers lost during the period. It does not consider new or reactivated customers. This makes it a clean measure of how much of your existing base you failed to retain, which is useful for tracking retention performance over time.
3. Net churn rate
Net churn rate (%) =
((Churned customers − New customers − Reactivated customers) ÷ Starting customers) × 100
If the result is negative, you effectively have negative churn:
your base grew more from new and reactivated customers than it shrank from churn.
Net churn rate adjusts gross churn by considering growth. When net churn is negative, it means your customer base expanded even after accounting for cancellations. Many subscription businesses aim for negative net churn because it indicates strong growth and retention.
4. Logo churn
Logo churn (%) =
(Churned customers × Logo weight ÷ Starting customers) × 100
Logo weight is typically 1.0, treating each customer as one logo.
You can adjust it if you want to emphasize certain segments.
Logo churn treats each customer as a single account, regardless of revenue. It is useful when you care about the number of relationships rather than their monetary value—for example, when tracking enterprise logos or strategic accounts.
5. Implied growth rate
Implied customer growth rate (%) =
((Ending customers − Starting customers) ÷ Starting customers) × 100
This growth rate shows how your customer base changed overall. It complements churn metrics by highlighting whether your net movement is positive or negative. A business can have moderate churn but strong growth if new and reactivated customers more than offset losses.
These formulas are intentionally simple and transparent. You can export the CSV and adapt them for revenue churn, segment‑specific analysis, or cohort‑based models. The goal is to give you a clear starting point for understanding churn dynamics, not to replace deeper analytics.
Understanding churn in recurring‑revenue businesses
Churn can feel like a blunt metric: a single percentage that says how many customers you lost. But behind that number is a story about product fit, customer experience, pricing, and competition. The churn rate calculator is designed to help you see that story more clearly by breaking churn into components and connecting it to overall customer growth.
When you enter starting customers, ending customers, new customers, reactivations, trial conversions, and churned customers, the tool checks whether your counts satisfy the basic customer flow identity. This simple check often reveals missing data or misclassified events. Once the identity holds, the churn metrics become much more trustworthy.
Gross vs. net churn
Gross churn tells you how much of your existing base you failed to retain. It’s a direct measure of retention performance. Net churn, on the other hand, tells you how your base changed after accounting for growth. A business can have relatively high gross churn but still grow if new and reactivated customers are strong.
For example, imagine you start the month with 1,200 customers. You lose 100, add 180 new customers, and reactivate 20. Gross churn is (100 ÷ 1,200) × 100 ≈ 8.3%. Net churn is ((100 − 180 − 20) ÷ 1,200) × 100 ≈ −8.3%. The negative net churn means your base grew despite the losses, which is a very different story than the gross churn alone.
Logo churn and strategic accounts
Logo churn is particularly useful when you care about the number of accounts rather than their revenue. Losing a single large enterprise customer might have a huge revenue impact but only a small effect on logo churn. Conversely, losing many small customers might barely move revenue but significantly increase logo churn.
By treating each customer as one logo, you can track how many relationships you maintain over time. If logo churn is high, it may signal issues with onboarding, product fit, or support—even if revenue churn looks manageable. The calculator’s logo weight field lets you adjust the emphasis if you want to highlight certain segments.
Connecting churn to growth
Churn does not exist in isolation. It interacts with acquisition, reactivation, and trial conversion. The implied customer growth rate in the calculator shows how your base changed overall. If growth is strong but churn is also high, you may be in a “leaky bucket” situation: you’re adding customers quickly but losing many as well.
Understanding this balance can guide strategy. If acquisition is expensive, reducing churn may be more cost‑effective than pushing for more new customers. If churn is low but growth is slow, you might focus on marketing, sales, or product expansion to attract new segments.
Practical example
Suppose you run a subscription service and want to analyze churn for a specific plan in March. You start with 800 customers on that plan and end with 860. During the month, you add 120 new customers, reactivate 10, convert 40 trials, and lose 110 customers.
The customer flow identity says ending customers should be 800 + 120 + 10 + 40 − 110 = 860, which matches your ending count. Gross churn is (110 ÷ 800) × 100 ≈ 13.8%. Net churn is ((110 − 120 − 10) ÷ 800) × 100 ≈ −2.5%. Implied growth rate is ((860 − 800) ÷ 800) × 100 ≈ 7.5%. The story: churn is relatively high, but strong acquisition and reactivation more than offset it, leading to modest growth.
Tips for using the churn calculator effectively
- Use customer counts from your billing or CRM system to keep inputs accurate.
- Run the calculator monthly and track gross and net churn trends over time.
- Analyze churn by segment or plan to see where retention is strongest or weakest.
- Use the notes field to capture context, such as product changes, pricing experiments, or support incidents.
- Export the CSV and combine it with revenue data to build a richer churn and growth dashboard.
Ultimately, the churn rate calculator is about turning a single percentage into a more nuanced view of your customer base. It helps you see how cancellations, new customers, and reactivations interact, and how those dynamics shape your growth. Combined with deeper analytics and customer research, it can be a powerful tool for improving retention and building a more resilient recurring‑revenue business.
Frequently Asked Questions
How should I define a churned customer?
A churned customer is typically someone who cancels, does not renew, or becomes inactive according to your internal definition. Be consistent across periods so your churn metrics remain comparable.
Should I include trial users in churn calculations?
Trials are usually excluded from churn because they are not paying customers. You can track trial conversions separately and use the trial conversions field to see how they contribute to growth.
Can I use this tool for cohort‑based churn?
Yes, but you would run the calculator separately for each cohort (for example, customers acquired in a specific month). The tool focuses on period‑level churn; cohort analysis adds a time dimension to retention.
What is a good churn rate?
Acceptable churn rates vary widely by industry, price point, and customer type. Rather than chasing a universal benchmark, focus on improving your own churn over time and comparing segments within your business.
How often should I measure churn?
Most businesses measure churn monthly, but high‑volume or fast‑changing businesses may benefit from weekly snapshots. The key is to be consistent and to pair churn metrics with qualitative insights from customers.
Does this tool change my billing or CRM data?
No. The churn rate calculator is purely analytical. It does not modify your billing or CRM records. Use it to interpret your data, then work with your systems and teams to implement any changes.
Related tools
Information on this site is for educational purposes only and is not financial, tax, or legal advice. Calculations are estimates and may not reflect actual results. See our Privacy Policy and Disclaimer.