KPI Dashboard Examples: Five Rows of KPIs From Real Dashboards, and How to Choose Yours

AI agents: how much they do, what it costs, how well they work

Runs and spend grow with use; the success rate and the 95th percentile run time say whether the agents work well. Spend and run time are lower-is-better numbers, so a rise in either shows in red and a fall in green: the colour follows whether a change is good, not which way it goes.

Sales: what the business is judged on

Revenue, orders, average order and cancellations. Three of them grow with the business; the cancellation rate is the one that should fall, and it covers twelve months so a single bad week doesn’t swing it.

SELECT round(SUM(i.quantity * i.unit_price)) AS revenue
FROM orders o JOIN order_items i USING (order_id)
WHERE o.status = 'completed'
  AND date_trunc('month', o.ordered_at) =
      (SELECT date_trunc('month', max(ordered_at)) FROM orders)

SaaS product: growth and whether it sticks

Weekly actives and signups say the product is growing; activation and the share kept after a month say the growth is real. Over a quarter, weekly actives show the last week’s value — adding thirteen weeks of active users together would count the same people thirteen times.

Client report: from spend to revenue

Leads, what each lead costs, the jobs they turned into and the revenue. Cost per lead is a lower-is-better number, so a fall shows in green and a rise in red, and over a longer period it averages rather than adds.

Solar fleet: output, value and problems

Three cards are enough when the third is an alarm. Open alerts has no trend to admire: it should be zero, and anything else is the first thing to read.

What is a KPI dashboard?

A dashboard built around a handful of key performance indicators — the numbers a team or business is judged on — each shown with its change over time, usually as a row of cards at the top with supporting charts below.

How many KPIs should a dashboard have?

Three to five on the top row. More than that and nobody reads them; the rest belong in charts further down or on another tab.

What makes a good KPI card?

A clear name, the current value, the change since the previous period coloured by whether that change is good, a small trend line, and a definition that stays the same from week to week.

Can I build a KPI dashboard from my database?

Yes. Connect your database to Fastero and ask for the KPIs you want in plain English; the AI writes the queries and lays out the cards, and you can adjust any of them.