All tools
ACQUISITION / ATTRITION / TARGETS / SCENARIOS

Model the list.
Expose the levers.

Project active subscribers with channel-specific acquisition, explicit monthly losses, a comparable improvement scenario, and a target you can solve backward.

  • Monthly ledger
  • Target solver
  • Local calculation
18-MONTH BASELINE

Baseline reaches the target in month 11.

16,200 gross acquired − 2,684 gross lost across 18 months. Calculations preserve fractional expected counts.

23,516projected active+13,516 from start
This is a deterministic flow model, not a promise.

It assumes entered rates continue, categories do not overlap, and each month's attrition applies to the opening active list before new subscribers arrive.

Gross acquired16,200

900 in month one

Gross lost2,684

0.90% of opening active each month

Required monthly569

Constant acquisition to reach 18,000

Scenario ending26,313

+2,796 versus baseline

ACTIVE LIST TRAJECTORY

Baseline, improvement scenario, and target.

7.1K14.2K21.3K28.4KM0M9M18
Baseline Improvement scenario Target
TARGET SOLVER

Baseline reaches 18,000 in month 11.

TARGET18,000

Desired active subscribers at or before month 18.

CONSTANT ACQUISITION NEEDED569

Closed-form result using current attrition and month-start timing.

VERSUS MONTH ONE-36.7%

Relative change from 900 current monthly acquisition.

FIRST TARGET MONTHM11

Scenario: month 9.

LONG-RUN CONTEXT

Constant inflow and proportional loss converge toward a fixed point.

100,000constant-flow equilibrium

At constant month-one acquisition of 900 and 0.90% monthly attrition, the mathematical equilibrium is 100,000 active subscribers.

ACQUISITION CONTRIBUTION

See which channel supplies the growth.

CHANNELMONTH 1MONTHLY CHANGEHORIZON TOTALSHARE
Product signups6500.0%11,700
72.2%
Content and events2500.0%4,500
27.8%
MONTHLY LEDGER

Opening list, inflow, outflow, and closing list.

MONTHOPENINGACQUIREDLOSTNETCLOSINGSCENARIO
M110,000+90090+81010,81010,963
M210,810+90097+80311,61311,919
M311,613+900105+79512,40812,868
M412,408+900112+78813,19713,811
M513,197+900119+78113,97814,746
M613,978+900126+77414,75215,675
M714,752+900133+76715,51916,597
M815,519+900140+76016,28017,513
M916,280+900147+75317,03318,422
M1017,033+900153+74717,78019,324
M1117,780+900160+74018,52020,220
M1218,520+900167+73319,25321,109
M1319,253+900173+72719,98021,992
M1419,980+900180+72020,70022,869
M1520,700+900186+71421,41423,739
M1621,414+900193+70722,12124,603
M1722,121+900199+70122,82225,461
M1822,822+900205+69523,51626,313
MODEL REVIEW

Assumptions are internally consistent.

Loss components must be mutually exclusive

Deduplicate people who could appear in multiple source events before adding component rates.

Improvement scenario creates measurable separation

2,796 more active subscribers by month 18 under the entered lift and attrition reduction.

Displayed people are rounded; calculations are not

The recurrence preserves fractional expected counts to avoid compounding display-rounding error.

PLANNING HANDOFF

Export exact assumptions, monthly flows, scenarios, target math, and model boundaries.

Active list size is opening balance, minus losses, plus acquisition.

The model keeps gross acquisition and gross attrition visible. A positive net number can still hide excessive loss, while a stable list can require substantial acquisition merely to replace people who leave.

CLOSING ACTIVEopening activemonthly losses+new subscribers

Attrition applies to the opening list before monthly acquisition.

New subscribers enter at the end of the modeled month and first face attrition in the next month. Real systems operate continuously, so the monthly result is an approximation whose value depends on consistent timing across baseline and scenario.

The target solver finds constant monthly acquisition under current attrition.

It uses the closed form of the same recurrence shown in the ledger. Channel growth assumptions are excluded from this particular answer so the result remains a clear constant-flow requirement.

Equilibrium exists only when acquisition and attrition assumptions are constant.

With constant monthly acquisition A and loss fraction c, the fixed point is A ÷ c. When any acquisition channel grows or declines each month, the acquisition flow moves and a single fixed equilibrium no longer describes the model.

What should starting active subscribers include?+

Use people who are currently contactable for the modeled stream and consent scope. Exclude historical contacts that are unsubscribed, suppressed, or otherwise ineligible.

Can I add unsubscribe, bounce, and cleanup rates together?+

Only when the categories are mutually exclusive in your source data. If one person can appear in multiple components, deduplicate the terminal loss first.

Why can the list grow while gross attrition is high?+

Acquisition can mask the outflow. That is why the tool reports gross acquired and gross lost separately from net change.

Is equilibrium a maximum list size?+

It is a fixed point under constant acquisition and proportional attrition, not a hard cap. Change either flow and the fixed point changes.

Are projected subscriber counts exact people?+

No. Calculations preserve fractional expected counts and the interface rounds for planning. Actual people and events are discrete and variable.