Hear this article read aloud.
Ask a simple question at the Monday meeting: how did last month go? The answer takes most of the morning. Sales are in the point of sale. Leads are in the website’s form inbox and the call log. Ad spend is in two different ad accounts. Payroll and costs are with the bookkeeper. Someone has a spreadsheet that ties a few of these together, and it was last updated in the spring.
Every one of those tools has a report. None of them answers the question. The problem is not a lack of data. It is that the data lives in six places, each one counting things its own way, and nobody has an afternoon to put it together.
You do not need a data team or a new system to fix most of this. You need a short list, a few definitions, and one place to look.
Start with the questions, not the tools
The usual mistake is starting with the software: buying a dashboard tool, connecting everything it offers, and ending up with forty charts nobody reads.
Start instead with the decisions you make every month. Where do we spend on marketing next month? Do we need another person on the schedule? Which services are worth pushing? Which customers are slipping away?
Write down three to five of those questions. Each one points to a number or two. That is your list. Everything else can wait.
Pick five to eight numbers
For most small businesses, the list ends up looking something like this:
- Revenue, by week and by service or product line
- New leads, by source: calls, forms, bookings, walk-ins
- Close rate, how many of those leads became customers
- Marketing spend, by channel
- Repeat customers, how many came back
- Cash on hand or money owed to you, whichever keeps you up at night
If your business runs on appointments, add how full the schedule is. If it runs on jobs, add how long a job takes from quote to paid. The point is a short list you can read in a minute. If marketing is the part you most want to understand, our piece on measuring what your marketing actually does goes deeper on leads, cost per lead and close rate.
Map where each number lives
For each number on the list, write down three things: which tool holds it, who has the login, and how you get it out. Most tools can export to a spreadsheet, and many can connect directly to other software.
This is where surprises turn up. A number you assumed was tracked is not. Two tools disagree about how many customers you have. A login belongs to someone who left last year. Better to learn that now, on paper, than halfway through a project.
While you are at it, note who should be able to see each number. Not everyone needs payroll. The same care you would give any account applies here, and our plain-English cybersecurity checklist covers access and logins.
Define every number once
Ask three people what counts as a “lead” and you may get three answers. Does a phone call that lasts ten seconds count? A form filled out by a vendor? A customer who booked twice?
Write one sentence for each number that says exactly what it counts and where it comes from. “A lead is a first-time call over one minute, a contact form, or an online booking from someone not already in our customer list.” Put the definitions at the top of the sheet. When a number looks strange later, the first question is whether the definition was followed.
Build one view, even a plain one
Now pull the numbers into one place. For many businesses, the first version is a single spreadsheet with a row per week and a column per number, filled in by one person every Monday. It works, and it shows you quickly which numbers you actually look at and which you can drop.
When the manual version proves itself, connect the sources so the numbers update on their own and put them on a simple dashboard. Do not start there. Automating a list you have not tested just builds the wrong thing faster.
Set a rhythm and an owner
A view nobody checks is the same as no view. Pick a time, such as Monday morning, and look at the same numbers in the same order. Ask what moved, why, and what you will do about it this week.
Name one person who owns the sheet: keeps it filled, notices when a number looks off, and fixes a definition when the business changes.
Questions to answer this week
- What three to five decisions do we make every month?
- Which numbers would help us make them?
- Where does each one live, and who has the login?
- Have we written down exactly what each number counts?
- Who fills in the sheet, and when do we look at it?
Where we come in
Our data and analytics team connects your sources, defines the metrics once, and builds dashboards your team actually reads. We work with the tools you already use rather than forcing a switch, and for many businesses we start with a few connected tools and a dashboard, adding a data warehouse only when the data outgrows that.
If your numbers live in six places and your Monday meeting starts with a scavenger hunt, book a call and bring the questions you wish you could answer.
