Framing Business Questions, Data and Metrics · Lesson 3

Defining Metrics and KPIs for Valid Comparison

4 min read

Lesson objectives

  • Build a metric card defining numerator, denominator, period, segment and required rules.
  • Distinguish counts, proportions and rates, and distinguish percentage points from relative percentage change.
  • Explain when a metric becomes a KPI and link it to an objective, decision and responsibility without inventing a benchmark.

A metric is a definition before it is a number

A number such as 77.5% is not sufficient on its own. For a metric to be interpretable and reproducible, its definition should specify numerator, denominator, period, eligible unit or population, segment, and inclusion/exclusion rules. Data source, refresh frequency and comparison basis may also matter. If two analysts use different denominators, both percentages can be mathematically correct while answering different questions.

Metric-card elementCheck question
Name and purposeWhat does it measure and why does the decision need it?
NumeratorWhich events or units are counted on top?
DenominatorWhat is the eligible comparison population?
Period/segmentWhen and for whom is it calculated?
RulesWhat is included or excluded?
Source and refreshWhere do the data come from and when are they refreshed?

Distinguish a count, a proportion and a rate. A count is a quantity such as 930 orders completed on time. A proportion relates a part to a whole, such as 930 of 1,200 eligible orders. A rate often adds a basis such as time or exposure, for example 12 orders per hour. Do not use these terms interchangeably when the denominator changes the meaning.

The denominator deserves special attention. If one team excludes cancelled orders from the denominator of “completion rate” while another includes them, the comparison is invalid even when both use the same label. Define the denominator so another analyst can identify eligible records without guessing the author’s intent.

When does a metric become a KPI?

A key performance indicator (KPI) is not simply any number placed on a dashboard. A metric becomes “key” when it is tied to an objective, a decision, regular monitoring and clear responsibility, often with a target or threshold indicating when attention is needed. In a synthetic case, management may set 80% as an on-time completion target. That is an assumed teaching target, not a universal standard or market benchmark.

MetricAcceptable definitionInsufficient definition
On-time completion proportionorders completed on/before due time ÷ eligible orders due in the periodfast orders ÷ orders
Average completed-order valuesum of completed-order value ÷ number of completed orders in the period and segmenttotal value ÷ all customers
Cancellation proportioncancelled orders ÷ orders created in the defined cohort under the period rulecancellations ÷ orders without a period rule

When a dashboard or report compares periods or teams, ask for the metric definition, not just its name. Definition stability is part of fair comparison. If the definition changes, record the effective date and explain the effect instead of presenting the time series as if it were fully comparable.

Lesson summary

A comparable metric needs stable definitions of numerator, denominator, period, segments and rules. Percentage points differ from relative percentage change, and a KPI is tied to an objective, decision, monitoring and responsibility; a synthetic teaching target is not a universal benchmark.