KPI Definition Sheet · KPI Pool
Key Performance Indicator Definition Sheet and Indicator Pool
What is a KPI definition sheet?
- A definition sheet is the calculation spec for a single indicator
- A pool is a list of vetted candidate metrics
- Confirm exclusion criteria and data sources at the start of the year
When people talk about setting KPIs, they tend to think of it as picking metric names. But the year-end disputes come from how the numbers are calculated, not from the names. Take the same 'on-time delivery rate': if Sales measures against the customer’s requested date and Production measures against the internally confirmed date, one company reports both 82% and 96% at once. A KPI definition sheet is the document that fixes, at the start of the year, who calculates this number, from what data, and how. A KPI with only a name is only half defined.
A definition sheet covers roughly eight items: the metric name, its purpose (which strategic priority it supports), the formula, the definitions of numerator and denominator with exclusion criteria, the data source and who pulls it, the measurement frequency, the target level and grade bands, and the direction. The cells most often left blank are exclusion criteria and data source. If it isn’t written down whether deliveries delayed by the customer count, or which screen in which system the number comes from, a negotiation begins at year-end, with each side pushing the reading that favors them.
A KPI pool serves a different purpose. It is a ready-made list of useful metrics by job role and function, so team leads can choose from vetted candidates instead of inventing metrics from scratch. Every metric in the pool must already have a definition sheet attached. Keep about 10 to 15 candidates per role, and narrow what each person actually selects to around five. When HR manages the pool, you can reduce the same role being judged by different standards from team to team.
Things go wrong in practice when the pool turns into a buffet. Once candidates swell to hundreds, team leads pick only the easy-to-hit metrics, and no one picks the hard ones tied to strategy. The fix is to separate required metrics tied to strategic priorities from optional metrics teams can choose freely. Also, if a definition sheet is written once and never updated, metrics linger that can no longer be pulled after a system change. Conversely, changing a formula mid-year breaks year-over-year comparison. It is safer to limit changes to once a year and record the reason and date.
John KimInstructor John Kim, author of “B2B Marketing Design” and CEO of Nanum Consulting
Jinho DanAccounting instructor who makes financial statements, costing, and tax easy to understand| Category | KPI Definition Sheet | KPI Pool |
|---|---|---|
| What it is | A calculation spec for a single metric | A list of candidate indicators to choose from |
| Unit | One page per indicator | Grouped by job role or function |
| What it contains | Formula, exclusions, source, frequency, target | Metric name, applicable role, required or optional |
| Problems it solves | The year-end dispute over calculation | Different standards per team, and the burden of starting from scratch |
| Owner | Metric-owning departments, plus HR and planning | HR and planning departments |
| Common failures | Approved with the exclusion criteria and source fields left empty | A buffet with hundreds of candidates |
It is not a template with a particular inventor; it is a working document that took shape through running performance management systems. As the Balanced Scorecard and management by objectives spread, the practice of documenting each metric’s formula and data source up front became standard.
Consider a hypothetical case. Company A, an auto parts maker, has 480 employees and 26 teams. In last year’s year-end reviews, Sales reported an 'on-time delivery rate' of 82% while Production reported 96%, and the debate over which number was right delayed finalizing the reviews by three weeks.
- When the HR lead looked at the calculation files from the two teams, Sales used the customer’s requested date as the baseline, while Production used the internally confirmed date. The Production lead said, "It isn’t our fault if the customer moves the date up, is it?"
- HR gathered all 143 company-wide KPIs and separately flagged 21 indicators that share a name but use different formulas, and 34 indicators whose data source no one could explain.
- Together with the planning team, they had a one-page definition sheet written for each indicator. On-time delivery rate was standardized to the final delivery date agreed with the customer, and the sheet stated an exclusion rule: orders changed at the customer’s request are removed from the denominator.
- Metrics whose definition sheets could not be completed were removed from the pool. The pool shrank from 143 to 88 metrics, of which 22 tied to strategic priorities became required metrics and the remaining 66 became optional.
- The 26 team leads each chose about five metrics: two or three required ones plus optional ones. When the purchasing team lead proposed a new metric, HR first received a draft definition sheet, reviewed it, and only then added the metric to the pool.
- At the next year-end evaluation, disputes over metric calculation fell from 17 to 2, and the time to finalize evaluations shrank from 5 weeks to 2.