7 metrics every small business should automate

The instinct when you get a new analytics tool is to track everything. Resist it. A dashboard with forty tiles is a dashboard nobody reads, and a metric nobody reads is worse than no metric at all because it creates the illusion of attention. After helping a few thousand small teams set up, we keep recommending the same short list. Automate these seven and you'll catch almost everything that matters before it becomes a fire.

1. Net revenue retention

The single best health check for any recurring-revenue business. It captures expansion, contraction, and churn in one figure. Above 100% means your existing customers are growing faster than they're leaving — the holy grail. Automate it weekly and alert on any month-over-month drop greater than three points.

2. Failed-payment recovery rate

Involuntary churn is the leak almost nobody watches. Cards expire, charges get declined, and customers who never meant to leave quietly disappear. Track the share of failed payments you successfully recover, and you'll often find money sitting on the floor. One of our customers found $28k a year this way in their first month.

3. Activation rate

Define one moment that means a new user 'got it' — sent their first report, connected their second source, invited a teammate — and track the percentage of signups who reach it within seven days. Activation is the leading indicator of retention; if it dips, churn is coming a few weeks later. Automating this gives you the head start.

• Pick a single, unambiguous activation event — not three competing ones.
• Measure within a fixed window (7 days works for most products).
• Segment by acquisition channel so you can see which traffic actually sticks.

4. Cash runway

Current cash divided by net monthly burn, refreshed daily. This is the one number a founder should be able to see without asking finance. When it's automated, you stop discovering bad news in a quarterly review and start steering months ahead of trouble.

5. Lead-to-customer conversion

Not just how many leads you get, but what share become paying customers, broken down by source. This is what tells you whether to spend more on a channel or turn it off. Automating it by channel turns a quarterly marketing debate into a daily, evidence-based decision.

6. Customer support response time

Median first-response time correlates tightly with retention, and it degrades silently as you grow. Put it on a live tile and alert when it crosses your promised SLA. Support quality is one of the cheapest moats a small business has — but only if you can see it slipping.

7. Gross margin per product

Revenue is vanity if you don't know what it costs to deliver. Margin by product line tells you which parts of the business to lean into and which are quietly subsidizing the rest. It changes slowly, so monthly is fine — but it should never require a manual spreadsheet exercise to produce.