Dental patient acquisition cost audit

Dental patient acquisition cost is the acquisition expenditure assigned to a defined enquiry cohort divided by the unique new patients in that cohort who attended their first visit by a stated reporting cutoff. To calculate it consistently, reconcile duplicate contacts, separate returning patients, and allocate enquiry-handling costs before dividing. Report the enquiry period, attendance cutoff and included expenses beside the result, so a booking or confirmation never gets counted as an attended visit.

The acquisition cost formula

The acquisition cost formula divides cohort acquisition expenditure by unique new patients with a recorded first attended visit. An enquiry cohort is the group whose original enquiries arrived during a defined period, regardless of when their appointments eventually took place. For this calculation, an acquired patient is someone new to the clinic who has attended, not someone who asked a question, booked, confirmed or accepted a treatment proposal. This definition gives reception and finance the same counting rule.

Keep advertising-only acquisition cost separate from fully loaded acquisition cost. The advertising-only version uses attributable advertising charges as its numerator. The fully loaded version also includes campaign production, external marketing fees and allocated acquisition-related reception or enquiry-handling costs. Both can be useful, but they answer different spending questions. Comparing one source's advertising-only figure with another source's fully loaded figure would compare different cost boundaries rather than source performance.

Use the clinic's expense records and attendance records instead of substituting an unsupported industry average. A practice handling enquiries from several countries may have different staffing arrangements, source attribution rules and booking intervals from another practice. Those differences need to be visible in its own calculation. Add a short calculation note to each report stating the cost definition, cohort dates, attendance cutoff and record owner. That note makes the result reproducible when someone reviews it later.

The cost boundary

The cost boundary is the written rule that determines which expenses belong in the acquisition numerator and how shared expenses are allocated. Start with the underlying advertising charges, production invoices and external marketing fees attributable to the cohort. Where an invoice covers several sources or periods, document the allocation basis rather than placing the whole charge against whichever campaign is under review. Use the same rule across the sources being compared.

• Expense reference: the invoice, payroll entry or subscription charge supporting the amount.
• Work category: advertising, production, external marketing, acquisition reception or enquiry handling.
• Allocation basis: directly attributable spending, recorded staff time or a documented activity-based share.
• Assigned cohort and source: the reporting group receiving the expense.
• Excluded share: the portion covering existing-patient reactivation, routine administration or other work.
• Reconciliation owner: the person responsible for matching allocated amounts to the underlying expense.

Allocate reception time using recorded acquisition activity where possible. For example, time spent responding to new enquiries and arranging first appointments belongs in a different work category from rescheduling existing patients. If an enquiry-handling subscription covers both acquisition and reactivation, use a documented activity rule to split the expense. Reconcile the allocated portions back to the original charge. Do not count the same staff cost once as reception payroll and again inside a general administrative allocation.

Keep treatment delivery costs outside the acquisition-cost numerator, but include them when assessing what the clinic can afford. Acquisition cost alone does not establish profitability. Review collected revenue attributable to the acquired group, the costs of delivering those services and the clinic's overhead commitments separately. Avoid setting an acquisition target from appointment value alone, particularly where revenue has not yet been collected or the related service costs have not been recorded.

The patient count

The patient count includes each unique new patient once, at their first recorded attended visit. Repeated calls, messages and appointment changes must link to one acquisition record rather than create additional patients. Use an enquiry identifier linked to a consistent patient identifier, with controlled access appropriate to the clinic's workflow. Keep the original enquiry date even when a later contact leads to the booking, otherwise the patient can drift into a different reporting cohort.

• Original enquiry: identifier, date, recorded source and contact language.
• Identity link: the consistent patient identifier and any duplicate enquiry identifiers merged into the record.
• Booking: first booking date and the appointment reference.
• Confirmation: the recorded reply or confirmation event, separate from attendance.
• Appointment changes: cancellations and reschedules, preserving their dates and event history.
• Attendance: the first recorded attended-visit date.
• Patient status: new patient, existing patient or unresolved pending a staff check.

A fictional administrative example shows the reconciliation rule: enquiry ENQ-ALPHA arrives by phone, and ENQ-BETA later arrives by message from the same person. Once staff verify the identity link, retain both communication histories under one acquisition record. If the first appointment is cancelled and a replacement is attended later, count one acquired patient on the later attendance date. Do not delete the cancelled appointment, because its history explains the sequence.

Exclude existing patients returning through reactivation from the new-patient denominator. Their communication and booking activity can be reported separately, with its own expenses. Preserve unknown-source records as unknown until evidence supports a source assignment; moving them into a convenient campaign changes the comparison without resolving attribution. Where identity or attendance is unresolved, assign a staff owner to check the record rather than letting an automated enquiry workflow decide the reporting status.

The reporting cutoff

The reporting cutoff is the date through which attendance is counted for a defined enquiry cohort. Cohort reporting keeps acquisition expenditure linked to the enquiries it funded while allowing their first visits to happen later. By contrast, dividing this month's spending by this month's first visits can mix newly generated enquiries with patients whose original enquiries arrived in earlier spending periods. A calendar-period report can describe current activity, but it should not be presented as the same calculation.

Choose the enquiry period and attendance cutoff before comparing sources. Mark a cohort as provisional while booked or unresolved first visits remain open, and retain dated snapshots rather than overwriting the previous report. When the acquired-patient count changes, record whether the change came from late attendance, a duplicate merge, a corrected attendance record or a source correction. Late attendance adds an event after the earlier cutoff; a correction changes the quality of the underlying record. The distinction matters when interpreting the movement in cost.

Worksheet layout

Use the following worksheet layout as an editable reporting template. Each row represents one source within one enquiry cohort at one reporting cutoff, not an individual patient. Populate it from reconciled records and label the expenditure basis in the worksheet title, such as advertising-only or fully loaded. Keep the patient-level reconciliation in a separate, appropriately controlled working file so the reporting sheet does not need contact or clinical information.

• A: cohort start date; B: cohort end date; C: attendance reporting cutoff.
• D: recorded acquisition source, including an explicit unknown category.
• E: acquisition expenditure under the stated cost boundary.
• F: unique new-patient enquiries received during the cohort period.
• G: unique new patients with a first booking recorded by the cutoff.
• H: unique new patients with a first attended visit recorded by the cutoff.
• I: acquisition cost; J: provisional or reconciled status; K: reconciliation note and owner.

Spreadsheet formula for cell I2: =IF(H2=0,"Undefined",E2/H2)

Copy the formula down the reporting rows. Before using it, check that column E contains numeric expenditure and column H contains the reconciled attended-patient count. A zero-attendance cohort can still have spending, enquiries and bookings, so preserve those fields rather than replacing the entire row with zero.

Source comparisons

Source comparisons require the same cost boundary, enquiry period and attendance cutoff before differences can be interpreted. Compare the sequence from unique enquiry to first booking to first attendance, rather than asking one acquisition-cost figure to explain every stage. The following measures use the same cohort expenditure so their denominators, rather than inconsistent expense definitions, explain what each calculation measures.

Before changing a budget, inspect source attribution, duplicate records, pending appointments and shared expense allocations. A lower reported cost after removing duplicates or correcting an invoice allocation is a measurement correction, not evidence that the enquiry process changed. If you also report enquiry-to-first-booking conversion, name it precisely: unique new patients in the enquiry cohort with a first booking by the cutoff divided by unique new-patient enquiries in that cohort. State the cohort dates and cutoff beside that ratio, and report attendance separately.

Segment by recorded contact language when it helps investigate operational coverage, but do not treat a language field as evidence of comprehension or attendance. Delta Fuji handles enquiry calls, WhatsApp follow-up and confirmations in the patient's language; record which steps were provided, what replies arrived and which questions required a staff handover. Keep enquiry screening administrative, covering the requested service, contact preferences and appointment availability, with clinical suitability referred to a clinician. For the next reporting snapshot, assign reception to reconcile events, finance to reconcile expenses and a named reporting owner to document unresolved records before publishing the comparison.

Common questions

What should a dental clinic include in patient acquisition cost? For a fully loaded calculation, include attributable advertising charges, campaign production, external marketing fees and the allocated acquisition share of reception and enquiry-handling expenses. Document how shared costs are allocated and reconcile them to invoices and payroll records. Keep treatment delivery, existing-patient reactivation and unrelated administration outside this numerator. Label an advertising-only calculation separately.

Should acquisition cost count booked appointments or attended first visits? Dental patient acquisition cost uses unique new patients with a recorded first attended visit. Bookings belong in a separate cost-per-first-booking measure. A confirmation records a reply or event, not attendance, and a rescheduled appointment does not create another acquired patient.

How should a clinic count a first visit attended after the reporting month? Keep the patient in the cohort defined by their original enquiry date. Count the attended visit in a later snapshot of that same cohort once the attendance cutoff includes it. Preserve the earlier snapshot and label the change as late attendance rather than silently moving the patient into a newer cohort.

How should returning patients and duplicate enquiries be treated? Report returning patients under reactivation or existing-patient activity, not new-patient acquisition. Link verified duplicate enquiries to one patient acquisition record while preserving each call, message and appointment event. Leave uncertain identity matches unresolved until a staff check establishes the correct link.

How can a clinic assess its acquisition cost without an industry benchmark? Compare its own reconciled cohorts using consistent cost definitions and attendance cutoffs. Review the underlying enquiry, booking and attendance counts before interpreting differences. Assess affordability separately using collected revenue, service delivery costs and overhead commitments; acquisition cost by itself does not establish profit or justify a budget change.