Most small businesses track the wrong things, or they track the right things in five different places and never line them up. Revenue lives in the invoicing tool. Pipeline lives in the CRM. Marketing spend lives in an ad dashboard. Cash sits in the bank's app. By the time someone exports all of it into a spreadsheet on the 5th of the month, the data is stale and the meeting is about last month instead of this week.
KPIs — key performance indicators — are the handful of numbers that tell you whether the business is actually working. Not the dozens of metrics you could track. The five to ten you should. This guide breaks down the KPIs that matter by function (sales, cash flow, operations, marketing, retention), gives you the formula for each, explains how to read it, and shows where it should live so you are not rebuilding a spreadsheet every Monday morning. The goal is a number you can glance at and act on — not a report you have to assemble first.
What makes a KPI worth tracking (and what makes it vanity)
A real KPI changes a decision. If a number goes the wrong way and you would do something differently — call a customer, pause an ad, chase an invoice, hire — it earns a spot on the dashboard. If it only makes you feel good or bad and changes nothing, it is a vanity metric.
Total page views is usually vanity. Conversion rate from visit to trial is a KPI. Lifetime followers is vanity. Repeat-purchase rate is a KPI. The test is simple: 'If this moved, what would I do?' If the answer is 'nothing,' cut it.
The second filter is leading versus lagging. Lagging indicators (revenue, profit) tell you what already happened. Leading indicators (pipeline created, demos booked, trial signups) tell you what is about to happen. A healthy dashboard has both — lagging numbers to keep score and leading numbers so you can change the outcome before it lands. Most small-business owners over-index on lagging revenue and have no leading indicator at all, which means every bad month is a surprise. Fix that ratio first.
Sales KPIs
- Monthly Recurring Revenue (MRR) / Monthly Revenue: for subscription businesses, sum of all active recurring revenue normalized to a month. For one-off sellers, total revenue booked in the month. The single most important scoreboard number.
- Pipeline value: sum of open deal amounts, ideally weighted by stage probability. A leading indicator — it tells you what revenue is coming before it arrives. Formula: Σ (deal value × stage win-probability).
- Win rate: deals won ÷ deals closed (won + lost). If it is dropping, either lead quality or your sales process changed. Track by source to see which is true.
- Average deal size / average order value (AOV): total revenue ÷ number of deals (or orders). Rising AOV often beats chasing more leads — it is cheaper to sell more to the same buyer.
- Sales cycle length: average days from first contact to closed-won. Lengthening cycles quietly strangle cash flow even when win rates hold.
The trap with sales KPIs is that they live in the CRM while the revenue they predict lives in the invoicing or billing tool — so 'pipeline says $40k is closing' and 'we invoiced $22k' never sit on the same screen, and nobody notices the gap until the quarter is over. When pipeline, closed deals, and actual invoiced revenue come from the same connected data, you can watch a deal move from open, to won, to invoiced, to paid without re-keying anything. That continuity is the whole point: a forecast is only useful if you can compare it to what actually landed, in the same view, while there is still time to react.
Cash flow KPIs
- Cash runway: current cash ÷ average monthly net burn = months of runway left. The number that determines whether you sleep at night. If you are profitable, runway is effectively infinite — but track it anyway during growth pushes.
- Days Sales Outstanding (DSO): (accounts receivable ÷ total credit sales) × number of days in period. How long it takes to actually collect a dollar you have invoiced. A DSO creeping from 30 to 55 days is a cash crisis forming in slow motion.
- Accounts receivable aging: the share of unpaid invoices that are 0–30, 31–60, 61–90, and 90+ days late. Everything past 60 days needs a phone call, not another emailed reminder.
- Gross margin: (revenue − cost of goods sold) ÷ revenue. Tells you how much of each dollar survives delivering the thing you sold, before overhead.
- Operating cash flow: cash generated by normal operations in the period. Profit on paper means nothing if the cash is trapped in receivables.
Cash flow is where small businesses die, and it is almost never because revenue collapsed — it is because collections slipped while expenses kept their schedule. The brutal version: you can have a record sales month and still miss payroll if DSO blew out and half your invoices are sitting at 75 days. That is why receivables aging belongs on the same dashboard as revenue. Seeing '$58k invoiced this month' next to '$31k of receivables over 60 days late' tells a completely different story than the top-line number alone, and it tells you exactly who to call today. The dollars-over-60-days bucket is the most actionable cash KPI most owners never look at.
Operations KPIs
- Utilization rate (services businesses): billable hours ÷ available hours. Below ~70% and you are overstaffed or underselling; above ~90% sustained and you are about to burn people out and miss deadlines.
- On-time delivery / completion rate: jobs, projects, or orders completed by their committed date ÷ total. The leading indicator of churn for service businesses — late delivery predicts cancellations.
- Average resolution / fulfillment time: mean time from order or ticket created to closed. Speed is a competitive moat customers feel immediately.
- Inventory turnover (product businesses): cost of goods sold ÷ average inventory value. Low turnover is cash sitting on a shelf; very high turnover risks stockouts.
- Capacity vs. backlog: committed work ahead ÷ weekly throughput = weeks of backlog. Tells you when to hire before quality slips, not after.
Operations KPIs are the ones most owners feel in their gut but never quantify. You know the team is slammed; you do not know that utilization hit 94% three weeks running, which is precisely when on-time delivery starts to crack and the support tickets pile up. The value of putting these on a dashboard is that they turn a vague sense of 'we are busy' into a specific, early signal: backlog is now five weeks, throughput is flat, so it is time to hire or stop selling. Because this data lives wherever your work actually happens — projects, field service, tickets, orders — it should roll up automatically rather than waiting for someone to tally timesheets by hand.
Marketing KPIs
- Customer Acquisition Cost (CAC): total sales + marketing spend ÷ new customers acquired in the period. The price of a customer. If it is rising faster than deal size, the model is leaking.
- Cost per lead (CPL): marketing spend ÷ leads generated. A leading indicator of CAC — it moves first when a channel degrades.
- Lead-to-customer conversion rate: customers ÷ leads. Where the funnel actually leaks. A 2% rate with cheap leads can beat a 10% rate with expensive ones — always read it next to CAC.
- Channel ROI / ROAS: revenue attributable to a channel ÷ spend on that channel. Tells you where the next marketing dollar should go. Most businesses keep funding a channel for months after it stopped working.
- Marketing-sourced pipeline: open deal value that originated from marketing. Connects marketing effort to revenue, not just to lead counts.
The recurring marketing problem is attribution across disconnected tools: the ad platform reports leads, the CRM reports deals, and the finance tool reports revenue — three systems, three definitions, no shared customer. You end up trusting the ad dashboard's ROAS, which counts a 'conversion' as a form fill, while the actual closed revenue tells a far less flattering story. CAC and channel ROI only mean something when spend, leads, deals, and paid revenue are computed from the same source. When they are, you can finally answer the question every owner asks and few can prove: which channel is actually bringing in customers who pay, and which one just looks busy.
Retention KPIs
- Customer churn rate: customers lost in the period ÷ customers at the start. For recurring-revenue businesses, the single number that determines whether growth compounds or treadmills.
- Net Revenue Retention (NRR): (starting revenue + expansion − contraction − churn) ÷ starting revenue. Above 100% means your existing customers grow faster than you lose them — the holy grail.
- Repeat purchase rate (product/services): customers who bought more than once ÷ total customers. Cheaper growth than acquisition, every time.
- Customer Lifetime Value (LTV): average revenue per customer × average customer lifespan × gross margin. Read against CAC — a healthy LTV:CAC ratio is roughly 3:1 or better.
- Net Promoter Score (NPS) or CSAT: a leading indicator of churn. Satisfaction drops before customers leave, giving you a window to intervene.
Retention is the most under-tracked category for small businesses because acquisition feels more urgent — but a 5% improvement in retention compounds into far more profit than a 5% bump in new leads, and it costs a fraction as much. The reason retention KPIs are hard to track is that they require connecting historical customer behavior: who bought, when, how often, whether they came back. That history is scattered across the CRM, the invoicing records, and the support inbox. Pull it together and churn stops being a quarterly surprise. You see the leading signals — a support ticket spike from a key account, a subscription that did not renew on schedule, an NPS dip — early enough to make a save call instead of a post-mortem.
A starter KPI dashboard for a small business
| KPI | Formula | Read it as | Cadence |
|---|---|---|---|
| Monthly Revenue / MRR | Σ active recurring revenue (or revenue booked) | The scoreboard — up and to the right | Weekly |
| Weighted pipeline | Σ (deal value × stage probability) | Leading indicator of next month's revenue | Weekly |
| Cash runway | Cash ÷ avg monthly net burn | Months before you must act | Monthly |
| Receivables over 60 days | $ of invoices 60+ days past due | Who to call today | Weekly |
| CAC | Sales + marketing spend ÷ new customers | Price of a customer vs deal size | Monthly |
| Lead-to-customer rate | Customers ÷ leads | Where the funnel leaks | Monthly |
| Churn rate | Customers lost ÷ customers at start | Whether growth compounds | Monthly |
| On-time delivery | On-time jobs ÷ total jobs | Early churn signal for services | Weekly |
Eight numbers. That is a real small-business dashboard — not forty widgets nobody reads. Four you check weekly because they are early signals you can still act on (revenue, pipeline, receivables, delivery) and four you review monthly because they are slower-moving structural numbers (runway, CAC, conversion, churn). Resist the urge to add more. Every metric you add dilutes attention from the ones that matter, and a dashboard nobody trusts because it is cluttered is worse than no dashboard at all.
The harder part is not picking the metrics — it is the plumbing. Each of these draws from a different corner of the business, and assembling them by hand every week is exactly the chore that gets skipped the moment things get busy, which is precisely when you most need the numbers.
Why a connected platform surfaces these without the spreadsheet
Here is the difference between a KPI dashboard you actually maintain and one you abandon by week three: where the data comes from. The traditional path is to wire a business intelligence tool to a data warehouse, build pipelines from each source system, and pay someone technical to keep it all connected. For an enterprise with a data team, fine. For a six-person business, that project never finishes.
Deelo Analytics takes the other route. Because your CRM, invoicing, projects, inventory, and support all already live on the same platform, the analytics layer reads that data directly — no warehouse, no ETL, no SQL required to get started. Pipeline value comes straight from the CRM. Receivables aging comes from invoicing. On-time delivery comes from projects or field service. They land on one dashboard because they were never in separate silos to begin with. You can ask a question in plain language, get a chart, pin it, and schedule the whole board to email itself to you every Monday at 7am. The KPIs above stop being a monthly spreadsheet ritual and become a live view of the business — which is the only version anyone keeps using.
Frequently Asked Questions
- How many KPIs should a small business track?
- Five to ten total, split between leading indicators (pipeline, leads, bookings) and lagging ones (revenue, profit, churn). Beyond about ten, attention scatters and the dashboard stops getting used. It is better to track eight numbers you act on than forty you only glance at. Start with the eight in the table above and adjust to your model.
- What is the difference between a KPI and a metric?
- Every KPI is a metric, but not every metric is a KPI. A metric is any number you can measure. A KPI is a metric tied to a goal that changes a decision — if it moves the wrong way, you do something about it. Page views is a metric. Visit-to-trial conversion is a KPI because a drop triggers action. The test: 'If this changed, what would I do?'
- What are the most important KPIs for cash flow?
- Cash runway (months of operating cash left), Days Sales Outstanding (how long it takes to collect an invoice), and the dollar value of receivables more than 60 days past due. The last one is the most actionable and most ignored — it tells you exactly which customers to call this week to avoid a cash crunch that revenue numbers alone will not warn you about.
- Do I need a data analyst to build a KPI dashboard?
- Not for a small business. Traditional BI tools require connecting a data warehouse and writing queries, which is why they tend to need technical help. A connected platform where your sales, finance, and operations data already live together — like Deelo — can surface these KPIs without ETL pipelines or SQL, so an owner or office manager can build and maintain the dashboard.
- How often should I review my KPIs?
- Match cadence to how fast the metric moves and how soon you can act. Leading indicators you can influence this week — pipeline, receivables, delivery — deserve a weekly look. Slower structural numbers — CAC, churn, runway — are better reviewed monthly. Checking everything daily creates noise; checking everything quarterly means you find problems too late to fix them.
See your KPIs without building a single spreadsheet
Deelo Analytics reads the data already living in your CRM, invoicing, projects, and support — so revenue, pipeline, receivables, and churn land on one dashboard with no data warehouse, ETL, or SQL. Ask a question in plain language, pin the chart, and schedule the board to email itself every Monday. Start free and watch your real numbers in one place.
Start Free — No Credit CardRelated pages
Explore More
Related Articles
Workflow Automation for Small Business: The Complete 2026 Playbook
A strategic playbook for workflow automation for small business in 2026 — what to automate first, build vs. buy, governance, and how to measure ROI.
11 min read
Feature GuideBuild a Custom Business App Without a Developer (Vibe AI Guide)
How to build custom business app without a developer using Vibe, Deelo's AI builder — go from a plain-English idea to a working tool wired into your data.
11 min read
ComparisonBolt.new vs. Vibe vs. Replit: AI App Builders for Real Businesses
Bolt vs Replit vs Vibe compared for real businesses. Bolt.new and Replit excel for developers; Vibe wires your app into your data, payments, and customers.
11 min read
TrendsWhen to Build a Custom App vs. Buy SaaS (Decision Framework 2026)
A build vs buy software decision framework for 2026: a matrix on differentiation, core-vs-context, and maintenance, plus how AI builders shift the math.
11 min read