How to Build a KPI Dashboard That Marketing and Sales Actually Use
Most KPI dashboards are chart graveyards. Nice at kickoff, ignored after two weeks. Here's how to build one your team opens every Monday morning.
Let's start from a real case
An Italian furniture ecommerce (our client, ~85,000 sessions/month) had a Looker dashboard with 34 widgets: sessions, users, bounce, CPC, CPM, CTR, ROAS by campaign, ROAS by channel, cohort retention, checkout funnel, and so on. The CMO opened it every Monday for 2 minutes, then went back to Excel.
We cut it down to 6 metrics organized in 3 blocks. After 8 weeks: weekly adoption went from 1 person to 7, average time on the dashboard from 2 to 11 minutes, and — most importantly — 3 documented operational decisions per month directly attributed to the data shown.
The "so what?" rule
Every widget must pass this test: looking at this number, what will I do differently tomorrow morning? If there's no answer, the widget doesn't ship.
The 6 metrics that work (marketing + sales)
| Block | Metric | Why |
|---|---|---|
| Acquisition | CAC by channel (last 30d vs prior 30d) | Flags channel saturation |
| Acquisition | Qualified traffic (sessions with >1 pageview + event) | Filters bots and accidental clicks |
| Conversion | Micro→macro conversion rate | Isolates the real bottleneck |
| Conversion | Revenue per session (RPS) | Honest metric, immune to vanity |
| Retention | 60-day repeat rate | Predicts LTV better than NPS |
| Pipeline health | Funnel velocity (avg days stage-to-stage) | Signals sales friction |
Anti-patterns to avoid
- Pie charts with more than 4 slices → unreadable
- Metrics without time comparison → a number alone tells you nothing
- Percentages without denominator → "conversion +40%" from 5 to 7 sales is not a win
- Dashboards without an owner → if no one maintains it, it dies
Update cadence
- Every Monday (10 min): review the 6 metrics + 1 written note for every >15% deviation
- End of month: one metric out, one in. Always 6. Never more.
The stat that should convince you
According to HubSpot (State of Marketing 2024), marketers who actively measure ROI on their activities are 1.6x more likely to receive additional budget the following year. A used dashboard is a budget multiplier. An ignored one is a cloud cost.
Try it on your own site
Curious how this looks for your business? Go to the Metriko homepage, paste your website URL in the hero, and get a plain-English read of your Google Analytics in under a minute — no signup, no credit card.