Looker Studio Dashboard for GA4: Business Guide

Igor Ivitskiy

Igor Ivitskiy

  • #6 in The Top 50 Most Influential PPC Experts
About the author ↓

Published 12 min read

In this article
  1. Why a business needs Looker Studio when GA4 already has reports
  2. How to connect Google Analytics 4 to Looker Studio
  3. The owner dashboard: five blocks on one screen
  4. How to join Google Ads and GA4 for a real return
  5. How to filter by source, campaign, and device
  6. How to share the report and email it on a schedule
  7. When this does not apply
  8. Questions and answers
  9. Are Looker Studio and Data Studio different products?
  10. Why does the lead price on the screen disagree with Google Ads?
  11. Who should be allowed to edit the report?
In short: put five numbers on one screen: ad cost, key events, cost per key event, revenue, and source. Do not add more charts until these five match the account.

A Looker Studio dashboard for GA4 is one screen. The official Google Analytics connector pulls ad cost, sessions, key events, and revenue onto it. You see three answers: how much money went out, how often the action you care about happened, and what one such action cost. You do not write a script for this.

Google’s help pages currently call this report builder Data Studio. The address lookerstudio.google.com opens the same product. The overview page says it is easy and free. The pricing page says there is no charge for the person who builds the report or for the person who only views it. Standard GA4 reports stay in place so you can check a number. I explain how to read those reports in How to Use Google Analytics 4.

Why a business needs Looker Studio when GA4 already has reports

A standard GA4 report answers an analyst’s question. The owner’s screen answers a money question. In GA4, cost, leads, and source sit in different sections. By the time someone pastes them into a spreadsheet, the week is gone and the budget is spent.

I have run Google ads and taught owners since 2006, and I keep seeing the same trap: many charts and no price for one lead. This screen puts the fields you need on one page for someone who does not live in the analytics account.

The connector help is plain about the limit. The connector matches GA4 reports, not explorations. A number that exists only in an exploration will not appear here on its own. A report that hits a Data API quota can show an error. That is why I keep a few scorecards, not an atlas.

How to connect Google Analytics 4 to Looker Studio

The same connector page lists the steps. The person who connects the property needs at least Read & Analyze permission on it. Without that permission the property list is empty, and the dashboard is not broken.

  1. Sign in to Data Studio. If you open lookerstudio.google.com, Google sends you to the same product.
  2. At the top left, click Create and choose Data Source.
  3. Choose the Google Analytics connector described in the help, not a third party connector.
  4. If you are asked for access, click Authorize.
  5. Select the account, then the GA4 property.
  6. At the top right, click Connect. The field panel appears. The source is connected.
  7. Click Create report, then Add to report. The editor opens, and the source becomes the report’s data.

On the field panel you can add a calculated field. You need one only when the connector does not already offer the metric. The price of a key event is already in the schema.

Choose whose access the source uses. Owner’s credentials let other people view the report without their own access to GA4. Viewer’s credentials require each person to have access to the property. For a bookkeeper I use the owner’s credentials: people see what the account that connected the property can see.

The owner dashboard: five blocks on one screen

These five blocks are the screen I want an owner to keep. They are not a Google limit. I do not add more charts until these five are in place. The questions worth using for a budget decision are in Ad Analytics for Business Owners. Here those questions sit on GA4 fields.

Block on the screenThe owner’s question
Ad costHow many dollars went into ads
Key eventsHow often the action you treat as a lead or a sale happened
Price of the eventWhat one such action cost
RevenueHow many dollars came back, if the event carries money
SourceWhere those people came from: channel, campaign, or device

A key event in GA4 is an action that matters to the success of the business. Any event you collect can be marked as one. The mark changes reports from the time you set it. It does not rewrite history. Events such as first_open or purchase may already be key events. A dentist who pays for a booked visit does not want a page scroll in the same pile. If both are key events, the price mixes the appointment and the scroll.

I take the scorecard fields from the Data API schema. In the connector the names are often in English, so look for them as they are written there.

Field in the reportWhat it counts
SessionsSessions that began on the site or in the app
Key eventsThe count of key events
Ads costThe total paid for ads, including a linked Google Ads account
Cost per key eventAd cost divided by all key events
Total revenuePurchase, subscription, and ad revenue minus refunds
Session sourceThe source that started the session
Session default channel groupThe session channel from source and medium
Session campaignThe session campaign name
Device categoryDesktop, Tablet, or Mobile

Cost per key event is the price of a result, the number an owner calls cost per lead. The schema has no field named CPA. The metric divides ad cost by every key event together, not by one event you pick. To get the price of one, put the Event name dimension in a table: each row aggregates the metric for one event name. Or keep a single event with a filter. Total revenue is purchase revenue plus subscription revenue plus ad revenue, minus refunds. Revenue appears only when GA4 receives purchase, subscription, or revenue events. If the lead carries no money, the screen shows a price per event, not a return.

How to join Google Ads and GA4 for a real return

A real return is revenue next to cost from the same property, not the letters ROI on someone else’s chart. Ads cost includes spend from linked integrations, including a linked Google Ads account, and cost uploaded by data import. If the account is not linked and cost has not been imported, the cost card is empty or incomplete.

Linking Google Ads to the GA4 property lets data move between the products. You can build a Google Ads conversion from a key event, see how that conversion performs, and reach people again from what they did on the site or in the app. I walk through the link itself in How to link Google Ads and Google Analytics.

The conversions column in Google Ads and GA4 key events are different counters. More than one in four accounts that track purchases have two or more purchase counters in that conversions column. About two thirds of accounts have a primary action that no campaign bids on. Put Ads conversions next to key events and call both leads, and the screen shows two different businesses.

The blending help lets you combine up to five sources without code, including Google Ads and Google Analytics metrics on one time series. I blend only when the field I need is missing from GA4. For cost and for the price of an event, one Google Analytics connector is enough after the link.

The date window is a separate problem. In a two step funnel the lead arrives almost at once and the payment arrives later. For such an account a report of 30 days undercounts the result by about a fifth. That is how this kind of funnel behaves. It is not a law for every trade. Label the date range on the screen. A short window can be right for leads. The same window will undercount revenue when the money comes in later.

How to filter by source, campaign, and device

A viewer cannot change an editor filter. A viewer can change a control. I give the owner controls, not a filter baked into the chart.

The control help says how to add one. In edit mode choose Add a control, pick the type, and set Control field to the dimension you want. These are the dimensions from the schema.

  • Session source is the source of the session. For a wider channel, use Session default channel group. Its values include Direct, Organic Search, Paid Search, Email, Referral, Display, and Video.
  • Session campaign is the campaign name. It includes Google Ads campaigns and campaigns you tagged yourself.
  • Device category is the device. The schema lists Desktop, Tablet, or Mobile.

The date range is its own control. A scheduled email uses the report’s default filters and date range. You can change those for one delivery on the Filters tab of the schedule. The email then arrives on the source you meant, not on whatever someone left selected the night before.

One caution on sessions. If a dimension splits one session into pieces, a stacked bar can add those pieces and show more sessions than the report inside GA4. For the owner’s scorecard I use a single Sessions number, not a stack of fragments.

How to share the report and email it on a schedule

Open the report and click Share. The sharing help splits the roles like this. Can view lets a person see the report and does not let them edit it or pass access on. Can edit lets them change the report, manage schedules, and share it further. I give Can view to the bookkeeper and to the owner who only reads the numbers. I give Can edit to the person who maintains the screen.

Access by email address requires a Google login. A public link does not, so I do not turn that on for cost and leads. A separate share of the data source is not required to view the report. Editing the data source or its fields requires permission on that data source.

The delivery help uses the same Share menu, then Schedule delivery. You are always on the recipient list, even when you add other people. Choose the pages, the start, and the repeat. The repeat can be your own pattern, not only every day or every month. The email carries a PDF, a preview of the first page, and a link to the full report. The owner or an editor sets the schedule. A recipient does not need edit access. If the company is on Data Studio Pro, an admin can limit which email domains are allowed. A blocked address will not save, and that is not a broken report.

The screen is only as useful as the action you are willing to pay for and the campaign you allow to spend. The step-by-step version of that setup is in my book on Google Ads for business owners.

Want the system, not scattered tips?

My e-book “19 Google Ads Secrets”: how to get the most out of Google Ads without draining your budget, drawn from real campaigns and tests.

See the book →

When this does not apply

The screen fails when several actions are key events and one of them is soft: a scroll, a click, a page view. Cost per key event divides ad cost by all of those events together. The price of a lead then looks better than the truth, and the budget looks healthy.

The screen fails when Google Ads is not linked and cost was not imported. Ads cost does not include that spend. Dividing a result by an empty cost does not help. Link the account and the property first, then put money on the card.

The screen fails when the number lives only in a GA4 exploration. The connector does not match explorations. If you check the number only there, the dashboard will not repeat it. Check it against a standard report.

Questions and answers

Are Looker Studio and Data Studio different products?

No. The address lookerstudio.google.com opens the product that the help pages currently call Data Studio. The Google Analytics connector and the PDF email live there.

Why does the lead price on the screen disagree with Google Ads?

Because the Google Ads conversions column and GA4 key events often count different things. The numbers agree when the Google Ads conversion is built from the same key event.

Who should be allowed to edit the report?

The person who maintains the screen. Everyone else can have Can view: they see the numbers and cannot change the fields or the schedule. The owner, an editor, or a person with Can create schedules can set the schedule. Can create schedules is a separate Data Studio Pro permission. Receiving the email does not require edit access. The person who creates the schedule is always a recipient.