Framework
One Number, One Definition, One Owner
When two dashboards disagree they are usually both right, which is why reconciling them fails and renaming both of them works.
Two dashboards show a different number under the same word, and a meeting gets spent deciding which one is correct. Almost always, both are. They compute two different quantities that were given the same name, and the room argues arithmetic when the problem is vocabulary.
This framework is three rules. Every number that matters has one definition, that definition has one named owner, and no two definitions may share a name.
Why this exists
The reconciliation instinct is the trap. Somebody volunteers to get to the bottom of it, spends two days diffing queries, and comes back with the answer: one includes canceled orders and the other does not. That answer is correct, satisfying, and changes nothing. Next quarter a third dashboard appears with a fourth treatment of cancellations, because nobody was ever told which treatment was supposed to win.
The durable fix is not picking a winner. Both numbers usually deserve to exist — finance needs one treatment, operations needs the other, and forcing either side to adopt the other’s rule only relocates the argument. Rename both, and retire the bare word. “Revenue” stops being something anyone may put on a chart. There is booked revenue and there is recognized revenue, each with its own sheet, and a panel titled only “revenue” becomes a defect you can point at without reading a line of the query behind it.
Ownership has a similar edge on it. The owner is not the person who built the pipeline. It is the person who will stand in front of whoever acts on the number and explain why it moved. Those are different people often enough that naming the wrong one breaks the rule quietly: an engineer who owns a definition will update it when the source system changes — correctly, reasonably, and without telling anyone — and the person making decisions on that number finds out months later, from a trend that was never real.
How to use it
Build the list from meetings, not from the warehouse. A number is in scope if it gets said out loud in a recurring meeting or if it triggers an action. That usually lands between twelve and twenty-five numbers. Everything else stays deliberately unowned, because a definition nobody consults rots faster than one nobody wrote.
Test a definition by handing the sheet to two people who have not spoken to each other and asking both to compute it. Then compare their row sets, not their totals. Matching totals is a weak test — two different definitions can land on the same figure for one period and separate the next. Matching rows means the sheet actually determined the answer.
Settle collisions with an arbitrary rule, on purpose. When a new number wants a name that is already taken, the newcomer renames and the incumbent does not move. It is unfair and it takes ten seconds, which beats a standing debate that recurs every time somebody builds a chart.
Where it goes wrong
It does not work on numbers that are under negotiation. Forecast, pipeline value, and anything with attribution in it are opinions in a numeric format. Give them an owner and skip the single-definition rule, or you will get one official definition and three shadow spreadsheets that people actually use.
It collapses under its own weight if you apply it to everything. At two hundred entries it is a catalog, and a catalog needs a review queue nobody is staffed to run. Hold the line at the meeting list even when somebody offers to do more.
The role dies quietly when the owner cannot say no. If anyone can ship a chart carrying a new definition without asking, you have documentation rather than governance. Watch for the wrong symptom: the failure signal is not conflict, it is silence. Six months with no change requests almost never means stability — it means the process got routed around.
And none of this makes a number true. A company can agree perfectly on a definition that measures the wrong thing. This framework ends the argument about which figure is right; it has nothing to say about whether the figure is worth having.
Copy and Clear become available when the worksheet is ready.
ONE NUMBER, ONE DEFINITION, ONE OWNER
A governing rule for the numbers your company says out loud.
RULE 1 -- ONE DEFINITION PER NAME
A name maps to exactly one computation. When two computations both
deserve to exist, BOTH get new names and the bare word is retired from
every chart title, every deck, every alert.
RETIRED WORD REPLACED BY
revenue booked revenue | recognized revenue
active user signed-in 30d | took-an-action 30d
open ticket unresolved ticket | unassigned ticket
headcount filled roles | filled roles + accepted offers
churn logo churn | net revenue churn
lead inbound contact | qualified opportunity
|
A panel titled with a retired word is a defect. You can flag it
without reading the query.
RULE 2 -- ONE OWNER, AND THE OWNER IS A PERSON
The owner is whoever will be asked to explain a move in this number to
the person who acts on it. Not the pipeline author. Not a team name --
a team cannot be paged and cannot say no.
POWER: approves every change to the definition.
DUTY: makes the restatement call on each approved change.
- leave a seam -- new basis starts , publish it
RULE 3 -- THE LIST IS SHORT ON PURPOSE
In scope only if it is said out loud in a recurring meeting, OR it
triggers an action. Expect 12-25 numbers.
Over 60 and you are cataloging, not governing. The sheets will rot
before anyone reads them, and the rot is invisible.
THE ROSTER -- one page, one line per number
NAME OWNER SAID OUT LOUD IN SHEET
y / n
y / n
y / n
y / n
y / n
y / n
y / n
y / n
THE TWO-ANALYST TEST -- how you know a definition is done
- Hand the sheet to two people who have not spoken to each other.
- Both compute it independently from the sheet alone.
- Compare ROW SETS. Not totals.
Totals agreeing proves little -- two different definitions land on
the same figure some days. Rows agreeing proves the sheet decided
the answer instead of the analyst deciding it.
- Result: rows identical
If they differ, the gap IS the missing field. Add it, retest.
COLLISION RITUAL -- ten seconds, deliberately unfair
A new number wants a name that is already taken.
- The NEWCOMER renames. Always.
- The incumbent definition does not move.
- No debate about which use is more deserving.
Arbitrary and instant beats fair and recurring.
WHEN TWO DASHBOARDS DISAGREE -- run this, not a reconciliation
- Do not diff the queries yet. Ask each side: what is this number
FOR? Who acts on it?
- If the two purposes are genuinely different -> Rule 1. Rename
both, retire the word, stop. You are done in ten minutes.
- If the two purposes are the same -> one of them is wrong.
NOW diff the queries, and the loser deletes, not renames.
- Either way, write down which case it was. The mix tells you
whether you have a vocabulary problem or a quality problem.
SIGNS THE PROCESS IS ALREADY DEAD
it means people stopped asking and started shipping.
Remove it. A short list is the whole mechanism.
WHAT THIS RULE CANNOT DO
It ends the argument about which figure is correct.
It says nothing about whether the figure is worth having.
Unanimous agreement on the wrong measure is still the wrong measure,
and it now has an owner defending it.