“Open Dental already records the referral source.”
It does, and it rarely gets read against revenue. That reading is what this produces.
For Open Dental
Export collections from Open Dental, bring the referral source and your other lead files with them, and rank every source on what it collected.
CloseRev reads an Open Dental export of collected payments — the patient's phone or email, the amount and the date — and matches it against the calls, ads and referrals that produced the first appointment. The practice's own database already records a referral source for many patients, and reading it against collected revenue is often the first time that field has been used for anything. Collections with no traceable lead are reported as Direct / Unknown.
Page updated September 25, 2026.
The gap
Front desk staff ask every new patient how they heard about the practice. The answers sit in a field no report has ever read.
What was sold, to whom, and for how much.
The click, the keyword, the call, and what each one cost.
The file
Three things carry the match: who, how much, and when. Anything else is optional and only changes how the report can be sliced.
On the patient record. The mobile number is often the most reliable key.
Payments received from the patient and the insurer together. Production is a forecast of this, not the same thing.
When money arrived. Payments follow a patient for years, and every one credits the lead that produced the first visit.
The recorded referral goes in the lead file as a source, dated by the first visit and named by who sent the patient — the referring practice (“Referral — Smith Family Dental”) or the channel (“Patient referral”), never the treatment the patient was referred for. The clinic is mapped as Location. Both are what make the report actionable.
Step by step
Written for somebody with Open Dental open in the next tab. Report names vary by edition, so each step says what to look for.
One row per payment with a contact detail, the amount and the date.
If your practice records who referred each patient, export it as lead rows — the patient's contact detail, the referring practice or channel as the source, the first visit as the date. It becomes one source among several rather than the only one.
Call tracking, online booking, paid search and anything else that captures a contact before the first visit.
Treatment plans take months to complete, and the second year of a patient is where recall revenue lives.
The join runs on the phone and the email, normalized, with the recorded referral competing on the same rule as every other source: the earliest lead takes the credit.
What comes back
Revenue by channel, the count of sales behind each figure, and an honest bucket for the ones nobody could trace. Sample figures, from the worked example on the Dentists page — not from a Open Dental account.
| Channel | Share | Sales | Revenue |
|---|---|---|---|
| Google Ads | 38 | $124,800 | |
| Meta Ads | 31 | $54,800 | |
| Email marketing | 14 | $27,400 | |
| Direct / Unknown | 46 | $97,400 |
Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.
The argument
Many practices ask new patients how they heard about the practice and record the answer. Over years, that field fills with thousands of responses.
It is self-reported, so it has the usual weaknesses: patients misremember, front desks pick the first option on a list, and the most recent thing a patient saw is not always what brought them.
Read against collected revenue, it is still one of the most useful fields a practice has, because it is the only record of the channels no tracking can see — the neighbor, the school newsletter, the other patient.
Keep it as its own labeled source beside any tracked ones rather than merging them; where a patient appears in both, the earliest lead takes the credit, and comparing the two lists is where the questions worth asking come from.
One referral answer may turn out to carry a far larger share of collections than anybody had assumed.
For endodontists, orthodontists, oral surgeons and periodontists, a large share of new patients arrives because a general dentist sent them.
Those referring practices are not an advertising line, and they are rarely ranked, yet they can be the specialist's most valuable source by a wide margin.
With the referring practice's name in the campaign column, the drill-down ranks referring practices on what their patients collected, which is the list a specialist's relationship-building should follow.
It also shows referrers whose volume has quietly fallen, which is the half nobody notices because nothing arrives to be noticed.
Dental groups share a database across locations and often share marketing. Their local markets differ, and a channel that fills one clinic's diary can do little for another.
Mapped as Location, the clinic lets the report cut revenue by location, and the matched-records export pairs each payment with its source, which turns a group-wide number into decisions each clinic can act on.
It also stops one busy clinic's results flattering a channel that the other clinics are paying for and getting little from.
For groups that are growing by adding locations, the per-clinic view is also the earliest signal of which new locations are finding patients.
Production is what was scheduled or completed at the practice's fee. Collections are what arrived after insurance adjustments and patient payments.
The two differ by payer mix and write-offs, and those differ by source, so ranking on production flatters the channels whose patients carry the largest adjustments.
Every payment credits the lead that produced the patient's first visit, rather than whatever ran in the month they paid.
It also makes the report stable month to month, because a patient's source does not change when their insurer pays late.
Fair questions
It does, and it rarely gets read against revenue. That reading is what this produces.
Much of it is. Kept as its own source beside tracked ones rather than trusted alone, the mess is visible rather than hidden.
Then the clinic split does not apply and the rest does.
No. It reads a file you exported, so your database, charts and schedule stay where they are.
Collected payments with a patient contact detail, the amount and the date, plus a lead file with the referral source where you record one.
It is self-reported, so partly. Keep it as its own source beside tracked ones; where a patient appears in both, the earliest lead takes the credit.
Because adjustments and write-offs differ by payer mix, and payer mix differs by source.
A year or more, so treatment plans complete and recall revenue appears. There is no window to set.
Yes, with the referring practice in the campaign column, on what their patients collected.
Yes, mapped as Location where the export carries the clinic.
No. Recall payments credit the lead that produced the patient's first visit; keep recall reminders out of the lead file.
They stay in the file. A channel's value includes the patients who did not continue.
Any collection with no traceable source and no recorded referral.
CloseRev does not sign HIPAA Business Associate Agreements and is not built for protected health information. Export only non-clinical fields from Open Dental — a phone or email, the amount and the date — never diagnoses, treatments or notes. If those contact fields count as PHI under your obligations, talk to your compliance lead first.
Collections by source, credited to how each patient arrived, cut by clinic where mapped, the recorded referral as its own source, and everything unmatched kept visible.
By trade
What the report looks like once the export is in, written for each one.
Other systems
Running more than one system, or comparing? The method is the same and the columns are not.
Open Dental and the other product names and logos on this page belong to their owners and are shown to identify the software a file comes from. CloseRev is not affiliated with or endorsed by them, and connects to none of them: it reads a file you export.
From the blog
Multi-site healthcare groups usually conclude that attribution is off limits because the data is clinical. It is not, because attribution does not need clinical data. What it needs is a phone number, an amount and a date, and there is a way to handle even those properly.
Read the articleA multi-location business that reports one national attribution number is hiding its most important finding. The same campaign performs differently in every market, and the aggregate is an average of things that should never have been averaged.
Read the articleZillow Premier Agent sells connections by share of voice in a zip code, or through Zillow Preferred for a fee when a lead closes, generally within two years. A monthly bill set against this month's closings will mislead you either way. Here is how to measure Zillow ROI by connection cohort, where the break-even between the two pricing models sits, and what to do about leads who were already your clients.
Read the articleStart today
Nothing to install in Open Dental, no API key, and no need to have been tracking anything until now. Last year works as well as this month.