Why doesn't the sum of attributed revenue equal total revenue on the profit and loss?
Because attributed revenue is a subset by construction. It excludes jobs whose lead was never tracked, repeat customers who called a technician directly, work sold in the field, commercial contracts, and everything that started before tracking existed. A credible report shows total revenue, attributed revenue, and the unattributed remainder as a named line rather than quietly dividing the difference.
The buckets that never attribute
- Pre-tracking customers. Anyone acquired before the current measurement existed keeps generating revenue with no recoverable source.
- Field-sold work. Add-ons, upgrades and second jobs sold at the kitchen table. Real revenue, no lead.
- Commercial and house accounts. Relationship-driven, contract-driven, and usually the largest single unattributable block.
- Direct-to-technician calls. The customer texts the tech who was here last time.
- Genuine word of mouth that arrived by a path nobody instrumented.
Why closing the gap to zero is a warning sign
If a vendor's attribution report sums exactly to total revenue, they are not measuring, they are allocating. Somewhere in that pipeline a rule is assigning leftover revenue to a channel because the alternative looked bad in a meeting.
An honest report has a remainder. The remainder should have a name, a size, and ideally a breakdown by the buckets above. That is the difference between a reconciliation and a decoration, and it is the same standard we apply in every dashboard we build.
The related tell is a report where the unattributed share shrinks every month without any measurement work having been done. Coverage improves when someone fixes tagging, imports call data or joins a new system. It does not improve on its own, and a number that quietly gets better is usually a rule getting looser.
Attributed share is the metric worth watching
Track attributed revenue as a share of total revenue over time. In a business that is improving its measurement, it rises for a while and then plateaus at a level well short of complete. That plateau is your realistic ceiling given how the business actually sells.
A sudden jump in that share almost never means marketing improved. It usually means a definition changed, a window widened, or a new source of unmatched revenue got mapped to something. Treat any step change as a data question first.
Making the report survive an audit
Tie the revenue side to the operational system and nothing else. Tie the spend side to the ad accounts. Publish match counts alongside the totals: leads received, leads matched to a source, jobs matched to a lead, revenue matched to a job. Anyone should be able to trace one job from invoice back to click.
That traceability is the actual product of integration work. The dashboard is just where it becomes visible.
Topics: reconciliation · unattributed · reporting integrity · finance
Have a version of this question about your own business?
The useful answer usually depends on which systems you run and how they're connected. That's a conversation, not a blog post.