
www.simplify-data.de
Metrics are supposed to help you run a business. In practice, though, companies often end up with long lists of figures that nobody looks at regularly. This article presents the metrics that have proven useful for mid-sized companies across most industries and explains how to measure them reliably.
What makes a good KPI
A KPI (key performance indicator) is a metric directly linked to a business objective. Not every number is a KPI: website visitors are a metric, and they only become a KPI when they are relevant for steering towards a specific goal.
Good KPIs meet a few conditions:
- Clearly defined: Everyone understands the same thing by it, including the formula and data source.
- Actionable: A team or person can change it through their own actions.
- Regularly available: The figure is available at a rhythm that matches the decision, such as weekly or monthly.
- Has a target: Without a target or benchmark, a number is hard to judge.
Eight to twelve KPIs are usually enough to start with. More metrics do not mean more control; they often mean less attention per figure.
Finance and liquidity
Financial metrics form the foundation because the data is already structured in your accounting system.
| KPI | Calculation | Data source |
|---|---|---|
| Revenue | sum of net sales in the period | accounting, ERP |
| Gross margin | (revenue minus cost of goods sold) / revenue | accounting, ERP |
| Contribution margin | revenue minus variable costs, per product or customer | ERP, cost accounting |
| Cash position | available bank balances plus unused credit lines | banking, accounting |
| Days sales outstanding (DSO) | receivables / revenue × days in period | accounting |
Days sales outstanding shows how many days customers take on average to pay. If it rises, cash gets tied up, even when revenue looks healthy.
For contribution margin, a breakdown by product, customer or region is worthwhile. It shows which business actually contributes to the bottom line.
Sales and customers
- Order intake: value of new orders received in the period. It is an early indicator of future revenue.
- Order backlog: value of accepted orders not yet delivered or invoiced. It shows how far capacity utilisation is secured.
- Quote win rate: number of quotes won / number of quotes submitted. This requires quotes to be tracked consistently with a status in the CRM or ERP.
- Revenue per customer and customer concentration: what share of revenue comes from your largest customers? High concentration is a risk that gets lost in many reports.
- Repeat purchase rate: share of customers who order again within a defined period. It is especially meaningful in retail and for consumables.
Operations and inventory
For manufacturers and distributors, operational KPIs are often more important than pure financial figures because they flag problems earlier.
- On-time delivery: share of deliveries that reach the customer on the promised date. A clear definition is essential, for example whether one day late already counts.
- Inventory turnover: cost of goods sold / average inventory. A low value means capital is tied up in stock.
- Days of supply: how many days current stock lasts at average consumption. This metric supports purchasing decisions.
- Complaint rate: number of complaints / number of deliveries or orders.
People
- Personnel cost ratio: personnel costs / revenue. It shows how costs and revenue develop relative to each other.
- Sickness rate: sick days / scheduled working days, usually viewed monthly and year on year.
- Staff turnover: number of leavers / average headcount in the period.
HR metrics often contain sensitive data. Show them in aggregated form and set appropriate access rights in the dashboard so that no conclusions about individuals are possible.
How to measure KPIs reliably
Definition before visualisation
The most common mistake is to start with charts. First define for each KPI: name, formula, data source, refresh rhythm, target and owner. A metric sheet like this prevents later debates about why sales has different figures from accounting.
One shared data foundation
If KPIs are calculated in different Excel files, they will diverge sooner or later. A central data model in a BI tool such as Power BI or Metabase ensures that each metric is defined once and is identical in every report.
Always show a comparison
A number on its own says little. Show at least one comparison for each KPI: previous month, same month last year or target. Simple colour coding (on target, close, off target) helps you see at a glance where action is needed.
Set a rhythm
Not every KPI needs daily updates. Cash and order intake often make sense weekly, margins and HR metrics monthly. What matters is that the figures are tied to fixed meetings, such as the monthly management review.
Common mistakes when choosing KPIs
- Only lagging indicators: revenue and profit show what has already happened. Add leading indicators such as order intake, quote volume or on-time delivery so you can react in time.
- Averages without distribution: an average margin of 30 percent can hide both good and very poor orders. For important KPIs, look at the breakdown too.
- Metrics without consequences: if nobody reacts when a KPI leaves its target range, you can drop it. Define who checks what when deviations occur.
- Too many goals at once: pursuing revenue growth, maximum margin and minimum inventory at the same time creates conflicting targets. Prioritise deliberately.
- Metrics that can be gamed: if you only measure the number of quotes, it will rise without producing more orders. Combine volume with success.
Checklist: your KPI set in six steps
- Write down the three to five most important business goals for the current year.
- Choose one to three KPIs per goal that measure progress.
- Create a metric sheet for each KPI: formula, source, rhythm, target, owner.
- Check whether the required data is complete in your ERP, CRM, accounting or payroll systems.
- Build a first dashboard with no more than twelve KPIs and comparison values.
- Review after three months: which KPIs are used, which can be dropped?
How Simplify Data can help
Simplify Data helps mid-sized companies define metrics and implement them in dashboards with Power BI or Metabase. We connect your data sources and build a data model that every department can rely on. Find out more on our Business Analytics page.
