Which channels produced treated, paying patients?

A covered skin check and a $1,400 laser course are the same appointment slot and completely different economics. Channels feed them unevenly — social produces cosmetic interest, search produces medical urgency.

Ranking on collected revenue, with the sale count beside it, shows whether a channel's money comes from a few large cosmetic cases or many smaller visits. A treatment-type column is not one to add: whether somebody came for medical or cosmetic care is health information.

Injectables, laser and skincare are repeat purchases on three- to six-month cycles. A patient acquired once may spend for years, and no click-based tool credits the original campaign past the first visit.

Because the match is on the patient, every subsequent treatment credits the channel that produced them, which usually more than doubles the apparent return on the channels that produce cosmetic patients.

In most general dermatology practices the advanced practice providers carry the majority of the visits. Acne, eczema, rashes and routine follow-ups are seen by a physician assistant or nurse practitioner, while the physician's diary is weighted toward surgical work and complex cases. The economics of those two schedules are not the same, the capacity constraints are not the same, and the marketing that fills them is usually one undifferentiated budget aimed at whoever searches for a dermatologist nearby. A practice that cannot see which of its two schedules a channel fills is flying on one instrument.

The consequence is subtle and expensive. A campaign delivering a steady stream of routine complaints looks productive on patient counts and fills the schedule that was never the bottleneck, while the surgical diary — the one with the waiting list and the revenue — is fed almost entirely by referrals nobody is measuring. The practice concludes that its advertising works, because the appointments do appear, and never asks which appointments they were. It is a comfortable conclusion, it is supported by every number on the dashboard, and it is answering a question about volume when the practice's constraint was never volume. The waiting list for surgery grows regardless.

A location column mapped as Location shows each site's revenue and how much of it traces to a channel, which is the breakdown available here. A provider column is not one to add: which provider somebody saw can reveal what they were treated for, and CloseRev signs no business associate agreements. What the report can still show is whether the practice's total revenue is reached by marketing at all, and the sale count beside each channel hints at whether it is filling the diary that was short or the one that fills itself. A practice may then stop advertising a service entirely, not because the campaign failed but because it was succeeding at something the practice did not need more of, which is a distinction no dashboard built on appointment counts can draw.

A full-body examination is billed at a modest amount and frequently produces a biopsy, and a biopsy sometimes produces an excision or a staged surgical procedure worth many multiples of the original visit. The sequence takes weeks. Every one of those steps happens under the same patient record and none of them happens inside any window an advertising platform recognizes, so the campaign that produced the screening is credited with the screening fee and nothing else. What the practice sees, months later, is a surgical schedule it cannot explain and a screening campaign it has decided is only breaking even. Both impressions come from the same missing join.

That understatement is not evenly distributed, which is what makes it a ranking problem rather than a rounding one. Campaigns aimed at screening and prevention produce the sequence; campaigns aimed at a cosmetic treatment produce a single transaction at a higher price. Compared on the first visit alone, the cosmetic campaign wins comfortably. Compared on everything that followed from the patient over the next quarter, the order frequently reverses, and the practice has been funding the wrong one on a number that was never wrong, only incomplete.

Because the join is on the patient rather than a session, all the downstream revenue credits the original inquiry once the export covers a long enough period. Three months is usually enough to see the biopsy and the excision land against the screening that found them. It costs nothing extra to look, since the billing records exist regardless, and it is the clearest illustration in this segment of why a first visit is a poor unit of account. Practices that extend the window from thirty days to ninety usually watch the screening campaign move several places up the ranking without anything about the campaign having changed at all.

General dermatology in many markets is booked out for a quarter, while cosmetic appointments are available next week. That gap has a measurable effect on what happens after the click. A patient who searched today and is offered a date in November will keep looking, and a proportion of them will be somebody else's patient before the appointment arrives. The advertising account still records the booking as a conversion, and it never learns that the chair sat empty. By the time anybody investigates, the inquiry is six months old and no longer belongs to any report that is still open.

Practices read this as a no-show rate and treat it as an operational nuisance rather than as the thing distorting their channel comparison. It is not evenly spread: sources that attract urgent, symptom-driven searches suffer most from a long wait, while sources producing planned cosmetic inquiries barely notice it. So the ranking a practice acts on is partly a ranking of how patiently each channel's patients wait, which is not a fact about advertising at all. It is, at best, a ranking of how well each channel's demand tolerates a delay the practice cannot currently fix, dressed up as a ranking of advertising quality.

Reconciling attended, paid visits against the inquiries that produced them puts that attrition where it belongs. Upload both files and the booked-to-attended ratio per source becomes visible, which usually reframes the discussion entirely. The answer is rarely to change the campaign; it is to hold slots differently, to triage at booking, or to stop advertising a service the practice cannot see anybody for until the spring. In each case the useful part is that the decision is now being made against an attendance figure rather than against a booking figure that was never going to be honored.