Customer movement walkthrough
Customer Churn Example: Measuring Customer Loss Correctly
A fitness subscription finishes the month with more members than it started with, yet it still lost customers. This example separates starting customers, losses, retention, and new additions, then shows why the same ending count can hide very different churn.
Reconcile the membership movement
PulsePath begins May with 800 paying members. During May, 64 of those starting members cancel. The service also acquires 90 new members, so the ending count is 800 − 64 + 90 = 826.
Churn asks what share of the starting base was lost: 64 ÷ 800 = 8%. New members do not reduce the numerator because acquisition cannot undo the fact that a starting customer left. Retention looks at the complementary 736 customers who stayed.
The end count is useful for reconciliation, but it is not an input to the calculator’s churn formula. A business can grow its total base while experiencing serious loss, or remain flat with almost no loss, depending on how many new customers enter.
What we’re calculating
Churn = Customers lost during period ÷ Customers at start × 100; Retention = (Start − lost) ÷ Start × 100
- Starting customers
- 800 active paying members at the opening boundary.
- Lost customers
- 64 members from that starting group who left during May.
- New customers
- 90 additions used to reconcile the ending count, not to calculate churn.
Retained-to-lost ratio is 736 ÷ 64 = 11.5. If nobody is lost, the ratio is reported as undefined rather than infinity.
Intermediate calculations, step by step
Freeze the opening cohort
Record 800 customers at the start before adding May signups.
Count losses from that base
64 starting customers leave during the selected month.
Calculate churn and retention
Churn = 64 ÷ 800 = 8%; retained = 736; retention = 92%.
Express operational ratios
Eight are lost per 100 starting customers; 736 ÷ 64 = 11.5 retained for each lost.
Reconcile the ending count
800 − 64 + 90 = 826, confirming movement without substituting net growth for churn.
Worked example
May membership movement
PulsePath separates loss of the opening cohort from acquisition during the month.
- Start
- 800 customers
- Lost
- 64 customers
- New
- 90 customers
- End
- 826 customers
- Retained customers = 800 − 64 = 736.
- Churn rate = 64 ÷ 800 × 100 = 8%; retention rate = 92%.
- Lost per 100 = 8; retained-to-lost ratio = 736 ÷ 64 = 11.5.
- Ending customers = 736 retained + 90 new = 826.
Net customer growth was 26, but acquisition of 90 masked 64 losses. Looking only at 826 versus 800 would show growth of 3.25%, not the 8% churn experienced by the opening cohort.
Comparison: same ending count, different churn
Scenario A is the main case: start 800, lose 64, add 90, end 826, and churn 8%. Scenario B also starts at 800 and ends at 826, but loses only 24 and adds 50. Its churn is 24 ÷ 800 = 3%, retention is 97%, and retained-to-lost ratio is 776 ÷ 24 = 32.33.
Both scenarios show identical net growth of 26 customers. Yet Scenario A must replace far more lost relationships to achieve it. Ending balance alone cannot tell the owner whether retention is improving, and subtracting ending from starting would incorrectly imply negative churn because the company grew.
- Scenario A: 64 lost + 90 new = 826 end; 8% churn.
- Scenario B: 24 lost + 50 new = 826 end; 3% churn.
- Equal start and end counts do not imply equal customer loss.
What the owner should notice
The acquisition team delivered positive net growth, but the retention team still has 64 departures to understand. Reporting both flows avoids blaming acquisition for churn or giving retention credit for replacement customers.
An 8% monthly example must not be casually converted into an annual promise by multiplying by twelve. Customer losses compound against a changing base, and rates may vary by season and cohort. Use the period actually measured and a deliberate model for longer horizons.
Alternative: zero losses
If PulsePath starts with 800, loses none, and adds 26, churn is 0%, retention is 100%, and ending count is again 826. Customers retained equals 800, while retained-to-lost ratio is undefined because dividing by zero losses has no finite meaning.
Undefined is not an error and should not be displayed as Infinity. The plain-language interpretation is sufficient: no starting customers were lost during the measured period.
Keep cohort boundaries stable when comparing months
PulsePath should decide when a customer becomes active, when a cancellation counts as lost, and how pauses, failed payments, reactivations, and plan transfers are treated. A change in any of those rules can move the reported rate even when underlying behavior is unchanged. The movement ledger should reconcile to billing records under one documented policy.
A single monthly rate can also hide concentration. Sixty-four losses might be spread evenly across the member base, or they might come mostly from customers in their first month, one location, or one plan. Churn calculation identifies the size of loss; cohort analysis helps locate where the experience or customer fit may be failing.
Retention action should be evaluated against more than the percentage. A concession that prevents cancellation can reduce revenue or gross margin, and aggressive outreach has a cost. The useful question is whether a change improves durable customer economics and experience, not whether it makes one rate look lower at any price.
Customer movement ledger
Retention view
- Start with a frozen opening base.
- Track losses from that base.
- Report retained customers, churn, and retention.
- Investigate departure reasons by coherent cohort.
Net-count shortcut
- Subtracts start from end.
- Lets new customers offset losses.
- Produces the same answer for different churn scenarios.
- Can report growth while hiding substantial replacement effort.
Common mistakes
Where the calculation goes wrong
Using net customer change
End minus start combines acquisition and loss; it is not churn.
Putting new customers in the denominator
This calculator measures losses against customers present at the start.
Counting the wrong boundary
Define active, paying, paused, and canceled status consistently at both dates.
Showing Infinity
When losses are zero, the retained-to-lost ratio is undefined; explain that no customers were lost.
Action checklist
Before you use the result
- Define the measurement period and active-customer rule.
- Freeze customers at the opening boundary.
- Count losses from that group.
- Calculate churn before adding new customers.
- Reconcile retained + new to the ending count.
- Compare cohorts and periods using the same definitions.
FAQ
Questions beyond the basic calculation
Should failed payments count as churn?
Include them if the business’s active-customer definition treats involuntary cancellation as a lost customer. Track voluntary and involuntary loss separately when the distinction helps action, while preserving the total.
How should reactivated members be counted?
Choose a consistent policy based on whether reactivation is treated as a new relationship or continuation. Document it so the start, loss, new, and end ledger reconciles.
Can retention be calculated as 100% minus churn?
Yes for this starting-customer definition: 100% − 8% = 92%. Both use the same opening cohort and period.
What happens when the period starts with zero customers?
Churn and retention are not defined because there is no starting base. Report the customer movement in counts until a valid opening cohort exists.
Note: This scenario illustrates customer-count churn, not revenue churn, and does not represent a fitness-industry benchmark. Definitions should match the business’s subscription records.