«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 enquiry and the payment instead.
Para AdvancedMD
Export collected payments from AdvancedMD, upload the enquiries beside them, and rank marketing on what was actually received.
Sin clave de API Nada que instalar en AdvancedMDNada que instalar Sin tarjeta de créditoSin tarjeta
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 enquiry are reported as Direct / Unknown.
Comprobado por última vez con la documentación del propio AdvancedMD el 24 de septiembre de 2026.
La brecha
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.
Qué se vendió, a quién y por cuánto.
El clic, la palabra clave, la llamada y cuánto costó cada uno.
El archivo
Tres cosas sostienen la coincidencia: quién, cuánto y cuándo. Todo lo demás es opcional y solo cambia cómo se puede desglosar el informe.
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.
Whatever separates your lines of care. It is the split that shows which channel brings routine visits and which brings the procedures.
Paso a paso
Escrito para quien tiene AdvancedMD abierto en la pestaña de al lado. Los nombres de los informes varían según la edición, así que cada paso indica qué buscar.
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 service line with poor collection will look like your best marketing if you use charges.
Call tracking, the website form, directory listings and any scheduling widget. Contact detail plus where the enquiry came from.
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 enquiry file.
The join is the phone and the email, normalised on both sides, with first visits and return visits reported apart.
Lo que recibe
Ingresos por canal, el número de ventas detrás de cada cifra y un grupo honesto para las que nadie pudo rastrear. Cifras de ejemplo, del caso práctico de la página Clínicas médicas, no de una cuenta de AdvancedMD.
| Canal | Proporción | Ventas | Ingresos |
|---|---|---|---|
| Google Ads | 41 | $148,200 | |
| Meta Ads | 33 | $81,900 | |
| Email marketing | 16 | $39,000 | |
| Directo / Desconocido | 44 | $120,900 |
Las ventas sin coincidencia quedan en Directo / Desconocido. Nunca se reparten entre los canales pagados para que el total se vea mejor.
El argumento
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.
The report separates a patient's first visit from everything after it. That also answers the more interesting question — whether a channel brings patients who stay — which no advertising platform has ever been able to see.
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 neighbourhood, 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.
Blended into one figure, the routine volume swamps the procedure revenue in the counts and the procedure revenue swamps the routine in the money. Neither number describes anything you can act on.
Where the export carries a service line, the report splits on it, and the split usually explains why a channel that looked expensive per appointment was the one worth keeping.
A contact detail, an amount and a date, plus a service line if you include one. No clinical notes, no diagnoses, no procedure codes beyond that optional column, no insurance identifiers.
The match cannot use any of it, which is the point: a system that only ever needs three columns cannot expose a patient's care, because it was never given it.
Preguntas justas
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 enquiry 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, and you should. Return visits are not this month's marketing and including them makes every channel look weak.
Yes, where the export carries one. Routine care and procedures are produced by different marketing and worth different amounts.
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 enquiry 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, where the export carries a location. A group average usually describes none of its sites.
A contact detail, an amount and a date, plus a service line if you include one. No clinical notes, no diagnoses, no insurance identifiers. Encrypted in transit and at rest, isolated to your practice's workspace, deleted with the import.
Collected revenue by channel, new patients separated from returning ones, and everything unmatched kept visible.
Por sector
Cómo se ve el informe una vez cargada la exportación, escrito para cada uno.
Otros sistemas
¿Usa más de un sistema o está comparando? El método es el mismo; las columnas, no.
AdvancedMD y los demás nombres de productos y logotipos de esta página pertenecen a sus propietarios y se muestran para identificar el software del que procede un archivo. CloseRev no está afiliada a ellos ni cuenta con su respaldo, y no se conecta a ninguno: lee un archivo que usted exporta.
Empiece hoy
Nada que instalar en AdvancedMD, sin clave de API y sin necesidad de haber rastreado nada hasta ahora. El año pasado funciona igual de bien que este mes.