Which channels produced signed installations?

Homeowners collect three quotes, compare them, wait for a bonus or a tax refund, and sign months later. The attribution window closed in week two.

Matching on the homeowner rather than a session credits the original campaign whenever the job is signed, which for this trade is the majority of the revenue currently attributed to nobody.

A pressure-treated fence and a composite deck are the same inquiry and several times apart in value, and channels feed them unevenly.

A material or job-type column mapped as Product / service shows premium work as its own line, with how much of it traces to a channel, rather than averaged away.

Fencing and decking demand is researched in the cold months and installed in the warm ones. Households plan a garden project through winter, gather quotes in early spring, and the work is carried out when the weather allows — which can be several months after the inquiry that started it.

That means the advertising spend and the revenue reliably fall in different quarters, and frequently in different financial years. A report comparing this month's spend to this month's invoices is comparing two unrelated cohorts and will conclude that the winter budget achieved nothing.

Matching the invoiced job back to the household who inquired puts the revenue against the period the inquiry came from. For a seasonal trade this is not a refinement; it is the difference between being able to justify an off-season budget and cutting it every year.

A pressure-treated fence and a composite deck of the same footprint differ in price by a multiple, and they are produced by different searches with different intent. One inquiry is one inquiry either way.

Because the volume in this trade is relatively low and the spread of job values is wide, a handful of high-specification jobs will carry a month, and whichever channel produced them will be invisible on a cost-per-lead view.

Ranking on invoiced revenue handles it automatically, and a material or product column mapped as Product / service shows how much of the expensive work traces to a channel at all — which is where the margin, rather than the volume, actually is.

The most common outcome of a first reconciliation is not a discovery, it is an argument. A channel that has looked excellent for years on inquiry volume, often the cheapest one and often the one somebody in the business championed, turns out to have produced very few signed installations and almost none of the large ones. The numbers are not subtle about it, and the first instinct is to look for a fault in the method rather than in the channel. That instinct is reasonable and is better followed to its conclusion than suppressed.

So follow it. Open the matched rows for that channel in particular and ask whether its inquiries are being recorded differently from everyone else's: a form capturing only an email, in a business whose jobs are booked by phone, will depress one channel and no other. Check whether its work sits under a job type that was exported inconsistently. If neither explains the gap, the channel is producing inquiries that do not become fences, and cost per inquiry was never the thing that deserved optimizing in the first place.

Acting on it deserves more patience than the finding does. Cut a channel to nothing on one quarter's evidence and you may have cut the one that fills next spring's diary, because this trade's inquiries and its revenue sit in different seasons by design. Halving a budget and watching two more cycles is the defensible move, and it is also the one that survives being questioned a year later. The report exists to make the conversation possible. It is not an instruction, and it knows nothing about what else changed in the market that quarter.