Reporting

Sales and marketing report different numbers

Two teams, one number, two answers, and a monthly meeting where everyone argues about whose report is right instead of what to do.

The short answerAlmost always the two reports are both correct and are measuring different things. Different date fields, different filters on record type, different definitions of the same stage, or one counting people while the other counts accounts. The fix is a written definition per metric, not a third dashboard.

The four usual culprits

Date basis: one report uses created date, the other uses close date, so the same deal lands in different months. Filters: one excludes a record type or a pipeline the other includes. Definitions: both say qualified and mean different things. Grain: one counts contacts, the other counts companies.

Building a third report makes it worse

The instinct when two reports disagree is to build a neutral one. Now three numbers exist and the argument has more surface area. The only thing that resolves it is agreeing what the metric means and then deleting whatever contradicts it.

Write the definitions down where they can be found

One page, one definition per metric, naming the field, the filter, the date basis and the owner. It sounds bureaucratic until the first month where nobody argues.

What a written definition has to contain

Each team built the measure it needed at the time, and with no written definition and no owner, those drifted apart quietly. One document fixes it, signed by all three leaders before any dashboard is touched.

One row per metric
ElementWhat it saysWhy it matters
The fieldWhich field, on which objectThe concept is not enough
The filterStages, record types, owners, anything excludedWhere most drift lives
The date basisCreated, closed, stage entry or modifiedThe biggest single cause of disagreement
The ownerOne named person who can change itA committee produces drift
The review dateWhen it gets checked againDefinitions decay as the business changes
Who signed itSales, marketing and CS leadersMakes it stick

Then rebuild on top of it

Dashboards are downstream. Rebuild them from the agreed definitions rather than patching the existing ones, because a patched report carries its old assumptions invisibly.

Diagnose it in one meeting

  • Put both reports on screen and find one record that appears in one and not the other
  • Check the date field each report is built on
  • Check the record type and pipeline filters on both
  • Write down the definition both teams will accept, before anyone touches a dashboard

Questions

Why do our dashboards disagree?

Usually different date bases, different filters, different definitions of the same stage, or one counting contacts while the other counts accounts.

Who should own metric definitions?

Revenue operations, with written sign off from every team that reports on them.

Should we build a single source of truth dashboard?

Only after the definitions are agreed. A new dashboard on top of an unresolved disagreement becomes a third opinion.

How do we stop this recurring?

A written definition per metric, an owner, and a review when the sales motion changes. Most recurrences trace back to a change nobody propagated.

Why do sales, marketing and CS define the same metrics differently?

Because each team built the measure it needed and no written definition existed. The usual differences are the date basis, which object is counted, and which stages are included.

How do we get three teams onto one set of metrics?

One document, per metric: the field, the filter, the date basis, the owner and a review date, signed by all three leaders before any dashboard is rebuilt.

Why do sales, marketing and CS report different numbers?

Because each team built the measure it needed and no written definition existed. The usual differences are date basis, which object is counted, and which stages are included.

How do we get three teams onto one set of metrics?

One document, per metric: the field, the filter, the date basis, the owner and a review date, signed by all three leaders before any dashboard is rebuilt.

Want to talk it through?

Leave an email and I will reply myself, usually the same day. No sequence, and no calendar link unless you ask for one.

One reply from a person. Nothing else.

Got it. You will hear from hello@sapwood.io.

Would rather just book time? Here is the calendar.