Lorixen.
EN

A One-Page Looker Studio Report for a Small Business Owner

Short answer: Looker Studio is Google's free reporting tool, and it can connect directly to Google Analytics 4 and Search Console. Build one page that shows six numbers: sessions, key events such as enquiries, top landing pages, search clicks, search impressions and top search queries. Pick a fixed date range, such as the last complete calendar month, and share the page using owner credentials so viewers see the data without needing access to the underlying accounts. Keep the layout to one page of scorecards and two or three simple charts, so it loads quickly on a phone.

Decide the six numbers first

Before you open the tool, write down the question the page must answer each month. For most small businesses it is something like: are more people finding us, are they contacting us, and which pages are doing the work? That leads to six numbers:

  1. Sessions from GA4, to show total visits.
  2. Key events from GA4, such as form submissions, booking clicks or phone taps, so the figure reflects enquiries rather than page views.
  3. Top landing pages from GA4, showing which entry points bring people in.
  4. Search clicks from Search Console, to show visits from Google results.
  5. Search impressions from Search Console, to show how often your pages appeared.
  6. Top search queries from Search Console, to show the words people typed.

Leave out anything you would not act on. A dashboard with twenty charts usually gets ignored after the first month.

Connect the data sources

  1. Open Looker Studio, choose Create, then Report.
  2. Add a data source and choose the Google Analytics connector. Select the GA4 property for the website.
  3. Add a second data source with the Search Console connector. Select the site property, not a single page.
  4. Name each data source clearly, such as "Site GA4" and "Site Search Console", so you can recognise them when building charts.

Build the page

Add scorecards for sessions, key events, search clicks and search impressions across the top row. Each scorecard should show the current period with a comparison to the previous period. Below them, add a table of top landing pages with sessions and key events, and a second table of top search queries with clicks and impressions. A single bar chart showing sessions by week fills the space well.

Avoid pie charts for this page. Small differences are hard to read, and the table already gives the exact values.

Avoid the blended-data trap

Looker Studio can blend two data sources into one chart, but blending needs a field that both sources share, and GA4 and Search Console rarely match cleanly. Results can look right and still be wrong, because the join drops rows. Keep each chart tied to one data source. If you need to compare the two, put the figures side by side in two charts, and explain the comparison in a short text box.

Use a date convention

Choose the last complete calendar month as the default date range. Using "last 30 days" changes meaning every day and makes month-to-month comparisons unreliable. Search Console data also arrives with a delay of a few days, so a range that ends today will look incomplete. Write the convention at the top of the page, such as "Figures cover the previous full month".

Keep it fast and readable

  • Limit each table to ten rows.
  • Remove fields you do not use, because each extra field adds work when the report loads.
  • Check the page on a phone, where scorecards should stack rather than squeeze.
  • Turn on the data cache if the connector offers it, so the page does not refetch the same figures every time someone opens it.

Share the page without exposing the accounts

Use the Share button and set each data source to use the owner's credentials. Viewers then see the figures without needing access to GA4 or Search Console, and they cannot edit the report unless you give them that role. Check the sharing list each quarter, and remove anyone who no longer needs it.

If the report needs to show different information to different people, make a copy rather than adding filters to the same page. Simple copies are easier to audit.

Write a short commentary box

A dashboard with no context invites the wrong conclusion. Add a text box at the top of the page with three lines: the period covered, one thing that changed since last month, and one action for next month. Keep it to what the figures show. Sessions can rise because of a seasonal event, and the note should say so rather than claim that a campaign worked.

Update the commentary by hand each month. It takes about ten minutes, and it turns the report from a picture into a decision aid.

When a number looks wrong

If a scorecard shows a figure you do not recognise, check three things first. Confirm the date range, because a custom range can differ from the calendar month you intended. Check the data source, since a chart can point to a different property than the one you think. Then compare the figure with the native report in GA4 or Search Console for the same period. Small differences are normal, because each tool counts differently, but a large gap points to a setup error.

FAQ

Is Looker Studio really free?

The standard tool is free to use with a Google account. Check the current terms if you plan to connect many large data sources or use premium connectors.

Why do the Search Console numbers differ from GA4?

They measure different things. Search Console counts clicks from Google results, while GA4 counts visits from all sources, after its own rules for sessions and consent. Use each for what it measures.

Can I add a monthly email?

Looker Studio can schedule email delivery for a report. Send it to a small group, and check that the recipients have the access they need.

How long does it take to build?

Expect a few hours for the first version, including checking the figures against the source reports. After that, a monthly refresh takes minutes.

If you would like us to build the page and check it against your accounts, tell us which Google accounts you use.

Sources

WhatsAppBook a call