Find where your clinic loses patients: a one-evening funnel count

Many clinic owners know exactly what they spend on advertising. Far fewer know what happens to an enquiry after the phone rings. How many people got a reply? How many booked? How many actually turned up, and how many paid for treatment? Without these numbers, every decision — ‘more budget’, ‘a new receptionist’, ‘lower prices’ — is made in the dark.

The good news: you do not need a new system or an analyst to see the picture. You need five numbers and one evening. Here is how I suggest collecting them and what to do with them next.

The five stages to count

A clinic funnel is the patient’s path from first contact to payment. For a first count, five stages are enough:

• Enquiries — how many new people called or wrote: phone calls, WhatsApp or Telegram messages, website forms, social media DMs and comments.
• Replied — how many of them the clinic actually answered: picked up, called back, wrote back.
• Booked — how many were given a specific date and time.
• Came in — how many of those booked actually turned up for the consultation or procedure.
• Paid — how many of those who came paid for treatment or a procedure, not just the consultation.

You can break the stages down further: consultation and treatment separately, the treatment plan and its first payment separately. For the first evening, though, this is enough. Counting five stages honestly matters more than counting twenty roughly.

Where to find the numbers

Almost everything you need is already recorded somewhere in the clinic. It is just scattered, and nobody puts it together.

• Call log. Your phone system shows incoming, answered and missed calls. If the front desk works from a mobile, check the call history on that phone. List missed calls separately and see which of them were returned.
• Messengers and social media. WhatsApp, Telegram, Viber, Instagram, Facebook. Scroll through the conversations for the chosen period: who wrote for the first time, who got a reply, who got none or got one too late.
• CRM. If you have one and it is kept up to date, it will hold enquiries and their status. Cross-check against the original sources, though: a CRM often captures only the people who have already been answered, while lost enquiries never reach it.
• Appointment book. The doctors’ schedule or practice management software shows who was booked and who came. No-shows usually appear as cancelled or empty slots.
• Till and accounts. Payments from new patients — from the till, the accounts or the same practice software.

If one of these records is not kept at all, that is already a finding. It means nobody is in charge of that stage, and the losses there are simply invisible.

How to count without fooling yourself

Numbers are easy to distort, even without meaning to. These are the rules I stick to when counting:

• Count people, not messages. One person may call twice and then send a WhatsApp as well. That is one enquiry. Match them by phone number or name.
• New patients only. Calls from existing patients about rescheduling or results are a separate stream. Mix them in and the funnel looks better than it is.
• One period for every stage. Take the last full month and follow exactly the people who got in touch that month: were they answered, did they book, did they come, did they pay?
• One spreadsheet. One row per person, one column per stage, ‘yes’ or ‘no’ in each cell. Add a column for the source: call, messenger, website.
• Do not fill gaps with guesses. If you have no data on someone, write ‘no data’, not ‘probably booked’.

The first count will not be perfectly accurate, and that is fine. If some data has not been kept, count from what you have and mark where the holes are. The holes themselves show which stage nobody in the clinic is tracking.

Until the stages are counted, every advertising decision is a guess.

How to read the gaps between stages

On their own, the numbers say little. The meaning is in the transitions: what share of people make it from one stage to the next. The biggest drop between two neighbouring stages is the first place where your clinic loses patients. Each gap has its own typical cause.

Working out a transition is simple: divide the number of people at the next stage by the number at the previous one. Compare the transitions with each other, not with someone else’s ‘benchmarks’ from the internet. A clinic selling expensive treatment and a clinic doing one-off procedures will look different. Your job is to find the weakest point in your own clinic.

Look at the source column too. Sometimes calls make it to a booking just fine, while messenger enquiries are lost at the very first reply. Or the other way round. Then the problem is not the whole funnel but a single channel — and that is the one to fix.

Enquiries → Replied

This is where missed calls, unanswered messages and next-day replies disappear. Someone who does not get an answer rarely waits — they message the clinic down the road. Check who answers at lunchtime, in the evening and at weekends, and whether there is a rule for returning missed calls.

Replied → Booked

The receptionist answered, quoted a price — and let the person go. No time offered, no questions asked, no explanation of what happens at the consultation. If the big gap is here, the problem is usually the conversation script, not the price. Listen to a few call recordings or reread the chats from the same month — the cause is usually obvious.

Booked → Came in

No-shows. The causes are usually simple: the appointment is too far ahead, there is no confirmation the day before, no reminder, no clear directions. Mark separately who cancelled in advance and who simply did not turn up. These are different problems with different fixes. The gap itself is often closed by one clear rule for confirming appointments.

Came in → Paid

The patient received a treatment plan and left to ‘think it over’. If nobody called or wrote afterwards, they make the decision without the clinic — or with a competitor. Check whether someone is responsible for following up after the consultation, and whether that follow-up has clear deadlines.

Checklist for the evening

1. Pick the period — the last full month.
2. Export the call log: incoming, missed, returned.
3. Go through messengers and social media and list the new enquiries.
4. Put everything into one spreadsheet: one person, one row.
5. Remove existing patients and duplicates.
6. Use the appointment book to mark who booked and who came.
7. Use the till records to mark who paid for treatment.
8. Work out the transitions between neighbouring stages and find the biggest gap.
9. Write down one hypothesis for why it happens and one action to test next week.

Once the spreadsheet is ready, see what these losses cost in money. That is what the loss calculator is for: enter your own numbers and you will see the amount at stake. If you want to check the whole front-desk process, start with the self-check.

And if you have no time to count it yourself, start with a free express front-desk check: I contact your clinic 3–5 times as a patient — by phone, on WhatsApp and on Instagram — put the findings on one page and, on a 30-minute call, show you what happens to an enquiry in the first stages. The full month-long funnel, enquiry → booking → visit → payment, with a review of each administrator, is what I build in the front-desk audit, which costs €300. The other steps and their prices are on the services page.