A list of KPIs helps only if you can compute them. Below are thirty, five per team, each with its formula. The eight that a plain orders table can produce come with the SQL we ran and its output.
The short answer: common KPI examples are revenue growth, average order value and win rate for sales; customer acquisition cost and channel share of revenue for marketing; activation and retention for product; net revenue retention, churn and Net Promoter Score for customer success; gross margin, net burn and cash runway for finance; and orders per day, on-time delivery and cost per unit for operations. A KPI is a metric you have chosen to steer by, so it has a target, an owner and a period. Every other number you track is just a metric.
Fastero
Connect your database. Ask questions. Get dashboards.
Postgres, BigQuery, Snowflake, and 10+ sources — live-connected, AI-powered, no dashboard builder learning curve.
Try free →KPI vs metric: what's the difference?
KPI.org, the Balanced Scorecard Institute's site, calls KPIs "critical, quantifiable measures of progress toward a desired result". Every KPI is a metric; most metrics never become KPIs.
| Metric | KPI | |
|---|---|---|
| What it is | Any number you can count or calculate | A metric picked to track a goal |
| Target | Usually none | Yes, for a stated period |
| Owner | Often nobody | One person or team |
The same number can be either: orders per day is a metric to the finance lead and a KPI to whoever staffs the warehouse. KPI.org also splits KPIs into lagging ones, "the result of past actions", and leading ones that predict them; its example is body weight against daily calorie intake. Pair a lagging KPI such as revenue with a leading one such as pipeline, and write each definition down.
The data behind the SQL
The queries run on 4,734 invented orders, 1 November 2024 to 31 October 2026, the same ones a new Fastero workspace starts with as Sample sales data. Each row has a date, region, channel (Online, Sales team or Partner), segment, category, product, quantity, unit price and revenue. There are no customer ids, costs, deals or tickets, so KPIs that need those get a formula only. DuckDB 2.0.0, Python 3.14, run on 18 November 2026:
CREATE TABLE sales AS SELECT * FROM read_csv_auto('sample-sales.csv');Sales KPIs
| KPI | What it tells you | Formula |
|---|---|---|
| Revenue | What was sold | Sum of order value in the period, after refunds and cancellations |
| Revenue growth, month on month | Direction | (This month − last month) ÷ last month |
| Average order value | What each sale is worth | Revenue ÷ orders |
| Win rate | How well deals close | Won opportunities ÷ all opportunities, per Salesforce |
| Sales velocity | Revenue the pipeline makes per day | Opportunities × deal value × win rate ÷ days in the sales cycle, per HubSpot |
WITH m AS (
SELECT date_trunc('month', order_date) AS month,
sum(revenue) AS revenue,
count(*) AS orders
FROM sales
GROUP BY 1
)
SELECT strftime(month, '%Y-%m') AS month,
round(revenue) AS revenue,
orders,
round(revenue / orders, 2) AS avg_order_value,
round(100 * (revenue / lag(revenue) OVER (ORDER BY month) - 1), 1) AS mom_pct
FROM m
ORDER BY month DESC
LIMIT 3;┌─────────┬─────────┬────────┬─────────────────┬─────────┐
│ month │ revenue │ orders │ avg_order_value │ mom_pct │
│ varchar │ double │ int64 │ double │ double │
├─────────┼─────────┼────────┼─────────────────┼─────────┤
│ 2026-10 │ 57518.0 │ 202 │ 284.74 │ -11.3 │
│ 2026-09 │ 64819.0 │ 227 │ 285.55 │ -25.7 │
│ 2026-08 │ 87202.0 │ 251 │ 347.42 │ 3.6 │
└─────────┴─────────┴────────┴─────────────────┴─────────┘Two monthly falls in a row, 25.7% then 11.3%, read like a slump. But September fell last year too, and the finance query below shows the last 12 months up 24.3% on the 12 before: this is the season. Month-on-month growth needs a year-on-year number beside it (how to compare periods in SQL).
Marketing KPIs
| KPI | What it tells you | Formula |
|---|---|---|
| Customer acquisition cost (CAC) | What a new customer costs | Acquisition spend ÷ new customers. a16z separates blended CAC (all new customers) from paid CAC (those from paid marketing only) |
| Channel share of revenue | Where revenue comes from | A channel's revenue ÷ all revenue |
| Lead-to-customer rate | Lead quality | New customers ÷ leads, in the same period |
| Cost per lead | Efficiency of paid campaigns | Paid spend ÷ leads from paid channels |
| Return on ad spend (ROAS) | Whether the ads pay | Revenue attributed to ads ÷ ad spend |
SELECT channel,
count(*) AS orders,
round(100 * sum(revenue) / sum(sum(revenue)) OVER (), 1) AS pct_of_revenue,
round(sum(revenue) / count(*), 2) AS avg_order_value
FROM sales
WHERE order_date >= DATE '2025-11-01' -- the last 12 months
GROUP BY channel
ORDER BY pct_of_revenue DESC;┌────────────┬────────┬────────────────┬─────────────────┐
│ channel │ orders │ pct_of_revenue │ avg_order_value │
│ varchar │ int64 │ double │ double │
├────────────┼────────┼────────────────┼─────────────────┤
│ Online │ 1296 │ 49.0 │ 308.83 │
│ Sales team │ 775 │ 29.4 │ 309.36 │
│ Partner │ 557 │ 21.6 │ 317.29 │
└────────────┴────────┴────────────────┴─────────────────┘Online brings almost half the revenue. Order size differs by under 3% across channels, so a shift in mix moves the order count, not the order value.
Product KPIs
| KPI | What it tells you | Formula |
|---|---|---|
| Activation rate | Whether new users find the value | New users who reach the first key action ÷ new users |
| Weekly active users | Reach | Distinct users who did a core action in the week. a16z warns that companies define "active" in almost any way they like, so write yours down |
| Retention | Whether they come back | Users from a signup cohort still active N weeks later ÷ the cohort's size |
| Stickiness | How habitual the product is | Average daily active users ÷ monthly active users |
| Feature adoption | Whether a feature is used | Users of the feature in the period ÷ active users |
These need event data with a user id on every row, which an orders file doesn't have. Our guide to cohort retention in SQL shows the query for retention.
Customer success KPIs
| KPI | What it tells you | Formula |
|---|---|---|
| Net revenue retention (NRR) | Whether existing customers spend more | (Starting MRR + expansion + reactivation − contraction − churned MRR) ÷ starting MRR, per ChartMogul |
| Customer churn rate | How many leave | Customers lost in the month ÷ customers at the start of it, per a16z |
| Net Promoter Score (NPS) | Whether customers would recommend you | % promoters (9 or 10) − % detractors (0 to 6), on a 0 to 10 scale, per Bain |
| Customer satisfaction (CSAT) | Whether a conversation went well | Good ratings ÷ all ratings; show how many people rated |
| First reply time | How long customers wait | Time from a ticket's creation to the first public agent reply (Zendesk's definition); report the median |
No query here either: these need subscriptions and tickets. Net revenue retention in SQL shows the first one.
Connect any database. Ask in plain English.
Start free →Finance KPIs
| KPI | What it tells you | Formula |
|---|---|---|
| Revenue, last 12 months | Size, with the season averaged out | Sum of the last 12 full months |
| Revenue growth, year on year | Growth on a like-for-like basis | Last 12 months ÷ the 12 months before − 1 |
| Gross margin | What's left after delivering | (Revenue − cost of revenue) ÷ revenue |
| Net burn | Cash lost each month | Monthly cash spent − monthly revenue, per Stripe |
| Cash runway | Months until the cash runs out | Cash on hand ÷ monthly net burn, per Stripe |
SELECT coalesce(category, 'All') AS category,
round(sum(revenue) FILTER (WHERE order_date >= DATE '2025-11-01')) AS last_12m,
round(sum(revenue) FILTER (WHERE order_date < DATE '2025-11-01')) AS prior_12m,
round(100 * (sum(revenue) FILTER (WHERE order_date >= DATE '2025-11-01')
/ sum(revenue) FILTER (WHERE order_date < DATE '2025-11-01') - 1), 1) AS yoy_pct
FROM sales
GROUP BY ROLLUP (category)
ORDER BY last_12m DESC;┌──────────┬──────────┬───────────┬─────────┐
│ category │ last_12m │ prior_12m │ yoy_pct │
│ varchar │ double │ double │ double │
├──────────┼──────────┼───────────┼─────────┤
│ All │ 816730.0 │ 656971.0 │ 24.3 │
│ Hardware │ 405704.0 │ 298639.0 │ 35.9 │
│ Software │ 199780.0 │ 174519.0 │ 14.5 │
│ Supplies │ 110044.0 │ 88328.0 │ 24.6 │
│ Services │ 101202.0 │ 95485.0 │ 6.0 │
└──────────┴──────────┴───────────┴─────────┘Hardware, now about half of revenue, grew fastest. ROLLUP adds the total row, so the company number and its breakdown come from one query and can't disagree.
Operations KPIs
| KPI | What it tells you | Formula |
|---|---|---|
| Orders per day | Workload | Orders ÷ calendar days in the period |
| Units per order | Size of each shipment | Units ÷ orders |
| On-time delivery rate | Reliability | Orders delivered by the promised date ÷ orders delivered |
| Order cycle time | Speed | Median time from order to delivery |
| Cost per unit | Efficiency | Operating cost ÷ units delivered |
SELECT year(order_date) AS year,
count(*) AS orders,
round(count(*) / 92, 1) AS orders_per_day, -- 92 days, July to September
round(sum(quantity) / count(*), 2) AS units_per_order
FROM sales
WHERE month(order_date) BETWEEN 7 AND 9
GROUP BY 1
ORDER BY 1;┌───────┬────────┬────────────────┬─────────────────┐
│ year │ orders │ orders_per_day │ units_per_order │
│ int64 │ int64 │ double │ double │
├───────┼────────┼────────────────┼─────────────────┤
│ 2025 │ 606 │ 6.6 │ 3.69 │
│ 2026 │ 746 │ 8.1 │ 3.75 │
└───────┴────────┴────────────────┴─────────────────┘A year apart, the same quarter has 1.5 more orders a day, each about the same size. Divide by calendar days, not days with orders, or a day with none drops out of the average.
Putting the KPIs on one screen
Each query above is one number on a dashboard. Fastero is an AI and data platform where people and AI agents work together on a team's data. Connect a database such as Postgres or BigQuery, or upload a CSV or Excel file, and ask for the KPIs you want:
- Fastero's assistant, or Claude through Fastero's connector, writes the SQL and builds the dashboard, and every number is a saved query you can open and check.
- It refreshes on a timer (1, 5, 15 or 60 minutes) or, for Postgres and BigQuery data only, when the data changes.
- It can email itself daily, weekly or monthly, with the numbers, charts and tables plus a PDF.
- Colleagues open it with their own login, and viewers are free. The Free plan is $0 with no end date; Pro is $20 per editor a month (checked 18 November 2026).

Headline numbers on a Fastero dashboard. Invented data.
For twelve finished dashboards, one per team, see KPI dashboard examples. To pick the single number above all of these, see north star metric.
FAQ
What are some examples of KPIs?
Revenue growth and win rate (sales), customer acquisition cost (marketing), retention (product), net revenue retention and NPS (customer success), gross margin and cash runway (finance), and on-time delivery (operations). Each is a KPI once it has a target and an owner.
What is the difference between a KPI and a metric?
A metric is any number you track. A KPI is a metric chosen to measure progress toward a goal, with a target, an owner and a period. Every KPI is a metric, but most metrics are never KPIs.
What are leading and lagging KPIs?
A lagging KPI reports a result that has already happened, such as revenue or churn. A leading KPI moves first and predicts it, such as pipeline or activation. Track them in pairs so you can act before the result is in.
What are good KPIs for a sales team?
Revenue against target, win rate, average deal size and days to close. Salesforce's win rate is won opportunities divided by all opportunities in the period, times 100.
How do you calculate a KPI in SQL?
Aggregate the period's rows with sum(revenue) or count(*), then compare with the period before using a window function such as lag(). Use whole periods only, and keep one saved query per KPI so every report agrees.
Sources
Read on 18 November 2026:
- KPI.org (Balanced Scorecard Institute): What is a Key Performance Indicator (KPI)?
- Sales: Salesforce on win rate, HubSpot on sales velocity
- Marketing, product and churn: a16z, 16 startup metrics
- Customer success: ChartMogul on net revenue retention, Bain on measuring NPS, Zendesk on ticket time metrics
- Finance: Stripe on burn rate and runway
- Queries: DuckDB 2.0.0 on an invented file of 4,734 orders, run 18 November 2026
Try Fastero free: connect your data, ask for the KPIs you track, and get a dashboard your team opens with its own login. No credit card required.
Fastero Dev Team