Which ads brought clients who actually came in?

The value of a new veterinary client is not the first consultation — it is the vaccinations, the dental, the emergency at some point, and often a second pet. Measuring advertising on the first visit systematically undervalues whichever channel brings clients who stay.

Because matching is on the client's phone number or email, all of their invoiced visits in the period trace back to the ad that produced them. Run the analysis over a year and the ranking usually looks quite different from the monthly view.

Emergency search is immediate, expensive and rarely produces a long-term client. Routine and preventative work converts more slowly and produces the clients who come back for a decade.

Splitting the report by visit type shows which channel is doing which, which is usually the difference between an advertising budget that grows the practice and one that just fills tomorrow.

A client on a monthly wellness plan is a different animal from one who appears only when something has gone wrong. They come in on schedule, their pets get seen before problems become expensive, and the practice can forecast them into next year's staffing. Recruiting them is one of the few marketing outcomes in veterinary medicine that genuinely compounds, and practically no practice knows which of its channels produces one. The enrollment happens at the front desk, weeks after the advert, and nothing joins those two events together.

The reason is arithmetic rather than neglect. A plan enrollment is worth perhaps $45 in the month it starts, against $340 for a single sick visit produced by the same advertising budget on the same day. On any monthly report the sick visit wins comfortably. Across two years of installments, plus the dental work and the diagnostics the plan makes affordable enough to accept, the comparison is not close, and a practice reading monthly reports has usually been funding the wrong side of it for as long as it has been advertising.

Because every installment carries the same client contact details, running the report across a longer range credits all of them to the advert that produced the enrollment. Marking plan rows with a column mapped as Product / service separates recurring revenue from episodic work, which answers the question practices actually care about and rarely ask out loud: is the plan recruiting new clients, or is it a discount being handed to the ones who were already coming in twice a year and paying in full?

Most practices are not short of demand. They are short of veterinarians, the appointment book is full three weeks out, and the phone rings anyway. Under that constraint, spending more on adverts does not add revenue — it adds people who ring, wait, get offered a slot in two weeks, and go to the practice down the road instead. The marketing question changes shape entirely, from how to generate more calls into which of the calls already arriving are worth an appointment that somebody else will otherwise take.

Answering it needs a figure almost nobody has to hand: average client transaction by source, and ideally spend per client across a year by source. A channel bringing a high volume of low-value first visits is actively harmful when capacity is the binding constraint, because each of those visits displaces one that would have been worth more to the practice and no less to the animal. The same channel in a practice with empty chairs would be entirely sensible. Capacity is what flips the sign on it, and capacity is not in any advertising report.

Practices that run this comparison usually end up spending less and earning more, which is an awkward result to take to a corporate group with a growth target attached to its marketing line. It survives the challenge because the unmatched revenue stays in its own bucket rather than being shared out across the channels being cut. Nothing in the report can be accused of having quietly moved money away from the campaign somebody wants to defend, because the report refuses to move money it cannot trace to a person.

Food, the online pharmacy, boarding, grooming and the retail shelf are all real revenue from the same client, and in many practices they sit in systems with no connection to the clinical software. A report built only from the practice-management invoice export therefore undercounts every channel — and undercounts them unevenly, which is the part that matters. The sources bringing long-term clients are exactly the ones whose revenue leaks into those other systems, so the omission penalizes precisely the advertising a practice should be protecting.

There is no integration to build here and no vendor to call. Each of those systems exports rows carrying a client contact detail, an amount and a date, which is the entire requirement. Append them to the sales file, mark them with a revenue-type column mapped as Product / service, and they join to the same client and therefore to the same original inquiry. The online pharmacy is usually worth doing first: it can be the largest single omission, it grows quietly year on year, and it is completely invisible in the invoice report most practices start from.

The one thing to watch is counting the same money twice. Where the practice-management system already posts a retail sale that the shop system also records, pick one source per revenue type and note the decision somewhere a colleague will find it. A first import that double-counts food sales is easy to spot, because the average client transaction comes out implausible, and easy to correct, because an import can be deleted and replaced without disturbing anything else in the workspace.