A KPI dashboard is one page that shows the handful of numbers that tell you whether your business is on track, such as revenue, pipeline, cash and conversion, each compared with a target or last period. A good one answers "are we OK this week?" in under a minute. A bad one has 30 charts and answers nothing.
This guide covers what a KPI dashboard is, how to choose the KPIs (leading vs lagging, and why seven is the limit), eight KPI dashboard examples for sales, finance, marketing, ecommerce and operations, layout rules, KPI dashboard software, and how to build one from a CSV export. We make one of the tools mentioned, the KissMySkills AI Dashboard. We say where it fits and where it does not.
What a KPI dashboard is
KPI stands for key performance indicator: a number that shows progress toward a goal. A KPI dashboard puts those numbers on one screen, usually as:
- KPI tiles: one big number, such as "Revenue this month: $48,200", with the change against last month or target.
- Trend lines: the same number over the last 12 weeks or months, so you can see direction, not just a snapshot.
- Breakdowns: a bar chart that splits the number by channel, product, region or rep.
What characterises a KPI dashboard, compared with a general report, is focus. Every number on it is tied to a goal, has an owner, and is reviewed on a schedule. If nobody would act when a number changes, it does not belong on the dashboard.
A KPI tracker is the simpler cousin: a spreadsheet with one row per KPI and one column per week. Many small businesses start with a tracker and turn it into a dashboard once the list settles.
Choosing KPIs: leading vs lagging, the 7-metric rule
Leading vs lagging
Lagging KPIs tell you what already happened: revenue, profit, churn, customers won. They are the results you care about, but by the time they move, it is too late to change this month.
Leading KPIs move first and predict the lagging ones: qualified leads, quotes sent, website conversion rate, demos booked, average response time. You can act on them this week.
A useful dashboard pairs them. If revenue is the lagging KPI, quotes sent and win rate are the leading ones that explain it.
The 7-metric rule
Keep each dashboard to seven KPIs or fewer. People can hold about that many numbers in their head during a meeting. Past that, the dashboard turns into a report and nobody reads it. If you have more than seven, you have more than one audience: split it into a company dashboard and team dashboards.
A quick test for each KPI:
- Does it tie to a goal we have written down?
- Does someone own it?
- Would we do something different if it moved 10%?
Three yeses and it stays. Otherwise it goes in a report, not the dashboard.
A worked example
Say you run a 6-person kitchen remodelling company. The owner's goal is $1.2 million in signed jobs this year with a healthy margin. A first draft of KPIs might list 15 things: website visits, Instagram followers, calls, quotes, jobs signed, revenue, margin, crew hours, material costs, reviews and more. Apply the test and it shrinks to seven:
- Signed job value this month vs target (lagging)
- Gross margin on completed jobs (lagging)
- New qualified inquiries (leading)
- Quotes sent within 48 hours of the site visit (leading)
- Quote win rate (leading)
- Jobs finished on schedule (operations)
- Cash in bank vs 8 weeks of costs (finance)
Instagram followers and website visits did not survive: nobody would change a decision if they moved 10%. They can live in a marketing report.
KPI dashboard examples
Here are eight dashboard examples you can copy. Each lists the core KPIs, where the data usually comes from, and how often it needs to refresh.
Sales KPI dashboard
The sales dashboard most small teams need shows pipeline health and results together.
- Lagging: revenue closed this month vs target, deals won.
- Leading: new qualified leads, pipeline value by stage, win rate, average deal size, average days to close.
Source: your CRM export. For forecasting on top of this, see how to use Claude for sales forecasting.
Sales rep dashboard
The same KPIs split by rep: calls or emails, meetings booked, deals won, revenue vs quota. Useful for coaching, but be careful: people will game whatever activity you count.
Financial dashboard
- Revenue and gross margin vs last month and budget.
- Operating expenses by category.
- Cash in bank and runway in months.
- Accounts receivable and days sales outstanding.
Source: accounting software export. For a deeper look at using AI on finance, see our piece on the AI CFO agent.
Cash flow dashboard
A narrower financial dashboard for businesses where cash is tight: cash in, cash out, net cash by week, and the next 8 weeks of expected payments and receipts.
Marketing dashboard
- Sessions and conversion rate by channel.
- Leads or sign-ups, and cost per lead.
- Ad spend and return on ad spend.
- Email list growth.
Source: GA4, ad platforms, email tool. Our guide to AI marketing analytics covers how to cut this down to what matters.
Ecommerce dashboard
- Revenue, orders and average order value.
- Conversion rate and returning customer rate.
- Top products by revenue.
- Refund rate.
Source: Shopify or another store platform's orders export.
Operations dashboard
- Orders or jobs completed on time.
- Average lead time or turnaround.
- Backlog size.
- Defect, rework or complaint rate.
Source: job tracker, ERP or a shared spreadsheet.
Customer support dashboard
First response time, resolution time, ticket volume by topic and customer satisfaction score. Source: help desk export.
Examples at a glance
| Dashboard | Core KPIs | Data source | Refresh |
|---|---|---|---|
| Sales | Revenue vs target, pipeline by stage, win rate, deal size | CRM export | Weekly |
| Sales rep | Meetings, deals won, revenue vs quota per rep | CRM export | Weekly |
| Financial | Revenue, gross margin, expenses, cash, runway | Accounting export | Monthly |
| Cash flow | Cash in, cash out, net cash, 8-week forecast | Bank and accounting export | Weekly |
| Marketing | Sessions, conversion, leads, cost per lead, ROAS | GA4, ad platforms | Weekly |
| Ecommerce | Revenue, orders, AOV, conversion, refunds | Store orders export | Weekly or daily |
| Operations | On-time rate, lead time, backlog, defects | Job tracker or ERP | Weekly |
| Support | Response time, resolution time, volume, CSAT | Help desk export | Weekly |
Layout principles
- Most important top left. People read a screen like a page. Put the one number that matters most where the eye lands first.
- Tiles on top, trends in the middle, detail at the bottom. Headline numbers first, then how they got there, then the breakdowns.
- Always show a comparison. "$48,200" means nothing alone. "$48,200, up 6% on last month, 92% of target" means something.
- Same time period everywhere. Do not mix this month's revenue with last quarter's conversion rate.
- One chart, one question. If a chart needs a paragraph to explain, split it.
- Colour means something. Use red and green only for good and bad, not decoration.
Common mistakes to avoid: vanity metrics that only go up (total followers, all-time revenue), percentages without the count behind them (a 50% win rate on 2 quotes), and KPIs with no target, which leave everyone guessing whether a number is good.
What is a KPI chart? Usually one of three: a KPI tile (big number with change), a line chart (trend over time) or a bar chart (comparison across categories). Gauges and 3D pies look busy and are harder to read; avoid them.
KPI dashboard software compared
KPI dashboard software falls into three groups: dedicated KPI tools with live integrations, BI platforms, and simple dashboard builders. Prices checked October 2026 on each vendor's own site.
| Tool | Type | Price | Data | Good for |
|---|---|---|---|---|
| Databox | KPI dashboards with integrations | Free plan; Analyst $71/mo, Team $199/mo (billed annually) | Live connections to many apps, alerts, goals | Marketing and agency teams tracking KPIs across tools |
| Klipfolio | KPI dashboards with integrations | From $120/mo billed annually ($140 monthly), unlimited users | 130+ integrations, scheduled refresh | Teams that want many dashboards for many viewers |
| Power BI | BI platform | Desktop free; Pro $14/user/mo (annual) | Hundreds of sources, data models | Drill-down and Microsoft data |
| Looker Studio | Dashboard builder | Free | Google sources, Sheets, CSV | Marketing KPIs on Google data |
| KissMySkills AI Dashboard | AI dashboard from a file | Free in browser; save and share with All-Access $15/mo or $129/yr | CSV, pasted rows, Google Sheet; one table | Fast KPI dashboards from exports |
Where the others win: dedicated KPI software such as Databox and Klipfolio wins on live integrations, goals and alerts. You connect your apps once and the numbers update on their own. BI tools such as Power BI win on drill-down: click a number and see the rows behind it, across joined tables. Our tool does neither. It is for the case where your data is an export and you want a clean KPI view now.
How to build one from a CSV
If your data comes out of your CRM, store or accounting tool as a CSV, here is how to build a KPI dashboard in a few minutes:
- Write down your KPIs first. Seven or fewer, each with a goal.
- Export the data. One table with a header row: a date column, the categories you want to split by (channel, product, rep) and the numbers (revenue, orders).
- Clean it. Remove total rows and notes, keep one date format.
- Open AI Dashboard and drop the CSV in, or paste a Google Sheet link. The free version builds KPI tiles, trends and breakdowns in your browser; your CSV is not uploaded.
- Adjust. Rename the title, add or remove charts, and choose how each value is aggregated.
- Save and share. With the All-Access subscription ($15 a month or $129 a year), save the dashboard, share a read-only link with your team, and refresh it from your Google Sheet each week.
You can also connect the KissMySkills connector to Claude or ChatGPT and ask: "Here is our sales export, build a KPI dashboard for the Monday meeting." The agent picks the KPIs and charts and gives you the link. All-Access also includes our other AI tools, such as AI CRM, which is free for up to 300 deals and 1 user.
Keeping it alive: weekly review ritual
Most KPI dashboards die within two months. Not because they were wrong, but because nobody looked. A simple ritual keeps them alive:
- Same time every week. Monday morning, 15 minutes, dashboard on screen.
- Refresh before the meeting. Whoever owns the data updates it the Friday before.
- Each owner speaks to their number. On track, off track, and what they will do about it.
- One action per red number. Written down, with a name and a date.
- Review the KPIs every quarter. Drop the ones nobody acted on; add what you wish you had seen.
A dashboard is only as useful as the conversation it starts.
FAQ
What is a KPI dashboard?
A KPI dashboard is a single page that shows the key performance indicators for a business or team, such as revenue, pipeline, cash and conversion rate, each compared with a target or the previous period, so you can see at a glance whether you are on track.
How do I build a KPI dashboard?
Pick seven or fewer KPIs tied to goals, export the data as one clean table, then build KPI tiles, trend lines and breakdowns in a spreadsheet, a BI tool or an AI dashboard generator. Put the most important number top left, show a comparison for each KPI, and review it weekly.
What characterizes a KPI dashboard?
Focus. Every number is tied to a goal, has an owner and is reviewed on a schedule. It shows a few KPIs with comparisons and trends, not every metric you can collect.
What is a KPI chart?
A KPI chart shows one key metric clearly. The most common types are a KPI tile (a big number with its change), a line chart for the trend over time and a bar chart for comparing categories.
Build your KPI dashboard today
You do not need new software to start tracking the right numbers. Pick your seven KPIs, export the data, and build your KPI dashboard from a CSV with AI Dashboard.
