One sales dashboard everyone trusts: agree the numbers before you build

A dashboard that nobody trusts is worse than no dashboard: people open it, disagree with it, and go back to their own spreadsheets. The cause is rarely the chart. It is that sales and marketing mean different things by the same word. Agree the numbers first, then build.

The order that works

1. InputName the decisionsWhat will someone do differently because of a number?
2. RuleDefine each metricOne written definition, one owner.
3. PersonAgree it togetherSales and marketing sign off the same page.
4. RulePull from the sourcesScheduled, not copied by hand.
5. OutputShow it, with checksLast updated time, and a flag when data looks wrong.

Five steps

1. Start from decisions, not charts. Ask what each person will do differently because of a number: where to spend, who to call, what to fix. A number that changes no decision does not need a tile.
2. Keep the list short. A handful of metrics per audience is plenty. Everything else can live in a table for the few who need it.
3. Write one definition per metric. Name, formula, where the data comes from, the time window, what is excluded, and who owns it. “Qualified lead” is the classic: is it a lead with a budget, a reply, or a booked call? Pick one and write it down.
4. Test the definitions on last week. Have sales and marketing each compute the same metric for the same past week. If the results differ, the difference is your next definition to settle. Do this before any building.
5. Build with checks. Pull data from the sources on a schedule, show when it was last updated, and flag a number that cannot be trusted (an empty feed, a sudden drop to zero) instead of quietly showing it.

What to leave for later

• Every metric anyone has ever asked for. Add one only when a decision needs it.
• A new BI platform. Your current sheets and tools are often enough to start.
• Forecasts and scores. Get the plain counts trusted first.

Signs it is working

The weekly report stops taking a day to assemble, nobody keeps a private copy of the numbers, and a disagreement is settled by opening the definition rather than by arguing. When a number changes meaning, the definition changes first, with a date on it.

Where this shows up

Hoàng Huy Đức has built onboarding automation, reporting dashboards and the data pipeline an account team runs on at Savyu (LinkedIn, September 2026). See the services for how a dashboard project starts.