The problem is not having too few KPIs. It is having the wrong ones.
Most companies that come to me with a data problem do not have a data problem. They have a metrics problem. They have piled up indicators over time, some inherited, others added in some strategy meeting, and the result is a dashboard with 40 metrics nobody looks at because it does not help decide anything concrete.
A useful KPI answers a single question: how do I know if what I am doing is working? If there is no clear answer to that, it is not a KPI. It is a number.
The confusion between operational and strategic metrics
An operational metric tells you what is happening right now. Number of orders processed today, open support tickets, website visits this week. They are useful to the operational team, but they rarely help management make strategic decisions.
A strategic metric tells you whether you are moving toward where you want to go. Margin by business line, customer acquisition cost, quarterly retention rate. These are the ones a director should see every week.
The most common mistake is to mix the two types in the same dashboard and call everything "KPIs". The result is that management sees 40 numbers, none of them gives a clear view of the business, and they end up making decisions on gut feeling anyway.
The four-perspective model
Kaplan and Norton, the creators of the Balanced Scorecard, identified decades ago that a well-run company needs visibility across four distinct areas: financial results, customer satisfaction, internal process efficiency, and learning and growth capacity. The original recommendation was no more than 20 strategic objectives and no more than 2 KPIs per objective.
That is between 20 and 40 metrics in total for the whole company. Most of the companies I work with have more than that in the sales area alone.
The constraint is a feature, not a limitation. When you force yourself to pick the 2 most important indicators per objective, you are clarifying what really matters. That exercise, on its own, is worth more than any business intelligence software.
If more than 5 people in your company could name the key KPIs of the business, and they would all give different answers, you have a metrics problem, not a data problem.
How to define a KPI that actually works
A well-defined KPI has four components: a clear business question it answers, an unambiguous calculation formula, a single agreed-upon data source, and a target or threshold that indicates whether the result is good, acceptable or worrying.
Without those four elements, what you have is a half-baked metric. Useful perhaps for one person in one specific area, but impossible to use consistently across the whole organization.
The exercise I usually run with management teams at the start of any project is simple: ask three people from different areas to explain how they calculate the same number. If all three answers are identical, the KPI is well defined. If they differ in anything, there is the problem to solve before building any dashboard.
The real cost of badly defined KPIs
A company that measures its metrics badly does not just waste time consolidating data. It makes decisions on the wrong premises. It invests in channels that look profitable but are not. It stops investing in areas that look stagnant but are growing. The cost is not in the hours of work, it is in the decisions made with incomplete or plainly incorrect information.
Reorganizing the metrics of a 50-person company usually takes between 2 and 4 weeks of work. The impact on management clarity is immediate. And it is the step to take before any other, because building a data system on top of badly defined metrics is building on sand.