Tabellab
Marketing Analytics Intermediate

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.

20 lessons 20 labs Certificate

  • 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

  1. Subscriber Growth and Churn: the Monthly List Ledger, Churn Rate, Net Growth Rate and the Replacement ShareLabFree
  2. Acquisition Cost by Source: Confirm Rate, Cost per Confirmed Subscriber, Blended vs Paid CAC and a Bar ChartLab Locked
  3. Source Quality: 90-Day Retention, Cost per Engaged Subscriber, Ranking the Sources and a Scale / Hold / Cut VerdictLab Locked
  4. Opens You Can Trust: Reported vs Human Open Rate, Click Rate, Weighted Averages and a Trend ChartLab Locked
  5. Sign-Up Cohorts: an Engagement Retention Grid with Mixed References, the Weighted Cohort Average and a Heat RuleLab Locked
  6. The Churn Curve: Monthly Churn of One Cohort, the Survival Curve, Steady-State Churn and Expected Subscriber LifetimeLab Locked
  7. Sponsorship Inventory: Available Slots, Fill Rate, Realized CPM and Effective CPM on All InventoryLab Locked
  8. Revenue per Subscriber: Three Revenue Streams, Monthly ARPS, Sponsorship Dependence, Annual ARPS and a Stacked ChartLab Locked
  9. Paid-Tier Conversion: Trial Start Rate, Trial-to-Paid Rate and Overall Conversion by Tenure and Engagement with SUMIFSLab Locked
  10. Paid Subscribers: the MRR Ledger, MRR Churn Rate, Weighted Average Churn and the Lifetime Value of a Paying ReaderLab Locked
  11. Subscriber Value by Source: XLOOKUP for Churn, Lifetime Value, LTV to CAC, Payback Months and a VerdictLab Locked
  12. Referral Program Economics: Reward Tiers, Cost per Referred Subscriber, the Referral Coefficient and the Power ReferrersLab Locked
  13. List Hygiene: Days Since the Last Click, Active / At Risk / Dormant with IFS, Counting Dormant Readers and a Sunset RuleLab Locked
  14. The Sponsor Pipeline: Deal Value, Stage Probabilities with XLOOKUP, Weighted Forecast per Month and Sell-ThroughLab Locked
  15. Sponsor Results: Cost per Click, Cost per Conversion against the Sponsor's Target, Renewal Outlook and Revenue at RiskLab Locked
  16. Forecasting the List: SLOPE and FORECAST.LINEAR on Twelve Months, a Driver-Based Forecast and the Ceiling of a Leaky ListLab Locked
  17. Split Tests on Clicks: Relative Lift, the Pooled z-Score, a Two-Sided p-Value with NORM.S.DIST and a VerdictLab Locked
  18. Pricing the Paid Tier: a Price × Conversion Grid with Mixed References, the Break-Even Conversion and a Target RuleLab Locked
  19. Allocating the Growth Budget: Ranking Sources, Cumulative Cost in Rank Order, Fund or Skip and the Blended Cost of the PlanLab Locked
  20. Final Project: the Quarterly Newsletter Scorecard with Revenue, Revenue per Subscriber, Cost per New Subscriber, Sponsorship Dependence, a Flag and a Combo ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy