Retention is where independent practices leak the most money without noticing. A bonded patient who quietly stops coming in for annual wellness, vaccines, or dental care represents years of recurring revenue walking out the door — and the reminder that should have pulled them back either never converted or never went out. This dashboard turns reminders and lapsed patients from a black box into a managed retention pipeline.
What this report answers
The reminder page answers whether the recall system is working: how many reminders went out, what share converted to a booked visit, and how compliance varies by reminder type and species. The lapsed-and-retention page answers the harder question: how many patients have slipped past the active window, what our 12-month retention rate is, and how much recoverable revenue is sitting in that lapsed population.
The metrics that matter
Reminder compliance rate — converted over sent — is the operational lever you can pull this week, and it almost always varies sharply by reminder type (a dental reminder converts very differently from an annual wellness reminder). The 12-month retention rate is the strategic number: small movements compound, because a retained bonded patient is far more valuable than a newly acquired one. Recoverable lapsed revenue puts a dollar figure on the reactivation list so outreach gets prioritized by value, not just by count.
Why the data is trapped across the systems
The reminder log, the appointment history, and the patient's last-visit date all live in the PIMS, but they're never joined into a funnel. AVImark and Cornerstone treat reminders as a print-and-mail task, not a measured conversion event, and even cloud systems rarely tie a sent reminder to whether it produced a booking. Computing active vs. lapsed, retention cycle-over-cycle, and the dollar value of the lapsed list means exporting reminders and visit history and modeling them together.
How to read it
Start with reminder compliance by type — the lowest-converting reminder is usually the easiest win, whether through better timing, channel, or message. Then read lapsed patients by months-since-last-visit: the 13–18 month bucket is the most reactivatable, while the deep-lapsed tail is harder to win back. Use recoverable lapsed revenue to rank the outreach list, and watch the 12-month retention rate as the score that tells you whether the whole effort is working.
The sample on this page uses fully synthetic data — anonymized patient and clinic ids, no real medical records.
Metrics it tracks
| Metric | What it means |
|---|---|
| Active Patients | Patients seen within the trailing 12-month active window. |
| Reminder Compliance Rate | Reminders that converted to a booked visit ÷ reminders sent — a SUM/SUM ratio. |
| Lapsed Patients | Patients whose last visit is past the 12-month active window. |
| 12-Month Retention Rate | Patients still active this cycle who were active last cycle ÷ patients active last cycle — a SUM/SUM ratio. |
| Reminders Sent | Count of reminder rows issued in the period. |
| Recoverable Lapsed Revenue | Expected next-visit value summed across lapsed patients — the reactivation opportunity. |
Used by: Practice owners and practice managers fighting patient attrition and lapsed-care revenue leakage
Frequently asked questions
What is reminder compliance and why is it the retention lever?
Reminder compliance is the share of reminders sent that convert to a booked visit. It's the most direct lever a practice can pull on retention because it measures whether the recall system actually brings patients back — and it varies sharply by reminder type, so a low-converting reminder is often the easiest win.
When is a patient considered lapsed in a veterinary practice?
A common definition is a patient whose last visit falls outside a trailing 12-month active window, though some practices use 14 or 18 months for certain species. The dashboard flags active versus lapsed on that window and ranks the lapsed population by months-since-last-visit so the most reactivatable patients are clear.
Can I build this on my own reminder and visit data?
Yes. Export your reminder log and visit history from your PIMS and use this as a template — we model it into a Power BI report. The sample uses synthetic data, so there are no real patient records in what you see here.
Build this report on your own data
Clone this Vet clinics template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →