SaaS Revenue & Churn Analysis

Role: Business Analyst · Context: board meeting prep for CloudTask Pro, a fictional B2B SaaS company (practice dataset) · Tools: Python (pandas, SciPy, scikit-learn), Tableau

Notebook and data on GitHub ↗

Customers
600
since Jan 2022
Churned
52%
313 customers
MRR, Dec 2025
$293K
up 12% in 2025
At-risk customers
85
~$82K in monthly revenue

Summary

The question

CloudTask Pro sells project management software and grew from 0 to 600 customers between January 2022 and December 2025. Revenue kept rising, but the board was worried about churn. The CFO asked for four things ahead of the board meeting: who is leaving and why, how revenue is trending, what each customer segment is worth, and which active customers are likely to leave next.

Data and approach

Two datasets: 600 customer subscriptions (plan, billing cycle, industry, company size, region, acquisition channel, feature usage, NPS survey score, and churn date and reason) and 48 months of revenue (MRR, new and churned customers, and acquisition cost). In pandas I calculated churn rates by segment, fit a linear regression to MRR, estimated customer lifetime value (CLV) by plan, and built a weighted risk score, which I checked with AUC.

1. Who is leaving

Churn rate by customer segmentShare of customers who have churned. Blue bars are above the 52% average.
Starter71%
Professional48%
Business41%
Enterprise22%
Show data
SegmentGroupCustomersChurnedChurn rate
PlanStarter21715370.5%
PlanProfessional1738348.0%
PlanBusiness1606641.3%
PlanEnterprise501122.0%
BillingMonthly35221360.5%
BillingAnnual24810040.3%
Company size1–101578956.7%
Company size11–501769352.8%
Company size51–2001416042.6%
Company size201–500884753.4%
Company size500+382463.2%
RegionLatin America603761.7%
RegionEurope1628954.9%
RegionAsia Pacific944851.1%
RegionNorth America28413948.9%
ChannelReferral1247661.3%
ChannelPartner1005858.0%
ChannelSocial Media522955.8%
ChannelPaid Ads1156153.0%
ChannelOrganic Search1536743.8%
ChannelDirect Sales562239.3%
IndustryReal Estate613760.7%
IndustryFinance613659.0%
IndustryRetail523057.7%
IndustryHealthcare613557.4%
IndustryLegal573154.4%
IndustryConsulting623251.6%
IndustryManufacturing643148.4%
IndustryTechnology512345.1%
IndustryMedia542444.4%
IndustryEducation773444.2%
Annual billing lowers churn within each planChurn rate by plan and billing cycle
  • Monthly billing
  • Annual billing
Starter60%77%
Professional35%58%
Business27%53%
Enterprise22% both
Show data
PlanMonthly: churned / customersMonthly rateAnnual: churned / customersAnnual rate
Starter103 / 13476.9%50 / 8360.2%
Professional57 / 9957.6%26 / 7435.1%
Business46 / 8752.9%20 / 7327.4%
Enterprise7 / 3221.9%4 / 1822.2%

Monthly customers churn at 61% and annual customers at 40%. That gap is not just a side effect of cheaper plans billing monthly: it holds within Starter, Professional, and Business. Monthly customers can leave at any time, while annual customers have committed up front and have a reason to get value from the product before renewal.

Cost drives churn on cheaper plansWhy churned customers left, as a share of each plan's churn
  • Cost (budget cuts, price too high)
  • Missing features
  • All other reasons
Starter153 churned38%52%
Professional83 churned34%14%52%
Business66 churned26%18%56%
Enterprise11 churned, small sample82%

All other reasons: company closed, no longer needed, poor support, switched to a competitor.

Show data
PlanBudget cutsPrice too highMissing featuresNo longer neededPoor supportSwitched competitorCompany closed
Starter29291518191924
Professional1414129111013
Business10712111178
Enterprise0113123

Budget cuts and “price too high” together account for a third of all churn (104 of 313 customers). Cost matters more the cheaper the plan: it is 38% of Starter churn but 26% of Business churn. Business customers are the likeliest to cite missing features. Lower tiers need a pricing and value fix. Higher tiers need product and support work.

Monthly recurring revenueGrew steadily for three years, then flattened in 2025
  • MRR
  • Linear trend (R² 0.97)
Growth slows$0K$100K$200K$300K2022202320242025
Show data
MonthMRRActive customersNewChurned
Jan 2022$0.0K050
Feb 2022$7.3K5101
Mar 2022$12.3K14130
Apr 2022$24.8K28113
May 2022$29.1K35111
Jun 2022$38.9K46102
Jul 2022$45.1K5386
Aug 2022$54.1K57186
Sep 2022$65.2K67135
Oct 2022$86.8K76165
Nov 2022$93.2K87145
Dec 2022$96.1K95142
Jan 2023$104.8K107124
Feb 2023$115.5K115103
Mar 2023$125.3K12352
Apr 2023$129.5K125148
May 2023$142.4K133134
Jun 2023$143.0K1401510
Jul 2023$147.6K145197
Aug 2023$158.9K157107
Sep 2023$162.8K160177
Oct 2023$170.8K170165
Nov 2023$184.1K181118
Dec 2023$189.6K18397
Jan 2024$191.8K186107
Feb 2024$192.4K18878
Mar 2024$196.2K189194
Apr 2024$200.1K203118
May 2024$217.1K206148
Jun 2024$215.8K213139
Jul 2024$222.3K216148
Aug 2024$242.2K223127
Sep 2024$234.8K226117
Oct 2024$239.3K233137
Nov 2024$253.5K238129
Dec 2024$260.9K240159
Jan 2025$266.1K247139
Feb 2025$274.2K251158
Mar 2025$280.9K257187
Apr 2025$287.8K2701317
May 2025$287.2K2641215
Jun 2025$280.7K2611511
Jul 2025$287.7K26599
Aug 2025$287.7K26577
Sep 2025$290.8K265139
Oct 2025$280.1K269189
Nov 2025$285.3K278119
Dec 2025$292.6K281114

MRR grew from $7K to $293K. A straight line explains 97% of the movement (R² = 0.97), with growth averaging about $6,500 a month. That fit describes the past well but overstates where revenue is heading: in 2025 MRR gained about $2,600 a month, and it has barely moved since March.

Monthly churn rate, 2023–2025Share of active customers lost each month
0%2%4%6%8%202320242025Apr–May 2025: 32 lost

2022 is left out: with under 100 customers, one or two cancellations swung the rate as high as 20%.

Show data
MonthChurn rateChurnedActive at start
Jan 20220.00%00
Feb 202220.00%15
Mar 20220.00%014
Apr 202210.71%328
May 20222.86%135
Jun 20224.35%246
Jul 202211.32%653
Aug 202210.53%657
Sep 20227.46%567
Oct 20226.58%576
Nov 20225.75%587
Dec 20222.11%295
Jan 20233.74%4107
Feb 20232.61%3115
Mar 20231.63%2123
Apr 20236.40%8125
May 20233.01%4133
Jun 20237.14%10140
Jul 20234.83%7145
Aug 20234.46%7157
Sep 20234.38%7160
Oct 20232.94%5170
Nov 20234.42%8181
Dec 20233.83%7183
Jan 20243.76%7186
Feb 20244.26%8188
Mar 20242.12%4189
Apr 20243.94%8203
May 20243.88%8206
Jun 20244.23%9213
Jul 20243.70%8216
Aug 20243.14%7223
Sep 20243.10%7226
Oct 20243.00%7233
Nov 20243.78%9238
Dec 20243.75%9240
Jan 20253.64%9247
Feb 20253.19%8251
Mar 20252.72%7257
Apr 20256.30%17270
May 20255.68%15264
Jun 20254.21%11261
Jul 20253.40%9265
Aug 20252.64%7265
Sep 20253.40%9265
Oct 20253.35%9269
Nov 20253.24%9278
Dec 20251.42%4281

Monthly churn settled into a 2–6% range from mid-2023. The exception is April and May 2025, when 32 customers left in two months, right as growth stalled. One likely explanation is a group of customers who signed up together and reached the same renewal point together. Checking the signup dates of the customers who left in those months would confirm it.

3. What each customer is worth

PlanMonthly revenueAvg tenureCLVCLV:CAC
Enterprise$2,98525.5 mo$76,106379×
Business$1,30419.0 mo$24,787123×
Professional$49716.4 mo$8,13741×
Starter$2169.4 mo$2,01610×

CLV is average monthly revenue times average tenure. Every plan clears the usual 3× CLV:CAC benchmark. An Enterprise customer is worth about 38 times a Starter customer, because they pay more and stay almost three times as long. Starter’s short tenure is what limits its value: keeping a Starter customer three months longer adds about $650.

The CLV:CAC ratios are rough. The dataset has one blended acquisition cost ($201) for every plan, and that figure is low next to about $1,000 in monthly revenue per customer, so the ratios are inflated. Enterprise customers almost certainly cost more to win than Starter customers. The ranking of the plans is useful; the exact multiples are not.

4. Spotting at-risk customers

Customers who use more of the product don't leaveChurn rate by share of product features used
Under 20%88%
20–39%67%
40–59%44%
60–79%0%
80% or more0%
Show data
Features usedCustomersChurnedChurn rate
Under 20%1079487.9%
20–39%24316367.1%
40–59%1275644.1%
60–79%5800.0%
80% or more6500.0%

On average, churned customers used 27% of the product’s features and active customers used 55%. Churned customers also gave lower NPS survey scores (3.0 versus 5.8 out of 10), and no one who scored 7 or higher left. I used these signals to build two flags for different jobs:

The composite score separates churned from active customers with an AUC of 0.94: pick one churned and one active customer at random, and the score ranks the churned one as riskier 94% of the time. Tenure makes that number look better than it should, because customers who churned early have short tenure partly because they churned. With tenure removed, usage and NPS alone still reach 0.91.

Recommendations

  1. Make Starter the retention priority. It has the highest churn and its customers mostly leave over cost, so test pricing and a clearer value message for this tier.
  2. Move monthly customers to annual billing. Offer a discount for committing annually. It is the one lever that works across Starter, Professional, and Business.
  3. Act on low usage early. Put the 85 low-usage accounts into an onboarding and feature-adoption program, and have account managers contact the 14 highest-risk accounts first, starting with those closest to renewal.
  4. Take Business-tier churn feedback to the product team. Missing features are this tier’s most common reason for leaving.
  5. Explain the 2025 slowdown before relying on the trend line. Look into the April–May churn spike and the flat months since, and don’t plan off the three-year linear trend in the meantime.

Limitations and next steps

Deliverables

A Jupyter notebook with the full analysis and a Tableau story of four dashboards for the board: MRR and churn trends, segment risk, CLV and profitability, and at-risk customers.