How to Measure Clinic Appointment Sources
To review clinic appointment sources, start with counts from systems your clinic has approved. Compare inquiries, booked appointments and attended appointments by broad source. Keep the reporting rules clear so the same visit is not counted twice.
This is a planning worksheet, not an approval to connect patient records to a marketing tool. Have the clinic’s privacy and security lead review the data flow, access and vendors before collecting or exporting information.
Set the reporting boundary first
Decide who needs the report and what decision it will support. A monthly budget discussion may need broad totals, not patient records. Keep operational records in the clinic’s approved systems and give marketing staff only the information they are authorized to receive.
Removing names does not by itself make health data de-identified. Dates, small groups, free text and other details can still identify someone. HHS describes specific methods for de-identifying protected health information. Ask the responsible privacy professional to determine what may be shared; a spreadsheet template cannot establish compliance.
Define the same source labels for everyone
Choose a short list that your team can use consistently. Possible labels include paid search, organic search, referral, offline promotion and unknown. Treat these as a proposed reporting scheme for review, not instructions to install tracking.
Keep an unknown category. A patient may not remember the source, and a staff member should not guess. If your approved workflow includes an optional source question, use a short answer list instead of open notes about the patient’s health or visit.
Campaign parameters can describe an approved campaign link. They do not reveal every organic search query or prove which earlier contact caused a booking. Never put patient details into URLs or campaign names.
Define each count before comparing channels
Write down what your team means by an inquiry. Decide how repeat contacts are handled. Then define a booked appointment and an attended appointment using the clinic’s existing records.
Choose a reporting period and explain how reschedules, cancellations and bookings made in an earlier period are counted. For a source comparison, follow one inquiry group long enough to observe its bookings. Do not divide unrelated monthly totals and call the result a conversion rate.
Build the report from approved totals
Use these columns in an internal report after the reporting design has been approved:
| Period | Source | Inquiries | Booked | Attended | Ad spend |
|---|---|---|---|---|---|
| Fill in | Approved category | Count | Count | Count | Recorded spend |
Use a broad enough period and source grouping for the intended audience. The privacy lead should decide whether small counts need to be combined or suppressed. Do not export patient-level rows to make this report easier to build.
Calculate the rates consistently
- Booking rate = booked appointments divided by inquiries, multiplied by 100 for a percentage.
- Attendance rate = attended appointments divided by booked appointments, multiplied by 100 for a percentage.
- Advertising cost per booking = recorded ad spend divided by bookings attributed under your stated method.
If the denominator is zero, report the measure as unavailable. If a source is unknown, keep that uncertainty visible. Advertising cost excludes staff time and other marketing costs unless you explicitly include them.
Use the report to ask better questions
A source with many inquiries and few bookings may need a closer look at the information on the page, appointment availability or the response process. A change in counts alone does not establish the cause.
Before changing spend, check that the periods, definitions and source rules are comparable. Separate new appointment bookings from attended visits. Neither count, on its own, proves revenue or patient benefit.
Review the workflow before adding tools
Do not install advertising pixels, session replay, call tracking or scheduling exports based on this worksheet. Each proposed integration needs its own review of what it collects, where it sends data and who can access it. A product’s price or a missing name field does not establish that it is suitable.
Keep a written record of approved fields and recipients. Revisit it when a form, vendor or reporting purpose changes. For general planning, use our monthly review worksheet and marketing budget planner. These resources do not replace the clinic’s privacy, security or legal review.