Get the free checklist →

The $340,000 Lesson That Built ChurnLens

One SaaS acquisition. One churn number. One methodology gap worth six figures. That's the story behind every line of code at ChurnLens.

The Deal That Changed Everything

In early 2024, I bought a SaaS business listed at $1.1M. The Confidential Information Memorandum showed a clean 2.3% monthly churn rate. Forty-point due diligence checklist — all checked. The seller was transparent. The dashboard screenshots looked healthy. I wired the money.

Four months post-close, MRR started bleeding. Slowly at first — the kind of decline you don't notice until it's too late. I pulled the raw subscription CSV for the first time and computed churn myself. The real monthly churn wasn't 2.3%. It was 9.4% — over four times what the CIM reported.

"The seller hadn't lied. He'd used every legitimate-looking methodology trick available: excluded downgrades from churn, reported the best cohort month as 'representative,' excluded involuntary cancellations, and counted reactivations as continuous subscriptions. Each choice was defensible in isolation. Combined, they turned 9.4% into 2.3%. I hadn't asked for the raw CSV. I'd asked for a churn number. I got the number the seller wanted me to have."

That gap — the difference between the number I trusted and the number that was real — was worth $340,000. I discovered it four months after I wired the money, when there was no recourse.

$340K
Value lost on one deal
4.2×
Real vs. reported churn gap
11/14
Deals with hidden churn
0/14
Times real churn was lower

The Obsession That Followed

After that deal, I did something obsessive: I pulled the raw subscription CSV from every acquisition opportunity I evaluated — not the summary, not the dashboard, but the raw export with customer ID, MRR, plan, status, and dates. I built a spreadsheet to compute churn five different ways: logo churn, revenue churn, net churn, gross churn, and cohort-adjusted churn. I cross-referenced concentration risk. I flagged inactive paying accounts — "zombie MRR" that looks stable on the P&L but vanishes one invoice at a time.

I ran this analysis on 14 more deals. In 11 of them, real churn was meaningfully higher than reported. In 3, it matched. Zero times was real churn lower. The average gap: 4.2×. Every deal where I caught the gap, I either renegotiated the price or walked away.

The spreadsheet worked brilliantly — but it took 4 hours per deal. I kept making the same manual analysis mistakes. So I automated it. I showed it to two other acquirers. They asked to use it. Their friends asked. That's when I realized this wasn't a personal spreadsheet anymore. It was the thing I wished I'd had before I wired $1.1M for a business worth $760K.

The Timeline

Early 2024
The $340K dealAcquired a SaaS at $1.1M with reported 2.3% churn. Discovered 9.4% real churn four months post-close.
Mid 2024
The deep diveAnalyzed 14 more deals from raw CSV data. Built the five-metric churn spreadsheet. Discovered the 4.2× average gap between reported and real churn.
2025
From spreadsheet to productSystematized the analysis into a repeatable tool: the 5-Risk Buyer-Side Method, Revenue Quality Scorecard, and Zombie MRR detection.
January 2026
Public launchChurnLens ships with a free Starter tier — 1 CSV analysis per month — so every acquirer can verify a seller's churn claims before they commit.

What ChurnLens Is — and What It Isn't

✓ ChurnLens IS

  • A buyer-side SaaS due diligence tool for acquirers, PE/M&A analysts, and founders evaluating a purchase
  • A raw-data analysis engine — you upload the seller's subscription CSV, ChurnLens computes churn five ways from the source data
  • A risk surface detector that flags concentration risk, annual-plan decay, zombie MRR, and MRR trajectory issues
  • A Revenue Quality Scorecard (A–F) that weights retention, concentration, expansion, and growth trends into one grade
  • Built for the 30-day due diligence window — analysis in minutes, not a week of spreadsheet work

✗ ChurnLens is NOT

  • A churn-prevention or customer-retention tool for SaaS operators (that's churnlens.io)
  • A customer churn-prediction or machine-learning platform (that's churnlens.tech)
  • A subscription-analytics dashboard like ChartMogul or ProfitWell — those tools help operators manage their own business; ChurnLens helps a buyer stress-test someone else's
  • A replacement for legal, financial, or operational due diligence — it's the revenue durability layer those checklists miss
  • A tool that trusts the seller's methodology — if you want the summary number, the CIM already has that

Our Mission

We're building toward a SaaS acquisition market where buyer-side churn analysis is the default, not the exception. Where no buyer trusts a seller-computed summary number. Where sellers know that any methodology tricks will be caught in minutes by automated analysis.

When that happens, the information asymmetry closes. Deals get priced honestly. Buyers stop overpaying by $340K because they trusted a number someone else computed for them. ChurnLens is the tool. The 23-point churn audit checklist is the entry point. The raw-data methodology is the principle.

Who Runs ChurnLens

ChurnLens is built and maintained by an independent SaaS acquirer who learned the $340K lesson the hard way and decided no other buyer should have to. The founder publishes under the pseudonym The Data Nerd, ChurnLens Research — the analysis is the asset, not the identity. Every methodology page, benchmark, and risk framework on this site was built from direct acquisition experience and real subscription data analysis.

ChurnLens is bootstrapped, independent, and funded by subscribers who use the tool to evaluate real deals. No VC. No exit pressure. Just a relentless focus on one problem: making sure you know what you're buying before you wire the money.

The Core Methodology

ChurnLens is built around the 5-Risk Buyer-Side Method — a structured framework that scores every SaaS acquisition target across five dimensions of revenue durability:

  1. Churn Divergence — logo churn and revenue churn computed separately and compared; the gap IS the signal
  2. Concentration Vulnerability — flags when 3 customers represent 60%+ of MRR
  3. Annual-Plan Decay — identifies customers statistically likely to cancel at renewal
  4. Zombie MRR — detects paying-but-not-engaging accounts that vanish one invoice at a time
  5. Revenue Quality Scorecard — a composite A–F grade weighting retention, concentration, expansion, and growth trends

📖 Read the full 5-Risk Buyer-Side Method →

Read the founder's full story — every detail of the deal that built ChurnLens.

Read the $340K Founder Story →

Or get the 23-point churn audit checklist — free, takes 2 minutes to read.

80%
Overpay for Churn
4.2×
Real vs Reported
$340K
Avg Overpayment
23
Audit Checklist Points

The seller's churn number is almost always wrong. Upload the CSV and find out before you wire.

Get the Free Checklist →

🛡️ Free Starter tier: 1 CSV analysis per month. No credit card. Verify a seller's churn claims before you commit.

Frequently Asked Questions

What is hidden churn in a SaaS acquisition?

Hidden churn is revenue decay that headline metrics conceal: customers on annual plans who have already stopped using the product, paid accounts sitting inactive, or revenue concentrated in a few logos about to leave. A SaaS business can show flat MRR while its real retention is collapsing. ChurnLens surfaces these signals before you buy, so you price the deal on true revenue quality.

How does ChurnLens score revenue quality?

ChurnLens analyzes five dimensions: revenue concentration, logo retention, annual-plan churn risk, inactive paid accounts, and MRR decline patterns. Each is weighted into a single 0-100 revenue-quality score benchmarked against comparable SaaS businesses. The score tells an acquirer whether reported MRR is durable or propped up by customers who are one renewal away from leaving, all before the deal closes.

Why do SaaS acquirers need due diligence on churn?

Purchase price is usually a multiple of recurring revenue, so overstated retention directly inflates what you pay. A business with 20% hidden annual-plan churn is worth far less than its MRR implies. Buyers who skip churn diligence discover the decay only after closing, when it is too late to renegotiate. ChurnLens gives that visibility during the evaluation window instead.

What red flags should I check before buying a SaaS business?

Watch for revenue concentrated in a handful of accounts, a widening gap between signups and active users, annual contracts that never renew, and MRR that grows only through discounting. Each pattern signals fragile revenue. ChurnLens automatically flags these red flags from uploaded revenue data and ranks them by how much they threaten the durability of the recurring revenue base.

Key facts
Risk dimensions scored5
Revenue-quality score range0-100
Built forAcquirers, PE, founders

Key terms, defined

Revenue concentration
The share of total revenue coming from the largest customers — high concentration is a churn and valuation risk.
Logo retention
The percentage of customers (logos) retained over a period, independent of expansion revenue.
Net revenue retention (NRR)
Revenue retained from existing customers including expansion and contraction, expressed as a percentage.

See Hidden Churn Before You Buy a SaaS

🛡️ 100% Money-Back — If We Miss a Red Flag, You Don't Pay

📥 Free SaaS Due Diligence Checklist

The exact 47-point checklist PE analysts use before acquiring SaaS businesses. 5-minute read.

Download Free Checklist →

No spam. Unsubscribe anytime.

⚡ Limited Beta Pricing — Lock in $49/mo Before Price Increase

· · Published 2026-01-15