lemme.surf
Presets:

Funnel Variables

Editable
$

Cost to acquire 1 trial user ($D_0$)

$

Upfront initial payment on Day 0 (W0)

$

Recurring subscription charge starting from W1

%
%
%
%
%
%
%
%

% of active subscribers churning each week after W1

%

Payment commissions, Store fees, and chargebacks

W

Number of weeks to simulate on payback charts

Payback Status

Pays back in 3.4 wks

Exact Breakeven

~24 Days

Gross LTV (∞) $22.77 Total user lifetime value
Net LTV (∞) $20.50 Net revenue after fees
Max Breakeven CPA $20.50 Absolute ceiling for CPA
Target CPA (2 Wks) $7.90 Net LTV at Week 2
Target CPA (4 Wks) $12.33 Net LTV at Week 4
CPA / W1 Revenue 2.7x Ideal benchmark < 2.5x

Daily Trial Cascade Waterfall ($D_0 \dots D_7$)

Step-by-step decay from 100 $D_0$ trial starts to 1st weekly payment ($W1$)

$R_1$ Cascade
0. Trial Starts ($D_0$) 100.0 users (100%)
1. Onboarding Completed ($\text{CR}_{\text{onb}}$) 92.0 users
2. Day 1 Active ($\text{Retention}_{\text{D1|Onb}}$) 82.8 users
3. Day 3 Active ($\text{Retention}_{\text{D3|D1}}$) 72.9 users
4. Day 5 Active ($\text{Retention}_{\text{D5|D3}}$) 67.0 users
5. Day 7 Active ($\text{Retention}_{\text{D7|D5}}$) 63.0 users
6. Auto-Renew Maintained ($1 - \text{OptOut}$) 53.6 users
7. Successful W1 Charge ($1 - \text{Payment Failure}$) 52.5 users ($R_1 = 52.5\%$)

Payback Trajectory

Cumulative Net LTV vs Target CPA

Net LTV Target CPA

First 6 Weeks Cohort Breakdown

Per 100 acquired trial users
Week Active % Gross Rev/User Cum. Net LTV Net Profit/User

Subscription unit economics are calculated using cohort analysis: revenue from retained users is averaged across the entire initial cohort acquired, accounting for weekly churn rates, payment processing fees, and chargeback reserves.

1. Why $D_3$ and $D_5$ Matter

In subscription trial modeling, engagement decays continuously across the 7-day trial window. While simplified benchmark reports often mention only $D_1$ and $D_7$, performance marketing and growth teams track intermediate milestones ($D_3$ and $D_5$) to pinpoint where user dropoff occurs (e.g., trial expiration nudges, activation milestone completion).

2. The Conditional Base Hierarchy

Each retention step is a conditional probability based on the active user population from the immediately preceding step:

$D_0$ Base ($N_0 = 100\%$): Total trial registrants acquired at Target CPA.
Onboarding Completion ($\text{CR}_{\text{onb}}$):
$$N_{\text{onb}} = N_0 \times \text{CR}_{\text{onb}}$$
Day 1 Retention ($\text{Retention}_{\text{D1|Onb}}$): % of onboarded users returning on Day 1.
$$N_{\text{D1}} = N_{\text{onb}} \times \text{Retention}_{\text{D1|Onb}}$$
Day 3 Retention ($\text{Retention}_{\text{D3|D1}}$): % of Day 1 active users who remain active on Day 3.
$$N_{\text{D3}} = N_{\text{D1}} \times \text{Retention}_{\text{D3|D1}}$$
Day 5 Retention ($\text{Retention}_{\text{D5|D3}}$): % of Day 3 active users who remain active on Day 5.
$$N_{\text{D5}} = N_{\text{D3}} \times \text{Retention}_{\text{D5|D3}}$$
Day 7 Retention ($\text{Retention}_{\text{D7|D5}}$): % of Day 5 active users who remain active through Day 7.
$$N_{\text{D7}} = N_{\text{D5}} \times \text{Retention}_{\text{D7|D5}}$$
Auto-Renew Maintained ($1 - \text{OptOut}_{\text{trial}}$): % of Day 7 active users who do not manually cancel before billing.
$$N_{\text{renew}} = N_{\text{D7}} \times (1 - \text{OptOut}_{\text{trial}})$$
Successful Billing ($1 - \text{Payment Failure}$): % of renewal charges accepted by payment gateways.
$$N_{\text{W1}} = N_{\text{renew}} \times (1 - \text{Payment Failure})$$

3. Complete $R_1$ Conversion Formula

Combining this hierarchical chain yields the total percentage of trial registrants who complete their first weekly renewal payment ($R_1$):

$$R_1 = \text{CR}_{\text{onb}} \times \text{Retention}_{\text{D1|Onb}} \times \text{Retention}_{\text{D3|D1}} \times \text{Retention}_{\text{D5|D3}} \times \text{Retention}_{\text{D7|D5}} \times (1 - \text{OptOut}) \times (1 - \text{Payment Failure})$$

4. Model Variables & Notation

Foundational metrics measured across the funnel:

CPA — Acquisition cost per trial user ($D_0$)
P_trial — Upfront trial price ($)
P_sub — Recurring weekly subscription price ($)
R_1 — Renewal conversion rate ($0 \le R_1 \le 1$)
c — Weekly post-conversion churn ($0 < c < 1$)
fee — Processing fees + chargebacks ratio

5. Weekly Gross Revenue per User

Average gross revenue generated by a single acquired user during week N:

$$\text{Rev}(0) = P_{\text{trial}} \quad \text{(Trial Period W0)}$$
$$\text{Rev}(N) = P_{\text{sub}} \times R_1 \times (1 - c)^{N - 1} \quad \text{(for } N \ge 1 \text{)}$$

6. Cumulative LTV Formulas

Total gross and net revenue generated per acquired user up to week N:

$$\text{Gross LTV}(N) = P_{\text{trial}} + P_{\text{sub}} \times R_1 \times \left[ \frac{1 - (1 - c)^N}{c} \right]$$
$$\text{Net LTV}(N) = \text{Gross LTV}(N) \times (1 - \text{fee})$$

7. Terminal Maximum LTV & Exact Payback Equations

Theoretical limit as $N \to \infty$ and exact payback week equation:

$$\text{Gross LTV}_{\infty} = P_{\text{trial}} + P_{\text{sub}} \times \left( \frac{R_1}{c} \right)$$
$$\text{Net LTV}_{\infty} = \text{Gross LTV}_{\infty} \times (1 - \text{fee})$$
$$N_{\text{payback}} = \frac{\ln\left( 1 - \frac{\left( \frac{\text{CPA}}{1 - \text{fee}} - P_{\text{trial}} \right) \times c}{P_{\text{sub}} \times R_1} \right)}{\ln(1 - c)}$$
Crucial Edge Case: If the numerator logarithm term is ≤ 0, CPA exceeds theoretical maximum Net LTV (Net LTV_∞), meaning the campaign will never reach breakeven under the current conversion and churn metrics.

Cookie settings

Essential site features stay on. Choose the optional measurement you allow.

Privacy