11 Retention Cost & Program Scenarios
11.1 The Price of Doing Nothing
The business loses roughly 34.54% of new customers after their first order. At the segment 3-year LTV figures, that pattern forfeits approximately £1.64M per year in forward portfolio value across both identified segments — £1.50M from UK one-timers and £140.21K from international. The figure compounds: a customer lost after order 1 in 2011 does not appear in 2012’s returning pool, so each year’s loss is the permanent absence of those customers from every subsequent period.
A 10-percentage-point improvement in 1st-to-2nd retention — the target of the day-30 follow-up program — would recover approximately £99.44K in three-year portfolio value across both segments (£87.31K UK, £12.13K international). The gap between £1.64M (total annual forfeiture) and £99.44K (recoverable at 10pp) is the permanent one-timer population that no program can reach.
For a buyer paying any revenue multiple for this business, the £1.64M annual figure is what the current customer base is forfeiting through one-timer churn. The day-30 program is the mechanism that closes the recoverable portion of that gap; its financial justification is this figure.
11.2 Three Programs With Computable Returns
The data identifies three specific, low-cost programs with clear financial returns based entirely on observed customer behavior. None requires significant capital.
Program 1 — The day-30 follow-up. This targets the large pool of customers who never return after their first purchase. A modest ten-percentage-point improvement in second-order conversions generates significant portfolio gains.
Program 2 — Recovering quiet frequent customers. This targets the most valuable customers showing early signs of going silent. If just 50% of these accounts are recovered, the business preserves a measurable portion of its three-year value.
Program 3 — Reactivating lapsed 2010 accounts. This targets customers who ordered in 2010 and went dark in 2011. Even a 10% success rate adds value at zero acquisition cost — these customers were already acquired.
Combined, these three programs add approximately £209.44K in three-year portfolio value under conservative assumptions.
11.3 Retention Program Scenarios
Three programs have computable returns from observed data. Each addresses a different point in the customer lifecycle. None requires significant capital.
Program 1 — Day-30 first-customer follow-up. Targets the 34.5% one-time customer rate by triggering contact at the point where the majority of eventual repeat customers return. A 10-percentage-point improvement in the first-to-second conversion rate, applied to the observed daily acquisition rate and the incremental forward LTV per converted customer, produces the base-case portfolio gain. The program requires a CRM trigger and account manager time.
Program 2 — Overdue Frequent customer recovery. Targets the highest-value customers showing early lapse signals. At a 50% recovery rate and the observed LTV per Frequent customer, the program preserves measurable three-year portfolio value. The cost is the account manager’s time for the contact calls.
Program 3 — Lapsed account reactivation. Targets accounts that ordered in 2010 and placed no orders in 2011. At a 10% reactivation rate and full forward LTV, the program adds to the portfolio at zero acquisition cost — these customers were already acquired.
Combined portfolio-value uplift under conservative assumptions: approximately £209.44K from the three programs. This is an upper bound — it assumes no interaction effects between programs and no overlap in the accounts they reach.
Sensitivity and uncertainty. These are point estimates built on four uncertain inputs. Each input has measurement uncertainty that compounds over three years. Any investment case should use the base estimate as the central projection and the pessimistic estimate as the floor for break-even analysis. If the pessimistic figure still exceeds implementation cost, the program is justified even under conservative assumptions.
11.3.1 Whole-Business — Forward Portfolio under Three Programs
Each scenario applies one program at a time to the baseline, then combines all three to show the cumulative portfolio uplift under conservative assumptions.
| Scenario | UK 3-Year Portfolio | International 3-Year Portfolio | Combined 3-Year Portfolio | Gain vs Baseline |
|---|---|---|---|---|
| Baseline (current) | £4.87M | £658.86K | £5.53M | £0 |
| Program 1 only — UK Day-30 follow-up | £4.96M | £658.86K | £5.61M | £87.31K |
| Program 2 only — UK Frequent customer recovery | £4.97M | £658.86K | £5.63M | £105.00K |
| Program 3 only — Intl Day-30 follow-up | £4.87M | £671.00K | £5.54M | £12.13K |
| All programs combined | £5.06M | £671.00K | £5.73M | £204.44K |
The Baseline row shows what the current identified customer base is expected to generate over 3 years if nothing changes. Each Program row shows the result if only that program is implemented at the stated improvement assumption. The Gain vs Baseline column is the number to use in any investment case.
The baseline Gain vs Baseline of £0 is correct — it represents no change from current behavior, not a calculation error.
Program 3 shows a modest gain of £12.13K because the International one-timer cohort is small: approximately 152 International one-timers against 1,352 UK one-timers. A 10-percentage-point Day-30 conversion applied to the smaller base, at the International incremental Y2+Y3 LTV of £809, is mathematically real but small in absolute portfolio terms.
The combined program gain is £204.44K in 3-year portfolio value — approximately £187/day in recovered forward value at the stated assumptions.
Analytical implication — what the gap represents. The gap between the Baseline row and the All Programs Combined row is £204.44K — the difference between what the business generates under current management and what it would generate under active management. A strategic buyer who already has the commercial infrastructure to run these three programs would capture that gap post-close.
11.3.2 UK — Forward Portfolio Programs
UK program contributions to the 3-year portfolio
| Scenario | UK 3-Year Portfolio | Gain vs Baseline |
|---|---|---|
| Baseline (current — no program changes) | £4.87M | £0 |
| Program 1 only — Day-30 follow-up (+10pp 1→2 retention) | £4.96M | £87.31K |
| Program 2 only — Overdue Frequent customer recovery (50%) | £4.97M | £105.00K |
| Program 3 only — Lapsed 2010 reactivation (10%) | £4.88M | £13.68K |
| All programs combined | £5.07M | £205.99K |
Program 1 — Day-30 follow-up adds £87.31K to the 3-year UK portfolio at a 10 percentage point improvement in 1→2 retention. This program targets the 1,352 UK one-time customers — at 10pp improvement, 135 additional customers convert to a second order, each generating £647 in incremental forward LTV (Y2+Y3 of the chain model).
Program 2 — Overdue Frequent customer recovery adds £105.00K assuming 50% recovery of the 42 currently overdue Frequent accounts at an average Frequent-tier 3-year LTV of £5.00K per customer. This is the most time-sensitive program: these customers exist right now and the window to contact them before a competitor does is closing daily.
Program 3 — Lapsed 2010 reactivation adds £13.68K at 10% reactivation of the 108 UK accounts that ordered in 2010 but placed zero orders in 2011 — 11 customers returning at full UK forward LTV. This is the only program with zero acquisition cost: every contact already has a transaction history with the business.
The combined gain of £205.99K represents approximately £188/day in recovered forward value at the stated improvement assumptions.
11.3.3 International — Forward Portfolio Programs
International program contributions to the 3-year portfolio
| Scenario | Intl 3-Year Portfolio | Gain vs Baseline |
|---|---|---|
| Baseline — no program changes | £658.86K | £0 |
| Program 1 only — Day-30 follow-up (+10pp 1→2 retention) | £671.00K | £12.13K |
| Program 2 only — Overdue Frequent recovery (50% of 0) | £658.86K | £0 |
| Program 3 only — Lapsed 2010 reactivation (10% of 12) | £660.46K | £1.59K |
| All programs combined | £672.59K | £13.72K |
Program 1 — Day-30 follow-up adds £12.13K at a 10pp improvement in 1→2 retention. This targets the 152 international one-time accounts. At 10pp improvement, 15 additional accounts convert to a second order, each generating £809 in incremental forward LTV.
Program 2 — Overdue Frequent recovery adds £0 assuming 50% recovery of the 0 currently overdue Frequent accounts at an average Frequent-tier revenue of £1.59K per account. The current overdue count is zero — the program value is in preventing future accounts from reaching the overdue threshold rather than recovering existing ones.
Program 3 — Lapsed 2010 reactivation adds £1.59K at 10% reactivation of the 12 international accounts that ordered in 2010 but placed zero orders in 2011. Zero acquisition cost: every contact already has a transaction history.
The combined gain of £13.72K represents approximately £13/day in recovered forward value.
11.3.4 Sensitivity Analysis
Each sensitivity table tests a ±5 percentage point shift in the retention assumption. If the pessimistic scenario still exceeds implementation cost, the investment is justified even under the most cautious assumptions.
Each scenario figure rests on four assumptions: observed retention, observed median order value, an assumed program improvement percentage, and an observed reorder interval. None of the four is a precise number — each carries measurement uncertainty that compounds over 3 years. The tables below show what a 5-percentage-point change in 1→2 retention does to per-customer LTV and the total portfolio.
UK sensitivity: ±5pp in 1→2 retention
| Assumption | UK LTV 3yr (per customer) | UK Portfolio 3yr |
|---|---|---|
| Pessimistic: 1→2 retention at 60% | £1.18K | £4.60M |
| Base: 1→2 retention at 65% (observed) | £1.24K | £4.87M |
| Optimistic: 1→2 retention at 70% | £1.31K | £5.14M |
Combined-stress UK scenario:
| Scenario | Retention assumption | AOV assumption | UK 3-yr LTV | UK portfolio |
|---|---|---|---|---|
| Pessimistic | -5pp from observed | -10% from median | ~£890 | ~£3.49M |
| Base case (observed) | 65.46% | £298.58 | £1.24K | £4.87M |
| Optimistic | +5pp from observed | +5% from median | ~£1,340 | ~£5.25M |
The pessimistic scenario applies simultaneously declining retention and AOV — the combined-stress case a CFO should use as the downside in acquisition modeling. The optimistic scenario reflects the upside if retention programs perform at stated assumptions.
International sensitivity: ±5pp in 1→2 retention
| Assumption | Intl LTV 3yr (per account) | Intl Portfolio 3yr |
|---|---|---|
| Pessimistic: 1→2 retention at 58% | £1.50K | £623.00K |
| Base: 1→2 retention at 63% (observed) | £1.59K | £658.86K |
| Optimistic: 1→2 retention at 68% | £1.68K | £696.42K |
The figures above are rounded to the nearest £100 — consistent with the precision the model supports over a 3-year horizon. Treat them as reliable within a ±10% band, not as precise forecasts.
11.3.5 Forward Revenue Scenarios — Bear / Base / Bull
The base case (£17.19M over three years from identified segments) assumes current retention rates hold with no programs implemented — the floor for a capable buyer. The bull case applies a 5pp retention improvement; the bear case applies a 5pp deterioration. The £1.91M spread between them is driven entirely by a 10-percentage-point retention range. Anonymous revenue (£1.51M annual) is excluded because it cannot be modeled without identity resolution.
The LTV model and program scenarios above answer what the current customer base is worth at current retention. This subsection translates those figures into the three forward revenue outcomes an acquirer should model before setting a bid price.
All scenarios below use the chain-model 3-year portfolio as the base. Anonymous segment revenue (£1.51M annually) is excluded from forward modeling — it cannot be reliably projected without CustomerID resolution. Year 1 revenue is approximated from the current annual gross figure adjusted for retention dynamics. These are transaction-data-only projections — they do not incorporate cost structure, margin, working capital, or supplier dynamics.
| Scenario | Assumption | Year 1 (identified) | Year 2 | Year 3 | 3-Year Total |
|---|---|---|---|---|---|
| Bear — Retention -5pp (transition disruption or competitive loss) | 60.08% blended 1→2 retention | £8.29M | £4.98M | £2.99M | £16.25M |
| Base — Current retention rates hold, no program execution | 65.08% blended 1→2 retention | £8.29M | £5.39M | £3.51M | £17.19M |
| Bull — Programs executed, retention +5pp improvement | 70.08% blended 1→2 retention | £8.29M | £5.81M | £4.07M | £18.16M |
| Note: | |||||
| Year 1 uses trailing 12-month net revenue as proxy. Years 2–3 apply blended retention rate compounding. No cost, margin, or working capital adjustments. Anonymous segment (£1.51M gross) excluded — cannot be modeled without CustomerID resolution. |
Reading the scenarios: The base case (£17.19M over 3 years from identified segments) assumes current retention rates hold and no programs are executed. This is the floor for a capable acquirer — any value creation program moves the outcome toward the bull case.
The bull-to-bear spread is £1.91M over 3 years — entirely driven by a 10 percentage-point retention range. A 5pp retention improvement is worth £974.18K in identified-segment revenue over 3 years. A 5pp deterioration costs £932.75K over the same period.
The anonymous segment is additive uncertainty. The £1.51M annual anonymous revenue is excluded from these scenarios because it cannot be modeled without CustomerID resolution.
Author: Shawn Phillips | Lailara LLC
← Lifetime Value & Forward Portfolio | Acquisition Cost Framework & Regional LTV →