Which channels produced billing accounts?

A single skip is a $340 transaction. A restaurant on twice-weekly collection is $18,000 a year for as long as it trades. Blending them into one cost-per-lead describes neither.

A service-type column mapped as Product / service shows residential one-offs and commercial contracts as separate lines, each with the revenue it actually produced and how much of it traces to a channel.

Judged on a first invoice, almost every channel that produces commercial accounts appears unaffordable, which is why this spend is so often cut.

Because the match is on the account, every month of service credits the channel that won it. That is usually the difference between a defensible budget and an abandoned one.

Two accounts of identical value are not equally valuable to a waste business. One sits on an existing round where the truck passes anyway; the other is eleven miles off route and adds forty minutes to a shift. The revenue line is the same and the contribution is not, and no marketing report has ever known the difference. A channel producing scattered accounts across a wide area looks identical on the page to one producing clustered accounts on a single industrial estate, and operations has no way to say so in budget language.

A round or area column in the revenue export, mapped as Location, closes part of that gap. The report then shows each round's revenue and how much of it traces to a channel, which turns an abstract argument about cost per acquisition into something somebody can look at. It does not rank channels within each round, but a round whose revenue sits mostly in Direct / Unknown is one the paid media is not reaching, and a round with a high attributed share is one it is. Geographic targeting is one of the cheapest levers in paid media and one of the least used in this industry, partly because nobody has had evidence about where the attributed accounts are.

A depot column supports depot-level comparison instead, which matters because depots differ enormously in competition, tipping costs and how full the rounds already are. A channel that is excellent for a depot with spare capacity may be actively unhelpful for one running at full utilization, where the only useful new account is a dense one. A group-level average sits between those two situations and describes neither, while being the number the group budget is set against. Mapped as Location, the column shows each depot's revenue and how much of it traces to a channel; it does not rank channels within each depot, but it shows where marketing is carrying a depot and where it is not.

A waste contract quotes a price per lift or per container, and the invoice includes a good deal more: weight above an allowance, contamination charges, rental of the container, fuel and landfill levies, missed-collection fees. Some of those are recharges and some are margin, and together they can move an account's actual value well away from the number it was sold at. Reporting on contracted price therefore ranks channels on what was quoted rather than on what was billed, and the two diverge most on commercial accounts.

Exporting billed revenue keeps the ranking anchored to money that arrived. It also guards against a specific failure: accounts that generate heavy contamination charges and repeated missed collections produce operational cost dressed up as revenue, and they look excellent on any report built from contract values. Marking each invoice line as a service charge or a recharge and mapping that column as Product / service shows the two as separate lines, with how much of each traces to a channel, which is worth doing once to see how far apart they are. If the recharge line is small, use the simpler export from then on.

Container rental deserves a mention of its own, because it behaves like a subscription. A customer with three skips on long-term hire produces steady monthly revenue independent of how often anything is collected, and that revenue credits whatever produced the account just as collections do. Businesses exporting only collection revenue lose it, and with it a systematic share of the value of every acquisition channel they run. The rows exist in the billing system because they were invoiced, so including them is a decision about the extract rather than a change to anything operational.

The two halves of this business convert on timescales with nothing in common. Domestic and small trade skip hire is an immediate purchase: somebody needs a container this week, they search, they call three suppliers, and the one who answers with a price and an availability wins. The decision is made within hours and the revenue is billed within days. Commercial contracts are procurement exercises — a site visit, a waste audit, a proposal, a comparison against the incumbent, a notice period — and six months from first inquiry to first collection is unremarkable.

Measuring both against one target is what pushes budget toward the fast half every single year. Cost per inquiry rewards the channel producing skip bookings, because they convert this week and can be counted this week, while the channel producing commercial inquiries shows a cost and no return for two quarters and gets cut somewhere in between. A service-type column mapped as Product / service and a long enough range prevent that, because the commercial revenue eventually credits the inquiry that produced it however long ago it arrived. There is no window to fall outside of.

Answering the phone deserves mention here, because it is the dominant variable on the fast half and it is invisible in every advertising report. A channel's apparent performance in skip hire is substantially a measure of how often calls from it were answered promptly and quoted competently. Where a call log goes into the lead file, the difference between calls received and accounts opened becomes readable per channel, which separates a demand problem from a handling one. Those two have entirely different remedies and are routinely confused, usually in favor of blaming the media.