Google Analytics 4 (Web + App)

• Introduction
  • An example of operation
  • Data schema
• Configuration
  • Before you start
  • Start creating the module
  • Initial settings
  • Setting the module in the schedule

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 Data Collect button.

Select Google Analytics 4 from the list of available modules

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.

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.

Setting the module in the schedule

Your module is now created in WitCloud 📊. The final step is to determine the time range for which you need to retrieve historical data. The schedule for retrieving current data will be created automatically.

Enter the appropriate range and click the Finish button.