Subscription and media analytics

Subscription analytics shows which offers bring subscribers who stay at full price, and what you can spend to win each. Publishing analytics adds which articles turn anonymous readers into registered ones, then subscribers. Both need retention read by cohort and by offer.

Last reviewed

Retention by acquisition offer, example

220 of 810 discount subscribers, 27.2%, left when the offer ended

Example data
Two retention curves, months 0 to 12, for 1,000 subscribers each. Full price falls to 640 by month 12. The 50% off for three months cohort stays above full price to month 3, drops from 810 to 590 at month 4 when the price steps up, and ends at 410.Still paying02505007501,000036912MonthFull price, month 0: 1,000 still payingFull price, month 1: 900 still payingFull price, month 2: 840 still payingFull price, month 3: 800 still payingFull price, month 4: 775 still payingFull price, month 5: 750 still payingFull price, month 6: 728 still payingFull price, month 7: 708 still payingFull price, month 8: 690 still payingFull price, month 9: 675 still payingFull price, month 10: 662 still payingFull price, month 11: 650 still payingFull price, month 12: 640 still paying50% off for three months, month 0: 1,000 still paying50% off for three months, month 1: 940 still paying50% off for three months, month 2: 875 still paying50% off for three months, month 3: 810 still paying50% off for three months, month 4: 590 still paying50% off for three months, month 5: 545 still paying50% off for three months, month 6: 510 still paying50% off for three months, month 7: 482 still paying50% off for three months, month 8: 460 still paying50% off for three months, month 9: 443 still paying50% off for three months, month 10: 430 still paying50% off for three months, month 11: 419 still paying50% off for three months, month 12: 410 still payingMonth 4: 810 to 590Price step: halfprice ends aftermonth 3Two retention curves, months 0 to 12, for 1,000 subscribers each. Full price falls to 640 by month 12. The 50% off for three months cohort stays above full price to month 3, drops from 810 to 590 at month 4 when the price steps up, and ends at 410.Still paying02505007501,000024681012MonthFull price, month 0: 1,000 still payingFull price, month 1: 900 still payingFull price, month 2: 840 still payingFull price, month 3: 800 still payingFull price, month 4: 775 still payingFull price, month 5: 750 still payingFull price, month 6: 728 still payingFull price, month 7: 708 still payingFull price, month 8: 690 still payingFull price, month 9: 675 still payingFull price, month 10: 662 still payingFull price, month 11: 650 still payingFull price, month 12: 640 still paying50% off for three months, month 0: 1,000 still paying50% off for three months, month 1: 940 still paying50% off for three months, month 2: 875 still paying50% off for three months, month 3: 810 still paying50% off for three months, month 4: 590 still paying50% off for three months, month 5: 545 still paying50% off for three months, month 6: 510 still paying50% off for three months, month 7: 482 still paying50% off for three months, month 8: 460 still paying50% off for three months, month 9: 443 still paying50% off for three months, month 10: 430 still paying50% off for three months, month 11: 419 still paying50% off for three months, month 12: 410 still payingMonth 4: 810 to 590Full price64050% off for three months410Cohort: first paidmonth and offer atsign-up, trialsexcludedPrice step: half price endsafter month 3Two retention curves, months 0 to 12, for 1,000 subscribers each. Full price falls to 640 by month 12. The 50% off for three months cohort stays above full price to month 3, drops from 810 to 590 at month 4 when the price steps up, and ends at 410.Still paying02505007501,0000123456789101112MonthFull price, month 0: 1,000 still payingFull price, month 1: 900 still payingFull price, month 2: 840 still payingFull price, month 3: 800 still payingFull price, month 4: 775 still payingFull price, month 5: 750 still payingFull price, month 6: 728 still payingFull price, month 7: 708 still payingFull price, month 8: 690 still payingFull price, month 9: 675 still payingFull price, month 10: 662 still payingFull price, month 11: 650 still payingFull price, month 12: 640 still paying50% off for three months, month 0: 1,000 still paying50% off for three months, month 1: 940 still paying50% off for three months, month 2: 875 still paying50% off for three months, month 3: 810 still paying50% off for three months, month 4: 590 still paying50% off for three months, month 5: 545 still paying50% off for three months, month 6: 510 still paying50% off for three months, month 7: 482 still paying50% off for three months, month 8: 460 still paying50% off for three months, month 9: 443 still paying50% off for three months, month 10: 430 still paying50% off for three months, month 11: 419 still paying50% off for three months, month 12: 410 still payingMonth 4: 810 to 590Full price64050% off for three months410Cohort: first paidmonth and offer atsign-up, trialsexcludedPrice step: half price ends after month 3Two retention curves, months 0 to 12, for 1,000 subscribers each. Full price falls to 640 by month 12. The 50% off for three months cohort stays above full price to month 3, drops from 810 to 590 at month 4 when the price steps up, and ends at 410.Still paying02505007501,0000123456789101112MonthFull price, month 0: 1,000 still payingFull price, month 1: 900 still payingFull price, month 2: 840 still payingFull price, month 3: 800 still payingFull price, month 4: 775 still payingFull price, month 5: 750 still payingFull price, month 6: 728 still payingFull price, month 7: 708 still payingFull price, month 8: 690 still payingFull price, month 9: 675 still payingFull price, month 10: 662 still payingFull price, month 11: 650 still payingFull price, month 12: 640 still paying50% off for three months, month 0: 1,000 still paying50% off for three months, month 1: 940 still paying50% off for three months, month 2: 875 still paying50% off for three months, month 3: 810 still paying50% off for three months, month 4: 590 still paying50% off for three months, month 5: 545 still paying50% off for three months, month 6: 510 still paying50% off for three months, month 7: 482 still paying50% off for three months, month 8: 460 still paying50% off for three months, month 9: 443 still paying50% off for three months, month 10: 430 still paying50% off for three months, month 11: 419 still paying50% off for three months, month 12: 410 still payingMonth 4: 810 to 590Full price64050% off for three months410Cohort: first paidmonth and offer atsign-up, trialsexcludedPrice step: half price ends after month 3
Cohort: first paid month and offer at sign-up, trials excluded
Month 4
Discount cohort810 to 590, 27.2% left
Full price800 to 775, 3.1% left
Blended, both cohorts1,610 to 1,365, 15.2% left
Example data: two invented cohorts of 1,000 subscribers each. The discount cohort held on better for three months, then lost 220 when the price doubled, and finished month 12 with 410 against 640 at full price.
Show the numbers
Retention table, example data
MonthFull price50% off for three months
01,0001,000
1900940
2840875
3800810
4775590
5750545
6728510
7708482
8690460
9675443
10662430
11650419
12640410

Subscription and media metrics, with formulas

Eight KPIs with formulas, built on contribution.

Eight media metrics and subscription KPIs, each with the formula that goes into the model. "Contribution" in every one means subscription revenue minus payment fees and the content cost you've agreed to allocate per subscriber.

KPIFormulaA good readingThe common mistake
Cohort retention at month nSubscribers from the cohort still paying at the end of month n ÷ subscribers who started in the cohortA curve that flattens after the first full-price renewalOne blended curve across every offer, which hides a discount cohort leaving at the price step
Monthly churn rateSubscribers lost in the month ÷ subscribers paying at the start of the monthRead per cohort and offer, with the price step months markedAdding the month's new joiners to the denominator, which makes churn look lower in a heavy acquisition month
Involuntary churn shareSubscriptions ended by a failed payment after all retries ÷ all subscriptions endedFalling, and read again after any change to how failed payments are retried or chasedCounting a failed payment as churn on the day it fails, before the retries have run
Contribution LTVSum of a cohort's contribution over a stated horizon, such as 24 months ÷ subscribers who started in the cohortQuoted with its horizon every timeUsing revenue, which leaves out payment fees and content cost, or giving no horizon at all
CACAcquisition spend ÷ new paying subscribersBelow contribution LTV for the same offerDividing by free-trial starts, when many trials never pay
LTV to CACContribution LTV over the stated horizon ÷ CACAbove 1 within the horizon, with the horizon written next to the ratioQuoting the ratio with no horizon, so it grows as far as anyone wants by stretching the months
Payback monthsThe month in which a cohort's cumulative contribution per starting subscriber first reaches CACShorter than the horizon used for LTVDividing CAC by full-price monthly contribution, which ignores the discount months and the subscribers who left
Paywall conversion per exposureSubscriptions started after a paywall view ÷ paywall views, per articleRead per article and per section, for anonymous and registered readers apartDividing by all page views or all users, which mixes readers who never met the paywall into the base

More worked examples are in the KPI and dashboard library.

Where subscription data usually lives

Billing, app stores and more, and where joins break.

The billing systemSubscriptions, invoices and failed payments, in whatever you bill through. Check whether yours keeps the cancellation date and the end of the paid period as separate fields. They are two different dates, and the churn rate moves depending on which one you count.
The app storesIf you sell subscriptions inside an app, check whether those subscribers reach your billing data at all. One person can hold a web subscription and an app subscription, and they'll count twice until the two are matched.
The paywall and CMSArticle metadata and paywall events. If the paywall logs events against its own reader ID, that ID has to be matched to the billing customer at the moment someone subscribes, or paywall conversion can't be traced to an article.
GA4Anonymous reading, measured by first-party browser cookie. A reader on two devices counts twice.
The offer codeUsually stored only as a coupon in billing. If it doesn't reach the warehouse, nobody can split retention by offer.

A blended churn rate of 15.2% is how a 27.2% exit at the end of an offer goes unnoticed.

Churn analysis by cohort and offer

Retention read by the offer each subscriber joined on.

A cohort is every subscriber whose first paid month is the same, split by the offer they joined on. Each cohort gets its own retention curve, and each offer's price step is marked on it. In the example, the half-price cohort keeps more subscribers than full price for three months. Then the offer ends and 220 of 810 leave in a single month. Read together, the two cohorts lose 15.2% that month, which looks like an ordinary bad month. Read by offer, the discount is the obvious cause.

The decision this changes is the offer itself. A discount is worth running if the subscribers still paying after the price step bring enough contribution to cover the discount and the extra cancellations. That sum needs month-12 retention, because at month 3 nobody on the offer has paid full price yet.

LTV to CAC on contribution, with payback months beside it

How to build LTV to CAC that holds up.

LTV to CAC only means something when LTV is built on contribution and has a horizon. Revenue LTV leaves out payment fees and the content cost each subscriber carries. An LTV with no horizon can be made as large as anyone likes by assuming subscribers stay for years. So the ratio is quoted with its months, for example 24, and payback months sits next to it, because payback shows how long the business funds each new subscriber.

Subscription analytics services that fit

The services subscription businesses need most, and why.

Read retention by cohort and by offer before you judge a channel or a discount. A blended churn rate hides the cohort that leaves at renewal.

Publishing analytics: registered and anonymous readers

How to count anonymous and registered readers.

Anonymous readersCounted by browser, so counts run high and reader frequency runs low. Measure them on reach and on how often they meet the registration wall.
Registered readersCounted by login ID, so frequency and the articles they read can be trusted. The conversion to watch here is registered to paying.
Paywall conversionRead per article exposure. An article that shows the paywall to 4,000 readers and converts 12 is doing different work from one that converts 12 out of 400, though both report 12 subscriptions. Both pairs of figures are example data.

AI in subscription and media analytics

What an AI needs before it can explain churn.

Ask an AI assistant "why did churn rise in March?" and it can only give a useful answer if cohort, offer and price step are columns it can query. With them, it can say whether March was the month a discount cohort reached full price. Without them it reports a blended rate and guesses at a cause. AI-led analytics builds those definitions first and shows the query behind every answer.

Questions people ask

Answers on churn, paywalls, cancellations and GA4.

Do you build churn dashboards for subscription businesses?

Yes. The core of one is a retention curve per monthly cohort, split by the offer each subscriber joined on, with the price step for every offer marked on the chart. Blended churn can sit beside it for the board.

Can you run paywall A/B tests for publishers?

Yes. The sample size is fixed before the test starts, from the current conversion per paywall exposure and the smallest lift worth having. A test that brings in more discounted subscribers is also read at the first full-price renewal, because that's where the difference shows.

How do you measure marketing for subscription businesses?

On subscribers who stay past the end of their offer. A channel that brings cheap sign-ups who leave at the price step can look like the best channel for three months. Where spend is large enough, a geo holdout test shows how many subscriptions it actually added.

How should we count a subscriber who has cancelled but still has access?

Pick one rule and write it down. We count a subscriber as lost at the end of the period they've paid for, because they can still read until then. Whichever rule you choose, churn, retention and LTV all have to use the same one.

Does GA4 work for publishers?

For anonymous reading, yes, with care. GA4 tells users apart by first-party cookie, so one reader on a phone and a laptop counts twice. Registered and subscribed readers are better measured on their own login ID, joined to the billing system.

Want retention split by offer?

Bring a year of subscription data with the offer codes. The first call works out whether your discount cohorts pay for themselves.

Book a call