How to count your missed calls

Almost every clinic phone system keeps a call log. On a cloud or IP phone system it is usually in the admin portal under call history or reports. On an older system, your telecom provider can often send a report for your number. Ask for the last seven days, exported to a spreadsheet if possible. If your clinic forwards calls to a mobile after hours, check that phone's call history too, because those calls may not appear in the main log.

You are looking for three kinds of call:

• Missed: the phone rang and nobody picked up.
• Abandoned: the caller hung up while waiting in a queue or on hold.
• Sent to voicemail: the call was answered by a machine. Count these as missed unless someone called back the same day.

If the log shows the caller's number, also count repeat callers: people who tried two or three times. That is a sign of how hard it is to get through, and it stops you counting one patient as three missed bookings.

A total on its own hides the pattern. Sort the log by time and group missed calls by hour. Then mark each hour as open or closed. You will usually see two shapes:

• Peak-hour misses during opening hours, often mid-morning, lunch and the hour before closing, when staff are with patients at the desk.
• Closed-hour calls after closing, early morning, on the weekend and on public holidays, when nobody can answer at all.

Keep these apart. They have different fixes. Peak-hour misses are overflow, and they usually mean the desk is busy, not empty. Closed-hour calls are a blackout: there is simply nobody there. To see how many hours a week your clinic is closed, use the blackout calculator.

Calls are only half of it. Many patients in the UAE message first. Open your clinic's WhatsApp Business account and scroll back a week. For each message that arrived after closing, note the time it arrived and the time your team first replied.

Count two things: how many messages arrived while the clinic was closed, and how many waited more than an hour for a first reply. If your clinic also takes enquiries on Instagram or the website chat, do the same there. These are the messages that go cold. A patient who wrote at ten at night and heard nothing until the next morning has often booked somewhere else by then.

Tonight, after closing, call your own clinic from your mobile. Then send a WhatsApp message. Listen and read as a patient would. Is there a message? Does it say when the clinic opens? Does it offer any way to book? Does anyone reply before morning?

This takes five minutes and it is often the most persuasive part of the exercise. Record what you heard in one sentence. It belongs on the first line of any note to your owner.

Do it on a weekday evening and again on a Friday or public holiday if your clinic is closed. Note the date, the time and what happened, in plain words. If the message gives no opening time or no way to book, that is the experience every patient who calls tonight will have. Ask a colleague to try from their phone too, in Arabic if your patients often speak Arabic.

Use one sheet per branch. The gaps are rarely even across branches. Fill it in from the log and the WhatsApp history, one row a day:

Add a note of anything unusual: a public holiday, a campaign that launched, a staff member off sick. One week is a sample, not a year. If you can, repeat it for a second week.

Share the sheet with the person who runs the front desk before you share it with anyone else. They will spot what the log misses, such as calls returned from a personal mobile or a line that was down for an afternoon. Their agreement also makes the number harder to dismiss later.

Now convert the tally into the inputs the ROI calculator asks for:

1. 1Missed calls a day. Add missed, abandoned and closed-hour calls, subtract repeat callers, and divide by seven.
2. 2Share that would have booked. Look at your answered calls. What share of callers book? Use that rate, or a lower one to be cautious.
3. 3Average visit value. Use the value of a first visit, not a full treatment plan, so the model stays modest.
4. 4Opening hours a week. Take them from your schedule.
5. 5No-show rate. Take it from your clinic system for the same period.

The result is the revenue at stake each month. It is a model built on your own sample, and you should label it that way. Its value is that anyone can check every input.

A few habits make the count less reliable. Watch for them before you share the number:

• Counting only opening hours. Many logs default to business hours. Make sure the export includes nights, weekends and holidays.
• Counting one patient several times. A caller who tries three times is one patient. Use the repeat-caller column.
• Mixing branches. A group total hides the branch that misses the most. Keep one sheet per branch.
• Choosing an unusual week. A public holiday or a campaign launch inflates the count. Note it, and repeat the week if you can.
• Forgetting messages. For many clinics the WhatsApp gap is larger than the phone gap.

None of these needs to stop you. A rough count you can explain is far more useful than no count at all.

If the number is small, good. You now know the phone is not where you are losing patients, and you can look elsewhere. If it is large, you have a case. Peak-hour misses point to overflow cover. Closed-hour calls point to after-hours cover. Unanswered messages point to a shared inbox.

The next step is to replace the model with a measurement. Our 7-day After-Hours pilot answers your line from closing to opening, and the ROI audit at the end counts the calls answered and the requests captured on your own number. If you need to take the case upward first, read how to pitch this to your owner.