KPI Framework for Swedish Companies – Define and Track the Right Key Figures in 2026

Your dashboard has 47 key figures. Nobody looks at them. Or you have three KPIs that everyone checks – but nobody knows what to do about the numbers. This is Sweden’s most common BI problem. Here is the solution.

At Excel Department we have built KPI dashboards for 60+ Swedish companies. We have seen everything from “measure everything that can be measured” to “we measure nothing”. Companies that succeed have one thing in common: they have defined the right KPIs and tied them to actual decisions and actions.

This guide does not present theoretical frameworks from American MBA programmes. It shows what actually works in Swedish mid-sized companies.

What makes a good KPI?

KPI stands for Key Performance Indicator. But what turns an indicator into a key indicator?

The four criteria for a good KPI

1. Influenceable If you cannot do anything about the number, it is not a useful KPI.

Bad example: “Share price” for a listed company – You cannot directly influence it – Too many external factors

Good example: “Sales growth per quarter” – Directly influenceable through marketing, sales efforts, product development

2. Linked to goals Every KPI should link to a specific business goal.

Bad example: “Number of LinkedIn followers” – Nice to know, but does it link to revenue or profitability?

Good example: “Leads from LinkedIn per month” – If the goal is lead generation, this is linked

3. Measurable and verifiable You must be able to measure it consistently without subjectivity.

Bad example: “Customer satisfaction” (without a definition) – What does satisfied mean? Who judges?

Good example: “Net Promoter Score (NPS) from a quarterly survey” – Clear methodology, objective measurement

4. Easy to understand If the CEO and the intern cannot explain the KPI in the same way, it is too complex.

Bad example: “EBITDA-adjusted rolling 12-month average customer profitability excl. one-off costs” – Nobody will remember what it means

Good example: “Average order value” – Everyone understands it immediately

Three types of KPIs

Most companies need a balance between these three:

Lagging indicators (Trailing) – Show the results of actions – Historical measures – Examples: Revenue, profit, number of customers

Leading indicators – Predict future results – Early warning signals – Examples: Number of leads, customer meetings, ongoing negotiations

Diagnostic indicators – Help understand why results turn out the way they do – Explanatory measures – Examples: Conversion rate, average order value, customer acquisition cost

Balanced mix: A sales team needs all three: – Lagging: Revenue (what was the result?) – Leading: Number of qualified leads (what can we expect?) – Diagnostic: Conversion rate (why do we win/lose?)

Common KPI mistakes that cost money

We have seen these mistakes a hundred times. They are expensive.

Mistake 1: Too many KPIs

“We measure 50 different things every month.”

The problem: When everything is important, nothing is important. Nobody can focus.

Reality: The brain can keep track of 3-7 things. If you have 50 KPIs, people look at 3-5 of them and ignore the rest.

Solution: Max 5-7 KPIs per level/department. – Company level: 5-7 KPIs – Department level: 5-7 KPIs – Team level: 5-7 KPIs

Example from a real client: They had 42 KPIs in their monthly report. We asked: “Which five do you actually look at and base decisions on?” The answer: Sales, margin, cash flow, customer satisfaction, staff turnover.

We restructured around these five. The rest became “supporting information” available when needed but not in focus.

Mistake 2: Measuring activity instead of results

“Number of sales calls per day” is not a goal in itself.

The problem: You optimise for activity, not outcome.

Example: A sales team is measured on the number of calls. Result: 100 pointless calls to the wrong people instead of 10 quality calls to decision-makers.

Solution: Measure results, not just activity. – Instead of “number of calls” → “number of qualified leads” – Instead of “number of products” → “revenue per product category” – Instead of “number of marketing activities” → “cost per lead”

Mistake 3: Nobody owns the KPIs

“Who is responsible for improving customer satisfaction?” – “Um, everyone?”

The problem: When nobody owns the KPI, nobody does anything about it.

Solution: Every KPI has a clear owner who: – Is responsible for measuring it correctly – Explains deviations – Drives actions when the KPI moves in the wrong direction

Example from a manufacturing company: – Production costs → Production manager – Quality deviations → Quality manager – Delivery precision → Logistics manager – Customer satisfaction → CEO (too important to delegate)

Mistake 4: KPIs without target values or thresholds

“Our customer satisfaction is 7.8.” – “Is that good?” – “No idea.”

The problem: Numbers without context are meaningless.

Solution: Every KPI needs: – Target value: What are we aiming for? – Thresholds: When is it acceptable? When is it a crisis? – Reference point: How was it last period? What is the industry average?

Example: Customer satisfaction (NPS) – Green: >40 (Excellent) – Yellow: 20-40 (OK, can be improved) – Red: <20 (Urgent need for improvement) – Target: 45 by the end of the year – Previous quarter: 38

Now the number has meaning.

Mistake 5: Set-and-forget

“We defined KPIs three years ago.”

The problem: The business evolves, the strategy changes, but the KPIs stay.

Solution: A quarterly review: – Are these still the right KPIs? – Do they drive the right behaviours? – Do we need to add/remove/change any?

KPI framework: From strategy to measurement

The right KPIs don’t start with “what can we measure?” but with “what do we want to achieve?”.

Step 1: Define business goals (Strategic level)

Question: What should the company achieve over the next 1-3 years?

Examples: – Grow revenue from 50 to 80 million in 2 years – Improve margin from 18% to 25% – Expand to Norway – Increase customer satisfaction and retention

Step 2: Break down into drivers

Question: What has to happen for us to reach the goals?

Examples for a revenue goal (SEK 50 → 80 million): – More customers: From 200 to 300 customers (+50%) – Higher order value: From SEK 50,000 to SEK 60,000 – Increased repurchase frequency: From 2 to 2.5 times per year

Step 3: Identify measurable KPIs

Question: How do we measure progress towards the drivers?

Examples: – Goal: More customers – Lagging KPI: Number of active customers – Leading KPI: New customers per month – Diagnostic KPI: Conversion rate lead → customer

Goal: Higher order value
- Lagging KPI: Average order value
- Leading KPI: Number of cross-sell offers
- Diagnostic KPI: Cross-sell conversion
Goal: Increased repurchases
- Lagging KPI: Average purchases per customer per year
- Leading KPI: Customer engagement (e.g. login frequency, email open rate)
- Diagnostic KPI: Customer satisfaction (NPS)

Step 4: Set target values and owners

Define for each KPI: – Current state: Where are we now? – Target: Where should we be? – When: What time horizon? – Owner: Who is responsible?

Example:

KPI	Current state	Target	Deadline	Owner
New customers/month	8	12	Dec 2026	Sales manager
Conversion rate	15 %	20 %	Jun 2026	Marketing manager
Average order value	50k	60k	Dec 2026	Product manager
NPS	38	45	Dec 2026	CEO

Step 5: Build the dashboard and routines

Dashboard design: – Show KPIs with current state, target and trend – Colour coding (green/yellow/red) for a quick overview – Ability to drill down into details

Routines: – Weekly: The sales manager looks at lead flow and conversion – Monthly: The management team reviews all KPIs – Quarterly: Evaluate whether the KPIs are still right

KPI examples by industry/function

The right KPIs vary between industries. Here are proven examples.

Sales

Basic level: – Revenue (per month/quarter) – Number of new customers – Average order value

Advanced level: – Conversion rate per sales stage – Length of the sales cycle – Win rate (won vs lost deals) – Pipeline value

Finance

Basic level: – Revenue – Gross margin – Cash flow – Profitability (EBIT/EBITDA)

Advanced level: – Working capital – DSO (Days Sales Outstanding – accounts receivable) – DPO (Days Payable Outstanding – accounts payable) – Profitability per product/customer/project

Production/Operations

Basic level: – Production volume – Production cost per unit – Delivery precision – Quality deviations

Advanced level: – OEE (Overall Equipment Effectiveness) – Downtime – First-time-right (share without rework) – Inventory turnover

Marketing

Basic level: – Leads per month – Cost per lead – Website traffic – Website conversion rate

Advanced level: – Marketing Qualified Leads (MQL) – Customer Acquisition Cost (CAC) – Return on Ad Spend (ROAS) – Customer Lifetime Value (CLV)

HR/Personnel

Basic level: – Staff turnover – Sick leave – Number of employees

Advanced level: – Time to hire – Cost per recruitment – Engagement score – Retention rate per department

Next steps – Define your KPIs

How do you get from “we should have better KPIs” to actual implementation?

Week 1: Workshop with the management team (2-4 hours)

Agenda: 1. What are our most important business goals? (30 min) 2. What drives these goals? (30 min) 3. How do we measure progress? (60 min) 4. Which KPIs should we focus on? (30 min) 5. Who owns what? (30 min)

Output: – 5-7 company KPIs – 5-7 KPIs per department – Clear ownership responsibilities – Target values and deadlines

Weeks 2-3: Data inventory

Questions: – Where is the data for our KPIs? – Can we measure them today or do we need new systems? – What is the data quality like?

Output: – A documented data source for each KPI – Identified gaps – A plan to close the gaps

Week 4: Build the first dashboard

Start simple. One dashboard with 5-7 KPIs.

Tools: – Excel with Power Query (works for many) – Power BI (if the data is larger or there are many users)

Content: – Each KPI is shown with current state, target, trend – Colour coding for a quick overview – Ability to see details

Monthly: Review and adjust

Agenda for the monthly meeting: 1. Go through each KPI (10 min) 2. Green: All good, carry on 3. Yellow: What are we doing to improve? 4. Red: Urgent action plan 5. Do we need to adjust any KPIs?

Quarterly: Evaluate the framework

Questions: – Do our KPIs drive the right behaviours? – Has the strategy changed so that the KPIs should change? – Are we missing important measures? – Are we measuring something that is no longer relevant?

Need help?

Excel Department helps Swedish companies define and implement KPI frameworks.

Our approach: 1. Workshop with management – define strategy and KPIs 2. Data inventory – map what exists and what is needed 3. Dashboard design and implementation 4. Training for owners and users 5. Follow-up and adjustment

Book a free KPI workshop (2 hours)

Summary

The right KPIs drive the right behaviours and the right decisions. The wrong KPIs create confusion and waste.

Rules for good KPIs: – Max 5-7 per level (company, department, team) – Linked to strategy and goals – Influenceable and measurable – Clear owners – Target values and thresholds defined – Regular follow-up and adjustment

Start here: 1. Workshop: Define strategy → drivers → KPIs 2. Take inventory of data: Can we measure what we want? 3. Build a dashboard: Start simple with 5-7 KPIs 4. Implement routines: Monthly follow-up 5. Evaluate: Quarterly review of the framework

KPIs are not something you define once. They evolve with the business.

What are your five most important KPIs right now? If you cannot answer straight away, it is time to define them.

Related guides: – Business intelligence for mid-sized companies – Overall BI strategy – Data-driven decisions – Creating a data culture – 5 Power BI dashboards every CFO needs – Concrete KPI examples

Need help with this? Our Excel courses will help you – the first consultation is free of charge.

Book a free call or phone 010-264 20 20.