Payments Analytics Tool

Cohort Revenue Modeler

Model subscriber LTV, passive churn curves, and recapture rates across cohorts and billing configurations. Understand how billthrough optimization compounds into LTV — and where the real revenue recovery opportunity lives.

Cohort Configuration

Monthly New Subscribers50,000
New subscribers acquired per month
Monthly Price (USD)$12.00
Average monthly subscription price
Voluntary Churn Rate4.2%
Monthly voluntary cancellation rate
Passive Churn Rate3.1%
Monthly passive churn from billing failure
Billthrough Rate78.0%
Share of billing attempts that succeed
Dunning Recovery Rate22%
Share of passive churn recovered via dunning

Cohort Retention Curve — 24 Months

Active Subscribers by Cohort Month

Month 1 Retention
After first renewal
Month 6 Retention
Month 12 Retention

Billthrough Impact on LTV

LTV at Different Billthrough Rates

The Compounding Effect

Cohort Revenue Table — 12 Months

Passive Churn Recovery Analysis

Monthly Passive Churn Lost
Subscribers lost to billing failure
Recovered via Dunning
Saved by dunning / retry
Net Passive Loss
Monthly recurring impact
Optimization Priority