Why 'active trials' is the most misleading number in your dashboard

Open most subscription dashboards and you’ll see a big, reassuring number: active trials. It feels like a pipeline of future revenue. It usually isn’t — and forecasting off it will make you overstate next month’s MRR.

The trap

A free trial stays in the trialing state until its window ends. But a user can turn off auto-renew on day one and still sit in that “active trial” bucket for the rest of the week. They’ve already told you they won’t convert — the dashboard just hasn’t caught up.

So “active trials: 18” might really be “10 who’ll convert + 8 who already bailed.” Project MRR on 18 and you’ll forecast revenue that was never coming.

Split the number in two

The fix is to separate intent:

• In trial now — everyone still inside a trial window (the gross count).
• Will convert — trials still set to renew (auto-renew on). This is the real pipeline.

The signal is RevenueCat’s auto_renewal_status: a trial marked will_not_renew is canceled-but-still-trialing. Exclude those from your forecast and your projection stops lying.

Forecast from the right base

A defensible next-month MRR projection looks like:

(trials still set to renew) × (your historical trial→paid conversion rate) × (their plan price)

Note all three corrections: only renewing trials, discounted by your real conversion rate (not “all convert”), valued at each trial’s own plan price (not a blended average). That’s a number you can actually plan against.

While you’re at it, fix the activity feed too

The same distinction matters in your event stream. A trial turning off auto-renew is not a paying customer churning — but most feeds paint both the same alarming red. Separating “trial canceled” (an expected funnel drop) from “canceled” (real lost MRR) keeps you from panicking over churn that was never revenue.

TapPilot’s economics view already splits “in trial” from “will convert,” projects MRR off the renewing trials only, and tones trial drop-offs differently from paying churn. See subscription economics.