Dental marketing ROI from inquiries to collected revenue

Dental marketing ROI compares contribution from acquired-patient cohorts with the marketing expense used to acquire them. Start with collected revenue after refunds, subtract agreed care-delivery costs and campaign costs, then divide the remaining amount by campaign cost.

Keep the appointment funnel beside the financial result. An inquiry, a booked visit, an attended visit and accepted treatment are different events, and none by itself establishes collected revenue.

Define the patient cohort and observation window

For this workflow, acquisition occurs at a new patient's first attended visit. Earlier inquiries remain assigned to their campaign so the report can explain the path to that visit. Returning patients and reactivation campaigns belong in separately labeled cohorts.

Use a fixed observation window from first attendance for collections and care-delivery costs. In the example, each acquired patient has a 90-day follow-up period. Compare campaigns only after that same window has closed for every included patient.

Agree on campaign credit before reviewing revenue. Here, each inquiry and eventual acquired patient belongs to the first recorded acquisition campaign. Retain unattributed inquiries as a visible category rather than allocating them to whichever channel looks strongest.

The analysis can use de-identified campaign, appointment and billing summaries. Counts, cohort labels, dates and financial totals are enough for this comparison; clinical records and treatment details are outside its scope.

Separate collections from treatment activity

The American Dental Association distinguishes production, adjusted production and collections, defining collections as money actually collected by the practice. That distinction matters when marketing reports use the value of accepted treatment as if it were cash received.

Keep acceptance as a stage count. Track receipts from the acquired cohort separately, including payments received from patients and payers during the observation window. Subtract refunds and use the same cutoff for every campaign. Exclude payments from older cohorts even when they arrive during the campaign month.

For contribution, use the care-delivery cost scope approved by finance. This example includes the agreed labor, supplies and laboratory costs for care delivered to the cohort during the window. It does not allocate every practice overhead expense, so the result is a contribution-based marketing return rather than net practice profit.

The general distinction between margin-based return and revenue-only advertising measures is covered in marketing ROI versus ROAS.

Build the funnel from aggregate summaries

A fictional US dental group compares a search campaign with a local event. Each count represents unique inquiries or people, rather than repeated calls, appointments or treatment items. Accepted treatment is a subset of attended new patients in this example.

Place these columns in A:E on a sheet named Funnel. On rows 2:3, calculate booking, attendance and acceptance rates:

F2 =IF(B2=0,"",C2/B2)
G2 =IF(C2=0,"",D2/C2)
H2 =IF(D2=0,"",E2/D2)

Search and the local event both book 60.0% of inquiries. Search attendance is 90 divided by 120, or 75.0%; local-event attendance is 40 divided by 60, or 66.7%. Acceptance is 50.0% of attended patients for both campaigns.

These rates locate operational differences without substituting appointment activity for money. Customer acquisition cost gives the broader denominator framework; here the acquired-patient count is the first-attendance count.

Match collections and costs to those cohorts

Finance provides the following totals for the same acquired patients and observation windows. Agency and creative costs are campaign-specific; no cost appears in both marketing and care delivery.

Put these columns in A:F on a sheet named Finance. Calculate net collections in G, marketing cost in H, contribution before marketing in I, contribution after marketing in J, ROI in K and acquisition cost in L:

G2 =B2-C2
H2 =E2+F2
I2 =G2-D2
J2 =I2-H2
K2 =IF(H2=0,"",J2/H2)
L2 =IF(Funnel!D2=0,"",H2/Funnel!D2)

The last formula assumes the same campaign order on both sheets; verify the labels before copying. If the input summary has multiple rows per campaign and cohort, Microsoft's SUMIFS function adds values matching the required criteria. Aggregate each source before combining it so campaign expense is not repeated for every receipt. Covirage is not affiliated with Microsoft.

Percentages are rounded to one decimal and currency ratios to two decimals. Retain unrounded figures in the calculations. The combined ROI is $24,000 divided by $14,000, or 171.4%; it is not the simple average of campaign percentages.

Reconcile before reallocating spend

The financial identity must hold: $75,000 of net collections equals $37,000 of care-delivery costs, plus $14,000 of marketing costs, plus $24,000 of contribution after marketing. Net collections also equal $78,000 of gross receipts less $3,000 of refunds.

Tie receipt and refund totals to the included billing-summary rows and care costs to the approved finance allocation. Tie marketing costs to campaign invoices or expense lines. Reconcile the 130 acquired patients to the aggregate first-attendance report, keeping repeat visits out of that count.

The local event has a higher observed return, but search produces more contribution dollars. A budget review should consider both measures and whether event volume can be repeated. Use marketing ROI tracking to manage later collection updates, and improving marketing ROI for the broader reallocation workflow.

Where it goes wrong

• Calling bookings acquisitions. Missed and canceled appointments inflate the denominator without an attended new patient.
• Treating accepted treatment as collected revenue. Keep acceptance, delivered care and actual collections separate.
• Giving cohorts different collection time. Recent patients have had less time to generate receipts; compare equal observation windows.
• Omitting campaign service costs or repeating them. Include the agreed full campaign scope once, with a visible reconciliation.
• Claiming incremental lift from matching alone. Campaign credit identifies an observed cohort; it does not establish what would have happened without marketing.

Compare your dental campaign summaries in Covirage

Bring de-identified campaign, first-attendance and billing summaries with matching cohort labels and an agreed care-cost scope. Covirage maps the columns, and its tools compute and check contribution and acquisition comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.

See Covirage for healthcare businesses for the supporting business context.