# How to Set KPIs: A 7-Step Method from Business Goals to Measurable Indicators

> How to set KPIs that drive decisions: a 7-step method, leading and lagging indicator examples and a KPI definition card with owner, target and threshold.

Source: https://digitalbridge.com.tr/en/blog/how-to-set-kpis.html
Publisher: Digital Bridge Teknoloji (https://digitalbridge.com.tr)
Topic: Data & Analytics
Published: 2026-10-06 · Updated: 2026-10-30

A [KPI (key performance indicator)](https://digitalbridge.com.tr/en/glossary.html#kpi) is a measure of progress towards one business goal, with a written calculation rule, an owner, a target and a threshold. To set KPIs, start from the goal rather than the data: pick one lagging indicator for the result and one or two leading indicators that signal it early, each tied to a definition card.

## Key takeaways

- A KPI is a metric tied to a goal, with a written formula, data source, owner, target and threshold.
- Setting KPIs takes seven steps: goal, lagging indicator, leading indicators, definition card, threshold, automatic calculation and quarterly review.
- For most companies, three to five goals and 6–12 KPIs are enough on the executive view.
- Every KPI linked to pay should be balanced by a quality measure that discourages gaming, such as error rate alongside speed.
- TurkStat's 2025 survey found only 6.5% of Turkish enterprises with 10+ employees used business intelligence (BI) software; most KPIs still live in spreadsheets.

## Why is tracking too many indicators a KPI problem?

In many companies the KPI problem starts with measuring too much: the monthly management pack runs to dozens of lines: revenue, order count, customer numbers, stock, collections, scrap, returns, absenteeism, website visits. Each one measures something, but none is tied to a decision. The meeting notes that "sales are down" and moves on to the next line without discussing why, or who will do what.

The second common problem is that the same indicator is calculated differently in each department. Sales counts revenue by order date, accounting by invoice date, and finance nets off returns. Half the management meeting goes on arguing which number is right. The third is that the KPI has no owner: when it turns red, nobody is clearly responsible for acting.

## What do wrong or undefined KPIs cost a business?

A wrong indicator does not just waste time; it lets you make the wrong decision with confidence. Data quality expert Thomas C. Redman, writing in [MIT Sloan Management Review in 2017](https://sloanreview.mit.edu/article/seizing-opportunity-in-data-quality/), estimates the cost of bad data at 15% to 25% of revenue for most companies. That is an expert estimate rather than a measured statistic, but it shows that vaguely defined KPIs, hand-stitched spreadsheets and calculation rules that change from team to team carry a real price.

Measurement that is not tied to a goal is also a recurring issue in large digital transformation programmes:

> [BCG's 2020 research on digital transformation](https://www.bcg.com/publications/2020/increasing-odds-of-success-in-digital-transformation) found that 70% of digital transformations fall short of their objectives; only 30% met or exceeded their target value and produced sustainable change.

A project that does not define measurable goals at the start cannot say at the end whether it succeeded; we apply the same principle to AI investments in [measuring AI project ROI](https://digitalbridge.com.tr/en/blog/measuring-ai-project-roi.html).

In Türkiye, the KPI gap is often the measurement infrastructure itself: according to the [Turkish Statistical Institute's (TurkStat) 2025 survey on ICT usage in enterprises](https://veriportali.tuik.gov.tr/en/press/54012), only 6.5% of Turkish enterprises with 10 or more employees used business intelligence (BI) software, falling to 4.9% among those with 10–49 employees. For most smaller firms, KPIs still live in manually prepared spreadsheets.

## How to set KPIs in seven steps

1. **Write the goal in one sentence.** "Grow" is not a goal; "increase repeat-order revenue from existing customers this year" is. Three to five goals per period is plenty; if everything is a priority, nothing is.
2. **Choose one outcome measure per goal.** This is the lagging indicator; it tells you whether the goal was reached (for example, repeat-order revenue as a share of total revenue). It is confirmed at month end and describes the past.
3. **Add one or two leading indicators.** A leading indicator is a behaviour that drives the lagging one and can be measured more often: customers with no order in 60 days, quotes issued, [quote conversion rate](https://digitalbridge.com.tr/en/blog/crm-sales-pipeline-guide.html). The chance to intervene lives in the leading indicator. We explain how to spot customers whose order frequency is falling in [customer churn analysis](https://digitalbridge.com.tr/en/blog/customer-churn-analysis-b2b.html).
4. **Fill in a definition card.** For each KPI, write the formula, the data source (which field in which system), what is included and excluded (returns, cancellations, intercompany sales), update frequency and owner. An indicator without a definition card is not a KPI.
5. **Set a target and a threshold.** Use past data to set a realistic target and a "red" threshold. Also write down who does what, and how quickly, when the threshold is crossed.
6. **Calculate automatically, with one rule.** Recalculating a KPI by hand every month lets the definition drift. The indicator should be computed straight from the source system, following the definition card. For KPIs fed by several systems, that single rule usually lives in a [data warehouse and ETL process](https://digitalbridge.com.tr/en/blog/data-warehouse-etl-guide.html).
7. **Review quarterly.** Drop indicators that nobody looks at, that never lead to a decision or that are being gamed. If the goal changes, the KPI should change too.

### Examples of leading and lagging indicators

| Goal | Lagging indicator (outcome) | Leading indicator (early signal) | Owner |
|---|---|---|---|
| Grow repeat business | Share of revenue from repeat orders | Customers with no order in 60 days | Sales manager |
| Improve cash flow | Average collection period | Receivables falling due within 7 days | Finance manager |
| Raise production efficiency | [OEE](https://digitalbridge.com.tr/en/glossary.html#oee) (Overall Equipment Effectiveness) | Unplanned downtime minutes per shift | Production manager |
| Customer satisfaction | Complaint rate | First response time | Customer service |
| Reduce stock cost | Inventory turnover | Value of stock with no movement in 90 days | Supply chain |

To expand the sales and customer rows of the table, see [sales dashboard metrics](https://digitalbridge.com.tr/en/blog/sales-dashboard-metrics.html) for an indicator set built for sales teams, and [how to measure NPS](https://digitalbridge.com.tr/en/blog/net-promoter-score-nps-guide.html) for tracking customer satisfaction with a single number, the Net Promoter Score.

The same logic applies to sector-specific indicators. In manufacturing the most common outcome measure is OEE; splitting it into availability, performance and quality shows which loss to tackle first ([how to calculate OEE](https://digitalbridge.com.tr/en/blog/how-to-calculate-oee.html)). In energy-intensive plants, energy consumed per unit produced is tracked instead of the total bill, because it strips out changes in output volume; we cover the metering side in [factory energy monitoring](https://digitalbridge.com.tr/en/blog/factory-energy-monitoring.html).

### A checklist for a good KPI

Before adding an indicator to your KPI list, ask these six questions:

1. Is it tied to a goal?
2. Will someone do something differently when it moves?
3. Are its formula and data source written down?
4. Does it have an owner?
5. Can it be calculated automatically from the source system?
6. Is it balanced against gaming? If you only count "tickets closed", tickets may be closed unresolved, which is why [call centre speech analytics](https://digitalbridge.com.tr/en/blog/call-centre-speech-analytics.html) measures quality as well as speed.

If any answer is no, fix the indicator or remove it from the list.

### Cascading company KPIs to departments

If the KPIs on the executive screen are not linked to departments' daily work, teams invent their own measures and coherence is lost. A KPI tree prevents this: the company goal and its lagging indicator at the top, the departmental measures that drive it below, and at the bottom the leading indicators teams can influence week by week. "Average collection period", for example, breaks down into "share of orders written on standard payment terms" for sales and "share of receivables due within 7 days that received a reminder" for finance.

In a KPI tree, each sub-indicator has its own definition card and owner. A department head can then see how improving their own measure contributes to the company goal, and management can trace which branch is feeding a KPI that has turned red. A practical way to present project indicators to management on a single page is a [weekly project status report](https://digitalbridge.com.tr/en/blog/project-status-report-guide.html).

## What are the most common KPI mistakes?

**Vanity metrics.** Website visitors, follower counts or total registered customers feel good when they rise but lead to no decision on their own. They only become useful when linked to a conversion or revenue measure.

**Tracking only lagging indicators.** Management that watches only revenue and profit learns about problems after the month has closed. Without leading indicators, a KPI system becomes a rear-view mirror. And the work does not end when a KPI turns red: in production, the "why" is answered by [root cause analysis with manufacturing data](https://digitalbridge.com.tr/en/blog/manufacturing-data-analytics-root-cause.html).

**Turning the measure into the target.** When an indicator is tied directly to bonuses or penalties, teams find shortcuts to improve the number. Every KPI linked to pay should be paired with a balancing quality measure, such as error rate alongside speed.

**Not writing the definition down.** Everyone assumes "revenue" means the same thing; until returns, discounts and intercompany sales are settled in writing, the same KPI will show two different numbers in two reports. Keep definition cards in one place with version history rather than in email attachments: in SmartFiles, part of Digital Bridge's [Smart360](https://digitalbridge.com.tr/en/smart360.html) family, every file uploaded to the same folder under the same name is saved as a new version, and earlier versions can be downloaded or restored, so you can see when a definition changed.

Once your KPIs are set, our guide to [building a management dashboard](https://digitalbridge.com.tr/en/blog/bi-dashboard-kpis.html) covers how to bring them together on one screen, and [moving from Excel reports to BI](https://digitalbridge.com.tr/en/blog/from-excel-reports-to-bi.html) covers the switch from hand-built spreadsheets to automated reporting. Data warehousing, GIS and other topics are gathered in [our Data & Analytics guide](https://digitalbridge.com.tr/en/blog/topic/veri.html).

## How we build KPI systems at Digital Bridge

At Digital Bridge, we do not hand over a list of KPIs and walk away; we make sure the indicators are calculated automatically, from the source systems, with one rule. A typical engagement looks like this:

- **Goals and KPI workshop.** With your management team we choose the period's three to five goals and the lagging and leading indicators for each, and fill in the definition cards. This often sits within our [digital transformation consultancy](https://digitalbridge.com.tr/en/consultancy/digital-transformation-consultancy.html), alongside your wider roadmap.
- **Mapping data sources.** We work out which field in which system feeds each indicator: ERP (enterprise resource planning) systems such as Logo, SAP and Mikro, CRM (customer relationship management), production and e-commerce systems. Missing or conflicting data is fixed at source through [data governance and quality](https://digitalbridge.com.tr/en/data-analytics/data-governance-quality.html) work.
- **One place to calculate.** Where data comes from several systems, we consolidate it in a [data warehouse](https://digitalbridge.com.tr/en/data-analytics/data-warehouse.html) and calculate each KPI once, following its definition card, so everyone sees the same number.
- **Executive dashboard.** We present the indicators on a [BI dashboard](https://digitalbridge.com.tr/en/data-analytics/bi-dashboard.html) built for your business, with threshold alerts and drill-down to invoice or work-order level. For production KPIs, the dashboard can connect directly to [MES (manufacturing execution system)](https://digitalbridge.com.tr/en/industry-40/mes-production-management.html) data.
- **Review rhythm.** After the first three months we look together at which indicators led to decisions and which did not, and we simplify the list.

Scope, phases and cost are set out in a written proposal after the needs analysis.

## Next step

Open your latest management report and write two notes next to each line: which goal is this indicator tied to, and what decision was made last month by looking at it? The lines where both notes stay blank show where your KPI set needs trimming. Then [get in touch](https://digitalbridge.com.tr/en/contact.html) and we will review your goals and data sources together and draft your first KPI set, complete with definition cards.

## Frequently Asked Questions

### How many KPIs should a company track?

There is no single number, but at management level it should fit on one screen. Three to five goals per period, each with one lagging and one or two leading indicators, means roughly 6–12 KPIs on the executive view for most companies. Departments can track more detailed measures below that.

### What is the difference between a KPI and a metric?

Every KPI is a metric, but not every metric is a KPI. A metric is any measurable value; a KPI is a metric tied to a goal, with a definition, an owner, a target and a threshold. Website visitors, for example, are a metric; they become a KPI once linked to a goal such as "grow sales from online enquiries this year", with an owner and a threshold.

### What is the difference between leading and lagging indicators?

A lagging indicator measures the result and tells you whether the goal was reached once the period has closed, such as collection period or the share of revenue from repeat orders. A leading indicator is a behaviour that drives that result and can be measured more often, such as receivables falling due. The lagging indicator describes the past; the leading one gives you a chance to act before the result is final.

### How do I find a good leading indicator?

List the behaviours that drive the lagging indicator and pick one that can be measured more often and that the team can directly influence. Then check with a few periods of data whether changes in it really do signal the outcome in advance. For collection period, receivables falling due soon are a good candidate; for repeat sales, customers with no order in 60 days.

### How often should KPIs change?

Definitions should rarely change, or periods become impossible to compare. The list itself should be reviewed quarterly, and indicators replaced when the goal changes, when they lead to no decisions or when teams start gaming them. When a definition does change, record the date on the definition card and, where possible, recalculate past periods under the new rule.

### Is tracking KPIs in Excel enough?

It can be to start with. But spreadsheets merged by hand from several sources inevitably suffer from broken formulas, competing versions and delays. Once the indicators are agreed, moving them to a dashboard calculated automatically from source systems keeps the definitions intact and removes the days of manual consolidation that the person preparing the report spends every month.

### How do SMART criteria help when setting KPIs?

SMART (Specific, Measurable, Achievable, Relevant, Time-bound) is a check for writing goals. When setting KPIs, write the goal to those five criteria first, then add the KPI definition card: formula, data source, owner, target and threshold. SMART makes the goal clear; the definition card makes sure the indicator is calculated with the same rule every month.
