Clew

HomeToolsProduct analyticsActivation → revenue

Activation rate calculator: how much revenue better activation brings

What is a few percentage points of activation worth? Enter sign-ups, current and target activation, paid conversion, ARPA and churn — the calculator models your paying base month by month and shows the extra MRR, ARR and revenue over the chosen horizon.

● Free, no sign-upUpdated:

Funnel to payment

Share of new users who complete the key action.
Set the target as
The activated share after your changes.
A share of activated users, not of all sign-ups.

Money and churn

Average monthly revenue per paying account.

—

 

Extra paying— 
Extra MRR at horizon— 
Extra revenue, total— 
Extra ARR (run-rate)— 
Monthly MRR: as is and with better activationshaded — extra MRR
Monthly MRR: as is and with better activation
current activationtarget activationdifference

Model assumptions

  • Sign-ups, activation, paid conversion, ARPA and churn stay constant over the horizon.
  • A customer pays in the month they activate; churn applies to paying customers only.
  • No expansion revenue (upsells), refunds or discounts; the effect starts in month one.

Everything is calculated in your browser — nothing you enter is sent anywhere.

How to use it

  1. Describe the funnelHow many sign-ups arrive per month, what share activates today, and what share of activated users starts paying.
  2. Set a targetA target activation level or a lift in percentage points — for example, from onboarding changes.
  3. Add the economicsARPA, monthly churn of paying customers, the current paying base and the horizon.
  4. Read the effectExtra paying customers, MRR and ARR at the end of the horizon, and cumulative revenue. Hover the chart to see any month.

How the calculator models the activation effect

Better activation does not hit revenue at once but through accumulation: every month a few more customers join the paying base, and every month churn removes a share of the base built so far. The calculator models this month by month, in monthly cohorts.

New paying per month N = sign-ups × activation × paid share Paying base P_t = P_(t−1) · (1 − churn) + N MRR in month t MRR_t = P_t × ARPA Revenue over period Σ MRR_t, t = 1 … horizon

The model runs twice — with current and with target activation — and the calculator shows the difference. The recursion has a closed form that makes the result easy to verify:

P_t = P_0 · (1 − c)^t + N · (1 − (1 − c)^t) / c Extra paying at horizon ΔP_t = ΔN · (1 − (1 − c)^t) / c Steady state (t → ∞) ΔP = ΔN / c, ΔMRR = ΔN · ARPA / c

The formulas reveal two properties. First, the current base P0 drops out of the difference: it shrinks identically in both scenarios, so “paying today” only affects the chart, not the effect. Second, the effect has a ceiling of ΔN / c: at 4% monthly churn the extra base tends to 25 times the extra monthly inflow. The lower the churn, the longer the effect compounds and the more activation is worth.

Example

2,000 sign-ups, activation grows from 25% to 32%, 15% of activated users pay: ΔN = 2,000 × 0.07 × 0.15 = 21 customers a month. At 4% churn, after 12 months the extra base is 21 × (1 − 0.9612) / 0.04 ≈ 203 customers; at $50 ARPA that is about $10,000 of extra MRR at year end. Revenue for the year is less than 12 × final MRR because the base grows gradually.

Assumptions and limitations, honestly

Any model like this is a simplification. This one is deliberately simple so you can recompute it on paper. Here is what it does not account for:

  • Constant parameters. Sign-ups, activation, paid share, ARPA and churn do not change over the horizon. A growing product also grows sign-ups — then the effect is larger.
  • Immediate effect. The new activation rate applies from month one and customers pay in the month they activate. If there is a trial between sign-up and payment, shift expectations by its length.
  • Churn for paying customers only. The model does not track activated users who have not paid yet: the paid share is applied to each cohort once.
  • No expansion or contraction. Upsells, plan changes, discounts and refunds are not modeled. If your net revenue retention (NRR) is well above 100%, the real effect is larger.
  • Same customer quality. Additionally activated users behave like current ones: they pay with the same probability and churn at the same rate. If the lift comes from less motivated users, their paid share may be lower.

So use the calculator for orders of magnitude and prioritization: is onboarding worth investing in if a 5-point activation lift yields this much MRR in a year? A precise forecast needs your cohort data — see the retention calculator and the LTV and churn calculator.

What counts as activation

Activation is the share of new users who reach the product’s value moment: they complete a key action after which the chance of staying and paying rises sharply. For a task tracker that may be the first task assigned to someone; for a BI tool, a connected data source and a first dashboard; for a CRM, imported contacts and a first deal.

A good activation definition is validated with data: activated users should convert to paid and stay noticeably more often than non-activated ones. If there is no difference, “more activation, more revenue” does not hold for your product, and the key action itself needs rethinking. More in how we set up Clew’s own activation onboarding; on who should own onboarding, see Onboarding without developers.

Common mistakes

  • Multiplying the lift by 12 months with no churn. “+20 customers a month × 12 × ARPA” overstates the effect: some of those customers leave before year end.
  • Computing paid share from sign-ups but entering it as a share of activated users. Then the activation effect is counted twice or lost.
  • Confusing MRR at the horizon with revenue over the horizon. The first is a rate, the second is accumulated money; the calculator shows both.
  • Trusting the forecast without an experiment. Confirm an activation lift from onboarding changes with an A/B test — the A/B test calculator tells you how many users that takes.

Sources

  1. Skok D. SaaS Metrics 2.0 — A Guide to Measuring and Improving What Matters. forEntrepreneurs.com — MRR, churn, SaaS customer economics.
  2. Croll A., Yoskovitz B. Lean Analytics: Use Data to Build a Better Startup Faster. O'Reilly Media, 2013 — activation, retention and revenue as user lifecycle stages.
  3. Fader P. S., Hardie B. G. S. How to Project Customer Retention. Journal of Interactive Marketing, 21(1), 2007 — customer base retention models and the limits of constant churn.

FAQ

How do I calculate the revenue impact of activation?

Multiply sign-ups by the activation lift and by the share of activated users who start paying — that is the extra paying customers per month. Then accumulate them with churn: each month’s base equals last month’s base times (1 − churn) plus new customers. Extra MRR is the extra base times ARPA.

Why not just multiply the lift by 12 months?

Because some acquired customers leave. At 4% monthly churn, a customer who joins in January is still there in December with a probability of about 64%. Simple multiplication overstates the effect, more so with higher churn and longer horizons.

What are MRR and ARR?

MRR (monthly recurring revenue) is subscription revenue per month. ARR (annual recurring revenue) is the yearly equivalent; here it is the run-rate: MRR at the end of the horizon times 12. One-off payments are not part of MRR or ARR.

What is ARPA?

Average revenue per account — average monthly revenue per paying customer (account, company). In B2B, ARPA is more useful than ARPU because a company pays while it has many users.

Why enter the current number of paying customers?

Only for the chart, so the MRR curves start at your current level. The current base does not affect the difference between scenarios — it shrinks identically in both.

Which horizon should I choose?

12 months is usually enough for product decisions. A long horizon with low churn gives big numbers, but uncertainty grows too: sign-ups, prices and churn will change over several years. The steady-state effect is shown under the extra customers figure.

How do I build a business case for onboarding?

Estimate how many points you can realistically lift activation, compute the extra revenue for a year here, and compare it with the cost of the changes. After launch, confirm the lift with an experiment and recompute with actual data.

More in Product analytics

Open the collection →

Tours, tooltips and checklists whose impact shows up in the numbers.

Try Clew for freeHow it worksFree plan forever · no credit card

Product tours, popups and onboarding in the age of AI

7 patterns with step counts, copy rules and what to measure, what AI changes, and a checklist before you publish. PDF, 2 pages. What is inside →