When cosmetic dental treatment decisions happen weeks after the first inquiry, evaluate marketing through first-party inquiry cohorts rather than comparing this month's advertising spend with this month's acceptances. The two totals may describe different groups of people.
Group inquiries by when they began, follow the practice's defined administrative stages and allow enough time to observe the decision. Keep the attribution rule explicit. A source attached to an inquiry is evidence of the recorded route, not proof that one channel caused the whole decision.
This is an owner-facing reporting framework, not a promise of return or a clinical treatment recommendation. Identifiable inquiry and treatment information belongs in approved practice systems, not in an external advertising dashboard by default.
Why the calendar-month comparison can mislead
Imagine advertising receives inquiries in January, consultations occur in February and some people make a decision in March. March's accepted cases cannot all be assigned to March's spend just because acceptance happened then.
The reverse error occurs when January's marketing is called unsuccessful before the January inquiries have had time to progress. Some remain unresolved, some are awaiting an agreed follow-up and others have made a clear decision not to proceed. Those are different outcomes.
A calendar-month operational report can still be useful for staffing and cash flow. It simply answers a different question from an acquisition cohort report. Label each report so the owner does not interpret monthly activity as the final performance of that month's inquiries.
Define stages the team can apply consistently
Separate a new inquiry, a booked consultation, an attended consultation, a documented treatment decision and a later operational milestone. Confirm which system holds each authoritative status. Do not use "conversion" for all of them without explaining the stage.
Have the responsible dental and operations teams define what counts as acceptance. A verbal expression of interest, an approved plan, a financial commitment and treatment delivered are not interchangeable. Marketing should not decide the clinical or contractual meaning of the stage.
Record unsuccessful contact, cancellation, unsuitable requests and undecided cases under agreed definitions. Keep clinical reasons within authorized systems. An owner-facing marketing report can use permitted aggregated categories without copying sensitive explanations.
Our guide to medical practice marketing ROI explains why stage definitions should precede calculations. A more detailed spreadsheet cannot rescue inconsistent inputs.
Build cohorts from the original inquiry date
Choose a cohort period suitable for your volume, such as an inquiry month. Record the cohort start, inquiry count and the dates of relevant administrative milestones in the approved first-party system. Keep one definition of a unique inquiry.
Do not count the same person again because they call after submitting a form. Preserve multiple contact events while reconciling duplicates under an approved process. A shared phone number alone may not prove identity, so uncertain matches need review rather than automatic merging.
Keep pre-existing relationships separate when they are not part of the acquisition question. A current patient asking about a new cosmetic service may need a different category from a first-time prospective patient. The report should explain which group it measures.
Use an observation window, not an invented industry benchmark
Choose the review window from the practice's actual decision pattern and reporting needs. Do not assume every case is complete after thirty days because a dashboard defaults to monthly reporting. A longer window can be appropriate, but it still leaves unresolved inquiries that need to be labeled.
Compare cohorts at a similar age. A recent cohort observed for one week is not directly comparable with an older one observed for several months. Show the age and the unresolved count beside the result.
When staff change the follow-up process or the practice changes service availability, record the date. A cohort exposed to a different process is not a clean test of advertising alone. Treat those changes as context rather than hiding them inside a channel average.
Work through a clearly hypothetical cohort
Suppose a fictional practice records 120 unique new inquiries in one cohort. At the chosen review date, 36 attended a consultation and 12 reached the practice's defined acceptance stage. Attendance divided by original inquiries is 30%; acceptance divided by attended consultations is about 33.3%.
Those rates use different denominators and answer different questions. They are not dental industry benchmarks. The example also does not establish profitability, because it contains no verified contribution, costs, treatment delivery or causal evidence.
If 20 inquiries remain unresolved, show them as unresolved rather than assuming they will never progress or treating them as accepted. If some acceptance decisions occur after the review date, a later cohort update can record them while preserving the earlier snapshot.
The owner can then ask which administrative step needs investigation. Perhaps consultations are not being attended, or perhaps a recent cohort simply has not matured. That is a more useful discussion than declaring the campaign unsuccessful from a mismatch of calendar totals.
Keep the attribution rule modest and visible
Define whether the report uses first recorded source, a permitted last-touch rule or another documented first-party approach. Keep the recorded source and any later contacts separate where appropriate. Do not change the rule halfway through a comparison without explaining the change.
Search, referrals, existing relationships and later research may all contribute to a person's decision. An inquiry source field cannot capture every influence. Present it as recorded attribution, not a claim of exclusive causation.
Google's Ads conversion-window documentation explains a platform reporting concept. It does not authorize sending individual treatment acceptance or patient information to Google. Platform data boundaries and the practice's legal obligations require a separate review.
Copy this inquiry cohort report
- Cohort period and original unique-inquiry definition.
- Inclusion and exclusion rules, including existing relationships.
- Observation date and cohort age.
- Recorded source rule and unknown-source count.
- Booked and attended consultation counts.
- Defined decision-stage count and unresolved count.
- Rates with explicit denominators.
- Changes in staffing, offer, availability or follow-up.
- Data owner and reconciliation exceptions.
- Next investigation, responsible person and review date.
Include only information approved for the audience. If a report could identify individuals through small groups or detailed combinations, obtain the appropriate privacy review before sharing it outside the authorized team. Hashing a name or address does not automatically make a record safe to send elsewhere.
Reconcile the receiving systems before interpreting trends
If the fictional cohort also had $2,400 of relevant acquisition spend, cost per original inquiry would be $20, cost per attended consultation about $66.67 and cost per defined acceptance $200. Each calculation still describes the chosen cohort and rule, not a guaranteed return. It would be misleading to multiply accepted cases by a headline procedure price and call the result realized revenue.
Write the spend boundary beside the calculation. Include which channels, vendor fees or other acquisition costs are covered, and avoid charging the same cost to two cohorts. If the allocation is uncertain, report that limitation. The owner can then compare a consistent model with other periods instead of treating a precise-looking number as stronger evidence than the underlying records support.
Ask the coordinator to check a small approved sample internally: original inquiry, appointment status and decision record should refer to the same journey. Missing updates can look like weak marketing when the real issue is an integration or ownership failure.
Document exceptions such as duplicate records, imported appointments or a changed definition. Correct the process and preserve the explanation so future reports remain interpretable. Do not silently rewrite historical results to make the new dashboard look consistent.
Use the cohort report alongside reception capacity and accurate service information. Our cosmetic dental inquiry diagnostic covers earlier handoffs. Long-window reporting should make those handoffs more visible, not conceal them behind a sophisticated attribution label.
Give the decision enough time to mature before judging the channel.