【For EC Site】Report Templates for GA4 Sales Analysis ｜With explanations of dimensions and indicators

February 27, 2023

【For EC Site】Report Templates for GA4 Sales Analysis ｜With explanations of dimensions and indicators

With EC's cart systems starting to support GA4 one after another, many of you are likely thinking about starting to prepare for GA4 version reporting. In this article details on benefits and usage of the GA4 reporting template for EC sites, which has been very popular and allows you to view reports in the same way as the previous UA version of Google Analytics.

Benefits of GA4 Report Template for EC Sites

With this EC site report template, you can easily analyze GA4 sales data and use it for internal and external purposes. This is particularly recommended for those who need to create reports for reporting but do not know how to do it. Automate your reporting tasks immediately and concentrate on improvement actions.

GA4 Report Template for EC Sites Features

Since it is created in the Looker Studio, it has all the features that EC staff can use it with no code.

Copy the report and you're all set!
The data is automatically updated
Unlimited number of target sites
More than one Google account can be redeemed.
Freely select the data range for the data
Filter data freely using it
Flexible customization
Extensive sharing functions such as PDF download and automatic email delivery

See all reports

Introduction of GA4 Monitoring Report Template for EC Sites

This template allows you to review the following data

Summary Report

Benefits of Summary Report

Look at the things that e-commerce managers need to see at a glance.
Display the e-commerce conversion rates (CVR) that do not exist on the GA4 admin screen using calculated fields
Filter data according to specific input channels (e.g. natural search, email, etc.)

Learn more about GA4 EC Analytics Dashboard template

Revenue Report

Benefits of Revenue Report

Grasp at a glance the items that e-commerce managers need to see regarding e-commerce site sales
Displays not only the last click, but also the source of a user's first purchase.

Learn more about GA4 EC Analytics Dashboard template

Page Report

Benefits of Page Report

Overview of what the EC manager must see on pages.
Visualize page's performance by hierarchy (create your own dimensions for each hierarchy using calculated fields)
Click on the title of each page to transition to the page itself.

Learn more about GA4 EC Analytics Dashboard template

User Report

Benefits of User Report

Overview understanding of essential user attributes for e-commerce professionals
Visualize the number of users and sales by user attributes such as device, region, gender, and age in an easy-to-understand graph.

Learn more about GA4 EC Analytics Dashboard template

Attracting Report

Benefits of Attracting Report

Overview of understanding the items that e-commerce professionals need to see in order to attract clients.
Displays not only the last click, but also the source of a user's first purchase.
Key data from the Search console is also displayed.

Learn more about GA4 EC Analytics Dashboard template

Daily Report

Benefits of Daily Report

Grasp a bird's-eye view of basic data
Date units can be adjusted freely between the default date to week, month, or year
Metrics can also be changed from users to sessions or sales to CVR

Learn more about GA4 EC Analytics Dashboard template

Monthly Report

Benefits of Monthly Report

Grasp a bird's-eye view of basic data
Date units can be adjusted freely between default date to week, month, or year
The indicators can be freely modified as well.

Learn more about GA4 EC Analytics Dashboard template

Description of the dimensions and indicators of the e-commerce site GA4 monitoring report template.

Dimension Description

Session Source/Medium

Combines the "Session Source" and "Session Medium" of GA4 using calculated fields. It is the referrer and media for the session inflow and is the same as the referrer/media in the UA version. Note that "session source" reflects the value of the utm_source parameter and "session medium" reflects the value of the utm_medium parameter.

User Source/Medium

GA4's First User Source/Medium. This is the Source/Medium of the user's first inflow and is almost the same as First Click Attribution when comparing models. By default, the first Source/Medium is displayed up to 30 days before the conversion.

The difference between user's Source/Medium and first click is as follows

User Source/Medium: If the first Source/Medium is Direct, it is classified as Direct.

First click for model comparison: If the first Source/Medium is a Direct, it is classified as a non-direct first Source/Medium (if all Source/Medium are Direct, it is classified to Direct).

Page

About the GA4 "Page Title". A calculated field is used to configure a hyperlink so you can create a link to the actual page.

Landing Page

About the GA4 "landing page". Landing pages are currently added in the GA4 admin, but not as part of the Looker Studio dimension, so they are implemented using the "session_start" event filter.

Device

About the GA4 Device Category. Items are classified in one of these categories below.

desktop
mobile
tablet
smart tv

Gender

About the GA4 "Gender". To use this dimension,it is necessary to activate Google Signals.

Age

About the GA4 "Age". To use this dimension,it is necessary to activate Google Signals.

Region

About the GA4 "Region". This is the prefecture where the accessing user accessing is in.

Indicator Description

Users

It's the "total number of users" in GA4. This is the number of unique users who visited the website.

New Users

This is the "new users" in GA4. That's the number of users who visited the site for the first time.First_visit event count.

Sessions

About the GA4 "Sessions".This is the number of times a website is accessed. For example, if a user visits a website twice, the number of sessions is counted as 2.

Purchases

The default is "ecommerce purchases" in GA4; it is the number of times an ecommerce purchase has been made (Ecommerce purhcase event count).The definition can be amended in bulk if necessary.

Purchase Rate

The "Purchase Rate" is calculated based on the "Number of Purchases / Sessions". When the definition of "Number of Purchases" is changed, the "Purchase Rate" is automatically reflected in the new "Number of Purchases".

Avg.Order Value

This is the average cart unit price calculated as "Revenue / Purchases".When the definition of "Number of purchases" is changed, it will be automatically reflected in the "Unit price per purchase" with the new "Number of purchases".

Revenue

The default is GA4 Revenue from purchases. This is the turnover generated by purchases (the events to be aggregated are in_app_purchase and the sum of the amounts obtained in the Value parameter of purchase). Shipping charges, taxes, etc. are included. Definitions can be modified in bulk if necessary.

Item Revenue

The default is GA4 "Item Revenue". Calculated by multiplying the number of purchases per item by the value of the item; calculated by the value included in the event of the item. It does not include delivery charges, taxes, etc.

PV(Pageviews)

It refers to the "number of times viewed" in GA4. This represents the total number of pages viewed. Even though the same page is viewed repeatedly, it is counted.

Avg.Duration Time

It is calculated using the calculation field in GA4 "User Engagement / Total Number of Users".It is the average length of stay of a user on the website.

Engagement Rate

About the GA4 "Engagement Rate". The engagement is counted if any of the following conditions are met.

Stayed on the site for more than 10 seconds
Viewed more than 2 pages
CV event occurred

Avg.Viewing Time

It is calculated using the calculation field in GA4 "User Engagement / Users Using". This is the average time a user has viewed a particular page.

Clicks

This refers to the number of "clicks" in Google Search Console. That's how many times a user clicks on your website.

Impressions

It is the "Number of times" displayed on the Google Search Console. This is the number of times a link to your site appears in a user's search results.