Analytics

Nobody Ships Against a Number They Doubt

Data trust is a product problem, not a pipeline problem, and teams that rebuild pipelines to fix it keep rebuilding.

5 min read

Listen
0:00 / 5:48
Contents

Nobody Ships Against a Number They Doubt

The most expensive recurring meeting in most companies is the one where a room full of people argue about whether the number is right instead of what to do about it. A decision was on the agenda. Forty minutes later the group is still debating whether the dashboard double-counts trials, whether the definition of “active” matches last quarter’s, whether Finance and Product are even pulling from the same table. The decision gets tabled. Everyone agrees to “align on the numbers” and reconvene.

Nobody logs this. There is no line item for hours spent relitigating provenance. It shows up as slow decisions, as a VP who quietly discounts every chart in the deck, as an analyst who spends Monday morning reverse-engineering why two reports disagree by 3 percent. The cost is real and the org has no field for it.

That is the tell. When a company cannot trust its own numbers, the failure is invisible in exactly the systems that would flag any other failure. And because it is invisible, it gets misdiagnosed. The org decides it has a data quality problem and points the data team at the pipeline.

Rebuilding the Pipeline Doesn’t Fix a Trust Deficit

Pipeline quality and data trust are different problems that happen to share a symptom. A pipeline can be clean, tested, and correct to six decimal places, and the VP will still open the deck and say “that doesn’t feel right.” Trust is not a property of the data. It is a property of the person deciding whether to stake a decision on the data.

Watch what actually happens when someone doubts a number. They cannot answer three questions fast enough to act: What does this metric mean, exactly? Where did it come from? Why does it disagree with the other number I saw? None of those are pipeline questions. They are questions about definitions, provenance, and traceability, the surfaces a human touches when they decide whether to believe. The pipeline is upstream of all of it and answers none of it.

So the org rebuilds the pipeline. The migration takes two quarters. The numbers are now cleaner and still distrusted, because nobody addressed the reason the VP couldn’t stake a decision on them. Then the trust deficit gets rediagnosed, and the next rebuild gets funded. This is how companies spend years and several headcount rebuilding infrastructure while the actual deficit sits untouched. It was a product problem wearing a pipeline’s clothes.

Design for the Skeptical VP, Not the Analyst

The metric layer has a primary user, and it is not the analyst who built it. It is the skeptical VP who has been burned before and now defaults to doubt. Build for that person and the trust problem becomes tractable. Build for the analyst and you get a technically correct system that decision-makers route around.

Designing for the skeptic means a small number of concrete requirements. Every metric has one definition, written in plain language, visible next to the number, not buried in a wiki nobody opens. Anyone can answer “where did this come from” in under a minute, with the lineage from source to chart legible without opening a warehouse console. When two numbers disagree, the system explains the disagreement instead of leaving it to a human to excavate. The semantic-layer work coming out of the dbt, Malloy, and Mode communities is mostly an attempt to encode this: a single place where a metric is defined once and every surface inherits that definition. The infrastructure matters because of what it does for the human staring at the dashboard, not for its own elegance.

This is Trust as a Product. The deliverable is not a cleaner table. It is a person who reads the number and moves, because the three questions that used to stall them now answer themselves before they’re asked. The writers at Locally Optimistic and Benn Stancil keep circling back to the same point about data trust: the work is judged by whether someone bets on the output, not by whether the output is correct in isolation.

A Trusted Number Moves the Argument Up a Level

Here is the compounding part. Once a number is trusted, the argument does not end. It moves up a level. The room stops fighting about whether trials are double-counted and starts fighting about what to do now that trial conversion is down. That second fight is the one worth having, and it is the one the org was never getting to.

This is the whole return on trust. Not fewer meetings. Better meetings, held one rung higher. A trusted metric layer reinforces itself: every decision made on top of it without incident deposits more confidence, and the next decision starts from belief instead of doubt. Compounding authority in the numbers is what lets a team move fast without relitigating its own foundation every quarter. The organizations that get this are not the ones with the cleanest warehouses. They are the ones where a chart ends an argument instead of starting one.

The Skeptics Are Right That Trust Can Curdle

The strongest objection is that some metric disputes are healthy, and a fully trusted number can be confidently wrong. Both are true. A team that never questions its numbers is one silent definition change away from steering off a cliff with total conviction. Trust taken too far becomes complacency, and a beautifully governed metric layer can encode a bad assumption and propagate it everywhere at once.

The objection doesn’t defeat the argument; it sharpens the target. The goal is not to end all disagreement about numbers. It is to move the disagreement from provenance to interpretation. Arguing about what “active user” should mean, or whether this quarter’s dip is noise or signal, is high-value work. Arguing about whether two dashboards are even measuring the same thing is pure waste. A healthy org has plenty of the first kind and almost none of the second. When your smartest people are fighting about what the number means for the business, the metric layer is doing its job. When they’re fighting about whether to believe it at all, no strategy built on top will survive contact with the room.