# 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
- Configure the module in the platform (indicate the place where BigQuery events gather).
- 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
- 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 Ghttps://witbee.com/docs/workflow/workflow/oogle 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)