Lapsed clients

Re-segment this once a month, not weekly. Reactivation campaigns take weeks to land, and re-sorting the whole record base every week is noise.

Total client recordsEveryone ever on file, from the scheduling system.Active clientsSeen within the last month.Confirmed moved or inactiveExcluded from the outreach math.Recently lapsed (1–3 months)Moderately lapsed (3–9 months)Long lapsed (9+ months)

Last visit date and lifetime visit count already live in the scheduling or EHR system. Export those two columns and count them into the buckets above rather than re-entering clients one at a time.

Why they stopped

Fill these in as outreach responses come back. The pattern is worth as much as the bookings.

CostSchedulingMoved awaySwitched providerNo response

Back to the weekly log

What a realistic campaign is worth

Addressable lapsed pool: 0
Expected clients won back: 0.0
Monthly revenue impact: $0

Enter the segment counts above to size the pool.