【For EC Site】GA4×Looker Studio（former Data Studio) Report Creation｜With Free Template

What is Looker Studio?

Looker Studio is a free reporting tool provided by Google that connects to a variety of data sources to create easy-to-understand, fully automated reports. For example, with Looker Studio's official GA4 connector, you can create a very easy-to-understand GA4 report for an e-commerce site, such as the following

 Demo Report

Free Trial

Who should use Looker Studio?

Support companies who want to automate regular reports for their clients.

Advertising agencies, web production companies, system development companies, and consulting companies that regularly submit reports on sales analysis, SEO, web advertising, etc. related to e-commerce sites to their clients.

Business companies that want to automate periodic reports for internal use

Marketing, web, and system staff at e-commerce management companies who regularly submit reports on sales analysis, SEO, web advertising, etc., related to e-commerce sites.

Marketers who want to automate daily data aggregation and monitoring

Marketers in data-driven marketing organizations who want to automate low value-added but time-consuming data aggregation tasks and focus on actions that lead to improved marketing ROI. 

Advantages of using Looker Studio for GA4 E-Commerce 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 800 different connectors for connection to various data.

More than 800 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.

Steps to create a GA4 report in Looker Studio

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

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.

Here are some representative graphs to help you see some of the key indicators of E-commerce.

Daily sales

Select Time series chart

 

Select

Dimensions: Date

Metric:Purchase revenue

Select the time period to be displayed here.

List of purchased products

Select Table

Select

Dimensions: Item name

Metric:Item revenue

The target period can be edited from the same location as before.

In this way, Dimension and Metric can be combined to represent the numerical values you want to see. Please give it a try.

Free GA4 Looker Studio report template for e-commerce sites

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
• Item:Monthly
• Item:Weekly
• Item:Daily
• Item:Ranking
• 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

Notice

The free template is based on the [one-time purchase]GA4 EC Standard Report Template[4012] with the following limited features.

All of the features will be available in the paid version, so please purchase the one-time purchase template if you need the following features.

• Select Date range
• PDF download and URL sharing of reports
• Logo change
• Keyword reporting using Search Console
• Customize data items and layout

{formbuilder:OTEzMQ==}