The Complete Guide to KPI Dashboards: Metrics That Actually Matter
Learn how to choose the right KPIs, avoid vanity metrics, and design dashboards that drive decisions instead of decorating walls.
What makes a KPI a KPI
A Key Performance Indicator isn't just any number you can measure. It's a metric that (1) connects to a business outcome, (2) someone is accountable for, and (3) can trigger action when it moves.
Page views? Usually a vanity metric. Revenue per visitor? Now we're talking.
The 5-KPI rule
The most common dashboard mistake is overcrowding. If everything is highlighted, nothing is. Effective dashboards lead with 3-5 primary KPIs displayed prominently, with supporting detail below.
Ask: "If I could only see five numbers each Monday morning, which would tell me if the business is healthy?"
Choosing KPIs by function
Sales: Revenue, pipeline coverage, win rate, average deal size, sales cycle length.
Marketing: Qualified leads, cost per acquisition, ROAS, conversion rate by channel.
E-commerce: Conversion rate, average order value, cart abandonment, repeat purchase rate.
Finance: Gross margin, burn rate, runway, budget variance.
Customer Success: Churn rate, NPS, time to resolution, expansion revenue.
Design principles that work
- Put the most important number top-left. Western readers scan in an F-pattern.
- Show trend, not just value. "Revenue: $50k" means little without "↑ 12% vs last month".
- Use color sparingly. Red/green for status only — not decoration.
- Match chart to data type. Trends → line charts. Comparisons → bars. Parts of whole → pie (only with ≤5 segments).
Automate or abandon
Dashboards die when updating them is manual. Connect your dashboard directly to the source spreadsheet so it refreshes automatically — that's the difference between a tool people use and a slide nobody opens.