---
title: "KPI vs metric and how to define each | Oplema"
description: "Learn the difference between a KPI and a metric, leading vs lagging indicators and how to write a metric definition where each clause moves the number."
url: "https://oplema.com/learn/business-intelligence/kpis-metrics"
updated: "2026-11-04"
---

Lesson 2 of 15 · Concept

# KPI vs metric: how to define what you measure

A metric is any number with a definition. A KPI, or key performance indicator, is a metric with a goal, a target and an owner who will act on it. So every KPI is a metric, and most metrics aren't KPIs.

The same activity as a metric and as a KPI
| Metric | KPI |
| --- | --- |
| Website visitors | Qualified leads per month, target 200 |
| Tickets opened | First response under two hours |
| Invoices sent | Net invoice value per quarter, target €12,000 |

If nobody would act when it misses, keep it as a supporting metric. Pair lagging KPIs, which confirm a result after the fact, with leading ones, which warn early. A sales pipeline is a leading indicator, and invoice value is the lagging one it predicts.

In this course's fictional example, [Vandelay Coffee Supply](https://oplema.com/learn/business-intelligence/what-is-bi) has one hire to place and two Q3 sales reports €5,682 apart.

## Each clause of a definition moves the number

Neither report says what it counts. Here is what each decision is worth on Vandelay's invoices.

Three clauses and their value
| Clause | Decision | Moves the total by |
| --- | --- | --- |
| Period | Invoice dated in Q3, so INV-1001 from June is out | €1,200 |
| Status | Booked only, so pending INV-1016 is out | €1,300 |
| Value | After rebates, so customer Starhopper's 10% comes off | €432 |

With every other clause applied, North has €6,010 and South €5,900. Starhopper, a North customer, has €4,320 of that. Which clause can change the leader?

The rebate. It's the smallest clause, and it takes €432 from North when North leads by €110. Size says little about what a correction does to a decision.

## Write a metric contract

A metric contract needs only a few lines. Write one for Vandelay before you open the model: name, what one row is, which rows count, how value is calculated, what happens to unknown prices, who owns it and the target.

Compare with a model contract

**Net booked invoice value.** One row per invoice, latest export. Booked, dated in Q3. List amount less rebate, in euros. Unknown prices stay empty and are counted. Regions from the current register. Owner: Sydney Swell. Target: €12,000.

From here on, call it net value. It comes to €11,478, South ahead by €322, which is 95.7% of target and €522 short. The rest of this course tests that figure.

"Revenue" would be a poor name. To an accountant it means something more specific, and cash collected and profit are different measures again. Use the name that says what's counted.

## Common KPI mistakes

- **Calling everything key.** Twenty KPIs means nobody knows which three matter.
- **No named owner.** A miss with no owner gets discussed and left alone.
- **A partial period against a full target.** Halfway through a month, compare with a target for the days so far, or label the difference.
- **A definition changed without a note.** The trend line then jumps for no business reason.

In SQL, a contract's clauses are usually the `WHERE` clause and the `SUM`. In Power BI, a measure gives the definition one shared home, so reports don't each rewrite it. In a spreadsheet, keep the contract on its own sheet beside the numbers.

## Template: metric contract

Print it or copy it into any document, one per metric.

Metric contract
| Clause | Your answer |
| --- | --- |
| Name |  |
| What is one row? |  |
| Which rows count? |  |
| How is value calculated? |  |
| What happens to unknown values? |  |
| Who owns it? |  |
| What is the target? |  |

To test a contract on your own export, try [Strata](https://oplema.com/strata), Oplema's browser app for data prep, with no account needed.
