Impact story · Analytics → Revenue
The half that never showed up
How fixing what we could see lifted the show rate — same leads, same spend, more consultations attended.
We were paying to book consultations — and quietly, nearly a third of them never happened.
The problem
A third of bookings never happened
Show rate sat near 68% — and outcomes were not being recorded consistently, so the true number and its causes were invisible. A booking that no-shows is wasted twice: the ad spend that won the lead, and the counsellor slot that sat empty.
What I did
Made it measurable, then fixed the leak
First the measurement: every consultation outcome recorded, so show rate was finally trustworthy. Then the analysis — where the drop happened, by channel and by the gap between booking and appointment. That pointed at three targeted fixes: automated reminders, a confirmation step, and same-day follow-ups on the bookings most likely to slip.
The result
68% → 82% show rate
Roughly one in five no-shows recovered — more consultations attended every week from the same bookings, with zero extra ad spend. That is the leverage of analytics: I did not spend a rupee more on leads, I just made the leak visible and closed it.
Show rate, before and after
Out of every 100 booked consultations
View as table
| State | Attended | No-show |
|---|---|---|
| Before | 68 | 32 |
| After | 82 | 18 |
Where the drop-off was hiding
Once outcomes were recorded reliably, the pattern was not uniform. Two variables explained most of the variance: the acquisition channel a booking came from, and how many days sat between the booking and the appointment itself.
Show rate by booking-to-appointment gap
The longer the wait, the more intent decays
View as table
| Booking-to-appointment gap | Show rate |
|---|---|
| Same day | 89% |
| 1–2 days | 81% |
| 3–5 days | 70% |
| 6+ days | 54% |
Illustrative shape based on the pattern the analysis surfaced; exact figures are commercially sensitive.
The 6+ day cohort was the one to attack. It was not the largest group, but it was where the most attended consultations were being lost per booking — which made it the obvious target for the confirmation step and same-day follow-up.
The three fixes
Reliable outcome tracking
Every consultation outcome recorded in GoHighLevel, so show rate could be measured and trusted before anyone tried to move it.
Reminders + a confirmation step
Automated nudges and an explicit confirm action before each consultation, so intent was re-tested closer to the appointment.
Same-day follow-ups
Fast follow-up routed to the bookings the analysis flagged as most likely to slip — long booking-to-appointment gaps and lower-intent channels.
Why this one matters
Every marketing team has a version of this problem: a number everyone quotes that nobody can actually trust. The instinct is to go straight to fixing the number. The order that works is the other one — make it measurable, let the data tell you where the loss concentrates, then spend your effort there.
It also cost nothing. No additional media budget, no new headcount, no new tool. The same leads and the same bookings produced meaningfully more attended consultations, which is exactly where analytics earns its keep.
← All projects