I spent a significant part of last year building a tracking spreadsheet. Nine tabs, covering every channel: LinkedIn impressions, website sessions, HubSpot contacts, email open rates. The works.
It was satisfying to build. It was less satisfying to use.
Because what I’d created was a very detailed picture of activity — how much we were doing, how often, with what reach. What it couldn’t tell me was whether any of it was working in any meaningful sense.
The measurement problem in marketing
There’s a seductive logic to measurement: more data, better decisions. It’s not wrong, exactly — but it skips over a harder question, which is what are you actually trying to understand?
Most marketing dashboards I’ve seen answer questions like:
- How many people saw this?
- How many clicked?
- How did this compare to last month?
These are fine questions. But they sit one level above the questions that actually matter:
- Did this content reach the right people?
- Did it change how they think about us?
- Did it make them more likely to buy, refer, or return?
The gap between what’s easy to measure and what’s worth measuring is where most marketing analytics lives.
What I changed
The shift I made — and it was gradual — was to anchor every metric to a decision.
Before adding anything to the dashboard, I’d ask: if this number goes up or down significantly, what would I do differently? If the answer was “nothing, really,” the metric probably didn’t belong there.
This removed a lot of data. It also made the data that remained much more useful.
The honest limitation
I want to be clear: attribution in B2B marketing is genuinely hard. The buyer journey is long, it involves multiple people, and a lot of the influence content has is invisible to analytics.
Someone reading your posts for six months before they fill in a contact form will look, in your data, exactly like someone who found you via a cold search that day. Your content gets no credit for the work it did.
This doesn’t mean analytics are useless. It means they’re incomplete — and treating them as complete is the trap.
The best marketing measurement systems I’ve seen are honest about what they can and can’t show. They track what’s trackable, acknowledge the gap, and make decisions accordingly.
That’s harder than building a nine-tab spreadsheet. But it produces better marketing.