What I needed
I want every surgeon's numbers to answer one question: is this provider getting enough of the right patients? A practice I work with has several surgeons and a few injectors. Leads come in through one website, one chat, one phone line. Then the coordinators sort them.
When you only look at total leads, everything seems fine. Total leads are up, so marketing must be working. But the questions that move the business are all about who:
- Is the newer surgeon getting enough consults to fill their calendar?
- Is one provider's close rate dropping, or are they just getting weaker leads?
- Which provider's procedures should get more of the ad budget this quarter?
- Which coordinator needs help following up on which provider's patients?
And when a surgeon asks why their calendar is light, you want to show them their own leads and consults. A practice-wide number doesn't answer that. It starts an argument.
How I figure out the fix
Before I build anything, I look at how leads actually get to each provider. Not how they're supposed to.
This practice was tracking provider by pipeline. Each surgeon had their own pipeline in the CRM, so leads per surgeon meant deals per pipeline. That stops working the day you consolidate pipelines, which they were about to do (the right call for the coordinators, fewer places to look and fewer stuck deals). The person who runs their reporting dashboard asked the obvious question: once the pipelines merge, how do we still see each surgeon's numbers?
The first idea on the table was UTM tags. Give each surgeon's landing pages their own source tag and count by that.
So I checked. Most of one surgeon's leads had no UTM at all. They came in through the general contact form, chat, the scheduling system, a list import. A coordinator then moved them to the right surgeon by hand. UTMs would have counted a small slice and called it the whole picture.
That's usually what I find. The tracking idea everyone agrees on assumes leads arrive the clean way. In a real practice, a lot of them don't.
The fix: two fields, filled automatically
What works is putting the provider on the lead record itself, as its own field. Two of them, because there are two different moments.
Requested provider. Who the patient asked for, before any consult. This is your lead volume per provider. Coordinators pick it from a dropdown, and where the setup allows it, an automation fills it in so it doesn't depend on anyone remembering.
Consult provider. Who the patient saw at consult. An automation copies this from the scheduling system once the consult is booked. Nobody types it.
One detail matters a lot here. PAs and patient coordinators often see consults on behalf of a surgeon. If you copy the name straight over, those consults count for the PA, and the surgeon's numbers come up short. So each staff member maps to the surgeon they work under. The PA sees the patient, and the consult counts for the surgeon.
The rules that keep the numbers trustworthy
A field is only useful if people trust what's in it. These are the rules I hold to:
- Fill blanks only. If a coordinator already picked a provider, the automation never overwrites it. Staff stop trusting a field the first time a system changes their work behind their back.
- Check more than once. The automation runs when a lead is created and again every time it moves stages, since coordinators move leads by hand all day.
- Fill in the history. A new field is empty on every old lead, so your reports start at zero. Fill past consults with the same rules, check the counts first, and keep a record of every change so you can undo it in one step.
- Decide who sees what. Consult provider goes to the reporting dashboard. Requested provider can stay internal. Not every field needs to be in every report.
How I know it works
Before turning anything on, I ran the consult rules against a month of real consults and checked that every one landed on a surgeon. Then I filled in the past consults, checked the counts, and set a date to look again in a week, once new leads had come through on their own.
What you can ask once it's in
Which surgeon's leads are growing and which are flat. Whether a light calendar is a lead problem or a follow-up problem. Where the next ad dollar should go. And you can clean up your pipelines without losing anyone's numbers.
Nobody sees these fields on a patient's chart. They just make the monthly meeting shorter.