Newsletter Growth & Monetization: Churn, Acquisition Cost by Source, Open & Click Cohorts, Sponsorship CPM & Fill Rate, Paid-Tier Conversion & Revenue per Subscriber
Run a newsletter as a media product. You will build the monthly subscriber ledger with churn and net growth, price every sign-up source by confirmed and by engaged subscriber, separate human from automatic opens, read sign-up cohorts and the churn curve, count sponsorship inventory with fill rate, realized and effective CPM, add up revenue per subscriber, follow the paid-tier funnel and the MRR ledger, then compare lifetime value with acquisition cost, cost a referral program, set a sunset policy, forecast the sponsor pipeline, judge campaigns from the sponsor's side, forecast the list, test split results for significance, map paid-tier prices in a what-if grid, allocate a growth budget and finish with a quarterly scorecard: 20 hands-on labs, one fictional newsletter, every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course treats a newsletter as a media business and teaches the numbers behind it in 20 interactive spreadsheet labs. You work on Copperline Dispatch, a fictional weekday newsletter for independent restaurant owners with sponsors and a paid tier. You build the subscriber ledger, calculate churn and net growth, compare sign-up sources by cost per confirmed and per engaged subscriber, correct open rates for automatic opens, read cohorts and churn curves, measure sponsorship inventory, fill rate and CPM, follow the paid-tier funnel and monthly recurring revenue, and connect it all through revenue per subscriber, lifetime value and payback. Later labs cover referral rewards, list hygiene, the sponsor pipeline, forecasts, split-test significance, pricing grids, budget allocation and a final quarterly scorecard. Every formula is checked as you type. All companies, people and figures are fictional and benchmarks are illustrative.
Lessons
- Subscriber Growth and Churn: the Monthly List Ledger, Churn Rate, Net Growth Rate and the Replacement ShareFree
- Acquisition Cost by Source: Confirm Rate, Cost per Confirmed Subscriber, Blended vs Paid CAC and a Bar Chart Locked
- Source Quality: 90-Day Retention, Cost per Engaged Subscriber, Ranking the Sources and a Scale / Hold / Cut Verdict Locked
- Opens You Can Trust: Reported vs Human Open Rate, Click Rate, Weighted Averages and a Trend Chart Locked
- Sign-Up Cohorts: an Engagement Retention Grid with Mixed References, the Weighted Cohort Average and a Heat Rule Locked
- The Churn Curve: Monthly Churn of One Cohort, the Survival Curve, Steady-State Churn and Expected Subscriber Lifetime Locked
- Sponsorship Inventory: Available Slots, Fill Rate, Realized CPM and Effective CPM on All Inventory Locked
- Revenue per Subscriber: Three Revenue Streams, Monthly ARPS, Sponsorship Dependence, Annual ARPS and a Stacked Chart Locked
- Paid-Tier Conversion: Trial Start Rate, Trial-to-Paid Rate and Overall Conversion by Tenure and Engagement with SUMIFS Locked
- Paid Subscribers: the MRR Ledger, MRR Churn Rate, Weighted Average Churn and the Lifetime Value of a Paying Reader Locked
- Subscriber Value by Source: XLOOKUP for Churn, Lifetime Value, LTV to CAC, Payback Months and a Verdict Locked
- Referral Program Economics: Reward Tiers, Cost per Referred Subscriber, the Referral Coefficient and the Power Referrers Locked
- List Hygiene: Days Since the Last Click, Active / At Risk / Dormant with IFS, Counting Dormant Readers and a Sunset Rule Locked
- The Sponsor Pipeline: Deal Value, Stage Probabilities with XLOOKUP, Weighted Forecast per Month and Sell-Through Locked
- Sponsor Results: Cost per Click, Cost per Conversion against the Sponsor's Target, Renewal Outlook and Revenue at Risk Locked
- Forecasting the List: SLOPE and FORECAST.LINEAR on Twelve Months, a Driver-Based Forecast and the Ceiling of a Leaky List Locked
- Split Tests on Clicks: Relative Lift, the Pooled z-Score, a Two-Sided p-Value with NORM.S.DIST and a Verdict Locked
- Pricing the Paid Tier: a Price × Conversion Grid with Mixed References, the Break-Even Conversion and a Target Rule Locked
- Allocating the Growth Budget: Ranking Sources, Cumulative Cost in Rank Order, Fund or Skip and the Blended Cost of the Plan Locked
- Final Project: the Quarterly Newsletter Scorecard with Revenue, Revenue per Subscriber, Cost per New Subscriber, Sponsorship Dependence, a Flag and a Combo Chart Locked
Learner reviews
Be the first to review this course.