“Our revenue cycle is managed centrally.”
Then the export comes from the revenue cycle team. A visit-level financial report is a standard artefact for them.
For athenahealth
Match collected revenue to the campaigns and calls that produced the patient, across the months a claim takes to settle.
No API key Nothing to install in athenahealth No card required
The gap
A visit in March collects in June at a rate nobody knew in March. Your marketing report closed the March book long before the money arrived.
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.
The patient record. Either works; export both where you can, since households share numbers and addresses.
Payments received rather than charges posted. The contractual adjustment is large and varies by payer, which varies by channel.
Use service date for attribution and keep it consistent between uploads.
Separates specialties that share a brand and an ad account but nothing else.
Step by step
Written for somebody with athenahealth open in the next tab. Report names vary by edition, so each step says what to look for.
One row per encounter with the patient's contact detail, the collected amount and the service date.
Export twelve to eighteen months so that visits and the money they eventually collected are both inside the file.
Phone or email is the join key. Account numbers cannot be matched to an ad click or a phone call.
Confirm the suggested mapping or map manually. Nothing is inferred silently.
Ad platform exports, call tracking, and any referral or outreach lists you want ranked on the same axis.
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 athenahealth 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 group running primary care, orthopaedics, dermatology and a surgical line has four different patient acquisition problems, four different economics and usually one budget. Reported together they produce a cost per new patient that describes none of them.
Carrying department or service line through the export splits the report the way the group is actually managed. It is usually the first cut a practice administrator asks for and the one that changes a budget conversation.
Two patients with identical visits and different insurance collect different amounts. Since payer mix correlates with how a patient found you — a self-pay aesthetic enquiry is a different acquisition from a referred medical visit — ranking channels on charges produces a systematically distorted table.
Exporting collections fixes it and makes the report reconcile to the group's own financials. That reconciliation is what lets the number survive being questioned by somebody who owns the P&L.
Between a visit and settled money sit the claim, the adjudication, the patient balance and sometimes an appeal. Months, routinely. Any attribution method that needs the revenue to land inside a window is structurally wrong here.
Matching on the patient means the lag is irrelevant. The person who enquired in February and the encounter that collected in July are one match, and the February campaign is credited with the July money.
The match reads a contact detail, an amount and a date. No diagnoses, no procedure detail beyond an optional service line, no notes. There is no tag on any page, no connected application and no permission to grant — the input is a report export.
Data is encrypted in transit and at rest, isolated per workspace and deletable in one click, with a DPA available. Which rules apply to your organisation is your determination to make with your own advisers; we do not see your records.
A meaningful share of specialty volume arrives by physician referral, which costs no media spend and a great deal of relationship time. It is almost always left out of marketing reporting entirely, which makes the paid channels look more important than they are.
Upload the referring provider list as a source file and it is ranked on collected revenue beside paid search. For a group weighing a liaison hire against an advertising increase, that comparison is the decision, and it has usually never been quantified.
It also surfaces referral relationships that have quietly decayed, which is a different kind of useful.
Fair questions
Then the export comes from the revenue cycle team. A visit-level financial report is a standard artefact for them.
If it reports on leads and appointments, this is the layer underneath it: what those appointments collected. If it already reports collected revenue by campaign, you may not need this.
A contact detail, an amount and a date. You decide what the export contains, and clinical fields are not read.
Visit or claim level financials: a patient phone or email, the collected amount, and the date of service.
Collections. Charges are not comparable across payers, and payer mix varies by channel.
Twelve to eighteen months, so the collection lag sits inside the file.
Yes, with a department or service line column.
No. A contact detail, an amount, a date, and optionally a service line.
No. It works from a CSV export.
Yes, with the relevant column, on Growth and above.
Yes, and they credit the channel that produced the patient originally.
Upload referrers as a source file and they rank on collected revenue beside paid channels.
Encrypted in transit and at rest, isolated per workspace, deletable in one click, DPA available.
Yes — a referring provider list is a source file and ranks on collected revenue beside paid channels.
Yes, with a service line column, which is the usual first cut for a multi-specialty group.
Yes, with a new-versus-established column. Blending them makes acquisition cost look better than it is.
Yes. The service line column simply becomes unnecessary.
Yes, with a payer or contract column, so the return is measured against the fee-for-service book the advertising competes for.
Export them as further rows against the same patient. They credit the original channel and keep the total reconcilable to your financials.
Yes. Referring providers upload as a source file and are ranked on collected revenue, which is the comparison behind most liaison-versus-advertising decisions.
The match runs on phone and email rather than name, which absorbs most of it. Anything that only links weakly is flagged for a person rather than counted.
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.
athenahealth 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.
Start today
Nothing to install in athenahealth, no API key, and no need to have been tracking anything until now. Last year works as well as this month.