Looker Studio dashboard for small business

A simple Looker Studio dashboard for a small business is one page that shows, at a glance, how many leads came in, from which channels, at what cost and how many became customers. Looker Studio, Google's free reporting tool, connects to GA4, Google Ads, Search Console and Google Sheets without extra cost, so you can build that page in an afternoon. The trick is restraint: eight well-chosen charts beat forty that nobody reads.

This guide walks through which data to connect, a layout that works for most local businesses, and the mistakes that make dashboards untrustworthy.

Why bother with a dashboard

GA4, Google Ads, Meta and your CRM each have their own reports, logins and definitions. Checking four tools every month is how owners stop checking at all. A dashboard pulls the key numbers into one place, updates automatically, and can be shared with a partner, manager or accountant with a single link.

It also forces a useful conversation: what do you actually want to see every month? Answering that is half the value.

Step 1: connect four data sources

For most small businesses, these cover the essentials:

1. GA4 for website traffic and key events (enquiries, calls, bookings). Make sure key events are set up first; my GA4 guide for small business owners shows how to check.
2. Google Ads, if you advertise there, for spend, clicks and conversions.
3. Search Console for how people find you in Google search: queries, clicks and positions.
4. A Google Sheet for everything else: Meta ad spend, CRM data on leads won and revenue, offline marketing costs.

The Sheet is the unsung hero. Many CRMs can export to a sheet, or you can fill in a few numbers by hand once a month. That is how customers and revenue, the numbers that matter most, get onto the dashboard without paid connectors.

Step 2: plan one page

Sketch it on paper before opening Looker Studio. A layout that works for most local service businesses:

Top row: four scorecards.

• Leads this month (with change vs last month).
• Total marketing spend.
• Cost per lead.
• Customers won.

Middle: two charts.

• Leads by channel over the last 12 months, as a stacked bar chart.
• Spend and cost per lead by channel, as a table.

Bottom: two tables.

• Top landing pages with sessions and key events.
• Top Search Console queries with clicks.

Add a date range control at the top so you can switch between months, and a channel filter if you want.

Step 3: build it

• Start from a blank report, not a busy template.
• Add your data sources.
• Create scorecards first. For each, set the comparison period to "previous period" so the change appears automatically.
• Use a blended data source if you need to combine spend from the Sheet with leads from GA4. Keep blends simple; they are where most errors hide.
• Use the same colours for the same channel in every chart.
• Label everything in plain words. "Enquiries" is clearer than "key_event_generate_lead".

Step 4: check the numbers

Before sharing, compare the dashboard with the source tools for one month:

• Do leads in the dashboard match GA4 key events for that month?
• Does spend match what Google Ads and Meta billed?
• Do customers won match your CRM?

Small differences are normal (time zones, attribution, consent). Big differences mean a filter, blend or date setting is wrong. Fix it now, or the dashboard will quietly lose your trust.

What to leave out

• Impressions and reach on the main page.
• Device and browser breakdowns, unless you are investigating a problem.
• Charts for channels you do not use.
• More than one page, at least until the first one is used regularly.

For more on which numbers deserve attention, see marketing reports: what to look at and what to ignore.

Common mistakes

Mixing up users and sessions. Pick one consistently for traffic.

Counting the wrong conversions. If GA4 counts page scrolls as key events, they will appear as leads. Clean up the event setup first.

Comparing different periods across sources. Search Console data appears with a delay of a few days, so the last few days of the month may look low.

Hard-coded date ranges. A dashboard stuck on "January 2027" is useless in March. Use relative ranges like "last month".

Sharing edit access widely. Give most people view access only, so the layout stays intact.

A variation for online stores and multi-location businesses

The one-page layout above suits most service businesses. Two common variations:

Online store. Replace leads with orders and revenue, and cost per lead with return on ad spend. Add a chart of revenue by channel and a table of top products. If the store platform does not connect directly, a weekly export to a Google Sheet works fine.

Several locations. Keep the same page, but add a location filter at the top and a table comparing leads, cost per lead and customers by location. This often reveals that one branch converts leads much better than another, which is usually a staffing or follow-up question rather than a marketing one.

In both cases, resist adding a second page until the first one is opened every month.

Privacy and access

Looker Studio shows aggregated data from your accounts, not personal information, as long as you do not pull individual customer names or emails into it. Keep CRM exports in the Sheet at the level of counts and totals. The report and the underlying accounts should belong to your business's Google account, not a freelancer's personal one.

Making it a habit

Set a reminder for the first Monday of each month. Open the dashboard, look at the four scorecards, note anything unusual, and ask one question of whoever runs your marketing. Fifteen minutes, twelve times a year, is enough to stay in control.

Getting it built

If you prefer not to build it yourself, I set up Looker Studio reporting connected to your GA4, Google Ads, Search Console and CRM data, quoted after a short call depending on the sources. If your tracking needs fixing first, a GA4 and Google Tag Manager setup costs $650. Everything is created in your accounts, so the dashboard stays yours.