Which channels produced accepted estimates?

Every channel produces estimate requests. Acceptance rates differ sharply, and a channel producing twice the estimates at half the acceptance rate is not the bargain the lead report claims.

Ranking on accepted job revenue rather than estimates requested reorders the channels immediately, and it is usually the difference between growth and a busier estimator.

A $900 interior room and a $40,000 commercial repaint arrive from different places, and blending them into one average job value describes neither.

A job-type column mapped as Product / service shows each kind of work as its own line, with how much of it traces to a channel, so neither is judged on the other's numbers.

A repaint of a family home and a scheduled maintenance contract for a property manager are sold differently, priced differently and won differently. One is a discretionary household purchase decided by a couple over several weeks against two other quotes; the other is a procurement decision with a budget cycle behind it.

They share a phone number, a website and usually an advertising account. Blended into one report, the residential volume dominates the job count and the commercial contracts dominate the revenue, and no single average describes either of them usefully.

A customer-type column mapped as Product / service, read beside a revenue-based ranking, splits them apart, so residential work is seen on collected job value while commercial work is seen on contract revenue over its term.

Almost every residential repaint is competitively quoted, which means the estimator visits, measures, specifies and prices work that two thirds of the time goes to somebody else. That time is the largest controllable cost in the business and it is invisible to every advertising metric.

A channel that produces households who collect quotes as a hobby is expensive in exactly the resource the company cannot buy more of. Ranking on collected revenue exposes it; uploading the quote list alongside the invoices exposes it precisely, as a quote-to-job conversion rate per channel.

For most painting companies that conversion rate, not the cost per lead, is the number that should be setting the marketing budget, and it is the one they have never been able to see.

The first upload is usually a disappointment and then a relief. A painting company that has never reconciled its invoices against its inquiry records will find duplicated households, estimates recorded under a spouse's mobile, and a handful of jobs with no contact detail on them at all. None of that is a fault in the data; it is what a busy estimating diary looks like when nobody has ever had a reason to read it end to end. The first month is largely spent discovering which of those habits matter to the answer and which are harmless.

Practically, the work divides into two evenings. One is spent mapping columns once, confirming which field holds the customer's phone and which holds the invoiced total, and that mapping is then reused on every later upload. The other is spent reading the matched rows behind the first ranking, plus the few links held for review, to see whether the records say what you think they say. Neither task returns in week three. By the second upload the whole exercise is a file export and ten minutes, and the useful question changes from whether the records are good enough to what to do about what they say.

One habit is worth starting immediately and costs nothing: capture a phone number or an email on every estimate, including the ones taken at the door and the ones that arrive through a neighbor. Adopting that in month one is the single change most likely to shrink the unmatched share by the end of the quarter, because the limiting factor in this trade is almost never the matching itself. It is whether the household was ever written down. Everything else in the report improves as a side effect of that one change to how an estimator takes a booking.