Behavior

Looker Studio: management reporting without Excel and without 40 charts

Looker Studio can turn data into a report that updates itself. Most dashboards, though, end up as 40 charts nobody looks at. Here is how to build a report you can actually make decisions with.

Štěpán Pluháček5 min read

Illustration: a clear report with a rising line and three key figures in front of a pile of spreadsheets.
In this article
  1. What Looker Studio is
  2. Why most dashboards interest nobody
  3. Data sources: what you can connect for free and what you can’t
  4. Building a management report step by step
  5. Example: a monthly report for an e-shop owner
  6. What to watch out for
  7. When Looker Studio stops being enough
  8. Checklist before you share the report

What Looker Studio is

Looker Studio is Google’s free tool for building reports and dashboards. It was called Google Data Studio until 2022, and in April 2026 Google went back to that name, so today you will find it as Data Studio and people search for it under both names. You connect data sources such as GA4, Google Ads, Search Console or Google Sheets and build a report from them that updates itself.

The main benefit is simple: instead of copying numbers into Excel and presentations, you have one link with the current state. The time saved is secondary, though. What matters more is that everyone looks at the same numbers with the same definitions.

Why most dashboards interest nobody

A typical dashboard is born when someone connects all the available data and puts everything possible on the canvas. The result: 40 charts, zero decisions. A dashboard only makes sense when it answers specific questions of a specific person.

  • Owner and management: Is marketing making money? How much does a new customer cost? Are we on plan?
  • Marketing manager: Which channels and campaigns perform, and where does money leak?
  • Specialist: Campaign, keyword and creative detail.

Three people, three reports. One universal report serves nobody. How to pick the right metrics is covered in our overview of KPIs and business dashboards.

Data sources: what you can connect for free and what you can’t

Google connectors

For free and without extra tools you can connect mainly Google services: Google Analytics 4, Google Ads, Search Console, Google Sheets and BigQuery. For most companies this is the basis of website and search reporting.

Third-party connectors

Data from Meta Ads, Sklik, your e-commerce platform or CRM gets into Looker Studio through partner connectors, which are usually paid, or through an intermediate step: an export to Google Sheets or BigQuery. When choosing, count on a monthly fee and check how often the data is refreshed.

Data only you have

Margins, cost of goods, the revenue plan, the number of sales opportunities from your CRM. No connector will find these, yet these are exactly the numbers that turn a marketing report into a business report. The easiest route is a Google Sheets table that finance or sales updates once a month.

Building a management report step by step

  1. Write down the questions. At most five that the report should answer.
  2. One number per question. For example revenue, marketing costs, PNO, number of new customers and the cost of acquiring them (CAC).
  3. Define the calculation. What exactly is “revenue”? With VAT, without VAT, after returns? Write the definition directly into the report.
  4. Connect the sources. Google sources directly, the rest through Sheets or a connector.
  5. Combine the data. Looker Studio can blend several sources on a shared key, typically the date. That way you get costs from all channels next to revenue from your e-shop.
  6. Add a comparison. A number without a comparison says nothing. Compare with last month, last year or the plan.
  7. Leave room for a comment. A short text block “what happened and what we’re doing about it” is often worth more to management than the charts.

Example: a monthly report for an e-shop owner

Example (made-up numbers) of the first page of the report:

  • Revenue excluding VAT: CZK 1,200,000 (plan CZK 1,100,000, i.e. +9%).
  • Ad spend across channels: CZK 156,000.
  • PNO: 156,000 / 1,200,000 = 13%.
  • Gross margin after ad spend: with a 38% margin that is 456,000 − 156,000 = CZK 300,000.
  • New customers: 520. Simplified, crediting all costs to new customers, CAC = 156,000 / 520 = CZK 300.
  • Average order of a new customer: CZK 1,450.

You can make decisions from these six numbers. A CAC of CZK 300 with an average order of CZK 1,450 and a 38% margin (about CZK 551 of gross margin) means acquiring the customer pays for itself with the first purchase. Campaign detail belongs on the next page for marketing, not on the first page for management. Why to calculate with margin and not just PNO is explained in PNO, ROAS and margin.

What to watch out for

  • Different numbers across sources. Google Ads, Meta and GA4 each count conversions their own way. In the management report use revenue and orders from the e-shop or CRM, and ad platforms only for the split by channel.
  • Speed. Reports with many charts on top of GA4 load slowly and can hit GA4 API limits. Fewer charts and pre-aggregated data in Sheets or BigQuery help.
  • Sharing. A report shared by link can be seen by anyone who has the link. Share sensitive numbers such as margins and revenue only with specific people.
  • Ownership. The report and the data sources should belong to a company account, not to the personal account of an agency or a former employee.
  • Input quality. A dashboard is only as good as its data. If GA4 is off, so is the report, so go through GA4 for beginners first.

When Looker Studio stops being enough

For most mid-size companies, Looker Studio on top of Google Sheets and Google services is enough for years. The limits show when:

  • you combine data from many systems and manual updates to Sheets start causing errors,
  • you need data on individual customers and orders across channels, not just daily totals,
  • the report loads so slowly that people stop opening it.

Then it is time for a data warehouse, typically BigQuery, where data from individual systems is pulled automatically, and Looker Studio stays only the presentation layer. Don’t start there, though. A report that answers the five right questions from a manually updated table is worth more than perfect data infrastructure nobody looks at.

Checklist before you share the report

  • The report has a clear audience and at most five questions.
  • Every number has a written definition.
  • Revenue and orders match the e-shop or CRM.
  • There is a comparison with the plan or the previous period.
  • There is room for a comment.
  • The report and data sources are owned by a company account.
  • Sharing is restricted to specific people.

Looker Studio turns data into a clear picture. What it means for budget, prices or next steps, however, is a matter of interpretation. For the big picture of measurement, see our overview of analytics and measurement.

Share the article

Frequently asked questions

Is Looker Studio free?

Yes, the basic version is free. The paid Looker Studio Pro mainly adds content management for teams and companies.

What is the difference between Looker Studio and Google Data Studio?

None. It is the same tool, renamed by Google.

How do I get Meta Ads or Sklik data into Looker Studio?

Through a partner connector, which is usually paid, or by exporting the data to Google Sheets or BigQuery, which Looker Studio connects for free.

How often is the data in the report refreshed?

It depends on the source and the data freshness setting. For third-party connectors, the provider decides. For a management report a daily refresh is usually enough.

Want to talk it through for your business?

In a consultation we go through where your marketing is leaking money and what to do about it. No strings attached, no bullshit.

Book a consultation

Your call withJan Rypar, Founder