RuffRuff App RuffRuff App by Tsun

How to represent GA4 content groups in Looker Studio

How to represent GA4 content groups in Looker Studio

GA4 content group is a grouping of specific content within a site. For example, you can group content by blog category, site menu, etc. This allows you to analyze visitor preferences and parts of your site. Normally, content groups are set up using Google tag manager, but Looker Studio offers a similar setup, so if you cannot use Google tag manager but want to group pages, try this.

You can read more about how to create reports in Looker Studio in this article.

In this case, we would like to divide the groups by title when we have the following data.

example

Decide what you want to group

First, decide what you want to group by and what you want to group by. In this case, we will group pages that do not contain "game" in the Page Title and those that contain "menu" in the Page Title.

How to set up grouping

Create a field

Select the one you are using and click the edit symbol for the data source on the right.

Then click ADD A FIELD below.

add a field

 The edit screen will then open and the following settings are made.

1.Field Name

Give it a name that will be easy to recognize later.

2.Formula

Grouped by what is listed here.The description of the contents of the page title and screen class includes the instruction to use the name "Game" when game is included, the name of the group "Menu" when menu is included, and the name of the group "Other" for all other cases.There are only three groups (Game, Menu, and Other), but more groups can be created by adding similar descriptions.

CASE
WHEN REGEXP_CONTAINS(Page title and screen class,"game")
THEN "Game"
WHEN REGEXP_CONTAINS(Page title and screen class,"menu")
THEN "Menu"
ELSE "Other"
END

3.Save

After completing the settings for the group you wish to create, click "save" in the lower right corner.

This completes the grouping setup. Next, let's set up the actual display for each group.

Display content groups

First, reload the report once.Select the table in which you want to display the group and search for the name of the group you just created in Dimension on the right side.

If you select a group name in the search, the table item will change to the group name and the following will be displayed.

after

The left side is the first table and the right side is the table displayed by group. As you can see, the right side of the table is divided according to the rules you set up earlier, and the views are also aggregated for each group.This completes the process.In this case we used the page title and screen class, but of course the same can be done with other dimensions.Please use this feature to further your analysis in Looker Studio.

Notice

Thus, content groups can be realized with Looker Sutudio without using Google tag manager, which is convenient, but there is one caveat. Please note that the number of sessions and users in a group is not unique, but rather a total value.Therefore, please be sure to create a table in GA4's administration screen or Looker Studio and compare the values to see how the created table behaves.

Looker Studio for GA4 Report

Although there are some caveats, it is very convenient to be able to group easily using only Looker Studio. In this case, I used page title and screen class, but you can use it in other dimensions to expand the range of its utilization. In addition, it is much easier to create a report using a well-designed template than to create a dashboard in Looker Studio all by yourself. You can also customize your reports as you like.

We also offer free report templates that you can use immediately.

Free GA4 Report Template

We also recommend this article

What is sampling?

GA4 sampling occurs when a large amount of data is used in an exploratory report and the number of events required to aggregate the report exceeds a certain upper limit. When this limit is exceeded, a representative sample is taken and a report is generated based on that sample data.

[GA4] How to create monthly and daily reports for E-commerce | Explore

This article will show you how to create monthly and daily reports using GA4's exploratory reports for e-commerce sites in an easy-to-understand manner. In this article, you will learn in detail how to create monthly and daily reports for e-commerce sites, as well as the key points to keep in mind when creating reports.

[GA4] How to Create Monthly/Daily Reports | Explore

This article will show you how to create monthly and daily reports using GA4's exploratory reports in an easy-to-understand manner. Read this article to learn more about how to set up monthly and daily reports and what to look out for.

 [GA4]Disappear after 14 months? Explanation of data retention that is often misunderstood | How to change the setting is also introduced.

This article provides a clear explanation of the data retention period for GA4. After reading this article, you will know how to change the data retention period for "exploratory reports" from the default of 2 months to 14 months, and that, in fact, data longer than 14 months is available without problems for most GA4 reports except for "exploratory reports".

 [GA4]How to use Explore | with Recommended Template

GA4's "Exploratory Report" allows for easy customization of items and advanced analysis using segments. Use them when you want to analyze your data in more detail. This article explains the types of GA4's "exploratory reports" and how to use them in an easy-to-understand manner. Examples of recommended report settings will also be introduced for your reference.

Back to blog

Featured collection