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.
| 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 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.
| 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.
| 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, Oplema's browser app for data prep, with no account needed.