1 of 78

Chingwen Chen

GA4 Custom Exploration Reports

Arbitrary Form Report (1)

2 of 78

Target

  • Creating Customized GA4 Exploration Reports
    • arbitrary format report
    • Display the United States, Canada, Taiwan.
    • Users through different channels,
    • Compare [Product View Events, Add to Cart, Transactions, Total Purchase Revenue, Purchase Conversion Rate]

3 of 78

How to Use

Google Merchant Demo Account

demo data

4 of 78

How to Use the Google Merchant Demo Account with Demo Data

  • 3- Acquiring [Data Sources]
    • Please go to the search engine and type in: Google Analytics demo account.

​

​

5 of 78

How to Use the Google Merchant Demo Account with Demo Data

​

​

​

6 of 78

Download

The first data resource hyperlink

Google Merchant Demo Account

7 of 78

【Data Download Method】

  • Click on the first data resource hyperlink.
  • Automatically download data to your GA4 account.

​

8 of 78

【Data Download Method】

  • Click on the first data source hyperlink ➜ Automatically download data to your GA4 account.

​

​

9 of 78

Basic Operations-1

​

GA4 Custom Exploration Reports

Arbitrary form report

10 of 78

Basic Operation-1: Explore ➜ Any Form

11 of 78

Basic Operations-2

​

Add three new "segmentation" variables: United States, Canada, Taiwan.

12 of 78

Add three new "segmentation" variables: United States, Canada, Taiwan.

  • Click on "Variables" on the left side.
  • Add "Segmentation" +
    • United States
    • Canada
    • Taiwan

​

13 of 78

Add three new "segmentation" variables:�United States, Canada, Taiwan

  • Click on "Variables" on the left side.
  • Add "Segmentation" +
    • 由於您提供的內容不完整，我無法進行完整的翻譯。如果您能提供更多的句子或段落，我將能更好地協助您。
    • Canada
    • Taiwan

​

14 of 78

Additional condition: Geographic location: Country

15 of 78

New filter added: canada

16 of 78

Segment Name: Canada

17 of 78

Please follow the same steps to set the partition name: Taiwan

18 of 78

Basic Operations-3

​

Drag 3 "Segment Variables": USA, Canada, Taiwan ➜ into "Segment Settings"

19 of 78

Drag 2 to 3 "Segment Variables": USA, Canada, Taiwan ➜ into "Segment Settings"

20 of 78

Basic Operations-4

​

Add one new dimension variable: the source/medium that initially attracted the user.

21 of 78

Add one new "Dimension" variable: the source/medium that initially attracted the user.

22 of 78

Basic Operations-5

​

Drag one "Dimension Variable": the original source/medium that attracted users ➜ drag to "Column" and remove "City".

23 of 78

Drag one "Dimension Variable": The original source/medium that attracted users ➜ drag it to the "Column" and remove "City".

24 of 78

Basic Operations-6

​

Add three new "metrics" variables: add to cart, number of products added to cart, transactions.

25 of 78

Add three new "metrics" variables: Add to Cart, Number of Products Added to Cart, Transactions.

26 of 78

Basic Operations-7

​

Add five new "metrics" variables: number of product view events, number of e-commerce purchases, quantity, total purchase benefit, and purchase benefit.

27 of 78

Added 5 new "metrics" variables: number of product view events, number of e-commerce purchases, quantity, total purchase value, and purchase value.

28 of 78

Basic Operations - 8

​

Add one new variable [Indicator]: Total Revenue

29 of 78

Please add one new variable: Total Revenue.

30 of 78

Basic Operation-9

​

Add one new variable: Total Number of Buyers

31 of 78

Add one new variable: Total Number of Buyers

32 of 78

10-Question: Several indicators have similar names; what are the differences?

1. Total purchasing benefits, total revenue from purchasing benefits, total revenue

2. E-commerce purchase frequency, transactions, quantity, total number of buyers

33 of 78

Basic Operations-11

​

How should one understand the definitions of "Dimensions and Metrics" in GA4 (Google Analytics 4)?

34 of 78

How should we understand the definitions of "Dimensions and Metrics in GA4"?

​

35 of 78

Basic Operations-12

​

Delete [Column Settings]: Device Category

36 of 78

Delete Column [Column Settings]: Device Category

37 of 78

Basic Operations-13

​

Track the following metrics: number of product view events, add to cart, transactions, e-commerce purchase frequency, quantity, and total number of purchasers. ➜ Drag these to the "Value" section and remove active users.

38 of 78

13-Drag [Indicator] product view events, add to cart, transactions, e-commerce purchase frequency, quantity, total number of purchasers ➜ Drag to [Value] and remove active users.

39 of 78

14 - What are the differences:

​

Trading,

Number of e-commerce purchases

Quantity,

Total number of buyers

40 of 78

Basic Operations-15

​

What are the three metrics calculated in Conversion Funnel Analysis?

41 of 78

These three GA4 events can form an e-commerce conversion funnel, allowing you to analyze the conversion rates in the shopping process.

42 of 78

Conversion Funnel Analysis

Conversion Funnel

43 of 78

These three events can be assembled into a conversion funnel analysis.

  • Generate three conversion rates (the last two are the most important).
    • 【Product Inspection】Conversion Rate
    • "Add to Cart" Conversion Rate
    • "Purchase Completion" Conversion Rate

44 of 78

E-commerce Conversion Funnel: Common Issues and Solutions

45 of 78

​

E-commerce Conversion Funnel (3 Events)

Important indicators that can be provided

46 of 78

E-commerce conversion funnel (3 events) can provide key metrics.

47 of 78

What are the three metrics calculated in the 15-Conversion Funnel Analysis?

  • Correct procedure: First add an indicator (+), then select "Custom" (however, Google has locked this option and does not allow access).

48 of 78

Basic Operations-16

​

If not using Google to customize three funnel conversion events, which three metrics should be used to perform a similar funnel conversion analysis?

49 of 78

If not using Google's custom three funnel conversion events, which three metrics should be used to perform a similar funnel conversion analysis?

  • Comparison of 3 Events and Corresponding Indicators

事件

對應指標

解釋

例子

商品詳情瀏覽數 (view_item)

商品瀏覽事件數

代表用戶對商品產生了興趣，並進一步查看了商品的詳細信息。

某商品在過去一周內被瀏覽了5000次。

加入購物車數 (add_to_cart)

加入購物車

表示用戶對商品有購買意願，將商品添加至購物車，準備下一步的結算。

某商品被加入購物車的次數為200次。

購買數量 (purchase)

交易、

電子商務購買次數

代表用戶完成了最終的購買行為，並產生了實際的交易。

某商品被購買了150次，總購買數量為300件。

50 of 78

Basic Operation-17

​

What are the differences between the comparison metrics [transactions, number of e-commerce purchases, total number of buyers, quantity]?

51 of 78

17 - Comparison Metrics [Transactions, E-commerce Purchase Frequency, Total Number of Buyers, Quantity] - What are the differences?

  • 1. Transaction
    • Definition: A complete purchasing behavior.
    • Key point: The focus is on the frequency of purchase behavior, not the quantity of goods.
    • Example: A customer purchased three items in one shopping session, which is considered a single transaction.
  • 2. E-commerce Purchases
    • Definition: The frequency of purchase behavior.
    • Includes: Similar to "transaction", but sometimes may not distinguish the quantity of goods included in a single purchase.
    • Key point: The focus is on the frequency of purchasing behavior.
    • Example: As in the previous example, a customer purchased three items, which constitutes an e-commerce purchase.

​

52 of 78

17-Comparison Metrics [Transactions, E-commerce Purchase Frequency, Total Number of Buyers, Quantity] - What are the differences?

  • 3. Total Number of Purchasers
    • Definition: The number of unique users who complete a purchase within a specific period.
    • Includes: Only users who have completed a purchase are counted, with no duplicates.
    • Key point: The focus is on the size of the customer base.
    • Example: Over the past month, 1000 users have completed purchases on your website; thus, the total number of purchasers is 1000.
  • 4. Quantity
    • Definition: The total quantity of goods purchased.
    • Include: Calculating the total quantity of all purchased items.
    • Key point: The focus is on the quantity of goods sold.
    • Example: If 1,000 customers each purchase an average of 2 items, then the total number of items is 2,000.

​

53 of 78

�17-Comparative Indicators [Transactions, E-commerce Purchase Frequency, Total Number of Buyers, Quantity] What are the differences?

指標

關注重點

示例

交易

購買行為的次數

一次購物車結帳

電子商務購買次數

購買行為的頻率

每位顧客購買的次數

購買者總人數

客戶群體的大小

完成購買的獨特用戶數

數量

銷售商品的數量

所有被購買商品的總和

54 of 78

What is the difference in the comparison indicators [total number of buyers, quantity]?

  • Example 1: Purchasing multiple items in a single order
  • Xiaohua purchases:
    • 2 iPhone 15s
    • 3 AirPods
  • GA4 Records:
    • Number of purchase events (number of transactions, total number of buyers) = 1 (only one order)
    • Item Quantity = 5 (2+3)

​

55 of 78

What is the difference between the comparison indicators "total number of buyers" and "quantity"?

  • Example 2: Multiple Orders

​

​

​

  • GA4 Records:
    • Number of purchase events (transactions, total number of buyers) = 3 (only 3 orders)
    • Item Quantity = 6 (2+1+3)

​

56 of 78

Basic Operations-18

​

In the "Value" field, delete the indicators "Number of E-commerce Purchases, Total Number of Buyers, Quantity."

57 of 78

18-Under "Value", delete the indicators "Number of E-commerce Purchases, Total Number of Buyers, Quantity".

58 of 78

Basic Operation-19

​

Drag [Indicator] Total Purchase Benefit, Purchase Benefit, Total Revenue�➜ to [Value]

59 of 78

Drag the "Total Purchase Benefit," "Purchase Benefit Total Revenue," and "Total Revenue" indicators to the "Value" field.

60 of 78

Drag the "Total Purchase Benefit, Purchase Benefit, Total Revenue" indicators to the "Value" field.

  • Result: The values of three yields are identical.
    • 1. Total Revenue from Purchase Benefits: The total income generated from all purchasing events.
    • 2. Total Purchase Benefit: Based on the total revenue from purchase benefits, further consideration is given to other factors.
    • 3. Total Revenue: Represents the sum of all sources of income and is the broadest concept, encompassing all sources of income.

61 of 78

Basic Operations-20

​

Delete "Value" Purchase Benefits, Total Revenue

62 of 78

Delete the "value" purchase benefits, total revenue.

63 of 78

Basic Operation-21

​

Add the custom metric "Purchase Conversion Rate" ➜ drag it to "Values"

64 of 78

21- Add custom metric [Purchase Conversion Rate] ➜ drag to [Value]

  • Google's custom purchase conversion rate is about 2%.

65 of 78

Basic Operation-22

​

Set up a filter to "display data from users who arrive at my e-commerce site via the Google search engine."

66 of 78

22-Setting up a filter to "display data from users who arrive at my e-commerce site via the Google search engine."

67 of 78

22-Setting up a filter to "Display data from users who arrive at my e-commerce site via the Google search engine"

68 of 78

22-Setting up a filter to "Display data from users who arrived at my e-commerce site via the Google search engine."

69 of 78

Basic Operation-23

​

How to save GA4 Exploration reports?

70 of 78

How to Save GA4 "Exploration" Reports?

  • GA4 automatically stores your "Exploration reports" in the cloud.
  • You can view it directly upon your next login.
    • Click on "Explore" in the top left corner to return to the main GA4 "Explore" report screen.
    • You should be able to see the newly created custom report, which you can open and edit at any time.

​

71 of 78

How to Save GA4 "Exploration" Reports?

  • GA4 automatically stores your "Exploration reports" in the cloud.

​

72 of 78

Basic Operations-24

​

How to Rename a GA4 Exploration Report?

73 of 78

How to rename a GA4 Exploration report? Method 1

  • Title: Arbitrary Form Report 1 - Comparison of Different Channels on [Product View Events, Add to Cart, Transactions, Total Purchase Revenue, Purchase Conversion Rate]

74 of 78

24-How to Rename GA4 Exploration Reports?�Method 2

75 of 78

How to rename a GA4 Exploration report? Method 2

  • Title: Arbitrary Form Report 1 - Comparison of Different Channels on [Product View Events, Add to Cart, Transactions, Total Purchase Revenue, Purchase Conversion Rate]

76 of 78

Basic Operation-25

​

How to download files in the formats of CSV, PDF, and Google Sheets?

77 of 78

How to download files in the formats of CSV, PDF, and Google Sheets?

78 of 78

  • The End