KPIs that compute themselves from real work — not scores typed at month end
We design indicators tied to the data your business already creates every day — invoices, job tickets, stock, service work — and present them as company, team, and individual KPI dashboards everyone reads the same way.
- 3 levels
- company, team, and individual on one data set
- Automatic
- values computed from systems, not entered later
- Weekly
- see the trend mid-cycle, while it can still change
- 5-7
- the KPI count most organizations start well with
The short answer
How is a real KPI dashboard different from a KPI spreadsheet?
A KPI spreadsheet asks each team to type in scores monthly, so numbers arrive late and depend on who filled them in. A working KPI dashboard computes each value from data your systems already produce — invoices, job tickets, stock movements — so everyone sees one continuous set of numbers and knows by mid-month which KPI is drifting off target.
Key facts
- A usable KPI has an owner, a target, a measurement cycle, and a named data source
- Values are computed from live system data, not scores entered after the fact
- Split across three levels: company, team, and individual
- Most organizations start well with five to seven KPIs, then add more as data matures
Last reviewed:
KPI structure
KPIs should connect company goals down to daily work
When every level reads one data set, meetings become decisions instead of debates about whose number is right.
Company level
The few indicators that describe business health — revenue, gross margin, cash flow, customer growth.
Team and department level
Indicators each team genuinely controls, that ladder up to the company goal.
Individual level
Indicators that stay fair because they compute from recorded work, not a manager's impression.
Review cycle
Each indicator gets the cadence it deserves — some weekly, some quarterly — and a named owner.
KPI examples by department
KPI examples that genuinely pull from systems
Every one of these computes from data most businesses already hold.
Close rate and average deal value
From recorded quotations and invoices — both the volume and the quality of deals.
Cost per new customer (CAC)
Ad spend against new customers closed in the same window, per channel.
Stock turnover and dead stock
From stock movements — which categories your cash is sitting in.
Scrap per run and capacity used
From per-lot production records, for staffing and maintenance decisions.
Response and resolution time
From job tickets or the repair system — where service work bottlenecks.
Receivables aging and overdue balance
From billing and receipts — how fast sales turn into cash.
Turnover rate and overtime hours
From time clock and employee data — an early signal of uneven workload.
Repeat rate and lifetime value
From purchase history, to decide between acquiring and retaining.
Try it
How each KPI ladders back to the company goal
Explore the structure from company target down to the indicators each team controls.
Goal
Grow with profit
Then act
Decide
KPI principles
The rules we set KPIs by
A well-set KPI focuses a team; a badly set one changes behaviour in ways nobody intended.
Get a free KPI assessmentMeasure what the team controls
An indicator should sit inside the decision-making power of whoever is measured, or nobody will own it.
Pair counterbalancing metrics
Speed with quality, revenue with margin — so chasing one number cannot quietly damage another.
Name every data source
If you cannot say where a value comes from, it is not ready to be a KPI. Keep it as a qualitative goal for now.
Start small, then extend
Five to seven KPIs everyone remembers beat twenty that nobody opens.
KPIs that live only in a spreadsheet
- Collected and retyped at every month end
- Each team calculates with its own formula
- Results arrive after the cycle closes, too late to act
- Meetings spend most of their time verifying numbers
KPIs connected to live systems
- Values refresh daily from already-recorded data
- Every team shares one formula and definition
- Trends visible mid-cycle, while plans can still change
- Meetings start from numbers everyone agrees on
How we implement
How we implement a KPI system
We start with what is genuinely measurable today, then extend as data matures.
- 01
Agree this year's goals
Sit with leadership on the outcomes that matter this year, then pick indicators that truly reflect them.
- 02
Check the data exists
For each candidate, confirm which system it comes from. Where it does not exist, we propose capture that adds no busywork.
- 03
Define formula and cycle
Every KPI gets its formula, conditions, and cadence written down, so nobody reinterprets it later.
- 04
Build dashboard and access
Screens designed per role, with explicit rules about who sees which level of detail.
- 05
Review after one full cycle
After one cycle we review together: which KPIs changed behaviour, and which need adjusting.
More in the dashboard family
Related dashboards
A KPI system works best on data that is already connected.
SME dashboard — the whole business
One owner screen for sales, stock, profit, and team.
Sales dashboard
Daily sales vs target, branch comparison, and margin per product.
Turn Google Sheets into a dashboard
Use the files your team already fills in as the starting point for live KPIs.
A Power BI / Looker Studio alternative
Off-the-shelf BI compared fairly against a purpose-built dashboard.
Payroll & HR system
Time and employee data that people KPIs can be computed from.
Data Dashboard & Analytics service
The full data service, from connecting sources to deeper analysis.
FAQ
KPI system FAQ
What executives ask before starting.
How many KPIs should an SME have?
Most organizations start well with five to seven company-level KPIs plus three to five per team. The right number is the number people can recall without opening a document. Beyond that, the usual outcome is that nobody looks at any of them.
What is the difference between KPIs and OKRs, and which should we use?
KPIs are indicators tracked continuously to show the health of ongoing work. OKRs are a goal-setting framework used in cycles to drive change. Most SMEs should stabilise KPIs on routine work first, then add OKRs once the habit of reviewing numbers exists.
Can we start KPIs without an ERP or CRM?
Yes. Many businesses start from what they have — sales files in Google Sheets, a time clock, a storefront POS. We choose the first KPI set from data that can genuinely be pulled today, and extend the indicators as you add systems later.
How do we stop KPIs from being gamed?
The reliable method is pairing counterbalancing metrics: jobs closed alongside rework rate, or revenue alongside margin and return rate. When metrics are paired, pushing one number while neglecting quality shows up immediately on the dashboard.
Will individual KPI data be visible company-wide?
No. Access is set by role. Typically a staff member sees their own figures and the team average, a manager sees individuals within their team, and leadership sees the overview. This is configured during implementation and can be adjusted later.
How long until we see the first KPI set?
If the data already sits in systems we can read, the first set usually takes a few weeks. Where new capture has to begin, it depends on your business cycle, since a trend needs enough data to be visible. We give a firm timeline after reviewing the real sources.
Learn more
Related articles
The KPIs an SME Owner Should Actually Track
There are hundreds of KPIs, but only a few that matter. Here are the ones worth tracking, how to read them, and leading versus lagging.
The Budget Was Set in January and Never Opened Again — A 45-Minute Review That Works
A budget without a review cycle is an intention, not a control. Split variance into price and volume, set the threshold for what needs explaining, and run a review that finishes in 45 minutes.
The KPI You Have Been Measuring Wrong All Along
When we measure the easy thing instead of the right thing, the numbers quietly steer our decisions off course.
OKR vs KPI: What Is the Difference and Which Should an SME Use
Many people think OKR and KPI are the same. In truth they do different jobs. This guide explains the difference with real examples for small teams, plus a checklist and common mistakes.
From the Owner's Profit Goal to Each Team's Weekly Number: Cascading a Target in Layers So Everyone Knows Exactly What to Move
An annual target announced at the party after which nothing changes does not mean the team refused it — it means the goal was never translated into work. This piece teaches cascading a profit goal through a driver tree — profit = revenue × margin − fixed costs — with a worked example breaking a +1M target down to weekly numbers for sales, purchasing, and the storefront, and the review rhythm that keeps the goal alive past mid-year.
The North Star Metric: One Number the Whole Team Rallies Around
When each team chases its own number, the organization pulls in different directions. A North Star metric is the single number reflecting the value customers truly get, aligning every team. Understand how to choose it well.
Make KPIs a management tool, not a month-end paperwork exercise
Send us the KPI list you use today. We'll tell you which ones can be pulled from systems now, which need new capture, and which set to start with.
Chiang Mai team — we start with the few KPIs that are genuinely measurable, then grow.