[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.

Please refer to "[GA4] How to Create Monthly/Daily Reports | Explore" for how to create monthly and daily reports for general websites, not e-commerce sites.

In the latter part of the article, we also introduce the free GA4 monthly and daily report templates, which are very popular among the more than 2,000 companies. As shown in the capture below, you can immediately use the very easy-to-understand monthly and daily reports completely free of charge.

How to create monthly and daily reports for e-commerce sites using explore

explore can be created by following these steps

• Select the type of report
• Select the items you want to use for the report
• Configure the report items

Now let's create the report in the capture below.

Select the type of report

First, select "Blank" from the types of explore, which is suitable for time series reports.

Select the items you want to use for the report

Select Dimensions

After selecting "Blank," first select the "Dimensions" to be used in the report.

Step1

On the "Variables" tab, select the "+" to the right of "Dimensions.

Step2

Type "date" in the search window at the top of the page, check the box for the date that appears in the list, and then select "Import" in the upper right corner. Then follow the same procedure to import the two dimensions below.

• Month
• Year

Step3

When the selected "date," "month," and "year" appear as shown in the capture below, you are done.

Select Metrics

Once you have finished adding "dimensions," select the next "metrics" to be used in the report.

Step1

On the "Variables" tab, select the "+" to the right of "metrics."

Step2

Enter "New users" in the search window at the top of the page, check the box for "New users" that appears in the list, and then select "Import" in the upper right corner. Then follow the same procedure to import all the following indicators.

• Active users
• New users
• Sessions
• Views
• Engagement rate
• Average engagement time per session
• Transactions
• Purchase revenue

Step3

When all selected metrics are displayed as shown in the capture below, you are done.

Configure the report items

Once you have added the items you want to use in the report, you can actually create the report. If you set up the following, you will end up with a monthly report and a daily report, as shown in the capture below.

Monthly Report Setup

• Rows: Year, Month
• Columns: none
• Values: Active users, New users, Sessions, Views, Engagement rate, Average engagement time per session, Transactions,Purchase revenue

Daily Report Setup

• Rows: Date
• Columns: none
• Values: Active users, New users, Sessions, Views, Engagement rate, Average engagement time per session, Transactions,Purchase revenue

The created reports can be shared with relevant parties.

Notes on monthly and daily reports using explore

While the "Explore" can be used for segments, it should be used with caution because of the following limitations

• Historical data can only go back 14 months
• E-commerce conversion rate and average cost-per-purchase indicators are not selectable and cannot be displayed in reports
• With Sampling  （What is sampling?）
• Can only be shared on a "read" basis and can only be viewed by users with permissions on the target GA4 property

（Related Articles）
[GA4] How to Use Reports & Explore | How to Use Reports for Different Purposes

Looker Studio for GA4 Monthly/Daily Report

As we have explained, "exploratory reports" are affected by the data retention period and can only go back up to 14 months in the past, so for reporting reports and KPI monitoring that require long-term data, we recommend Looker Studio, which allows unlimited historical data.

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.