Demo — All numbers and rows below are illustrative sample data, not a real warehouse. For context, see Attribution for Offline Conversions.

Subscription Journey Attribution (demo)

Subscriptions are the canonical offline-conversion problem: the signup happens once, but every Stripe renewal months later is a separate revenue event that needs to be attributed back to the original touchpoint. Channels that look identical on signup-day volume diverge dramatically once you measure the actual revenue stream.

Total Subscribers
8,412
6,188 active today
MRR
$412,840
From all active subscriptions
Blended LTV
$1,284
Across all channels, weighted by signups
Lifetime Churn
26.4%
Cumulative churn across all cohorts
Blended CAC
$318
LTV : CAC
4.0×
Payback
7.4 mo
LTV vs CAC by Acquisition Channel

Channels ranked by realized lifetime value of subscribers acquired there. The LTV:CAC ratio tells the unit-economics story.

ChannelSignupsLTVCACLTV : CAC12-mo Retention
salesforce / outbound411$3,244$6125.3×78.2%
google / cpc — brand1,412$2,188$18811.6×71.4%
organic / seo988$1,944$4246.3×68.1%
partner-network / referral612$1,812$2208.2×66.8%
(direct) / (none)923$1,64470.2%
klaviyo / lifecycle-email522$1,488$8816.9×62.4%
google / cpc — competitor1,188$612$4121.5×28.4%
facebook / paid_social1,644$488$2242.2×22.0%
tiktok / paid_social712$312$1841.7×14.8%

Key insight: Facebook and TikTok paid social drive the most signups (~28% of new subscribers combined) but have the worst LTV — a third of those subscribers are gone after a month, and the LTV barely covers CAC. Outbound and brand search look small at signup but compound: those cohorts retain past 70% at month 12 and produce 4–17× LTV:CAC. Without joining Stripe revenue back to acquisition channel in the warehouse, every signup looks equally valuable — and the budget gets misallocated for years.

Retention Curves by Acquisition Channel

Percentage of each channel's signup cohort still subscribed N months later. Same product, same pricing — wildly different retention.

MRR Contribution by Acquisition Channel

Stacked monthly recurring revenue, attributed back to the channel that originally acquired each subscriber. The composition is what matters — paid social adds up to less MRR than its signup share would suggest.

Cohort Retention Table

Percentage of each acquisition cohort still subscribed at month 1, 3, 6, and 12. Sorted by 12-month retention.

Acquisition ChannelSignupsM1M3M6M12
salesforce / outbound41197.1%93.0%86.2%78.2%
google / cpc — brand1,41296.2%89.4%80.8%71.4%
(direct) / (none)92395.9%88.8%80.0%70.2%
organic / seo98894.8%87.6%78.4%68.1%
partner-network / referral61295.4%88.2%79.6%66.8%
klaviyo / lifecycle-email52293.0%84.8%75.0%62.4%
google / cpc — competitor1,18881.2%58.2%40.2%28.4%
facebook / paid_social1,64478.4%49.8%30.4%22.0%
tiktok / paid_social71271.6%41.2%24.0%14.8%