“Our front desk asks every new patient how they heard about us.”
They do, and the answer is unreliable in a known direction — people say the internet, or a friend, or they do not recall. This reads the inquiry and the payment instead.
For AdvancedMD
Export collected payments from AdvancedMD, upload the inquiries beside them, and rank marketing on what was actually received.
CloseRev reads an AdvancedMD export of collected payments — the patient's phone or email, the amount received and the service date — and matches it against the calls and forms that produced the appointment. It answers which marketing produced patients who were seen and paid for, rather than which produced requests for an appointment. Visits with no traceable inquiry are reported as Direct / Unknown.
Page updated September 24, 2026.
The gap
The schedule is full and the collections report is fine. Which of your marketing filled either is a question nobody in the practice can answer.
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 rather than the encounter. Practices capture a phone almost universally and an email less often, so both columns earn their place in the file.
What was received from the patient and the payer, rather than what was charged. Charges are a negotiating position; collections are revenue.
Either works and they answer different questions. Service date ties to when the patient came; payment date ties to cash, which for insured work lands much later.
The site the visit happened at, mapped as Location, for a practice with more than one. Nothing about what the visit was for.
Step by step
Written for somebody with AdvancedMD open in the next tab. Report names vary by edition, so each step says what to look for.
One row per visit or payment with a patient contact detail, the amount collected and a date. Look for the export listing what was received rather than what was billed.
Charges include what was written off, adjusted and never paid, and those differ systematically by payer. A channel whose patients collect poorly will look like your best marketing if you use charges.
Call tracking, the website form, directory listings and any scheduling widget, combined into one lead file with a contact detail and the source on every row.
The visit happens in March and the payment lands in June. If you match on payment date, the sales file needs to reach well past the inquiry file.
The join is the phone and the email, normalized on both sides. Return visits carry the same patient contact and credit the channel that produced the first.
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 Medical Clinics page — not from a AdvancedMD account.
| Channel | Share | Sales | Revenue |
|---|---|---|---|
| Google Ads | 41 | $148,200 | |
| Meta Ads | 33 | $81,900 | |
| Email marketing | 16 | $39,000 | |
| Direct / Unknown | 44 | $120,900 |
Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.
The argument
A practice's schedule is mostly return visits, which marketing did not produce this month and in most cases did not produce this year.
Counted together, every channel looks weak, because the denominator is full of people who were always coming back. Counted apart, the acquisition channels can be judged on the thing they actually did.
Return visits carry the same patient contact, so they credit the channel that produced the patient; to read acquisition on its own, map a new-or-returning column as Product / service. Whether a channel brings patients who stay is then visible, which no advertising platform has ever been able to show.
Two patients with identical visits can collect very differently depending on their insurance, their plan, their deductible and whether they are self-pay.
Payer mix is not evenly distributed across marketing channels. A campaign targeting one neighborhood, one age band or one service line will bring a different mix from one targeting another, and the difference shows up in collections rather than in appointment counts.
That is why collections, not visits, is the right unit. It is also why a practice can find that its cheapest source of appointments is its most expensive source of revenue.
An annual physical and an elective procedure sit at opposite ends of a practice's economics, and they are produced by completely different searches.
Counted as appointments, the routine volume swamps the procedures, and a channel producing a handful of elective cases looks weak. Counted in collected money, the picture can turn round.
CloseRev does not split the two by service line: a column saying which patients came for a procedure would put health information in the file. Ranked on collections, the whole-practice view still credits each channel with the procedure money its patients brought, which is where a channel that looked expensive per appointment can turn out to be the one worth keeping.
A contact detail, an amount and a date, plus the site if you have more than one. No clinical notes, no diagnoses, no procedure codes, no service line, no insurance identifiers.
The match cannot use any of it. CloseRev does not sign HIPAA Business Associate Agreements and is not built for protected health information, so keep the file to those columns and settle with your compliance lead whether even they count as PHI for you.
Fair questions
They do, and the answer is unreliable in a known direction — people say the internet, or a friend, or they do not recall. This reads the inquiry and the payment instead.
Then match on service date, or widen the file. Either works; what does not work is a window shorter than the lag.
A contact detail, an amount and a date. No clinical record, no diagnosis, no insurance identifier — none of it is needed and none of it is asked for.
No. It reads a file you exported, so your charts and your clearinghouse are not reachable from here — there is nothing to reach them with.
Collected payments with a patient contact detail, the amount and a date.
Collections. Charges include everything written off and adjusted, which differs by payer and would flatter the wrong channels.
Either, consistently. Service date ties to the visit and payment date ties to cash, and for insured work they can be months apart.
Yes, with a new-or-returning column mapped as Product / service. Return visits are not this month's marketing, and blending them in makes every channel look weak.
No. The report reads the whole practice, and each site where you map a location column; collections already credit procedure revenue to the channel that produced the patient.
A great deal, and it is why collections rather than appointments is the right unit — the same visit collects differently depending on the plan.
Past the inquiry file, and further if you match on payment date.
They cannot be matched and are reported as Direct / Unknown rather than assigned to a channel.
Yes: map the site column as Location. A group average usually describes none of its sites.
CloseRev does not sign HIPAA Business Associate Agreements and is not built for protected health information. Export only non-clinical fields from AdvancedMD — 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.
Collected revenue by channel, new and returning patients apart where the export marks them, 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.
AdvancedMD 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 articleThe channel with the cheapest leads is often the one whose leads almost never buy. Lead conversion rate by source divides the new customers each channel produced by the real, deduplicated leads it sent, counted by the month the lead arrived. Here is the formula, what to take out of the denominator, why small counts lie, how revenue per lead and cost per customer follow from it, and a five-channel worked example.
Read the articleStart today
Nothing to install in AdvancedMD, no API key, and no need to have been tracking anything until now. Last year works as well as this month.