Report – Customer Churn and Retention Analysis for a Subscription Business

Executive Summary

This report analyses customer churn and retention for StreamNova Australia Pty Ltd (referred to throughout as the business), a hypothetical mid-tier subscription video-on-demand (SVOD) provider serving approximately 150,000 Australian subscribers across three plans. The purpose of the report is to quantify churn and its economic cost, diagnose the underlying drivers, and evaluate a portfolio of retention initiatives on a return-on-investment basis so that management can prioritise spending. Australia is one of the most penetrated SVOD markets in the world and competition for subscriber attention is intense (Roy Morgan 2023; Deloitte 2023), which makes retention, rather than continual acquisition, the more sustainable lever on recurring revenue.

Across the analysis window the business recorded a blended monthly churn rate of 4.58 per cent, equivalent to a retention rate of 95.42 per cent, an average customer lifetime of 21.8 months, and a blended lifetime-value to customer-acquisition-cost (LTV:CAC) ratio of 4.7:1. Churn is highly uneven by segment: the monthly Basic plan loses subscribers at 7.0 per cent a month, while the annual Premium plan loses only 1.8 per cent. Total recurring revenue at risk from current churn is approximately A$1.30 million a year. Diagnosis attributes 22 per cent of churn to involuntary payment failure and 78 per cent to voluntary cancellation, led by price sensitivity amid cost-of-living pressure (ABS 2024; RBA 2024). Four modelled initiatives would retain an estimated A$343,000 a year for a combined cost of A$230,000, a blended return of 49 per cent, and would lower blended churn to roughly 3.5 per cent. The single highest-return action, automated dunning of failed payments, returns 160 per cent. All retention tactics must remain consistent with Australian Consumer Law expectations on easy cancellation (ACCC 2023) and with the Privacy Act 1988 (Cth) and the Australian Privacy Principles governing customer data (OAIC 2023).

Introduction

Subscription and recurring-revenue business models depend on retaining customers across many billing cycles, so churn, the rate at which subscribers cancel, is the metric that most directly determines financial sustainability (Tzuo & Weisert 2018). Small movements in the monthly rate compound heavily: at 5 per cent monthly churn the average customer stays 20 months, whereas at 4 per cent the same customer stays 25 months, a 25 per cent increase in lifetime value from a single percentage point. In the Australian market, where SVOD penetration is high and households increasingly review discretionary subscriptions, incumbents face persistent switching and downgrade behaviour (Deloitte 2023). Managing the customer base as an asset, and understanding the economics of its erosion, is therefore central to strategy (Kumar & Reinartz 2018).

The aim of this report is to measure churn and retention economics for the business, to identify and size the drivers of cancellation, and to evaluate candidate retention initiatives by expected return. The scope covers the existing subscriber base over a twelve-month window, analysed by plan segment. Customer acquisition strategy, detailed statistical churn prediction, and content-commissioning decisions sit outside the boundary of this report, although each is referenced where it bears on retention.

Data and Method

The analysis draws on four internal sources: the billing and subscription ledger, payment-gateway transaction logs, product engagement records such as first-month viewing hours, and a structured cancellation survey completed at the point of exit. These are the data assets a customer-analytics function would ordinarily consolidate to convert behavioural signals into managerial decisions (Verhoef et al. 2016). Subscribers are grouped into three plan segments, which serve as a proxy for behavioural cohorts because commitment length and price differ markedly between them.

The core measures are defined as follows. Monthly churn rate is churned subscribers divided by opening subscribers for the period; retention rate is one minus the churn rate; and average customer lifetime, under a constant-churn assumption, is the reciprocal of the churn rate. Customer lifetime value is calculated as average revenue per user (ARPU) multiplied by a gross contribution margin, assumed at 65 per cent to reflect content, licensing and delivery costs, multiplied by average lifetime. Customer acquisition cost is total segment marketing spend divided by subscribers acquired. Revenue at risk is the annualised recurring revenue represented by current monthly churn. The reciprocal-of-churn approximation is standard but tends to overstate lifetime for young cohorts, whose early-month churn is higher than the steady-state rate, so the survival profile is examined separately in Figure 1 (McCarthy & Fader 2018).

All customer data used in the analysis is handled under the Privacy Act 1988 (Cth) and the Australian Privacy Principles, which require that personal information be collected for a stated purpose, secured, and used consistently with the reasonable expectations of the individual (OAIC 2023). Modelling is performed on de-identified and aggregated records, and any downstream personalisation drawing on these findings must rest on a lawful basis and clear consent rather than on covert profiling.

Cohort and Segment Churn Analysis

Table 1 sets out the churn and value economics for each plan segment and for the blended base. The segments differ by an order of magnitude on almost every measure, which is the central finding of the analysis: the business does not have a single churn problem but three distinct ones.

Table 1: Churn and customer-value economics by plan segment

Worked calculations

The figures in Table 1 are derived from the raw subscriber counts as follows, with the formula, the substitution and the result shown for the Monthly Basic segment, which reported 3,360 cancellations in the month against 48,000 opening subscribers.

Monthly churn rate = churned subscribers / opening subscribers = 3,360 / 48,000 = 0.070 = 7.0 per cent. Retention rate = 1 – 0.070 = 0.930 = 93.0 per cent.

Average customer lifetime = 1 / churn rate = 1 / 0.070 = 14.3 months.

Lifetime value = ARPU × gross margin × average lifetime = 11.99 × 0.65 × 14.3 = A$111. Dividing by acquisition cost gives LTV:CAC = 111 / 45 = 2.5:1.

Revenue at risk (annualised) = monthly churned subscribers × ARPU × 12 = 3,360 × 11.99 × 12 = A$483,437.

Applying the same steps to the whole base, blended monthly churn = 6,870 / 150,000 = 4.58 per cent, giving an average lifetime of 1 / 0.0458 = 21.8 months and total revenue at risk of A$1,301,656 a year.

Interpretation

The commercial signal is clear. A widely used benchmark treats an LTV:CAC ratio of about 3:1 as the threshold for healthy unit economics (Kumar & Reinartz 2018). On that test the Annual Premium segment is exceptional at 13.3:1 and the Monthly Standard segment is comfortable at 5.0:1, but the Monthly Basic segment, at 2.5:1, barely recovers the cost of acquiring the customers it is losing. The annual plan retains far better not because those subscribers are inherently more loyal but because the annual commitment removes eleven monthly cancellation decisions from the customer, a structural effect rather than an attitudinal one. In dollar terms the largest pool of revenue at risk sits in the Monthly Standard segment (A$602,305), the biggest base, followed by Monthly Basic (A$483,437). Retention effort must therefore be weighed by revenue at risk, not churn rate alone, or it will over-invest in the small but noisy Basic cohort and under-invest in the larger Standard one.

Churn Driver Analysis

Understanding why subscribers leave requires separating the point in the customer lifecycle at which they leave from the reason they give. Figure 1 tracks a new-signup cohort through its first year and shows that attrition is heavily front-loaded: almost a fifth of subscribers are gone within the first month and nearly two in five within three months, after which the curve flattens as a habitual core remains. Early engagement is therefore decisive, and the onboarding period is where retention is won or lost.

Table 2 attributes total churn to six drivers, sized from the cancellation survey, payment-gateway logs and engagement analytics. The drivers are classified as involuntary, where the subscriber did not choose to leave, or voluntary, where they did, because the two categories call for entirely different responses.

Table 2: Churn driver analysis, share of total churn and addressability

The most important insight from Table 2 is that involuntary churn, at 22 per cent, is the largest single addressable category. These subscribers intended to keep paying but were lost to an expired card or a failed transaction, so recovering them requires operational fixes rather than persuasion and does not risk annoying customers who wished to stay. Price sensitivity, the largest voluntary driver at 26 per cent, is tied to the external environment: consumer prices for recreation and communication services have risen and household budgets have tightened under sustained interest-rate pressure, so discretionary subscriptions are among the first outgoings that Australian households review (ABS 2024; RBA 2024). Two cautions follow from the retention literature. First, a review of retention management stresses matching the intervention to the driver rather than treating all at-risk customers alike (Ascarza et al. 2018). Second, and more pointedly, targeting the customers judged most likely to churn can be ineffective or even counterproductive if the contact itself prompts a cancellation the customer had not yet decided on (Ascarza 2018). Retention design must therefore be selective and evidence-led, not a blanket campaign.

Retention Initiatives and Return on Investment

Four initiatives were modelled, each aimed at a specific driver from Table 2 and each sized by the number of subscribers it is expected to retain per month, valued at the blended ARPU of A$17.94. Table 3 reports the cost, the expected churn reduction, the annualised revenue retained, and the return on investment, defined as net benefit divided by cost.

Table 3: Retention initiatives, cost, expected effect and return on investment

Worked calculation, automated dunning

The highest-return initiative is worked through in full. Involuntary churn accounts for 22 per cent of the 6,870 subscribers lost each month, or 1,511 subscribers, and a smart-retry and pre-expiry-alert system is assumed to recover 40 per cent of them.

Subscribers recovered per month = involuntary churners × recovery rate = 1,511 × 0.40 = 605 subscribers.

Revenue retained (annualised) = recovered subscribers × blended ARPU × 12 = 605 × 17.94 × 12 = A$130,150.

Return on investment = (revenue retained – cost) / cost = (130,150 – 50,000) / 50,000 = 1.60 = 160 per cent.

Taken together the four initiatives would retain about 1,596 subscribers a month, cutting blended churn from 4.58 per cent to roughly 3.52 per cent and retaining A$343,417 a year for A$230,000 of spend, a portfolio return of 49 per cent. Sequencing matters as much as the total. Automated dunning is a low-cost, high-certainty operational fix and should be implemented first. Personalised recommendations and the onboarding program address the front of the funnel shown in Figure 1, where attrition is steepest, and pay back over more than one year. The pricing initiative returns least in year one because discounts and pause options give up margin, and it should be targeted narrowly at genuinely price-driven, high-value subscribers rather than offered across the base, consistent with the warning that indiscriminate retention offers can erode revenue without changing behaviour (Ascarza 2018).

Two compliance constraints bound the design of these initiatives. Retention tactics must not make cancellation difficult or rely on unclear terms: the Australian Competition and Consumer Commission has scrutinised subscription practices and unfair contract terms, and easy, transparent cancellation is both a legal expectation and a trust advantage (ACCC 2023). Personalisation must operate within the Australian Privacy Principles, using customer data only in ways the subscriber would reasonably expect and has consented to (OAIC 2023). Handled well, retention also builds advocacy, since satisfied long-tenure subscribers recommend the service and lower effective acquisition cost (Reichheld et al. 2021).

Recommendations

1. Implement automated dunning, smart card-retry logic and pre-expiry alerts as the immediate priority, given the 160 per cent return and the absence of any risk to customers who intend to stay.
2. Rebuild the first-30-day onboarding experience with guided setup, a personalised watchlist and staged engagement prompts, targeting the steep early attrition shown in Figure 1.
3. Prioritise retention spending by revenue at risk rather than by churn rate, directing the largest effort to the Monthly Standard segment, which carries A$602,305 of annual revenue at risk.
4. Migrate suitable monthly subscribers to annual plans through modest incentives, since the annual structure, not subscriber attitude, is the main reason the Premium segment retains at 98.2 per cent.
5. Target price and pause offers narrowly at identified high-value, price-sensitive subscribers rather than campaigning across the base, to protect margin and avoid prompting avoidable cancellations.
6. Govern all retention analytics and personalisation under the Australian Privacy Principles and keep cancellation simple and transparent in line with ACCC guidance, treating compliance as a retention asset rather than a constraint.

Conclusion

Churn at the business is moderate in aggregate but sharply uneven beneath the blended figure, and it carries a recurring revenue cost of approximately A$1.30 million a year. The economics diverge by segment, from a barely viable 2.5:1 LTV:CAC ratio on the Monthly Basic plan to an exceptional 13.3:1 on the Annual Premium plan, and the retention funnel shows that the decisive battleground is the first three months of the customer relationship. The largest addressable driver, involuntary payment failure, can be recovered through an operational fix that returns 160 per cent, while the largest voluntary driver, price sensitivity, reflects a cost-of-living environment the business cannot control and must instead manage through targeted, margin-aware offers. A disciplined portfolio of four initiatives would reduce blended churn from 4.58 per cent to about 3.5 per cent and generate a 49 per cent return, provided the effort is sequenced by return and revenue at risk, targeted rather than indiscriminate, and delivered within Australian consumer-protection and privacy obligations. Retention, managed on these terms, is the most reliable source of value the subscription base can offer.

References

Ascarza, E 2018, ‘Retention futility: targeting high-risk customers might be ineffective’, Journal of Marketing Research, vol. 55, no. 1, pp. 80-98.

Ascarza, E, Neslin, SA, Netzer, O, Anderson, Z, Fader, PS, Gupta, S, Hardie, BGS, Lemmens, A, Libai, B, Neal, D, Provost, F & Schrift, R 2018, ‘In pursuit of enhanced customer retention management: review, key issues and future directions’, Customer Needs and Solutions, vol. 5, no. 1, pp. 65-81.

Australian Bureau of Statistics (ABS) 2024, Consumer Price Index, Australia, December quarter 2023, Australian Bureau of Statistics, Canberra.

Australian Competition and Consumer Commission (ACCC) 2023, Digital platform services inquiry: September 2023 interim report, Australian Competition and Consumer Commission, Canberra.

Deloitte 2023, Digital media trends: Australian edition, Deloitte Australia, Sydney.

Kumar, V & Reinartz, W 2018, Customer relationship management: concept, strategy and tools, 3rd edn, Springer, Berlin.

McCarthy, DM & Fader, PS 2018, ‘Customer-based corporate valuation for publicly traded non-contractual firms’, Journal of Marketing Research, vol. 55, no. 5, pp. 617-635.

Office of the Australian Information Commissioner (OAIC) 2023, Australian Privacy Principles guidelines, Office of the Australian Information Commissioner, Sydney.

Reichheld, F, Darnell, D & Burns, M 2021, Winning on purpose: the unbeatable strategy of loving customers, Harvard Business Review Press, Boston.

Reserve Bank of Australia (RBA) 2024, Statement on monetary policy, May 2024, Reserve Bank of Australia, Sydney.

Roy Morgan 2023, Subscription video on demand in Australia, Roy Morgan Research, Melbourne.

Tzuo, T & Weisert, G 2018, Subscribed: why the subscription model will be your company’s future, and what to do about it, Portfolio, New York.

Verhoef, PC, Kooge, E & Walk, N 2016, Creating value with big data analytics: making smarter marketing decisions, Routledge, London.