5 Metrics Every Small Business Should Track (and How to Automate Them)

Most small businesses track revenue. Some track expenses. Very few track the numbers that actually predict whether the business will be healthy six months from now. Here are the five metrics that matter most — explained in plain English — and how to set them up so they update themselves.

1. Revenue per customer (average transaction value)

What it is: Total revenue divided by total number of customers (or transactions) over a given period. If you made $50,000 last month from 200 customers, your revenue per customer is $250.

Why it matters: This number tells you whether you're growing because you're getting more customers or because each customer is spending more. Those are very different growth stories with very different strategies. If your revenue is climbing but revenue per customer is flat or falling, you're on a treadmill — running faster just to stay in place.

It also exposes pricing problems. If your average transaction value hasn't moved in two years but your costs have gone up, your margins are quietly eroding.

How to automate it: If you use Stripe, this is one API call away. Stripe's reporting dashboard shows average revenue per customer out of the box. For businesses using QuickBooks or Square, you can pull transaction data via their APIs into a custom dashboard that calculates this daily. The key is making it visible without anyone having to run a report manually.

2. Customer acquisition cost (CAC)

What it is: How much you spend to get one new customer. Add up everything you spent on marketing and sales last month, divide by the number of new customers you acquired. That's your CAC.

Why most small businesses get this wrong: They only count ad spend. Your CAC includes the hours your team spends on sales calls, the cost of your CRM, the time spent writing proposals that don't close, the networking events, the free trials. If you're spending $2,000/month on ads and getting 10 customers, your CAC isn't $200 — it's $200 plus whatever else you're spending to close those deals.

The other mistake: not tracking it per channel. Your Google Ads CAC might be $150 while your referral CAC is $30. That's a strategic insight you can't get from a blended number.

How to automate it: Connect your ad platforms (Google Ads, Meta) and your CRM (HubSpot, Pipedrive) to a central dashboard via their APIs. Tag every new customer with their acquisition source. A scheduled pipeline can pull spend data from ad platforms and customer counts from your CRM nightly, then calculate CAC per channel automatically. We build these as part of our dashboards and analytics work — it's one of the most common requests we get.

3. Cash flow forecast (not just current balance)

What it is: A forward-looking projection of money in vs. money out over the next 30, 60, or 90 days. Not your bank balance today — your predicted bank balance next month.

Why it matters: This is the number that kills businesses. Not low revenue, not thin margins — running out of cash. A profitable business can die if a big client pays 60 days late and payroll is due Friday. Cash flow forecasting is the difference between seeing that problem three weeks early (when you can do something about it) and seeing it three days early (when you can't).

The businesses that survive rough patches aren't always the most profitable ones. They're the ones that saw the gap coming and acted — drew on a credit line, accelerated an invoice, delayed a purchase.

How to automate it: QuickBooks and Xero both have cash flow forecasting features, but they're basic. For something more useful, pull your receivables (invoices out, expected payment dates), payables (bills due), and recurring expenses into a time-series model. Stripe's API can tell you expected subscription revenue. QuickBooks' API gives you outstanding invoices and their due dates. A custom dashboard that combines these into a rolling 90-day forecast — updated daily — is worth its weight in gold. This is exactly the kind of thing a purpose-built dashboard handles well.

4. Customer retention / churn rate

What it is: The percentage of customers who stop buying from you over a given period. If you had 100 customers in January and 85 of them bought again by March, your retention rate is 85% (or 15% churn).

Why it matters — even for non-subscription businesses: People think churn is only a SaaS metric. It's not. If you run a landscaping company, a dental practice, or a restaurant, you have repeat customers. Tracking how many come back (and how many don't) tells you whether your service quality is holding up, whether your pricing is pushing people away, and whether your marketing should focus on acquisition or retention.

Acquiring a new customer costs 5–7x more than keeping an existing one. If your churn rate is climbing, pouring money into acquisition is like filling a leaky bucket.

How to automate it: Define what "active" means for your business (purchased in the last 90 days? Visited in the last 60?). Then set up a scheduled job that checks your customer database against that definition. Stripe handles this natively for subscription businesses. For non-subscription businesses, connect your POS or invoicing system (Square, QuickBooks, Shopify) to a dashboard that flags customers who haven't transacted in X days. Automated alerts when churn spikes above your baseline are easy to set up and incredibly valuable.

5. Time-to-completion or inventory turnover

What it is: For service businesses: how long it takes from "customer says yes" to "work is delivered." For product businesses: how quickly your inventory sells and gets replaced.

Why it matters: For service businesses, time-to-completion directly affects capacity and cash flow. If your average project takes 6 weeks but you're quoting 3, you have a planning problem that will eventually become a customer satisfaction problem. If it's creeping up over time, you're either understaffed or your scope management is slipping.

For product businesses, inventory turnover tells you how efficiently your capital is working. Inventory sitting on shelves is cash you can't use for anything else. A turnover rate that's declining means you're either overstocking or demand is softening — both things you want to catch early.

How to automate it: Service businesses: track project start and completion dates in your project management tool (Asana, Monday, ClickUp) and pull that data into a dashboard via API. Calculate average time-to-completion weekly. Product businesses: connect your inventory system (Shopify, Square, or a custom database) and calculate turnover ratio automatically. Set alerts for when either metric drifts outside your target range. These integrations are straightforward to build and pay for themselves quickly.

The common thread: visibility without effort

The pattern across all five metrics is the same: the data already exists in your tools. The problem is nobody's looking at it because pulling it together manually is tedious. The solution isn't "try harder to check your numbers" — it's building a system that surfaces the right numbers automatically.

A well-built dashboard that pulls from your payment processor, accounting software, and CRM — and updates itself daily — turns these five metrics from "things we should probably track" into "things we actually see every morning."

Want these metrics on autopilot?

We'll connect your existing tools into a single dashboard that tracks what matters — no manual spreadsheets, no weekly report-building. Free consultation, no pressure.

Get a Free Consultation

Keep Reading