Methodology · 13 min read

Subscription LTV Cohort Analysis: 30/60/90/180-Day DTC Subscriber Math

Subscription DTC brands (skincare clubs, supplements, pet food, coffee) cannot judge ad campaigns on first-order AOV: a $40 subscriber who renews eight times is worth far more than a $200 one-time buyer. This playbook lays out 30/60/90/180-day subscriber cohort math you build from your billing export, and how to cross-check it against Admaxxer's per-ad LTV.

30/60/90/180d
Cohort windows
Built in your own worksheet
7–365d
Per-ad LTV windows
Ad LTV & ARR page
Stripe
Subscription revenue
Or Shopify and other revenue sources

Why subscription LTV is different from product LTV

Product LTV is a statistical estimate. It is repeat-purchase rate multiplied by average order value across some chosen window, with a probability distribution attached. You can never know the LTV of a one-time purchaser until they either come back or stay away long enough that you decide they will not.

Subscription LTV is deterministic up to churn. A $40 monthly subscription generates exactly $40 every month until cancellation. There are only two unknowns: when the subscriber cancels, and whether they pause or upgrade in between. Both of those signals are recorded by the subscription platform in real time as state transitions on the contract record. You do not estimate them, you read them.

That distinction changes the whole cohort vocabulary. For product DTC you build a back-of-envelope payback curve and accept that the right side of the curve is noise. For subscription DTC you build a survival curve on the contract table and you can read the LTV today for any subscriber who signed up six months ago. The math is exact at every point.

Practically this means subscription brands should never make ad-mix decisions on first-order AOV alone. A subscriber whose first order is $40 may be worth $240 over six months, or $80 if they cancel after two refills. Two campaigns with identical first-order economics can have a 3x gap in 180-day revenue. The campaign-mix question is invisible without cohort math.

The 30, 60, 90, and 180-day windows — why these buckets

Use four cohort windows: 30 days, 60 days, 90 days, and 180 days. Each one is chosen for the kind of subscriber behavior it captures, not because the numbers look round.

Day 30 is first-renewal hesitation. The first auto-renewal lands roughly at day 30 for a monthly billing interval. This is when subscribers who never intended a recurring commitment cancel. It is a noise-bucket: heavy on impulse signups, accidental signups, and gift-as-subscription confusion. A 5% drop in the first 30 days is normal; a 25% drop is a product-onboarding problem.

Day 60 is the second renewal. Subscribers who hesitated at day 30 but stayed have now paid twice. Day 60 retention is the cleanest early signal that the product is actually being consumed. If day 60 retention is flat against day 30, you have an active early-life cohort and the day-180 LTV will be high. If day 60 dropped 15% from day 30, you have a product-fit problem masked by the first month.

Day 90 is the post-honeymoon mark. The novelty has worn off, the cabinet is full, and the credit-card statement is showing a recurring charge that the subscriber notices. Day-90 retention is the canonical 'how good is this DTC subscription' number. DTC-wide median is 55–65% at day 90; top-decile brands hold 80%+. Below 50% at day 90 is a hard signal to either fix product, pricing, or shipping cadence.

Day 180 is price-sensitivity. After six months the subscriber has had ample chance to compare your prices against alternatives, has likely been targeted by a competitor with a 20%-off offer, and has made an explicit cost/benefit judgement. Day 180 retention separates 'they like the product' from 'they value the product enough to keep paying.' For high-AOV subscriptions, day 180 is where the LTV curve flattens — subscribers past this mark tend to stay for years.

Churn cliffs — what they look like, how to read them

A churn cliff is a column on the cohort heatmap where retention drops sharply between two adjacent windows. Colour your worksheet pivot as a heatmap, with signup months on the y-axis and elapsed days on the x-axis. Healthy cohorts show a smooth gradient from green to amber across the row. Unhealthy cohorts show a green block followed by a red block — a cliff.

There are three canonical cliff patterns. First, the day-30 cliff: retention drops 10+ points between day 0 and day 30. This is bad onboarding. The product arrived, the subscriber tried it, and decided not to continue. Investigate first-shipment quality, confusion about the next bill, and whether the signup flow over-promised.

Second, the day-60-to-90 cliff: retention is flat through day 60 then drops 15+ points by day 90. This is the post-honeymoon cancellation pattern. Subscribers who tolerated the first two months now notice the third charge and act. Investigate price perception, inventory management on the subscriber's end (are they accumulating product faster than they consume it), and whether the second renewal email was tone-deaf about the recurring commitment.

Third, the day-180 cliff: retention holds through day 90 then drops 10+ points by day 180. This is competitive churn — a subscriber has been offered a better price elsewhere and switched. Investigate competitor activity, your win-back offers, and whether subscribers approaching the 6-month mark see a loyalty offer or get treated like every other charge.

Reading the heatmap row-by-row also reveals seasonal vs structural cliffs. A cliff that shows up in November cohorts only is BFCM-related: those subscribers signed up at peak promotion and were lower-intent. A cliff that shows up in every cohort uniformly is a structural product/pricing problem that needs a fix, not a campaign tweak.

Campaign-level subscriber LTV — the breakdown that exposes 3x LTV gaps

Channel-blended subscription LTV is useful for board-deck headlines and useless for campaign decisions. The honest number is per-campaign and per-creative, and it surfaces 2–3x LTV deltas that ROAS-on-first-order reporting hides.

Admaxxer's Ads Manager › LTV & ARR (/ads-manager?view=ltv) takes the customers whose first purchase falls in the window you pick (7, 30, 90, 180 or 365 days) and credits each one to the ad that acquired them, by first or last paid click. Everything the customer pays afterwards, including subscription renewals, stays with that original ad — it is not re-attributed to whichever ad the subscriber clicked last week.

The page breaks down by campaign, ad set and ad, showing day-1 revenue, revenue since, subscription revenue, LTV ROAS and the MRR / ARR each ad's customers carry today. The most common operator-actionable insight at the creative level: video creatives almost always beat static creatives on first-order match rate (lower CAC, more clicks), and static creatives almost always beat video on day-180 retention (higher LTV per acquired subscriber). The mechanism is selection — video creatives convert impulse buyers; static creatives over-represent considered buyers who churn less.

The decision rule that falls out: optimize Meta video creatives for cold prospecting (CAC efficiency at scale), optimize static creatives for retargeting and lookalikes (LTV per converted subscriber), and never compare them on first-order ROAS alone. The Ad LTV & ARR page gives you the revenue side per ad; subscriber retention per window comes from your own worksheet.

The same rule generalizes across platforms. Google Performance Max often beats Meta on first-order ROAS but loses on day-180 LTV because PMax over-indexes on warm in-market searches; Meta's prospecting reaches a colder audience that converts at lower ROAS but stays longer. Without a cohort view you cannot see this; with one, your monthly budget mix recommendation is unambiguous.

Getting subscription data in: what connects today

Connect your revenue source on /integrations. Stripe is the subscription source most workspaces use; Shopify, Paddle, WooCommerce and the other revenue connectors cover store orders and other billing. Admaxxer counts those payments on the ad that acquired each customer, and splits out the subscription share on the Ad LTV & ARR page.

Dedicated connectors for Recharge, Bold Subscriptions, Skio and Loop are not available yet. If you bill through one of them, subscriber-level retention comes from that platform's own customer or subscription export, which feeds the worksheet below.

Whatever the source, the shape you need is the same: signup date, acquisition campaign, billing interval, every renewal with its timestamp and amount, and the cancellation date. Keep pause and skip events apart from cancellations so they do not pollute the churn signal.

Avoiding double-counting between store orders and subscriptions

A subscriber who buys a one-off product at signup and then continues their subscription is one customer, not two. On the Ad LTV & ARR page, a store order and a later Stripe subscription from the same person (matched by email) count as one customer on the ad that acquired them.

In your own worksheet, apply the same rule: one row per subscriber, not per charge. If your store and your subscription app both record the same renewal, keep one of them and drop the duplicate before you compute retention.

The acquisition campaign on each row is the one that brought the subscriber in, not a later re-engagement ad. If a subscriber clicks a win-back ad three months in, the renewal revenue still belongs to the original acquisition campaign.

Channel and creative breakdown by 30 / 60 / 90 / 180 windows

Start your worksheet with acquired-subscriber count, day-30 / 60 / 90 / 180 retention, and cumulative revenue through each window, broken out by source and medium. The actionable view is one level deeper: the same metrics at the campaign and creative level.

Meta video creatives versus Meta static creatives is the single highest-signal split for DTC subscription brands. Video over-indexes on impulse signups (lower CAC, higher day-0 conversion, lower day-180 retention); static over-indexes on considered signups (higher CAC, lower day-0 conversion, higher day-180 retention). The two creative formats answer different acquisition strategies, and budget allocation between them is best made on day-180 LTV, not day-0 ROAS.

Google PMax versus Google Search is the next-most-signal split. PMax fishes in a broader audience pool and converts at lower last-click ROAS but with subscriber profiles that resemble Meta video — impulse-leaning, lower 180-day retention. Search captures already-intent traffic that converts at higher last-click ROAS and retains better. Subscription brands that over-allocate to PMax based on last-click numbers tend to discover an LTV problem six months later.

TikTok and Pinterest carry their own profiles. TikTok over-represents younger demographics that churn harder on price-sensitivity at day 180. Pinterest over-represents save-for-later behavior that converts later (longer attribution windows needed) but retains exceptionally well. A cohort breakdown by network makes these patterns visible.

A workable routine: every Monday, update the worksheet and compare last week's cohort against the trailing 13-week median on the same source × medium × campaign tuple. Any 10+ point retention drop is a flag. Drill into the creative breakdown to find which ad changed. This catches creative fatigue and audience drift before they show up in monthly revenue.

Healthy retention benchmarks for DTC subscriptions

Subscription retention benchmarks vary by vertical, AOV, and shipping cadence. As a rough rule of thumb (not a figure measured from Admaxxer data), DTC subscriptions land at about 55–65% day-90 retention. Top-decile brands hold 80%+ at day 90 and stay above 70% through day 180. The bottom-decile drops below 40% at day 90 and is unlikely to be profitable at any reasonable CAC.

Vertical patterns commonly reported: supplements retain better than apparel-as-subscription (cabinet effect is weaker, consumption is daily, refill cadence aligns with actual usage); coffee and grocery retain at high day-30 but degrade at day-180 when subscribers realize they prefer variety; skincare shows a bimodal pattern — high day-90 retention for the subset who incorporate it into a routine, sharp churn for the subset who treated it as a one-off trial; pet food retains the longest of any vertical (the pet eats every day, the human does not have to remember to use it).

The benchmark to internalise: below 50% at day 90 is a churn-cliff signal. Investigate it against the three canonical drivers (onboarding, price, competitive) before scaling spend. Above 70% at day 90 is healthy and means the acquisition mix can be pushed harder without worrying about LTV degradation.

Day-180 retention follows day-90 with a typical 8–15 point further drop. Healthy: above 55% at day 180. Top-decile: above 65%. Below 40% at day 180: the LTV math will not support double-digit CAC growth and the brand should fix retention before scaling spend.

Building the cohort table yourself

Admaxxer does not keep a subscriber-level retention table or a cohort API yet, so day-30 / 60 / 90 / 180 subscriber retention is a worksheet you build from your subscription platform's own customer export. The revenue side per ad is already on Ads Manager › LTV & ARR (/ads-manager?view=ltv), which you use to check your numbers.

One row per subscriber, from your subscription platform's
customer / subscription export:

  subscriber_id      the platform's customer id
  signup_date        date of the first subscription charge
  signup_campaign    the campaign that acquired them (UTM campaign,
                     or the ad shown on Admaxxer's Ad LTV & ARR page)
  billing_interval   month | quarter | year
  first_order_value  first charge, net of discounts and refunds
  paid_through_30d   revenue collected in days 0-30
  paid_through_60d   revenue collected in days 0-60
  paid_through_90d   revenue collected in days 0-90
  paid_through_180d  revenue collected in days 0-180
  cancelled_at       empty if still active

Then pivot:
  rows    = signup month (or signup_campaign)
  columns = day 30 / 60 / 90 / 180
  value   = share of subscribers with no cancelled_at before that day

Only count a cohort's day-N column once the cohort is N days old.

Use realised revenue, not contracted: the 30-day column is the money that actually billed and cleared in the first 30 days. Leave out failed payments and net out refunds so the column compares directly to revenue. A pause is not a cancellation — leave cancelled_at empty for paused subscribers.

How to read the pivot, per campaign:

  subscribers acquired           count of rows
  day-90 retention               active at day 90 / subscribers
  avg revenue per sub @ 180d     sum(paid_through_180d) / subscribers
  180-day ROAS                   sum(paid_through_180d) / campaign spend

Cross-check the revenue side against Admaxxer's Ad LTV & ARR page
(window 180 days): its per-ad LTV ROAS should land close to your
180-day ROAS for the same campaigns.

Where to get the numbers today

What exists now, and what does not. A cohort API, CSV cohort export, warehouse destination and read-only database access are not available yet.

  1. Ads Manager › LTV & ARR (/ads-manager?view=ltv) — customers acquired in a 7, 30, 90, 180 or 365-day window, on the campaign, ad set or ad that acquired them: day-1 revenue, revenue since, subscription revenue, LTV ROAS and the MRR / ARR they carry today.
  2. Retention heatmap (/dashboard/retention) — returning-visitor cohorts by day, week or month from the first-party pixel. It measures visits, not paid renewals, so use it as an engagement signal next to your subscriber worksheet.
  3. Your subscription platform's export — subscriber-level retention (who cancelled, and when) comes from your billing platform's own customer or subscription export.
  4. AI agents over MCP — connect an AI agent to Admaxxer over MCP (/integrations/mcp) and ask which ads drive LTV and ARR. It reads the same numbers as the Ad LTV & ARR page.

Worked example — a $40/mo skincare subscription, 35% day-90 churn

Walk through illustrative numbers for a DTC subscription brand. The product is $40/month, the first-shipment includes a small one-time onboarding kit at $15, day-90 retention is 65% (slightly below the DTC median), and the brand is choosing between two Meta campaigns.

Campaign A is a Meta video creative — bright, impulse-friendly, costing $50 CAC. Campaign B is a Meta static carousel that explains the product clinically — higher consideration, costing $80 CAC. On first-order ROAS Campaign A wins easily ($55 first-order revenue / $50 CAC = 1.10x first-order ROAS vs Campaign B's $55 / $80 = 0.69x). A monthly performance report optimizing on first-order ROAS would scale Campaign A and pause Campaign B.

Now factor in the cohort retention curves attributable to each acquisition source:

-- $40/mo skincare subscription, 35% churn at day 90.
-- Numbers are illustrative (rounded to round-figure paths).
Campaign A — Meta video creative
  CAC:                        $50
  First-order value:          $40
  Day-30 retention:           92%
  Day-90 retention:           68%
  Day-180 retention:          54%
  Cumulative revenue (180d):  ($40 × 1) + ($40 × 0.92 × 1)
                            + ($40 × 0.78 × 2) + ($40 × 0.61 × 3)
                            = $40 + $36.80 + $62.40 + $73.20
                            = $212.40 per acquired subscriber
  ROAS @ 180d:                $212.40 / $50 = 4.25x

Campaign B — Meta static creative
  CAC:                        $80
  First-order value:          $40
  Day-30 retention:           97%
  Day-90 retention:           81%
  Day-180 retention:          71%
  Cumulative revenue (180d):  ($40 × 1) + ($40 × 0.97 × 1)
                            + ($40 × 0.89 × 2) + ($40 × 0.76 × 3)
                            = $40 + $38.80 + $71.20 + $91.20
                            = $241.20 per acquired subscriber
  ROAS @ 180d:                $241.20 / $80 = 3.01x

Without LTV, you'd kill Campaign B (CAC too high).
With 180d LTV, you'd kill Campaign A — Campaign B builds a
better book of business even with a 60% higher CAC.

The decision flips. Campaign A returns 4.25x at day 180 but the absolute revenue per acquired subscriber is $212. Campaign B returns 3.01x at day 180 but the absolute revenue is $241. If both campaigns are scaled to the same target subscriber count, Campaign B generates 14% more cumulative revenue at day 180 — and the gap widens as the cohort ages beyond 180 days because static-acquired subscribers churn less per month going forward.

The right mix is usually 'both campaigns running, budgets balanced on a blended LTV target' — not 'kill the high-CAC campaign.' The cohort worksheet makes this visible; the first-order ROAS report buries it.

Operator checklist — running this in your own workspace

  1. Install Admaxxer's first-party pixel on your storefront (Shopify custom pixel, WordPress plugin, or the copy-paste snippet).
  2. Connect your revenue source on /integrations (Stripe for subscriptions; Shopify or another store for orders).
  3. Connect your ad accounts (Meta, Google, TikTok) on the same page.
  4. Export subscribers from your subscription platform and build the cohort worksheet: one row per subscriber, day 30 / 60 / 90 / 180 retention per signup month and campaign.
  5. Open Ads Manager › LTV & ARR (/ads-manager?view=ltv) with a 180-day window and compare its per-ad LTV ROAS with your worksheet's 180-day ROAS.
  6. Watch /dashboard/retention for returning-visitor drop-offs next to your renewal data.
  7. Flag any cohort whose day-90 retention falls 10+ points below your trailing baseline, and investigate the matching cliff pattern above.
  8. Repeat the review weekly on the same source × medium × campaign tuple to catch creative fatigue and audience drift early.

The Admaxxer setup takes under an hour. The worksheet is useful for week-old cohorts and becomes more reliable as cohorts age.

Frequently asked questions

Why is subscription LTV different from product LTV?
Product LTV (one-time purchases) depends on repeat-purchase rate and AOV over a window. Subscription LTV is predictable up to churn: a $40/mo subscription generates $40 a month until cancellation. The two signals to watch are (1) churn cliffs, the points where cancellations spike (often around the first renewal, around day 90 and around day 180), and (2) subscriber revenue per campaign at 30/60/90/180 days, which is the honest way to compare a $50 CAC campaign with an $80 CAC one; the more expensive campaign can still bring subscribers who stay much longer.
Where does Admaxxer get subscription revenue from?
From the revenue source you connect on /integrations: Stripe for subscriptions, or Shopify, Paddle and the other supported revenue sources. Admaxxer counts subscription payments on the ad that acquired each customer, and on the Ad LTV & ARR page a store order and a later Stripe subscription from the same person count as one customer. Dedicated Recharge, Bold, Skio and Loop connectors are not available yet.
What does a healthy 90-day subscription cohort retention look like?
There is no single benchmark; it varies by category, price and billing interval. As a rough rule of thumb, not a figure measured from Admaxxer data, compare each cohort with your own trailing baseline and investigate any cohort whose day-90 retention falls 10 or more points below it. Subscriber-level retention comes from your billing platform's export, built into the cohort worksheet in this playbook. Admaxxer's retention heatmap at /dashboard/retention shows returning-visitor cohorts, which is an engagement signal rather than paid renewals.
Can I see subscription LTV at the campaign and ad level?
Yes, for revenue. Admaxxer's Ads Manager › LTV & ARR (/ads-manager?view=ltv) shows customers acquired in a 7, 30, 90, 180 or 365-day window on the campaign, ad set or ad that acquired them: day-1 revenue, revenue since, subscription revenue, LTV ROAS and the MRR and ARR they carry today. Subscriber retention by day 30/60/90/180 is not a built-in report yet; build it from your billing export and cross-check its 180-day ROAS against Ads Manager › LTV & ARR.
How do I get subscription cohort data into my BI tool?
A cohort API, CSV cohort export, warehouse destination and read-only database access are not available yet. Today, subscriber-level data comes from your subscription platform's own export, and per-ad LTV and ARR are on the Ad LTV & ARR page. You can also connect an AI agent to Admaxxer over MCP and ask it which ads drive LTV and ARR; it reads the same numbers as that page.

Run this playbook in your own dashboard

Admaxxer ships the pixel + server-side purchases to Meta, TikTok and Klaviyo + Maxxer AI agent + cohort analytics out of the box. The playbook above becomes a live surface in your account after a 5-minute setup.

Start a 7-day trial See pricing