Define the process before choosing another tool
A customer relationship management system can organise enquiry work, but installing one does not prove that enquiries are captured, followed up or linked to appointments. Map the channels the clinic actually uses and decide where each enquiry should arrive.
For each channel, identify the responsible team, response process, next-action record and authoritative appointment system. A website form, phone conversation and social message may need different handling, even when the reporting definitions are shared.
This guide describes a reporting method and an illustrative calculation. A dashboard is dependable only when its figures can be reconciled with authorised source records. Check the actual configuration and booking links for the clinic before using it to make decisions.
If the gap occurs before an enquiry reaches the clinic, use the website conversion audit to check the page and its next-step route.
Give each stage a clear meaning
Agree a short data dictionary with the people who will use the system. A workable starting point is:
- New enquiry: a genuine request received through an agreed channel, with its received time and an internal identifier.
- Response recorded: a meaningful reply or contact attempt has been logged. Distinguish an automated acknowledgement from a human response.
- Awaiting next action: the record names the owner and the next agreed step, including when it should be reviewed.
- Consultation booked: a confirmed appointment exists in the authoritative booking system and is linked to the enquiry. An invitation or proposed time is not enough.
- Closed without booking: the outcome and an appropriate reason are recorded. Keep unknown or unresolved outcomes visible instead of silently dropping them.
Attendance, cancellation and later treatment are separate events. Preserve the history of a rescheduled appointment so that changing its date does not create a second conversion.
Reception staff can record a request and arrange the next step. Clinical suitability and treatment decisions remain with the appropriately qualified team; a marketing score should not substitute for that assessment.
Use a fixed enquiry cohort for the booking rate
For an enquiry-to-booking rate, start with enquiries received during a stated period. Then count how many of those same enquiries have a verified first consultation booking by a stated reporting cut-off. Do not divide all appointments booked this month by all enquiries received this month if they concern different people or periods.
Write the definition before opening the report: receiving period and timezone; unit of counting; eligible channels; duplicate rule; test and spam exclusions; booking evidence; reporting cut-off; and cancellation treatment.
A useful metric is: eligible enquiries with at least one verified consultation booking by the cut-off, divided by eligible enquiries in the receiving cohort, multiplied by 100. Count each enquiry once in this rate, even if it has several appointments.
If you report “ever booked by the cut-off”, retain a later cancellation in that historical numerator and show cancellations separately. If you instead report “currently booked at the cut-off”, label that different definition clearly. Do not switch definitions between periods.
Recent cohorts may still be developing. Show their age and unresolved count, and compare periods with a similar follow-up window. An enquiry without linked booking evidence is not a verified booking.
Worked example: ten eligible enquiries, three verified bookings
Illustrative numbers only. These are invented to demonstrate the calculation and are not ClinicGrower or client performance data.
Suppose a defined week contains 12 received records: one internal test, one duplicate of an existing enquiry and ten eligible enquiries after those exclusions. By the stated reporting cut-off, three of the ten have a linked confirmed consultation booking.
The enquiry-to-booking rate is 3 divided by 10, multiplied by 100: 30%. The two excluded records remain in the reconciliation log with their reasons. They are not counted in the rate.
If one of the three bookings is later cancelled, an “ever booked” rate remains 30%, with one cancellation reported separately. A “currently booked” measure would be 2 out of 10, or 20%, at that later cut-off. Neither figure establishes attendance or revenue.
If a fourth enquiry has an unconfirmed note saying “probably booked”, keep it unresolved until the appointment evidence is checked. Do not raise the numerator to make the report look complete.
Keep acquisition evidence separate from assumptions
Record the source when reliable evidence is available, such as an agreed campaign tag or a referring website. Keep the evidence type and the landing page where appropriate. Direct or missing attribution should remain unknown rather than being reassigned to the channel someone prefers.
A click from an AI service can be recorded as a referral when the source evidence is present. It does not prove that every person who saw an AI answer visited the website. A Google organic visit does not by itself identify an AI Overview or voice interaction.
Report platform conversions, website enquiries, CRM records and confirmed bookings as different measures, then reconcile the links that actually exist. A tracking event firing is not proof that the clinic received a genuine enquiry.
For a wider view of ownership and measurement, see ClinicGrower Performance OS. Confirm the agreed scope and working integrations for the individual clinic before expecting a particular report.
Keep the working queue useful and protect patient information
Give each open record an owner and next action. Agree what happens when the owner is unavailable, when a person does not reply and when they ask not to be contacted. Review overdue work without turning the queue into repeated automated messages.
An enquiry is not blanket permission for promotional email or SMS. Check the purpose and applicable permission before enabling a sequence, and keep requests to stop contact effective. The ICO’s electronic-mail marketing guidance explains the consent and exception requirements.
Keep marketing reports to the information needed for their purpose. Use internal identifiers and aggregate counts where possible; avoid copying clinical notes, sensitive free-text messages or patient contact details into general marketing documents. The ICO’s data-minimisation guidance explains this principle.
Ask the clinic’s responsible privacy lead to confirm access, retention and the handling of sensitive information for its systems. A reporting template alone does not establish that the full process is compliant.
Verify a small sample before relying on the dashboard
Check a small authorised sample against the source enquiry, owner, stage history and linked appointment. Confirm that exclusions are explained and that repeated imports or reschedules do not inflate counts. Use existing records where appropriate; do not create patient-facing test messages or bookings without an agreed test.
Record the report version, extraction time, period, cut-off, numerator, denominator and unresolved cases. If access or booking linkage is missing, label the report incomplete and name the missing evidence.
Review the first documented failure, fix it within the agreed scope and repeat the relevant check. A Clinic Growth Audit can help identify which part of acquisition, enquiry handling or measurement needs attention first.
Use sheet 3 of the marketing working sheets (editable PDF) to record the cohort, counting rules, booking definition and aggregate calculation. Keep patient details out of the worksheet.
Before you choose
Your questions, answered.
How do you calculate enquiry-to-booking conversion?
Count eligible enquiries from a defined receiving period that have a verified consultation booking by a stated cut-off. Divide that count by all eligible enquiries in the same cohort and multiply by 100. Document duplicate, test, cancellation and unresolved-record rules.
Does a CRM lead marked won prove that a consultation was booked?
Only if the stage has an agreed meaning and is supported by the authoritative appointment record. A manual label, tracking event or proposed appointment time alone is not sufficient booking evidence.
Does a booking rate prove the return on marketing spend?
No. It measures the proportion of an enquiry cohort that booked under the stated definition. Attendance, treatment, collected revenue and costs need their own verified records. The worked example in this guide is illustrative and is not a client result.