Track Ad ROI Without Online Booking: A Simple Enquiry Tracker
A clinic offering premium health assessments took bookings by phone and email, not through an online system. That made it hard to see which ads produced patients. Google could count clicks and form submissions, but it could not see who booked after a phone call. The owner wanted to know how to track ad ROI without buying new software.
The answer was surprisingly simple: a well-kept enquiry tracker. Here is how any clinic can do it.
Why you cannot always track ad ROI from online data alone
When patients book by phone, email or in person, the ad platform cannot see the end result. It may count a click or a form, but not whether that person became a patient. Without a link between the enquiry and the outcome, you cannot tell which ads pay their way.
What a simple tracker does
An enquiry tracker is a shared spreadsheet, or a simple database, where staff record each enquiry: date, source, service, what happened next and the value. Filled in consistently, it links marketing to patients. It costs almost nothing, and it can reveal far more than a dashboard alone.
Choose the columns that matter
Start with date, name or reference, how they found you, the service they asked about, the outcome (booked, attended, lost) and the fee. Add a notes column for reasons. Keep it to what staff can complete in a minute. A simple tracker that is used beats a perfect one that is ignored.
Ask every caller how they found you
Train the team to ask a friendly question at the start or end of each call: how did you hear about us? Give a short list of options and leave room for free text. Consistency matters more than perfection, and answers build up into a useful picture.
Track ad source more precisely
Use different phone numbers or web addresses for different campaigns, where you can. Tracked numbers show which ads bring calls. Add a source field to forms. These details give you firmer evidence than memory, and reduce reliance on what callers remember.
Record the outcome, not just the enquiry
An enquiry is only the beginning. Note whether it became a booking, whether the person attended and what they paid. Outcomes turn the tracker into a picture of return on investment. Without them, you only know how busy the phones were.
Match the tracker to your ad data
Each month, compare the tracker with your ad reports. How many enquiries did ads claim, and how many appear in the tracker? Where do they differ? This shows how much your ad account under- or over-counts, and helps you understand its numbers.
Calculate cost per booked patient
Divide monthly ad spend by the number of booked patients from paid sources. Compare it with what a patient is worth. If it is higher, look for ways to improve, or reconsider the channel. This one figure often tells you more than any click-based measure.
Feed offline results back to Google Ads
Where possible, upload offline conversions, such as booked patients, so that Google learns which clicks led to real results. This needs consent and careful data handling, and a developer or agency can help. It lets the system optimise for patients, not just enquiries.
Protect personal data
A tracker holds personal information. Keep it in a secure, access-controlled place, share it only with those who need it and follow data protection rules. Use references instead of full names where possible. Careless handling of a spreadsheet can become a serious problem.
Review the numbers with your team
Hold a short monthly meeting: what did we learn, which sources are best, what needs to change? Include reception, who hear what patients say. A shared review keeps the tracker alive, and turns data into action.
Upgrade when you need to
A spreadsheet works well at small scale. If volumes grow, consider a simple customer relationship tool that connects to your phone and forms. Upgrade because the volume demands it, not because a tool sounds impressive. Keep the habits that made the spreadsheet work.
Check for double counting
Patients may enquire more than once, through a form, then a call. Give each person one record, and note each contact against it. Otherwise your tracker will overcount enquiries and undercount outcomes, making your ads look either better or worse than they are.
Use the tracker to plan capacity
Once you know how many enquiries become patients, and how many staff hours they take, you can plan capacity and budget more accurately. The tracker then becomes a planning tool as well as a measure of advertising, and helps you grow at a pace the clinic can sustain.
Include referrers and word of mouth
Not all patients come through adverts. Add options for referrals, recommendations and returning patients, so the tracker shows the whole picture. Knowing what share comes from each source helps you judge advertising fairly, and protects the channels that quietly bring your best patients.
A quick checklist
- Set up a simple shared enquiry tracker.
- Ask every caller how they found you.
- Record outcomes and fees.
- Compare the tracker with ad reports monthly.
- Work out cost per booked patient.
- Keep personal data secure.
Our companion article on clinic imagery covers how a brand appears to patients, and our guide to Google Ads attribution explains how to see where bookings come from. If you would like help, we are glad at Pulse Digital Health to talk.
Frequently asked questions
Can I track ad ROI without an online booking system?
Yes. A simple enquiry tracker, kept consistently, links each enquiry to its source and outcome. Combined with asking callers how they found you and using tracked phone numbers, it shows which ads bring booked patients. Keep the tracker simple enough that staff use it every day.
What should I record in an enquiry tracker?
Date, a reference for the person, how they found you, the service, the outcome (booked, attended, lost) and the fee. Add a notes column for reasons. Keep it short enough that staff will complete it every time. Ask the question warmly, as part of the conversation, not as an interrogation.
How do I know which ad brought a phone call?
Use different tracked phone numbers or web addresses for different campaigns, where possible, and ask callers how they heard about you. Together these give firmer evidence than memory. A different number for each main campaign quickly shows what brings calls.
What is cost per booked patient?
Your ad spend divided by the number of booked patients from paid sources. Compare it with what a patient is worth to your clinic. It often tells you more than clicks or enquiries. Divide spend by booked patients monthly and compare with what a patient is worth.
Is a spreadsheet safe for patient data?
Only if kept secure: use access controls, share only with those who need it, follow data protection rules and use references instead of full names where possible. Restrict access to those who need it, and review who has access regularly.
When should I move beyond a spreadsheet?
When volumes grow enough that it becomes hard to maintain. Choose a simple customer relationship tool that connects to your phone and forms, and keep the good habits you built. Upgrade only when the spreadsheet becomes hard to keep accurate.
