Newsletter Churn & Subscriber LTV Calculator.
Convert monthly churn into lifetime value, model organic referral compounding, and uncover the highest viable CPA you can afford before paid growth loses money.
1. Your Growth Metrics
Percent of subscribers leaving each month (unsubscribes, cancellations, hard bounces, and inactive list purges).
Calculate Churn from Last Month
Churn = lost ÷ start subscribers.
Direct signups from organic search, social profiles, cross-promotions, and paid ads (excluding referrals).
Percentage of your active reader base that successfully refers 1 new subscriber each month (forwards, SparkLoop, Substack Recommendations).
Free list: monthly sponsorship revenue ÷ total list size. Paid list: monthly subscription price (or annual ÷ 12). Margin strips Stripe fees and ESP sending costs.
Your blended cost to acquire a subscriber via Meta ads, Twitter ads, Google, or SparkLoop.
Unit Economics & LTV Dashboard
Unit Economics Comparison
Max Viable CPA is the binding lower limit between your target LTV:CPA ratio ceiling and what you recover within your payback window.
Subscriber Growth Trajectory
Churn Sensitivity Matrix (±2% Shift)
Small changes in retention compound massively over time. Shaving just 1% off monthly churn frequently outperforms doubling ad spend.
Newsletter Growth Economics & Lifetime Value Demystified
Understanding Monthly Churn Velocity
Unlike SaaS where customers cancel accounts, newsletter churn encompasses passive churn (spam complaints, deleted inboxes, corporate email firewalls) and active churn (unsubscribe clicks). Tracking net monthly churn velocity ensures you don't inflate reader counts with ghost subscribers.
The Power of Closed-Form Referral Compounding
When a newsletter achieves organic word-of-mouth (virality factor $k = \text{referrals} / \text{churn}$), every paid subscriber generates a compounding geometric series of future readers. If $k = 0.33$, each paid subscriber delivers $1.5\times$ total lifetime value.
Why Payback Windows Dictate Working Capital
High theoretical LTV is useless if your payback period is 36 months and you run out of cash in month 4. Setting a strict 6 to 12-month payback limit protects your balance sheet and ensures cash flow reinvestment velocity stays positive.
Calculating ARPU for Free Newsletters
To compute monthly ARPU for a sponsor-supported newsletter: sum all sponsorship revenue earned over the past 90 days, divide by 3 (to get monthly revenue), then divide by your total active subscriber count. Typical tech/business newsletters achieve $0.40 to $1.20 monthly ARPU.
Builder Hustle Studio crafts high-performance web platforms, custom interactive calculators, and high-speed digital architecture tailored for modern digital publications and creator businesses.