Guide · 18 November 2026 · 5 min read

How to build a small business dashboard in Looker Studio: which numbers to track, connecting your data, layout tips and keeping it accurate and easy to read.

A paper dashboard with three gauges, the middle needle amber

By Rakibul Hasan, Moonlab

A small business dashboard is one page that shows the handful of numbers you check to run the business: sales, enquiries, cash owed, website traffic and reviews. Looker Studio, Google's free reporting tool, can build one from your spreadsheets, analytics and ad accounts.

This guide covers which numbers to track, how to connect data, how to lay out the page and how to avoid the mistakes that make dashboards ignored. It is for owners and managers in the US, UK and Europe. Features and connectors change, so check Google's current Looker Studio documentation. If you prefer a message to a page, see moonlab.space/guides/automated-business-reports.

Start with the questions, not the charts

Write down the five questions you ask most often. Are we on track this month? Where are enquiries coming from? Who owes us money? Each question becomes one or two numbers on the page.

If nobody will act on a number, leave it out. A dashboard with fifteen charts is a wall of noise.

Which numbers to track

Pick leading numbers, such as enquiries, and lagging ones, such as revenue. Use the same definitions every time.

  • Revenue and gross margin, by month.
  • New leads by source, and the share you answered within a day.
  • Quotes sent, quotes won and win rate.
  • Overdue invoices and the total owed.
  • Website visits, top pages and enquiries from the site.
  • Google Business Profile calls and direction requests.
  • Review count and average rating.
  • Ad spend and cost per enquiry, if you run ads.

Connect your data

Looker Studio connects directly to Google Sheets, Google Analytics, Search Console, Google Ads and many others. For tools without a direct connector, such as your CRM or accounting software, you can send data to a Google Sheet or a database using an automation or a third party connector, and point Looker Studio at that.

Third party connectors may charge a fee, so check the pricing. A tidy Google Sheet that is updated automatically is often the simplest bridge.

Design a page people can read

Put the most important numbers at the top as large scorecards with a comparison to last month. Group related charts. Use one or two colors and clear labels. Add a date range control and a title that states what the page shows.

Check the dashboard on a phone. Many owners look at it on the move.

  • Scorecards for headline numbers.
  • Line charts for trends over time.
  • Bar charts to compare sources or products.
  • Tables only for detail people need to read.
  • No 3D charts or decoration.

Keep it accurate

Write definitions on the page or in a note: what counts as a lead, whether revenue includes tax. Check the numbers against the source tool when you first build it and again after changes. Treat odd spikes and zeros as possible data errors.

Looker Studio shows what is in the source, so the quality of the source decides the quality of the dashboard.

Sharing and privacy

Share with named people, not with a public link, if the data is sensitive. Limit access to financial and customer data. If a report includes personal data about people in the UK or EU, remember GDPR applies. Do not include more personal data than you need.

Make it a habit

Review the dashboard at a set time each week, for ten minutes. Decide one action. Remove numbers that never lead to action, and add ones you keep asking about. If a bigger system is needed later, see moonlab.space/guides/power-bi-vs-looker-studio.

A worked example and common mistakes

Here is a made-up example. An electrician in Leeds wants to see, on one page, how many enquiries came in, how many quotes were sent and won, and how much was invoiced. He keeps enquiries in a Google Sheet that a web form fills automatically, and invoices in an accounting tool that exports a monthly summary to the same workbook through an automation.

In Looker Studio he creates a new report and adds the Google Sheet as a data source, checking that the date column is recognized as a date. At the top he adds four scorecards: enquiries this month, quotes sent, quotes won and invoiced total, each compared with the previous period. Below he adds a line chart of enquiries by week, a bar chart of enquiries by source (website, Google profile, referrals) and a table of unpaid invoices. A date range control at the top lets him change the period.

He then shares the report with his office manager by email address, not with a public link. Every Monday he spends ten minutes on it and writes down one action, such as following up quotes older than a week. After a month he removes a chart nobody used and adds average job value.

Look out for these mistakes when you build yours.

  • Too many charts, so the key numbers are buried.
  • Different definitions in different charts, such as lead and enquiry.
  • Not checking the dates and number formats in the source sheet.
  • Sharing a public link to financial or customer data.
  • Never checking the numbers against the source tool.
  • No owner, so nobody fixes it when a connection breaks.
  • Using decorative charts that are hard to read.

How to decide and what to do this week

Here is a simple routine to get your first dashboard live in a week, without letting it grow out of control.

  • Day one: write down five questions and the number that answers each.
  • Day two: put the source data in one Google Sheet or connect it directly.
  • Day three: build four scorecards and two charts only.
  • Day four: check every number against the source tool.
  • Day five: share it with named people and ask what is missing.
  • The next Monday: review it for ten minutes and note one action.

How Moonlab can help

We build dashboards and the data pipes behind them. See moonlab.space/services/data-and-analytics and moonlab.space/services/database-management.

A free 30-minute automation audit at moonlab.space/contact can help you decide which numbers matter.

Common questions

Related services

More guides

Find out what you can automate.

Book a free 30-minute audit. We go through a normal week with you, list the work that can run on its own, and estimate the hours it would save.

  • 30-minute call, free
  • Fixed price before any work
  • Everything built in your accounts