A template for recording what each metric means, where it comes from and who owns it – the document that settles most reporting disputes before they start. It is the practical companion to Building a KPI & Metric Dictionary.

Every metric in a recurring report should have one entry. Where definitions are recorded, two reports disagreeing is a fact to investigate; where they are not, it is an argument.

If two people can describe a metric differently, you do not have a metric. You have a word.

What the template contains

The template is a table with one row per metric, and a defined set of columns.

  • Metric name – as it appears in reports.
  • Definition – what it means, in one sentence.
  • Formula – how it is calculated, with components.
  • Source system – the system of record, named exactly.
  • Extract or report – the specific extract or run used.
  • Owner – the person accountable for the definition.
  • Cadence and timing – how often and when it is produced.
  • Units and currency – so no figure is ambiguous.
  • Caveats and exclusions – what the metric does not include.
  • Dependencies – other metrics it is built from.
  • Version and effective date – so a definition change is traceable.

Six of these are the minimum – name, definition, formula, source, owner and cadence. The rest improve the entry as the dictionary matures.

A worked entry

One completed row shows how the template is used.

  • Metric name: Gross margin
  • Definition: Gross profit as a percentage of revenue for the period.
  • Formula: (Revenue – cost of goods sold) / revenue
  • Source system: Finance system
  • Extract: Monthly revenue and COGS extract, month-end
  • Owner: Finance systems lead
  • Cadence: Monthly, available day 3
  • Units: Percentage, one decimal place
  • Caveats: Excludes one-off restructuring costs; gross, not contribution, margin
  • Dependencies: Revenue; cost of goods sold
  • Version: v2, effective 1 July 2026

With this entry in place, two reports disagreeing on gross margin is a solvable question. Without it, it is a debate about which number is right.

How to roll it out

A dictionary fails when it is attempted all at once. Start small and grow it.

  • List the metrics that appear in your most-produced reports.
  • Document the top ten first, with owners named.
  • Publish it where reports are written, so it is used rather than filed.
  • Review annually, and after any dispute that revealed a gap.
  • Version changes, so a definition shift is visible and dated.

Twenty well-documented metrics cover most reports in most businesses. The dictionary improves as disputes teach you which definitions need sharpening.

Common mistakes

  • Documenting everything at once. The effort defeats itself and the dictionary is abandoned.
  • No owners. A metric without an owner drifts.
  • Formulas omitted. The metric cannot be recomputed or checked.
  • Caveats missing. The reader applies the metric more broadly than intended.
  • No versioning. A definition quietly changes, and comparability is lost.

Frequently asked questions

What columns does a metric dictionary need?

At minimum: metric name, definition, formula, source, owner and cadence. Add units, caveats, dependencies and a version as the dictionary matures.

How many metrics should the dictionary cover?

Start with the ten to twenty that appear most often in your reports. That covers most reports and settles most disputes.

Should the dictionary be a spreadsheet?

For most teams, yes – findable, owned and reviewed. A dedicated system helps at scale, but the definitions matter more than the format.

How do you handle a metric two teams define differently?

Choose the definition that best serves the decision, record it, and give both teams the same term. If two definitions are genuinely needed, give them distinct names.

How often should metrics be reviewed?

Annually at minimum, and after any dispute that revealed a definitional gap. Review the whole dictionary before a major reporting change.

Who owns the dictionary?

The reporting owner coordinates it; the metric owners are accountable for each entry. Every entry should name one accountable person.

Next step

Document your top ten metrics with owners and formulas, publish the dictionary where reports are written, and reference it in your report template. If you would like it built for you, book a pilot call.

Sources

  • Definition and ownership practice follows standard data-governance and reporting convention: one definition per metric, a named owner, and versioned definitions for recurring reports.

No statistic in this asset is invented; where a figure appears in the linked guides, it is cited there with its source and date.