“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.
CloseRev reads an athenahealth export of collected amounts — patient contact detail, the payment and the date of service — and matches it against the call and lead records held outside the practice. It turns a channel's appointment volume into a channel's collected revenue, which are different rankings more often than not. Visits with no traceable source stay in Direct / Unknown.
Page updated September 24, 2026.
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.
The clinic or site, mapped as Location, for a group that runs several. It is the split a group can make without describing anyone's care.
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 — combined into one lead file with the source named on every row, so they rank 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, orthopedics, dermatology and a surgical line has several patient acquisition problems, different economics and usually one budget. It is tempting to want the report cut by specialty, and CloseRev does not do that: a department or service line on each patient's row would put health information in the file.
What it does instead is report the whole group's collected revenue by channel and, with a location column mapped as Location, each site's revenue and how much of it traced to a channel. That is the reading that reconciles to the group's own financials, which is what lets it survive a budget meeting. It does not rank channels within a site, so read the site split as a share of each site's money, not as a separate league table.
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 inquiry 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 inquired 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, no 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. CloseRev does not sign HIPAA Business Associate Agreements and is not built for protected health information; what the export may contain is your organization's call, made with your compliance lead before the first upload.
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.
Add referrals to the lead file, each under the name of the practice that sent the patient — “Referral — Smith Family Practice”, never a specialty or the reason for the referral — and they are ranked on collected revenue beside paid search. For a group weighing a liaison hire against an advertising increase, that comparison is the decision.
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.
Not by department; by site, yes. Map a location column as Location and each site's collected revenue is shown with how much of it traced to a channel.
No. A contact detail, an amount, a date, and the site if the group has several.
No. It works from a CSV export.
No. One sales file can carry every site, with the site in a column mapped as Location; the lead file stays a single file per import.
Yes, and they credit the channel that produced the patient originally.
List referrals in the lead file under the referring practice's name and they rank on collected revenue beside paid channels.
CloseRev does not sign HIPAA Business Associate Agreements and is not built for protected health information. Export only non-clinical fields from athenahealth — 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.
Yes — each referring practice becomes a source name in the lead file and ranks on collected revenue beside paid channels.
Not in CloseRev. The report reads the whole group, and each site where a location column is mapped; it has no field for a specialty.
Yes, with a new-versus-established column. Blending them makes acquisition cost look better than it is.
Yes. With one site and one specialty, the whole-practice view is the whole answer.
Yes — filter it out of the export, 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 practices go into the lead file as sources of their own and are ranked on collected revenue — the comparison a liaison-versus-advertising decision needs.
The match runs on phone and email, never on name, so a different registered name does not matter. If neither contact detail agrees, the visit stays in Direct / Unknown rather than being linked on a guess.
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.
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 cheapest leads you buy can turn into your most expensive customers. Customer acquisition cost by channel divides what a channel cost by the new customers it actually produced, and for a business that closes by phone or in person those customers live in the sales records, not the ad dashboard. Here is the formula, which customers to count, fully loaded against paid-media CAC, blended against per-channel, untraced customers, payback and time lag, with a worked example where cost per lead and CAC rank four channels in different orders.
Read the articleStart 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.