Most reporting is built to be admired in a meeting. The useful kind answers one question: what should you do more of?
It’s entirely possible to hold a great deal of data and still have no idea what’s working. Dashboards across three screens, a tab for every channel, and a shrug when somebody asks where the best clients came from.
Clarity beats decoration
The only reason to measure anything is to make a better decision. A report that wouldn’t change what you do next week is decoration, however well it presents.
Most attribution breaks at the join. You can see what generated enquiries, and you can see which clients signed, but nothing connects the two ends. So the channel producing volume takes the credit, and the one actually producing revenue gets cut at the next review.
- Follow each signed client back to where they genuinely came from.
- Check it in the meeting where you decide what to spend.
- Keep the few numbers that have ever changed your mind. Drop the rest.
If nobody changed a decision because of it, you didn’t build a report. You built a newsletter.
Where attribution actually breaks
The break is nearly always in the same place, and it is not a technical failure. Your advertising platforms know about clicks and enquiries. Your invoicing knows about clients and revenue. Nothing carries an identity across the middle, so the two halves can never be spoken about in the same sentence.
The consequence is predictable. Channels get judged on the half of the journey that is easy to see. A source that delivers plenty of cheap enquiries looks efficient, and a source that delivers four enquiries a quarter of which two become your best clients looks like a rounding error. Cut the second one and you will feel clever for two quarters.
It gets worse the longer your sales cycle is, because the gap between the click and the signature is where the identity gets lost. The businesses that suffer most from this are the ones whose deals take longest — which tends to mean the ones with the most at stake per deal.
The join you actually need
The fix is unglamorous and mostly clerical. You need one identifier that survives the whole journey, and one habit of writing it down.
When an enquiry arrives, record where it came from, in the same field, in the same words, every time. Not a paraphrase from memory a week later. When that enquiry becomes a client, that source travels with them into whatever you use to invoice. Now you can ask the only question that matters — which sources produced the clients you would want more of — and get an answer rather than an argument.
- One field, one vocabulary. "Referral — existing client" every time, not sometimes "word of mouth".
- Capture it at the moment of arrival, before anyone has a theory about it.
- Carry it through to the signed client, not just the enquiry.
- Record the ones that went nowhere too, or you only ever see your winners.
This does not require new software. A column that is filled in consistently beats a platform that is configured beautifully and populated by nobody.
The one view worth having
For most businesses the useful view fits on a single page. Where the good clients came from, what it cost to get them, how long it took. Three things tracked honestly will beat a dashboard nobody opens.
Sorted by source, that page answers the questions you actually have. Which sources sent clients I would take ten more of. What each of those cost, including the time nobody bills for. How long each took from first contact to signature, because a source that works in three weeks and a source that works in nine months need different amounts of patience and different amounts of cash behind them.
Review it on a rhythm rather than when something feels wrong, because judging a channel in the month it disappointed you is how good sources get cut. Give the slow ones at least one full sales cycle before you draw a conclusion about them.
Strip out the theatre and keep the view that tells you what to do more of. Then do more of it, which turns out to be the part most people skip. It also tells you something about fit: when you can see which sources produced the clients worth having, who you are for stops being a matter of opinion.