Small Business Metrics to Track Every Week (The 8 That Matter, With Formulas)

Updated 2026-10-28 · AI Agent Starter Kit

Most owners know their bank balance and roughly how busy they feel. That's not enough to spot a problem early. A slow month usually shows up weeks ahead as fewer inquiries, slower replies or quotes that stop turning into jobs. By the time it hits the bank account, you've lost a month to fix it.

You don't need a dashboard with 40 numbers. You need about eight, checked once a week, written in the same place. This guide covers which eight, how to calculate each one, where the data lives and a 15-minute Monday routine to review them.

Why weekly, not monthly

Monthly numbers are good for the big picture (see the monthly business review template). Weekly numbers are for steering. If new leads drop for two weeks in a row, you can still do something about it this month. If you only look monthly, you find out after the fact.

Weekly also keeps the habit small. Fifteen minutes every Monday is easier to keep than a half day every quarter.

The 8 metrics worth tracking

Not every business needs all eight. Pick the ones that match how you make money, and keep the list short.

A few notes on the trickier ones:

• Lead reply time is the earliest warning sign most owners never measure. If it creeps from 2 hours to 2 days, leads go to whoever answered first. Track email response time in Gmail shows four free ways to measure it, and the lead response time calculator gives a rough sense of what slow replies may cost.
• Close rate only counts quotes that have been decided. Leave open quotes out, or the number will swing for no reason. How to calculate close rate walks through examples, and the free close rate calculator does the math.
• Cash collected vs revenue booked. A business can be busy and still run out of money. If booked work keeps running well ahead of cash collected, look at your invoicing and payment reminder emails.

What to leave off (for now)

These can matter, but they're poor weekly steering numbers for most small businesses:

• Social media followers and likes. Only track them if social is where your leads actually come from, and even then track the leads, not the likes.
• Website visits on their own. Useful context, but inquiries are what pay the bills.
• Profit margin every week. Costs land unevenly, so weekly margin is noisy. Check it monthly.
• Anything you can't act on. If a number moving wouldn't change what you do next week, drop it.

A copy-paste weekly scorecard

Put this in a Google Sheet, one row per week:

Week of | New leads | Avg reply (hrs) | Quotes sent | Won | Lost | Close rate | Revenue booked | Cash collected | Overdue invoices ($) | Emails waiting | Note

The close rate cell is =IFERROR(E2/(E2+F2),"") if Won is column E and Lost is column F. Format it as a percentage. Add a simple line chart on New leads and Revenue booked once you have six or more weeks of data. The small business KPI dashboard in Google Sheets guide has a fuller layout with formulas and a trend chart, and the lead tracking spreadsheet is where numbers 1 to 4 usually come from.

The Note column matters more than it looks. "Holiday week," "ran an ad," "Sam out sick." Three months later, it's the only way to explain a dip.

The 15-minute Monday routine

1. Fill in last week's row (5 minutes). Pull each number from its source. If a number takes more than a minute to find, that's a sign to fix how you record it.
2. Compare to the last 4 weeks (3 minutes). Don't react to one week. Look for two or three weeks moving the same way.
3. Pick one thing (5 minutes). If reply time went up, block an hour a day for replies. If quotes went out but nothing closed, follow up on open quotes (the quote follow-up guide has templates). If leads dropped, ask where last month's leads came from and do more of that.
4. Write it down (2 minutes). Put the one thing in your calendar for this week. The weekly review template folds this into a fuller weekly reset.

Worked example (illustrative)

A two-person landscaping business starts tracking in March. For four weeks, new leads hold at 12 to 14 a week, but average reply time climbs from 3 hours to 20 as the season gets busy, and close rate slips from 45% to 30%. The owner blocks 30 minutes at noon and 5 PM for replies. Two weeks later, in this example, reply time is back under 4 hours and close rate is near 40% again. These numbers are made up for illustration, not a measured result, but the pattern of slow replies showing up before lost jobs is common.

Where AI helps (and where it shouldn't)

AI is useful for turning a row of numbers into a short summary: "leads steady, reply time up for the third week, two invoices overdue over 30 days." That saves the reading, not the thinking.

What AI should not do is produce the numbers themselves. Language models can and do invent figures that look plausible. Count with formulas or code, and let the AI only describe numbers that were already counted. If a summary mentions a number that isn't in your sheet, treat the whole summary as suspect.

Get the Monday numbers done for you

The Weekly CEO Report Kit is an n8n workflow that runs every Monday at 7 AM. It reads your lead sheet, your inbox labels, your sent mail and (optionally) your Google Calendar, counts new leads, reply times, stuck leads and overdue emails with code, then has AI write a short narrative. A built-in check strips any number the AI made up. The report is saved to your Gmail Drafts and logged as a row in a Weekly tab, so the scorecard above fills itself in for those numbers. To be clear about what it doesn't do: it doesn't read your bank, invoicing tool or payment processor, so revenue, cash and overdue invoices stay manual. Nothing sends without you. Get the kit

Want a daily version of the same idea, free? The Morning Briefing Agent emails you every weekday at 7 AM with today's meetings, the 3 unread threads most likely to matter and one suggested priority. It's read-only on your calendar and inbox. Get it free

More guides

• Daily Planner Template for Small Business Owners (Free Copy-Paste Version)
• Year-End Review Template for Small Business Owners (Copy-Paste Doc + 12 Questions)
• Weekly Team Meeting Agenda Template for Small Businesses (30 Minutes, Copy-Paste)
• Time Blocking for Small Business Owners: A Simple Weekly Schedule That Leaves Room for Leads
• Quarterly Planning Template for Small Business Owners (90-Day Plan You Can Copy)
• How to Write a Project Status Update Email (Template, 6 Examples and a Weekly Routine)
• How to Use Google Calendar for a Small Business: A Simple Setup That Actually Runs Your Week
• How to Schedule a Meeting by Email: 8 Templates and a Simple Way to Stop the Back-and-Forth
• How to Re-Engage Old Leads: 7 Email Templates to Revive Cold Leads
• How to Prepare for a Client Meeting: A 15-Minute Checklist for Small Business Owners