Every month you open GA4, then Search Console, then Google Ads, maybe Meta too, and copy a few numbers into a message or a notebook. Each tool has its own menus and date pickers, and by the third one you have forgotten what the first said. You want one page that shows the essentials, updates itself, and opens in a browser like any other link.
A Looker Studio dashboard for a small business can be exactly that. Looker Studio is Google’s free reporting tool, and it connects directly to GA4 and Search Console. This post explains how to connect your data, what to put on a single page, and how to keep the dashboard simple enough that you keep using it.
What Looker Studio is, and what it is not
Looker Studio, previously called Google Data Studio, builds reports and dashboards from data sources. You connect a source, drag charts onto a page, and the charts update from the source when the report is viewed. Reports are shared like Google Docs, by link or with specific people.
It does not collect any data of its own. If your GA4 key events are wrong, the dashboard shows the same wrong numbers more attractively. Get tracking right first; our overview of small business marketing analytics covers that foundation.
It is also not a replacement for looking at the underlying tools occasionally. A dashboard answers the questions you designed it for, and hides everything else.
Connecting your data sources
Google provides free connectors for its own products. For a small business, three matter most.
Google Analytics
Add a data source, choose the Google Analytics connector, and pick your GA4 property. You need at least read access to the property. Charts can then use GA4 dimensions such as session default channel group, landing page and date, and metrics such as sessions, key events and engagement rate.
Search Console
The Search Console connector asks you to choose your site and a table. The site impression table summarises performance for the whole site and suits totals and query lists. The URL impression table is broken down by page and suits a “top pages from search” chart. If your site is not verified in Search Console yet, start with our guide to connecting WordPress to Search Console.
Google Ads and Sheets
A Google Ads connector brings in spend, clicks and conversions. A Google Sheets connector is useful for anything else, such as a lead sheet with real enquiry outcomes, or monthly spend from platforms that do not connect for free.
Meta Ads and many other platforms need third-party partner connectors, many of which are paid. For a small business, typing monthly Meta spend and results into a sheet is often simpler than paying for a connector.
A one-page marketing dashboard layout
Resist the long multi-page templates. One page, readable at a glance, is the kind that gets used. This layout works for most service businesses:
| Area | Chart type | Shows |
|---|---|---|
| Top row | Scorecards with comparison to previous period | Sessions, key events (enquiries), search clicks, ad spend |
| Middle left | Time series | Key events by week over the last few months |
| Middle right | Table or bar chart | Key events by channel |
| Bottom left | Table | Top landing pages with sessions and key events |
| Bottom right | Table | Top search queries with clicks and impressions |
| Header | Date range control | Lets the viewer change the period for every chart at once |
For an online shop, swap key events for purchases and revenue, and add a table of top products.
Building the Looker Studio dashboard, step by step
- Create a blank report and add the GA4 data source.
- Add a date range control at the top and set its default to the last complete month, or the last few weeks. Every chart on the page follows it unless set otherwise.
- Add scorecards. In each scorecard’s settings, switch on the comparison to the previous period, so the change shows as a small up or down figure.
- Add the time series with date as the dimension, set to week, and key events as the metric. Weekly lines are easier to read than daily ones for small numbers.
- Add the channel table with session default channel group and key events, sorted by key events.
- Add the Search Console source and build the query table from it.
- Label everything in plain words. Rename “key events” to “enquiries” in the chart if that is what they are. Add a short text box explaining what counts.
- Share it with view access for anyone who needs it.
Keeping the marketing dashboard simple and trustworthy
- Show results first, activity second. Enquiries and sales at the top, sessions and impressions below.
- Use one metric name per idea. If you rename a metric, rename it the same way everywhere.
- Limit charts. A heavy page with many GA4 charts can load slowly or hit Google’s usage limits and show errors. Fewer, focused charts load faster.
- Mind small numbers. Percentage changes on tiny totals look dramatic. A scorecard jumping from two enquiries to four is not a doubling of the business.
- Note tracking changes. A text box listing dates when tracking was fixed or changed stops people misreading jumps in the charts.
- Keep ownership in the business. Create the report with a business Google account, and check the data credentials setting, so the dashboard does not stop working when an employee or agency leaves.
Who should see it, and how often
A dashboard nobody opens is wasted effort, and one that everyone checks hourly causes its own trouble. Decide who it is for before sharing it widely.
- The owner or decision-maker should look at it once a month, ideally at the same point each month, alongside the real enquiry list.
- Whoever runs the ads or the SEO may look more often, but should still make judgements on monthly or longer trends.
- Front-desk or sales staff usually need only the enquiry figures, if anything. A filtered copy with just the top row is enough.
Give view access by default. Edit access belongs to the one or two people maintaining the report, so charts do not change unexpectedly between reviews.
What a dashboard cannot do for you
A dashboard shows numbers. It does not tell you why they moved, whether the leads were any good, or what to do next month. That interpretation belongs in a short written report, built from the dashboard and your own records. Our monthly marketing report template covers that part.
If you are not sure which GA4 numbers belong on the page in the first place, our tour of the GA4 screens owners actually use is a good starting point.
Frequently asked questions
Is Looker Studio really free?
The standard Looker Studio is free to use with Google’s own connectors, such as GA4, Search Console, Google Ads and Sheets. Costs usually come from third-party connectors for other platforms, or from the paid Pro version aimed at larger organisations. Most small businesses never need either.
How up to date is the data in a Looker Studio dashboard?
Charts fetch data from the source when the report loads, subject to a data freshness setting that caches results for a while. GA4’s own processing delay also applies, so the most recent day or two may be incomplete. For a monthly view this rarely matters.
Can I get the dashboard emailed to me each month?
Yes. Looker Studio can schedule delivery of a report by email to chosen recipients on a regular schedule. The email includes a link and an attached copy of the page. Set the date range control to a relative period such as last month so each delivery shows the right dates.
Should my agency give me their dashboard or build one in my account?
Ask for the report to be owned by, or transferred to, a Google account your business controls, with data sources using credentials that will keep working if the agency leaves. A dashboard owned only by the agency can disappear when the relationship ends.
A small, clear dashboard is one of the easier wins in analytics once the tracking underneath it is right. If you want the tracking checked and a simple dashboard built on top of it, our tracking and dashboard setup covers both. You can see how it supports the rest of our digital marketing services.
Next in this series: GA4 Not Tracking? Checks When Analytics Shows No Data
