Looker Studio: dashboards that update themselves

Looker Studio (formerly Google Data Studio) is a free Google tool for building dashboards and reports. You connect sources like GA4, Search Console, Google Ads and Google Sheets, and build overviews that update automatically. No more monthly exports and pasted charts — just one report you open again and again.

What you can do with Looker Studio

• Data from several sources on one page. GA4 traffic, Search Console search data and Google Ads costs side by side, without copying numbers from three tools yourself.
• Automatic updates. Your report is always current; you read it instead of rebuilding it every time.
• Share like a Google Doc. Via a link, with view or edit rights, or as a scheduled email with a PDF attachment on a fixed day each month.
• Filters and date pickers, so everyone can zoom in on a channel, period or campaign without changing the whole report.
• Calculated fields, such as cost per enquiry or conversion rate per channel, built from existing numbers.
• Templates, letting you start quickly instead of from a blank canvas.

How to build a report (step by step)

1. Open Looker Studio and choose "Blank report" or a template. Google offers ready-made templates for GA4 and Search Console, a good starting point if you've never built a dashboard before.
2. Add a data source. Choose GA4, Search Console or Google Ads, sign in and select the right property or account.
3. Drag your first chart onto the canvas. Start with a scorecard (one big number, like "enquiries this month") rather than complex charts straight away.
4. Add a date range control, so you can change the period yourself without rebuilding the report.
5. Build out section by section. For example: key numbers at the top, a table per channel below that, a trend chart over time at the bottom.
6. Set up automatic refresh and sharing. Under "Share" you can schedule a fixed email with a PDF for, say, the first of the month.

Free versus Looker Studio Pro

For most SMEs the free version is plenty. Do watch ownership: create reports with a company account, not the personal Gmail of an employee who may leave one day. If that person leaves with their account, your report can suddenly stop working because the connection was tied to their name.

Connectors

Google's connectors (GA4, Search Console, Google Ads, Google Sheets, BigQuery) are free and built into Looker Studio by default. If you want other sources in there, such as Meta Ads, LinkedIn, HubSpot or Shopify, you usually need a partner connector: a link built by a third-party company, such as Supermetrics, Windsor.ai or Porter Metrics. These are often paid, per month or per connected source; check current pricing on the relevant provider's site.

A cheaper alternative: export the data manually (or via an automated connection) to Google Sheets or BigQuery, and connect Looker Studio to that instead. It takes more setup work, but saves a fixed monthly fee for a connector if you only need one or two external sources.

Building a good dashboard

The risk with Looker Studio is that it's so easy you put everything in. A dashboard with sixty charts leads to fewer decisions than one page with five numbers, because nobody knows where to start.

1. Start with the question. Which decision do you want to make each month? Splitting budget, improving pages, comparing channels? Build the report around that decision, not around everything that's measurable.
2. Pick three to five numbers per goal. See KPIs and avoid vanity metrics: pageviews say little, enquiries and revenue say a lot.
3. Answer at the top. Scorecards with the key numbers and the comparison with the previous period, so the reader knows in five seconds whether things are going well or badly.
4. Explanation below. Per channel, per page, per campaign: where does that rise or fall come from?
5. One dashboard per audience. Management wants a different overview than your campaign specialist: high-level versus detailed.
6. Write down what you see. A text box with "what stands out and what we'll do" is worth more than another chart, and stops everyone drawing their own conclusion.

Web shop example: a dashboard with revenue, number of orders and average order value this month versus last month at the top, a table of revenue per channel (organic, Google Ads, email) below, and a six-month trend line at the bottom.

B2B service provider example: the number of enquiries and their source (organic, Ads, referral) at the top, an overview per landing page below, making clear which pages actually generate leads.

Local business example: a simple report with phone clicks, directions requested and form submissions per week, linked to Google Ads spend to show whether the ads are paying for themselves.

Common mistakes

• Too much in one report. One overloaded dashboard instead of a few focused reports per audience.
• Numbers without context. A figure without a comparison to a previous period or a target says little.
• Building a report and never touching it again. A dashboard that doesn't grow with your business becomes outdated over time.
• Ownership resting with one person. See the point above about company accounts; this often goes wrong at growing companies.
• Only looking, never discussing. A dashboard only adds value once it's actually used in a meeting or decision.

What to watch

• Numbers differ. GA4, Google Ads and your CRM never report exactly the same, for example due to differences in attribution or measurement windows. Agree which source leads. See measuring online marketing.
• Speed. Many charts directly on GA4 make reports slow and can hit quota limits, especially with large datasets. As you grow, use an extract or BigQuery.
• Access. Data access runs through the source owner. If they leave, your report may stop working.
• Privacy. Don't share reports with personal data (names, email addresses) via a public link; use restricted access instead.

How it works with other tools

Looker Studio rarely stands alone. A typical combination: Google Tag Manager makes sure the right events get measured, GA4 collects and structures that data, and Looker Studio turns it into a readable overview. For data that doesn't come from Google tools by default (like CRM numbers or manual targets), Google Sheets often works as a middle step: you fill a sheet manually or automatically, and connect it to your report.

When you don't need Looker Studio (yet)

If you only have one data source and already look at it directly (for example just GA4 for a small site), a separate dashboard adds little. Looker Studio becomes valuable once you want to combine multiple sources, share a report structurally with several people, or spend time every month manually gathering numbers from separate tools.

Alternatives

Power BI (strong in Microsoft environments and organisations already working with Excel and Microsoft 365), Tableau (heavy and powerful, mainly for large data teams), Databox and AgencyAnalytics (quick out of the box, but paid monthly). If you mainly work in Google tools, Looker Studio is the logical free start. Note the difference with Looker (without "Studio"): that's Google Cloud's heavyweight paid BI platform for large data teams, not to be confused with the free dashboard tool.

Frequently asked questions about Looker Studio

Is Looker Studio free?

Yes. There's a paid Pro version with admin and support, and some third-party connectors cost money.

Is Looker Studio the same as Google Data Studio?

Yes, Google Data Studio was renamed Looker Studio in 2022. The functionality stayed largely the same; only the name and branding changed.

Can I put Meta Ads in Looker Studio?

Not with a free Google connector. Use a partner connector such as Supermetrics or Windsor.ai, or an export via Google Sheets.

How often does the data update?

It depends on the source and the data freshness setting, often every few hours. GA4 data has its own delay too, so don't expect real-time numbers in a Looker Studio report.

What's the difference between Looker and Looker Studio?

Looker Studio is the free dashboard tool for marketing reports. Looker is a paid enterprise BI platform for data teams working with much larger and more complex datasets.

Can I use Looker Studio without Google Analytics?

Yes, you can connect any supported source, such as Google Sheets, BigQuery or Search Console, without GA4 being required. Many businesses do combine them, since GA4 often forms the basis of their web data.

Is Looker Studio suitable for a small business with no data background?

Yes, the basics can be learned with a bit of practice without technical knowledge. For more complex calculated fields or combining multiple sources, spreadsheet experience helps.

Further reading

Want to know more about good reporting? Read measuring online marketing, KPIs and Google Tag Manager for the tracking itself. Want to look together at which numbers count for you? Book a free strategy session.