Which channels produced paid print and signage jobs?

A print shop quotes far more than it wins, and estimators are the constrained resource. A channel producing twice the quotes at half the win rate is actively expensive.

Ranking on completed job revenue rather than quote requests shows which channels are worth an estimator's afternoon and which are consuming it.

A business that buys signage will rebrand, expand and replace. Vehicle graphics, wayfinding and event work recur on multi-year cycles.

Because the match is on the account, those later jobs credit the channel that produced the first one, which is how a low first order turns out to have been a good acquisition.

A print business usually runs three routes to market at once and reports on one of them. A web-to-print storefront takes card payment from customers nobody speaks to. The counter or the phone takes work from local businesses who found you somehow. A rep or estimator handles the accounts placing the large recurring runs. Only the first of those produces a clean digital trail, and it is nearly always the lowest-value of the three per customer. The report built from it describes the cheapest tenth of the business with great precision, and everything else by feel.

Putting all three into one revenue file, with a column naming the route, is what makes the comparison possible. Every completed job goes in with the customer's contact detail, the amount and the date, regardless of how it was ordered. What matches, matches; what does not is reported as unattributed rather than assigned to whichever campaign happened to be running when the job was printed. The route column, mapped as Product / service, then shows each route's revenue and how much of it traces to a channel, because a storefront order and a managed account do not respond to the same marketing at all.

The most common discovery is that the storefront and the account business draw on genuinely different demand. Search spend often turns out to be feeding the storefront almost exclusively, while the accounts carrying the shop's overhead came from referral, networking, a long-standing rep relationship or a sign on the building. Neither result argues for stopping anything. It argues for funding each route against what it actually produces, and for noticing that the channel everyone discusses may not be the one paying the rent. That only becomes visible when completed jobs are what the ranking is built from.

Signage revenue arrives in pieces. A survey, a design fee, a permit application, fabrication, installation, and then the next phase of the same rollout six months later. On a multi-site program the sequence can run past a financial year, and the accounting system records each stage as its own invoice against the same customer. A marketing report built on first invoices sees the survey fee and concludes the inquiry was worth a few hundred dollars, when the program behind it may be worth two hundred times that. The rows are already there and nobody has pulled them together.

Exporting all completed invoices against the customer contact fixes this without any judgment calls. Each stage credits the channel that produced the original inquiry, and the report reflects the size of the program rather than the size of its first line. For businesses doing rollout work it can be the single largest correction the first report makes. The effect is biggest on channels producing fewer and larger inquiries, which are precisely the ones most likely to have been cut on cost per lead. A job-type column mapped as Product / service keeps the one-off print work readable as its own line.

Permits and local authority approvals introduce a second kind of gap. A project can sit for months waiting on a consent that has nothing to do with the customer's enthusiasm or the shop's performance, and the revenue then appears in a quarter with no marketing activity behind it at all. Because the match is on the customer rather than a session, the delay is irrelevant and the revenue credits whatever produced the inquiry whenever it lands. It does mean quarterly comparisons in signage are close to meaningless; whole years or matched quarters are the only honest reading.

The first thing many shops see is how much revenue comes from customers who have been buying for years. Reorders, annual campaigns, a restaurant's menu reprint every season, a contractor's site boards for every new job — all of it lands in Direct / Unknown unless the original inquiry can be traced, and much of it cannot, because the relationship predates any of the current marketing. That is the honest reading and it is worth seeing at full size, because it sets expectations for the attributed portion underneath it.

The second is about estimating load. Quote volume is usually treated as a sign of health, and the report frequently shows that one source generates a large share of the quoting and a small share of the work. For a shop where the estimator is the constraint, that is a capacity finding as much as a marketing one, and it is actionable the same week. Either the source is qualified harder before it reaches an estimator, or it is funded less, or the quoting process for it is simplified. Any of those beats absorbing it silently.

The third tends to be geographic. Print and signage are logistics businesses as much as manufacturing ones, and a job forty miles away carries installation and delivery costs that a job in the same town does not. A column naming the area each job was delivered to, mapped as Location, shows how much revenue comes from each area and how much of it traces to a channel. It does not rank channels within each area and does not calculate margin, and it does not need to — seeing how much attributed work comes from far away is enough for somebody who knows what the van costs, and it changes a bidding radius rather than a budget.