GA4 Looker Studio Full User Guide with Templates｜Describe how to link and create reports.

February 19, 2023

GA4 Looker Studio Full User Guide with Templates｜Describe how to link and create reports.

Introduction.

With the end of Google Analytics Universal Analytics (UA) on July 1st, 2023, many of users may be considering how to use GA4 to create reports for your clients or internal use that have been created using UA data.

Or, there are many people who have already created GA4 reports on Look Studio, but are now having trouble using the reports they have created due to errors in the data set settings caused by the GA4 API allocation limit settings that Google will implement in November 2022. This article will explains how we created a GA4 report and how we can use that report.

This article explains how to efficiently create GA4 reports on Looker Studio with plenty of knowledge gained from our experience of completing GA4 reports on Looker Studio through repeated trial and error.

After reading this article, you will be able to create GA4 reports in now Looker Studio for the past 24 months and over 30 pages without error, as the following

GA4 monthly report google Looker Studio template

Advantages of using Looker Studio for GA4 reporting

Data can be obtained in the past 14 months.

First of all, in the GA4 administration screen, only the "Exploratory Report" allows users to set their own items, and the only way to create reports on the GA4 administration screen is to use this Exploratory Report. However, exploratory reports are currently used for personal analysis, and are difficult to use them creating reports due to various restrictions.

For instance, while reports other than GA4's exploratory reports can select data for the entire period regardless of the data retention period, exploratory reports are affected by the data retention period. For example, a common graph such as a year-on-year comparison of the number of sessions In the past year would require data for the past 24 months, which is not possible with the exploratory report.

The Looker Studio is not affected by the data retention period and can produce the time-series reports.

Complimentary daily reports and automatically updated.

Reports created in the Looker Studio are automatically updated when created, eliminating the need to create a large number of reports at the start of every month. In addition, users can modify the time period displayed in the report and use filters to narrow the focus of the report, and the interactive dashboard features are enhanced.

Over 700 different connectors for connection to various data.

More than 700 connectors are available, including GA4, Google Analytics, Search Console, Google Ads, and other Google-based media, as well as advertising data such as Facebook ads and Yahoo ads, and SNS data such as Instagram and Twitter. The data of various services can be connected.
This allows you to create a single report that combines data from GA4, Search Console, and Google Ads.

Can be shared in various ways, including automatic email and PDF download.

The Looker Studio, like a spreadsheet, allows anyone to access the latest data by sharing a URL. The data can also sent automatically by email each morning to concerned parties with the previous day's performance data, or downloaded in PDF format for use as reporting materials.

How to link GA4 x Looker Studio and create reports

Using the Looker Studio is very simple: Create a data source, then create a report using that data source, and simply share it when the report is complete.

Create a GA4 data source

Open the Looker Studio and select "Data Sources" in "Create" on the home screen.

Select "Google Analytics" from the screen of connectors list.

Select the target GA4 account

Once you have granted the Looker Studio access to your Google Analytics account, you will see the Google Analytics account properties view available.For GA4, there is no view, so as shown in the figure below, select the property that begins with GA4|. Select it and choose "Connect" in the upper right corner.

Make sure you're signed in to a Google account with Google Analytics privileges for the subject you wish to report on.Please work only with the Google account above connected(all other Google accounts need to log out). Google may not be able to switch to the desired Google account.

You have now successfully created your GA4 data source.

After the connection, you will be redirected to the list of fields screen as indicated in the figure below, and you have completed the creation of the data source. Select "Create Report" in the upper right corner to proceed to creating the report.

Create a GA4 report according to the data source you created.

Add a graph

When the report generation screen is displayed, go to "Add Graph" and select a format to create a graph. In this case, we will select a time series graph.

Configure graph settings.

The edit screen will displays on the right side, where you can configure settings related to the graph. ou can configure detailed parameters such as dimensions, indicators and filters to be used on the graph.

In this case, we added page titles as a breakdown,and created a chronological graph of page displays by page title.

Set the style

Changing the tab on the editing screen to "Style" will switch to the design settings screen. You can customize colors and sizes of graphs, fonts, backgrounds, etc. in detail, So let's create a graph that is easy to read.

This time, I designed a dark version with a dark background.

Share Reports

Add people(individualy)

Select "Share" in the upper right corner, enter the email address of the target (linked to your Google account), then select either "Viewer" or "Editor", and select "Send" in the same way as for managing permissions on Google Spreadsheets.

Add individuals(Batch assignment to multiple users)

You can select any item from the Link settings and share it by URL.

Download as PDF

After selecting "Share" in the upper right corner, select "Download Report", then select the page to download and choose "Download".

GA4 Looker Studio Report Template.

You can create your own report from scratch, but we recommend using a template, especially if you are a beginner, as it can take a lot of time to create. With a template, you can create a standard report by simply copying it, and then customize it only when required to complete the report.

Here we introduce the very popular GA4 Looker Studio template sold by 888 studio, which also addresses the dataset setting error caused by Google's November 2022 API allocation cap setting for GA4, So if you have gone to the trouble of creating a GA4 report, you can now use the GA4 Looker Studio. When you have created a GA4 report with Looker Studio, but if it is not available anymore due to an error, please use this template.

GA4 Report template for Monthly Reports (30 pages)

Completely automated reports for monthly reports on the website
Coverage of GA4 and Search Console metrics
Customizable to display indicators such as CVR which does not exist in GA4's management screen.
Reports can be easily customized as needed
Full suite of reporting features, including comment boxes and company logos
Set configuration errors from the GA4 API allocation limit settings released in November 2022 have been resolved.

GA4 monthly report google Looker Studio template

GA4 Report Template for EC site Monthly report (37 pages)

Fully automated reports for monthly reports on e-commerce websites
Coverage of GA4 and Search Console indicators
Allows you to set and display your own indicators, such as CVR, which does not exist in the GA4 management screen
Reports can be easily customized as needed
Full suite of reporting features, including comment boxes and company logos
Set configuration errors from the GA4 API allocation limit settings released in November 2022 have been resolved.

GA4 EC monthly report template

GA4 Analysis Dashboard Template (8 pages)

Fully automated day-to-day monitoring of your website
The coverage of GA4 and Search Console indicators to be viewed
Customizable to display indicators such as CVR which does not exist in GA4's management screen
Reports can be easily customized to meet your needs
Data display period can be freely selected
Set configuration errors from the GA4 API allocation limit settings released in November 2022 have been resolved.

GA4 looker studio dashboard template

GA4 EC Site Analysis Dashboard Template (8 pages)

Completely automated day-to-day monitoring of your e-commerce site
The coverage of GA4 and Search Console indicators to be viewed
Allows you to set and display your own indicators, such as CVR,which does not exist in the GA4 management screen
Reports can be easily customized as needed
Data display period can be freely selected
Set configuration errors from the GA4 API allocation limit settings released in November 2022 have been resolved.

GA4 EC analytics dashboard template

Search Console x GA4 SEO Monthly Report Template for Monthly SEO Report (19 pages)

Monthly professional SEO reports, including rank measurements and the number of keywords per rank for target keywords to be covered in SEO reports
Centralization of data from Search Console and GA4
Customize your own data sources (e.g. number of keywords per rank) by using functions in the calculation fields for items not found in the default data source.
Display search queries below the 1,000th position (search console is limited to the top 1,000)
The data is updated automatically every month.
Set configuration errors from the GA4 API allocation limit settings in GA4 released in November 2022 have been resolved.

SEO monthly report template

Frequently asked questions about GA4 x Looker Studio

Is there a manual for the Looker Studio?

Please refer to the official help section of Looker Studio. If you are unable to find the answer, you can also throw a question through the official help forum. You will not always get an answer, but in the case of a bug or other problem, Google will response your question.

Report shows dataset setup error

In November 2022, Google sets an API allocation limit for GA4, and if this API allocation limit is exceeded, an error will occur. We did not hear any error reports from GA360 users because the limit is approximately 10 times that of the free version.

Google recommends the following measures, but we recommend using an extraction data source that is free to use and avoids the error with the least effort.

Reduce traffic to the report
Reduce the amount of graphs on each page
Use an extracted data source
Use BigQuery
Upgrade to GA360

I would like to display the number of page views, but I can't find it.

Please use "impressions," which means the number of page viewed on the GA4 management screen, as "views" is used in the Looker Studio index.

For example, the names of the items on the GA4 management screen and the Looker Studio may be different.

Is the segment feature available?

Segment functionality has not been implemented at this time. Only filters are available. (as of December 2022)

How do you display the number of conversions?

In UA, the number of conversions for each goal could be selected, But in GA4, only the indicator "conversions" exists, and the number of conversions for each goal is not included in the indicator.

Which dimension should I use for the Inflow Pathway Report?

Use "Session Referrer" and "Session Media" If you want to view a single string as referrer/media, as was the case with UA, use the following calculated fields.

If you would like to display the first path of the converted user, rather than the path of the inflow immediately before the conversion, use the "User Referrer" and "User Media".

(function of calculated field)

CONCAT(session referrer, " / " ,session media)

CONCAT(user referrer, " / " ,user media)

More than 2,000 companies have adopted the system! If you want to utilize Looker Studio, 88studio is the one you needed.

88studio offers a wide variety of customizable Looker Studio report templates to suit a variety of needs. IIf you want to automate reporting, but struggle to build your own reports from scratch, use 88studio to make the most of your time.

Unlimited number of sites for websites to report
Sites associated with several Google accounts are also acceptable
Copy the report and you're all set!
Personalise the way you want
Can be used for commercial purposes

Presents GA4 free templates

This is Looker Studio's versatile GA4 report template , which can be used for both report automation and efficient daily monitoring. Just select a site in the pull-down menu to view the report. The powered-up Looker Studio's official Google GA4 connector allows you to retrieve historical data for the entire period of time.

Report List

Monthly
Weekly
Daily
Acquisition：Channel
Acquisition：Source/Medium
Acquisition：Source/Medium/Campaign
Engagement：Page
Engagement：Landing Page
User：User Attribute
User：Device
Region

How to use (3 easy steps)

Step1：Submit the form
Step2：Open the introduction manual you receive by email and open the free GA4 template.
Step3：Select the GA4 account you want to appear in the report from the pull-down menu at the top of the report