A dashboard for your business: the KPIs you should check every week

Many small business owners run their company by looking at two things: the bank balance and a gut feeling about whether the week went “well” or “so-so”. The problem is that the bank tells you what already happened, weeks late, and gut feeling is easily fooled. By the time you notice sales dropping or payments arriving late, the problem has been growing for a while.

A dashboard exists precisely for that: to see what's happening in your business in time, through a few well-chosen numbers. In this article I explain what it is exactly, which indicators are worth tracking in each area, how to tell the ones that help you decide from the ones that are just decoration, where the data comes from and how to turn it into a weekly routine that takes no more than half an hour.

A dashboard is a screen or report that brings together your business's key indicators, the so-called KPIs (key performance indicators), in one place. Its goal is not to show every possible piece of data, but the few that tell you whether you're on track and where you need to act.

The classic comparison is a car dashboard. It doesn't show you the temperature of every engine part; it shows your speed, your fuel and a couple of warning lights that come on when something is wrong. That's enough to drive. A good small business dashboard works the same way: between eight and fifteen indicators, compared with the previous week or month and with a target, and nothing more.

Vanity metrics are the ones that make you feel good but don't help you decide. They tend to be big numbers that only go up and aren't connected to money. Useful metrics, on the other hand, are tied to revenue, costs or customers, and let you spot problems and opportunities.

• Social media followers versus contacts who come from social media and ask for a quote.
• Total website visits versus conversion rate: what percentage of visits ends in an enquiry, booking or purchase.
• Number of quotes sent versus percentage of quotes accepted and their value.
• Monthly revenue on its own versus revenue actually collected and the margin on what you sell.
• Emails sent versus replies or sales attributed to those emails.

This doesn't mean visits or followers don't matter. They matter as context, but they shouldn't sit at the centre of your dashboard. What counts is whatever is closest to getting paid.

Every business has its quirks, but there is a set of indicators that works for almost any small service or product business. I suggest grouping them into four areas and picking two or three from each.

Sales

• Sales or revenue for the week, compared with the same week of the previous period and with your target.
• Average order value: how much each customer or order spends on average.
• Close rate: out of every ten opportunities or quotes, how many turn into a sale.
• Pipeline value: the total amount of open opportunities, to anticipate sales in the coming weeks.

Lead generation

• New contacts or leads per week, broken down by channel (website, Google, social media, referrals).
• Website conversion rate: visits that end in a form, call, booking or purchase.
• Cost per lead or per customer on paid channels, if you invest in advertising.
• First response time to a new contact: an often forgotten indicator that has a big influence on how many convert.

Collections and cash

• Amount outstanding, and how much of it is already overdue.
• Average collection period: how long it takes you, on average, to get paid after invoicing.
• Overdue invoices older than 30, 60 or 90 days.
• Cash forecast for the coming weeks: what comes in versus what goes out.

Operations

• Orders or projects in progress and how many are running late.
• Average delivery or resolution time.
• Incidents, returns or complaints during the week.
• Utilisation of the team or the calendar, if you sell hours or appointments.

You don't need to start with all of them. A first dashboard with six to eight well-chosen indicators already changes the way you run a business. What matters is that they're linked to your goals for the year: if your priority is growth, lead generation and sales will carry more weight; if it's getting cash flow in shape, collections will.

A dashboard is only as reliable as the data feeding it. In a typical small business, the information is spread across three or four places:

• The CRM: contacts, opportunities, quotes, close rate and response time. If you still manage customers in scattered spreadsheets, it's worth reading why a CRM beats Excel on this specific point.
• The invoicing software or ERP: sales, average order value, outstanding and overdue payments, and margins.
• Web analytics: visits, traffic sources and conversions. If yours isn't set up properly, start with my guide to Google Analytics 4 for small businesses.
• Ad platforms and the booking calendar: spend, cost per contact, appointments and utilisation.

The challenge isn't so much getting the data as making sure it's consistent. If the CRM calls something a “customer” that the invoicing software doesn't, or if contacts coming through the website aren't recorded with their source, the dashboard will show numbers that don't add up and you'll end up not trusting it. That's why, before designing charts, it's worth reviewing how each piece of data is recorded and making sure the source of every contact is captured from the very first moment.

The other challenge is getting the data to arrive on its own. If building the dashboard means someone has to export three reports every Monday and paste them into a spreadsheet, the routine won't last many weeks. Most CRMs, invoicing tools and analytics platforms let you pull information automatically, and connecting those sources is a typical automation job that you do once and forget about. Ideally, when you open the dashboard, the numbers are already there, up to date and untouched by anyone.

To get started, a spreadsheet is a perfectly valid option. One tab per area, one row per week and a few simple formulas give you a first dashboard in an afternoon. Free tools such as Looker Studio also let you connect Google Analytics and spreadsheets to generate charts that update themselves.

The problem appears when the data lives in several programs and has to be copied by hand every week. That's when the spreadsheet starts failing for the usual reasons: someone forgets to update it, a figure gets pasted into the wrong row, formulas break and, in the end, nobody knows whether the numbers are this week's or last week's.

• Spreadsheet: ideal for testing which indicators work for you, with little data and a single person in charge.
• Connected visualisation tools: a good intermediate step if your programs have an available connector.
• Custom dashboard: makes sense when data comes from several systems, you want it to update itself, you need indicators calculated with your own rules or you want each team member to see only what's relevant to them.

A custom dashboard can live inside your own CRM, reading directly from invoicing and the website, without copying anything. That's one of the advantages of having a custom CRM: the dashboard isn't an add-on, it's just another screen in the system you already use every day.

A dashboard nobody looks at is useless. What really makes the difference is checking it on the same day, at the same time and with the same questions. This is the routine I usually recommend:

1. 1Same time every week. Monday morning or late Friday, blocked in your calendar like any other meeting.
2. 2Start with what's out of the ordinary. Look at which indicators have changed a lot since last week or are far from target. Give the rest a quick glance.
3. 3Ask why. A drop in contacts could be down to a broken form, a change at Google or a campaign that ended. The number tells you where to look, not the answer.
4. 4Decide on one or two actions. Not ten. One or two concrete things for the week, each with an owner.
5. 5Review last week's actions. Did they happen? Did they move the indicator? That's how the dashboard becomes an improvement loop rather than just another report.

Once a month, spend a bit more time looking at trends: how the indicators have evolved over several months and whether your targets still make sense. And once a quarter, ask yourself whether you're still tracking the right indicators.

• Too many indicators: if there are forty numbers, you don't look at any of them.
• Figures without comparison: a number on its own doesn't tell you whether it's good or bad. Always compare it with the previous period and with a target.
• Relying on someone to copy the data by hand every week.
• Measuring only the past: add at least one leading indicator, such as the pipeline or new contacts, that warns you about what's coming.
• Not defining each indicator in writing: if everyone calculates the close rate their own way, the discussions will be about the number rather than the business.

A dashboard isn't a technology project; it's a management habit backed by good data. Choose a few indicators per area that are tied to revenue, collections and customers, make sure the data flows reliably from your CRM, invoicing and analytics, and check them every week with the intention of deciding something. Start with a spreadsheet if you like; when copying data becomes a burden, that's the time to automate it.

I'm Elmar Mamedova, a full stack developer based in Málaga. I build custom CRMs and dashboards for small businesses that want to stop running things by eye: systems that bring sales, collections and lead generation together on one screen and update themselves. If your numbers are scattered across several programs and spreadsheets, I'll help you put them in order so that every Monday you know exactly where your business stands.