Which channels produced booked door jobs?

A broken spring and a two-door replacement are the same inquiry on a cost-per-call report. One pays for the click ten times over; the other barely covers the van.

Ranking on completed job revenue separates them on the first report, and the channels that produce installation work are usually not the ones that produce the most calls.

A repair customer often replaces the door within a few years, and the campaign that produced them is credited for none of it.

Because the match is on the customer, the later replacement credits the original channel. That reframes repair advertising from a low-margin necessity into an acquisition channel with a measurable return.

A broken spring is an emergency worth a few hundred dollars and converts within hours. A new insulated door with an opener is a considered purchase worth several thousand and takes weeks. They arrive through overlapping searches, they are served by the same technicians, and they are reported as one job count.

The consequence is predictable: emergency repair keywords dominate the volume, look excellent on cost per lead, and produce a fraction of the revenue. Replacement keywords cost more per inquiry and carry the margin, and on a lead-based report they look like the weaker investment.

A job-type column mapped as Product / service, read beside a revenue-based ranking, separates them, so repair and replacement revenue are seen as their own lines rather than as a blended figure that flatters one and penalizes the other.

A significant share of replacement doors are sold by a technician standing in a garage having just fixed something else. The homeowner called about a spring, and left having ordered a door. That sequence is one of the most profitable things this trade does and it is credited to nobody.

Because the match is on the customer rather than the job, the later replacement invoice credits the channel that produced the original repair call. Channels that generate repair volume stop looking like a low-value commodity once the work they lead to is attached to them.

One file of completed jobs with a customer phone or email, the amount and a date. A job-type column separating repairs from replacements is the one addition that changes the report materially, because without it the two businesses average into a number that describes neither.

The second file is your advertising export — Google Ads, Local Services, or a call tracking export if you run one. This trade is almost entirely phone-booked, so a call export can produce the highest match rate available to you and is worth adding even if it is the only demand-side file you have.

There is nothing to install and nothing to connect. Because the method reads records kept for billing rather than a tag that had to be running at the time, last year is as analysable as this month, which is how most companies start.