# Google Analytics 4 (Web + App)

# Introduction

The module copies and processes data from Google Analytics 4 (Web + App) collected in BigQuery. New columns appear in the table, making it much easier to work with GA4 data. After configuring the module, we have the option of activating all other processes in WitCloud that are compatible with Analytics 4. This allows for more advanced analyzes and adding additional data on media or business costs.

# An example of operation

  1. Configure the module in the platform (indicate the place where BigQuery events gather).
  2. We set the module on the schedule - the data will be copied in full, additionally new fields will be added to import business and media data
  3. After the table is processed, you can use other reporting modules, data import or attribution that are integrated with it.

# Data schema

The Google Analytics Target Table 4 is very extensive, with several hundred metrics and dimensions. The fields that will be enriched in relation to the standard table exported by Google Analytics have been marked in green.

Expand to see the data schema
Field name Type Mode
session_id STRING NULLABLE
session_number INTEGER NULLABLE
event_name STRING NULLABLE
event_date STRING NULLABLE
event_number INTEGER NULLABLE
event_timestamp INTEGER NULLABLE
hour INTEGER NULLABLE
minute INTEGER NULLABLE
is_entrance BOOLEAN NULLABLE
is_exit BOOLEAN NULLABLE
event_params RECORD REPEATED
event_params. key STRING NULLABLE
event_params. value RECORD NULLABLE
event_params.value. string_value STRING NULLABLE
event_params.value. int_value INTEGER NULLABLE
event_params.value. float_value FLOAT NULLABLE
event_params.value. double_value FLOAT NULLABLE
event_previous_timestamp INTEGER NULLABLE
event_value_in_usd FLOAT NULLABLE
event_bundle_sequence_id INTEGER NULLABLE
event_server_timestamp_offset INTEGER NULLABLE
user_id STRING NULLABLE
user_pseudo_id STRING NULLABLE
wit_user_id STRING NULLABLE
user_properties RECORD REPEATED
user_properties. key STRING NULLABLE
user_properties. value RECORD NULLABLE
user_properties.value. string_value STRING NULLABLE
user_properties.value. int_value INTEGER NULLABLE
user_properties.value. float_value FLOAT NULLABLE
user_properties.value. double_value FLOAT NULLABLE
user_properties.value. set_timestamp_micros INTEGER NULLABLE
user_first_touch_timestamp INTEGER NULLABLE
user_ltv RECORD NULLABLE
user_ltv. revenue FLOAT NULLABLE
user_ltv. currency STRING NULLABLE
page RECORD NULLABLE
page. hostname STRING NULLABLE
page. referrer STRING NULLABLE
page. title STRING NULLABLE
page. search_keyword STRING NULLABLE
page. path STRING NULLABLE
page. path_level_1 STRING NULLABLE
page. path_level_2 STRING NULLABLE
page. path_level_3 STRING NULLABLE
page. path_level_4 STRING NULLABLE
page. path_level_5 STRING NULLABLE
device RECORD NULLABLE
device. category STRING NULLABLE
device. mobile_brand_name STRING NULLABLE
device. mobile_model_name STRING NULLABLE
device. mobile_marketing_name STRING NULLABLE
device. mobile_os_hardware_model STRING NULLABLE
device. operating_system STRING NULLABLE
device. operating_system_version STRING NULLABLE
device. vendor_id STRING NULLABLE
device. advertising_id STRING NULLABLE
device. language STRING NULLABLE
device. is_limited_ad_tracking STRING NULLABLE
device. time_zone_offset_seconds INTEGER NULLABLE
device. browser STRING NULLABLE
device. browser_version STRING NULLABLE
device. web_info RECORD NULLABLE
device.web_info. browser STRING NULLABLE
device.web_info. browser_version STRING NULLABLE
device.web_info. hostname STRING NULLABLE
geo RECORD NULLABLE
geo. continent STRING NULLABLE
geo. country STRING NULLABLE
geo. region STRING NULLABLE
geo. city STRING NULLABLE
geo. sub_continent STRING NULLABLE
geo. metro STRING NULLABLE
app_info RECORD NULLABLE
app_info. id STRING NULLABLE
app_info. version STRING NULLABLE
app_info. install_store STRING NULLABLE
app_info. firebase_app_id STRING NULLABLE
app_info. install_source STRING NULLABLE
traffic_source RECORD NULLABLE
traffic_source. source STRING NULLABLE
traffic_source. medium STRING NULLABLE
traffic_source. name STRING NULLABLE
traffic_source. content STRING NULLABLE
traffic_source. keyword STRING NULLABLE
traffic_source. start_page STRING NULLABLE
traffic_source. ad_cost FLOAT NULLABLE
traffic_source. impressions FLOAT NULLABLE
traffic_source. clicks FLOAT NULLABLE
traffic_source. account_id STRING NULLABLE
traffic_source. campaign_id STRING NULLABLE
traffic_source. adgroup_id STRING NULLABLE
traffic_source. ad_id STRING NULLABLE
traffic_source. criteria_id STRING NULLABLE
traffic_source. click_id STRING NULLABLE
traffic_source. user_list_id STRING NULLABLE
traffic_source. adnetwork_type STRING NULLABLE
stream_id STRING NULLABLE
platform STRING NULLABLE
event_dimensions RECORD NULLABLE
event_dimensions. hostname STRING NULLABLE
ecommerce RECORD NULLABLE
ecommerce. transaction_id STRING NULLABLE
ecommerce. total_item_quantity INTEGER NULLABLE
ecommerce. purchase_revenue_in_usd FLOAT NULLABLE
ecommerce. purchase_revenue FLOAT NULLABLE
ecommerce. refund_value_in_usd FLOAT NULLABLE
ecommerce. refund_value FLOAT NULLABLE
ecommerce. shipping_value_in_usd FLOAT NULLABLE
ecommerce. shipping_value FLOAT NULLABLE
ecommerce. tax_value_in_usd FLOAT NULLABLE
ecommerce. tax_value FLOAT NULLABLE
ecommerce. unique_items INTEGER NULLABLE
items RECORD REPEATED
items. item_id STRING NULLABLE
items. item_name STRING NULLABLE
items. item_brand STRING NULLABLE
items. item_variant STRING NULLABLE
items. item_category STRING NULLABLE
items. item_category2 STRING NULLABLE
items. item_category3 STRING NULLABLE
items. item_category4 STRING NULLABLE
items. item_category5 STRING NULLABLE
items. price_in_usd FLOAT NULLABLE
items. price FLOAT NULLABLE
items. quantity INTEGER NULLABLE
items. item_revenue_in_usd FLOAT NULLABLE
items. item_revenue FLOAT NULLABLE
items. item_refund_in_usd FLOAT NULLABLE
items. item_refund FLOAT NULLABLE
items. coupon STRING NULLABLE
items. affiliation STRING NULLABLE
items. location_id STRING NULLABLE
items. item_list_id STRING NULLABLE
items. item_list_name STRING NULLABLE
items. item_list_index STRING NULLABLE
items. promotion_id STRING NULLABLE
items. promotion_name STRING NULLABLE
items. creative_name STRING NULLABLE
items. creative_slot STRING NULLABLE
items. crm_metrics RECORD REPEATED
items.crm_metrics. index STRING NULLABLE
items.crm_metrics. value FLOAT NULLABLE
items. crm_dimensions RECORD REPEATED
items.crm_dimensions. index STRING NULLABLE
items.crm_dimensions. value STRING NULLABLE
crm_metrics RECORD REPEATED
crm_metrics. index STRING NULLABLE
crm_metrics. value FLOAT NULLABLE
crm_dimensions RECORD REPEATED
crm_dimensions. index STRING NULLABLE
crm_dimensions. value STRING NULLABLE
custom_goals RECORD REPEATED
custom_goals. index STRING NULLABLE
custom_goals. value FLOAT NULLABLE

# Configuration

# Before you start

Access to the Google Analytics 360 table required

In order to use this module, you must have access to the event table dumped to BigQuery by Google Analytics 4.

# Start creating the module

From the menu on the left, select the "Collect" tab, then click the "Add new Pipeline" button.

image alt text

Select "Google Analytics 4" from the list of available modules

image alt text

# Initial settings

In the first step, we have two fields to complete.

Collect name - the name of our module. It will be visible under this name elsewhere on the platform.

Referral exclusion list - Referral exclusion list. Incoming traffic from these sites is considered direct traffic.

image alt text

In the second step, we indicate the table with the data dropped by Google Analytics 4. After pressing the create button, the module configuration will be created.

If the data is on a different project than the one synchronized with WitCloud, the Custom projectId option is in the Google Cloud Project field.

This option will work if the dataset is made available to the WitCloud account at the IAM or BigQuery level.

WARNING

Select the table events_YYYYMMDD from the list, the intraday table is handled automatically by WitCloud.

image alt text

# Setting the module in the schedule

Your Google Analytics 4 module is already created in WitCloud 📊. The last step is to establish a schedule and include our module in it. You can read about how to do it here link (opens new window)

Last updated: 2/3/2021, 10:28:38 AM