One Dashboard for Every Number That Runs Your Business

You know your busiest day of the week. You probably know roughly what came in last month. But if someone asked you right now whether your Google Ads spend is generating more bookings than it did three months ago, whether your review score has shifted since you took on new staff, or what percentage of last month's revenue came from repeat customers, you would need four logins and ten minutes to find out.

That is not an information problem. It is a location problem.

The numbers exist. They sit in your booking system, your Google Ads account, your Google Business Profile and your bank. The problem is that data checked in separate places, at separate times, never shows you the connections between pieces. And the connections are where every real business decision lives.

Why do I have loads of data but still can't answer basic questions about my business?

Because scattered data creates the illusion of information without the reality of it. According to a Digitalisation World study, half of business leaders feel overwhelmed by the volume of data and dashboards they encounter daily, yet only 45% of business data is ever actually used in decision-making.

The rest sits in platforms you check reactively. You look at bookings when you are worried about a quiet week. You check your ad spend when the invoice arrives. You notice your reviews when a customer mentions one. Each number lands alone, so the pattern between them stays invisible.

A unified dashboard does not give you more data. It shows you existing data at the same time, which is when patterns become decisions.

What numbers should a small business actually track?

For most local service businesses, four numbers tell the full story: bookings (how many appointments or jobs came in), revenue (what they were worth), ad spend and cost per lead (what you paid to generate them), and your Google review score with recent volume. Everything else is downstream of these four.

Social media reach is a vanity metric if it does not convert. Website traffic matters only if you know whether it generates enquiries. These four numbers are directly connected: your ad spend should move your bookings; your bookings generate revenue; your review score affects whether the next person who finds you on Google calls or scrolls past.

The UK Competition and Markets Authority estimates £23 billion of UK consumer spending is influenced by online reviews each year. Businesses with more than nine recent reviews generate around 52% more revenue than the average. Your review score is not a reputation metric. It is a revenue metric, and it belongs on the same screen as your bookings and your ad spend.

Does having everything in one place actually change anything?

Yes, and the reason is not convenience. It is sequence. When you see related numbers together, you can ask the question that actually matters: did the campaign that cost more bring in more revenue, or just more clicks?

A plumber that Braynex Services worked with was spending £280 a month on Yell and getting three leads. He was checking enquiries on his phone and looking at his Yell account separately when the monthly bill arrived. The two numbers never appeared together, so the cost per lead was never visible.

When Braynex Services moved him to a Google Business Profile combined with a small Google Ads campaign at £120 a month and set up a simple dashboard showing spend alongside monthly enquiry volume, the result was immediate: 18 to 22 enquiries a month at less than half the previous cost.

He had the information to make a decision he had been putting off for two years. Not because he had new data, but because he saw the existing data in the right order, at the same time.

Why do most small business dashboards fail?

They track too much, or they go stale. A dashboard with 22 metrics is not a dashboard. It is a report that nobody reads. According to Digitalisation World research, 34% of business leaders say they do not have enough time to analyse the data they already receive. Adding more numbers does not fix that problem. It makes it worse.

The second failure is maintenance. Pulling live data from five separate platforms is technically awkward, so many businesses end up with a dashboard updated manually every few weeks by whoever has a spare hour. That is a spreadsheet with extra steps. A useful dashboard updates automatically, shows fewer than ten numbers, and can be read in under two minutes.

How do I build a KPI dashboard without technical skills?

Start with Google Looker Studio. It is free, connects directly to Google Ads, Google Analytics and Google Business Profile, and requires no coding. For bookings and revenue, most modern booking systems export data or have a direct connector to a Google Sheet, which Looker Studio reads automatically. With clean data sources, this is an afternoon's work, not a developer project.

What should go on the dashboard?

• Bookings this month vs. last month, from your booking system or CRM
• Revenue this month vs. last month, from your payment processor or accounts package
• Google Ads spend and cost per enquiry, pulled directly from Google Ads
• Current Google review score and number of reviews in the last 90 days, from Google Business Profile

That is four data points. Add call volume, email sign-ups or repeat booking rate once the basics are working. Start with four.

What routine should I build around it?

Block 20 minutes on the same day each week. Look at the same four numbers. Ask one question: what moved, and why? A dashboard you look at for 20 minutes every Monday will outperform one you spent months building and check quarterly.

What if I don't have a booking system yet?

Then the dashboard is not your first problem. If bookings are arriving through WhatsApp messages, unlogged phone calls and occasional emails, you have an infrastructure problem, not a reporting one. A dashboard cannot summarise data that was never captured in the first place.

Only 25% of UK businesses analyse data to generate new insights, despite 86% now handling digitised data, according to the GOV.UK Business Data Survey 2026. For most local businesses, the blocker is not analysis. It is that the underlying data was never recorded cleanly. Braynex Services regularly works with businesses that need to get onto a proper booking system before any reporting makes sense. You cannot unify what was never collected.

This is the sequence that actually works: own your infrastructure first, capture clean data second, then build the view on top. Skipping straight to the dashboard is why most attempts fail within a month.

What is the simplest version I can start with today?

A Google Sheet with five columns: week, bookings, revenue, ad spend, review count. Updated every Monday before you open. Shared with no one except you. That is technically a dashboard. It is not elegant, but it will tell you more than five separate platforms checked at random across the week, and it takes ten minutes to set up.

When you are ready to automate it and pull live data, that is the point to bring in proper tooling. The habit of looking at the same numbers in the same order each week matters far more than the sophistication of the tool you use to do it. Start there.

If you want to see what your business looks like when the numbers are finally in one place, Braynex Services offers a free audit at braynexservices.com. We will look at what data you currently have, where the gaps are, and what a simple unified view of your business would actually show you.