A low cost per inquiry does not show whether a practice gained appointments it could appropriately serve. Cost per attended appointment can provide a more useful operating view, but only when the costs, appointment cohort and attribution limits are explicit. This original worksheet helps a practice compare acquisition activity with a verified administrative outcome. Attendance is not a measure of clinical benefit or proof that advertising caused the visit.
Choose The Cohort And Observation Window
Start with inquiries first received during a defined campaign period and follow their associated appointment status through a stated cutoff using approved internal reporting. Separate new requests from existing-patient service activity when that distinction matters to the campaign's purpose. Document how duplicates, rescheduling and multiple appointments are handled.
Allow enough time for the relevant appointments to occur before comparing channels. A recent cohort may have many bookings still pending, making its attendance cost look worse than a mature cohort. Report pending appointments separately rather than treating them as failures or estimating them as attended. If only a partial window is available, label the result provisional.
Define The Cost Numerator
State whether the calculation includes media spend only or also agency work, creative, landing-page work and attributable scheduling labor. Either view can be useful if it is clearly labeled and applied consistently. Avoid presenting a media-only figure beside another channel's fully loaded cost without explaining the difference.
If shared costs are allocated, state the allocation method and its limitations. A practice-wide website project should not be charged entirely to one small campaign merely because it launched in the same month. Conversely, excluding a campaign-specific scheduling contractor can understate the resources needed to operate the channel. Use internal finance records and the owner's approved cost boundaries.
Calculate And Interpret A Worked Example
Illustrative calculation: a mature inquiry cohort is associated with 30 attended appointments. Media spending was $3,000, and the practice allocated another $600 of campaign-specific administrative and creative cost. Media cost per attended appointment is $100. The defined broader cost is $120. These invented figures show the arithmetic and do not represent a benchmark, client result or expected return.
Suppose another 10 appointments remain pending. Keep them outside the attended denominator and show them separately. If they later occur, update the cohort with a new observation date. Do not quietly revise old reports without noting the cutoff change. A reader should be able to reproduce the calculation from the displayed counts and cost definition.
Keep Attribution And Causation Separate
Describe how an appointment became associated with the campaign: an approved source field, a voluntary response or another reviewed internal method. Missing information should remain unknown. A person may have encountered several sources, and an attributed appointment may have occurred without the campaign. The metric assigns a reporting relationship; it does not prove incremental demand.
Use privacy-reviewed aggregate outputs for marketing decisions. Do not send patient identifiers, appointment details or sensitive service information to advertising platforms simply to make attribution appear complete. The practice's privacy and security owners should approve the measurement design and any necessary processing before data moves between systems.
Make A Budget Decision With Operational Context
Review the cost alongside suitable appointment capacity, unresolved requests, staff effort and the clarity of the advertised offer. A channel with a higher cost may reach a different appointment category or impose less administrative rework. Those differences need explanation before choosing a winner.
Set the next decision as a bounded adjustment: continue the existing allocation, repair a scheduling problem or test a limited budget change within capacity. Compare future cohorts using the same definitions. Avoid equating appointment attendance with revenue collected, profitability or patient outcomes. Each is a separate question requiring its own evidence and responsible owner.
Common Questions
Can We Calculate This Before All Appointments Occur?
Yes, as a provisional result with a visible cutoff and pending count. Do not compare it directly with a mature cohort without explaining the different observation windows.
Does A Low Cost Per Attended Appointment Prove Profitability?
No. It does not establish collections, service delivery costs, incremental demand or clinical value. Use it as one operating measure within a broader, appropriately reviewed decision.