Here’s a common one. A leadership team had a headline revenue dashboard — pipeline, forecast, conversion, the lot — and in meetings they’d glance at it, then argue from their own spreadsheets instead. The dashboard existed; nobody trusted it. Let’s take apart why, because untrusted reporting is its own kind of leak.
What typically happens
The dashboard isn’t wrong, exactly. It is built on data with known soft spots that were never fixed, so every number carries an asterisk in people’s heads. Three problems typically compound.
Deals sit in stages for months with fictional close dates, so the forecast is visibly optimistic and everyone knows it. A chunk of pipeline traces back to “unknown” source, so the channel numbers are treated as guesses. And marketing’s lead figures never reconcile with sales’, so the top of the funnel doesn’t tie out to the middle.
None of these was fatal alone. Together they meant that for any number on the dashboard, someone in the room could name a reason it might be off — and once a number can be plausibly waved away, it stops driving decisions.
Why the distrust spread
Trust in reporting is binary in practice. The moment one number is caught being wrong, people discount all of them, including the accurate ones. This dashboard had a few genuinely shaky metrics, and their unreliability contaminated the trustworthy ones by association. So leaders reverted to personal spreadsheets — each subtly different, none reconciled — and the “single source of truth” became a slide nobody used.
The fix
The fix didn’t start with the dashboard — it started with the data underneath: purged stale deals, enforced real close dates, closed the source-attribution gaps, and reconciled the lead figures across both teams. Only then did we rebuild the view — smaller, tied to specific decisions, every number defensible.
The rebuild worked precisely because it came second. A prettier dashboard on untrusted data would have changed nothing.
What it cost
Months of decisions made from private, unreconciled spreadsheets — which meant leaders were often working from quietly different versions of reality in the same meeting. The dashboard wasn’t just unused; its distrust was actively fragmenting how the team saw the business.
The move
If your team argues from personal spreadsheets while a shared dashboard sits ignored, the dashboard isn’t the problem — the data under it is. A free health check will tell you which numbers you can actually defend.
Related reading
See is your CRM data lying to you? and HubSpot reporting dashboards that actually get used.