Integration of Google Analytics 4 with BigQuery
Copies your Google Analytics 4 BigQuery export into your WitCloud dataset and adds sessions and attribution tables, so traffic sources are assigned to sessions and conversions.
Updated
Introduction
The Google Analytics 4 BigQuery integration solves the most common problems of working with GA4 data in BigQuery, such as assigning traffic sources to sessions and to conversions.
It reads the raw events that Google Analytics 4 exports to BigQuery and builds session and attribution tables for three models: Google Analytics 4, Universal Analytics Cross-Device and Universal Analytics Device. It also saves the conversion events defined in your GA4 property.
WitCloud does not change your GA4 export. The data is copied to your WitCloud dataset and enriched there. The name of every table ends with the ID of the data collect, for example ga4_sessions_<collect ID>.
Configuration guide
The integration reads the GA4 export to BigQuery, so it has to be switched on first. This is done in Google Analytics (Google's interface, not WitCloud's): in GA4 go to Admin → BigQuery Links. Watch the tutorial on YouTube The location of the BigQuery export must match the location of your WitCloud project. For example, if your WitCloud project is in europe-central2, set the GA4 export to europe-central2. With a different location (for example EU) the integration will not work properly, and the Review step shows Location mismatch.
To link Google Ads campaign data with Google Analytics 4, set up the Google Ads integration first. WitCloud then connects it to your GA4 properties automatically.
Module setup
Go to Integrations in the menu and click Add integration.

From the list of integrations, choose Google Analytics 4 BigQuery.

Enter the Collect name, for example Analytics 4 PL. You can select several GA4 properties in one go, so this is a base name: each property becomes its own data collect, named after the base name with the property name added (Analytics 4 PL - Demo Store PL).

Then set the attribution options on the same screen:

- Campaign timeout — how many days a campaign or traffic source stays assigned to a user when sessions and conversions are attributed. The default is 30 and the maximum is 90. A longer timeout means more data processed in BigQuery in every run.
- Attribution - Time decay (days) — the setting of the Time decay model, which gives a bigger share to traffic sources closer to the conversion. The value is the half-life in days: a source loses half of its share for every that many days before the conversion. The default is 7 and the maximum is 7. With 7, an interaction 8 days before the conversion gets half the share of an interaction 1 day before it.
- Is User ID implemented? — turn it on if you send the User ID to GA4. The integration then also fills the
ga4_users_deduplicationtable. When it is off, that table is created empty. - Attribution - Position based — the setting of the Position based model. Drag the two handles to split the conversion value between First touch, Middle and Last touch. The default is 40% for the first touch, 40% for the last one and 20% shared by the sources in the middle.
Click Next.
Authorization
Click Authorize next to the Select Analytics authorization field. If you already authorized Google Analytics in WitCloud, pick that authorization from the drop-down instead. To change it later, click Re-authorize.

A Google window opens (it is Google's, not WitCloud's). Sign in and accept the permissions. WitCloud asks for read-only access to your Google Analytics data (analytics.readonly) and for your basic Google profile. Use an account that can see the GA4 properties you want to connect.
The BigQuery data itself is read with the WitCloud service account, not with your Google account. See the Review step below.
Choose the account in Select account.

In Select properties, choose one or more GA4 properties.


Click Next. WitCloud now checks every selected property.
Review: BigQuery export and Google Ads
You do not choose a BigQuery project, dataset or table. For every property, WitCloud finds the BigQuery export that is linked to it in GA4 (the analytics_<property ID> dataset) and shows the result in the Review step:
- Property — a green dot when the BigQuery export works, a red one when it does not.
- BigQuery — Connected with the project and the dataset, or the reason why it does not work.
- Google Ads — Connected with the name of your Google Ads data collect, Not configured when the property is linked to a Google Ads account that has no Google Ads data collect in WitCloud yet, or Not linked when no Google Ads account is linked to the property in GA4.

Continue is enabled when every property has a working BigQuery export and no Google Ads account is left without a data collect. Fix the rows that show a problem and click the refresh icon in the Google Ads column header (Refresh status) to check again. A property can be removed from the list with the small cross at the end of its row, as long as at least one stays.
| Message | What it means and what to do |
|---|---|
| Access denied | WitCloud cannot read the analytics_<property ID> dataset. Share it with the WitCloud service account using BigQuery Admin access. The step shows the account with a Copy service account button. It is needed when the GA4 export is in a different Google Cloud project than your WitCloud project. |
| Export disabled | The export is set up but switched off. Enable it in GA4 under Admin → BigQuery Links (Google's interface). |
| No BigQuery export configured in GA4 | The property has no BigQuery link. Set it up in GA4 under Admin → BigQuery Links (Google's interface). |
| Location mismatch | The export is in a different location than your WitCloud project. Both must be in the same region. |
| Connection failed / Detection failed | The check did not finish. Click the refresh icon to try again. |
When a property shows Not configured, click it to open the Google Ads integration. After you create the Google Ads data collect you return to this wizard, with your settings kept.
When every row is green, click Continue.

Historical data and schedule
In Historical Data, enter the number of days of history to fetch, up to 365. The same number is used for every selected property. Days from before the GA4 export to BigQuery was switched on have no data and are skipped.

The data synchronization schedule is created automatically. You can find more information about it here.
Click Create.

Done! One data collect per selected property now fetches the history and then synchronizes with BigQuery every day. A day is processed once the GA4 export for that day has data.
Changing a data collect
Open the data collect from Integrations to change its settings. The edit view has the same Collect Settings and Analytics Settings, and one more step, BigQuery Settings, where you can point the data collect to another export:
- Google Cloud Project — choose the project connected to WitCloud, or Custom Project Id and type the ID of the project that holds the GA4 export. Click Projects to reload the list, or Datasets to load the datasets of the custom project. A dataset in another project must be shared with the WitCloud service account (the view shows it with Copy service account) using BigQuery Admin access.
- BigQuery Dataset — only datasets with
analytics_in the name are listed. If none appears, the view shows No GA4 export dataset found: configure the GA4 export to BigQuery and use the same location as your WitCloud project. - BigQuery Table — the GA4 events table (
events_YYYYMMDD).
If the chosen dataset is in another location than your WitCloud project, the view shows Location mismatch detected: the data collect will not work as expected.
The edit view also has the Connect Google Ads accounts field, where you choose the Google Ads data collects whose campaigns are linked to the property.
Data schema
Each data collect creates the tables below in your WitCloud dataset (the table name ends with the collect ID, for example ga4_events_<collect ID>).
Data schema for ga4_attribution
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| journey_id | NULLABLE | STRING |
| conversion_time | NULLABLE | TIMESTAMP |
| session_path_time | NULLABLE | TIMESTAMP |
| session_id | NULLABLE | STRING |
| event_date | NULLABLE | STRING |
| attribution_timespan | NULLABLE | STRING |
| conversion_time_micros | NULLABLE | INTEGER |
| session_path_time_micros | NULLABLE | INTEGER |
| user_pseudo_id | NULLABLE | STRING |
| event_name | NULLABLE | STRING |
| event_value | NULLABLE | FLOAT |
| session_path_traffic_source | NULLABLE | RECORD |
| session_path_traffic_source.source | NULLABLE | STRING |
| session_path_traffic_source.medium | NULLABLE | STRING |
| session_path_traffic_source.campaign | NULLABLE | STRING |
| session_path_traffic_source.campaign_id | NULLABLE | STRING |
| session_path_traffic_source.gclid | NULLABLE | STRING |
| session_path_days_from_conversion | NULLABLE | INTEGER |
| path_length | NULLABLE | INTEGER |
| path_length_days | NULLABLE | INTEGER |
| path_step_number_reverse | NULLABLE | INTEGER |
| path_step_number | NULLABLE | INTEGER |
| attribution_score | NULLABLE | RECORD |
| attribution_score.first_click | NULLABLE | INTEGER |
| attribution_score.last_click | NULLABLE | INTEGER |
| attribution_score.linear | NULLABLE | FLOAT |
| attribution_score.position_based | NULLABLE | FLOAT |
| attribution_score.timedecay | NULLABLE | FLOAT |
| attribution_direct | NULLABLE | STRING |
| ecommerce | NULLABLE | RECORD |
| ecommerce.event_timestamp_utc | NULLABLE | TIMESTAMP |
| ecommerce.transaction_id | NULLABLE | STRING |
| ecommerce.currency | NULLABLE | STRING |
| ecommerce.coupon | NULLABLE | STRING |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_duplicate_nr | NULLABLE | INTEGER |
| ecommerce.items | REPEATED | RECORD |
| ecommerce.items.item_id | NULLABLE | STRING |
| ecommerce.items.item_name | NULLABLE | STRING |
| ecommerce.items.item_brand | NULLABLE | STRING |
| ecommerce.items.item_variant | NULLABLE | STRING |
| ecommerce.items.item_category | NULLABLE | STRING |
| ecommerce.items.item_category2 | NULLABLE | STRING |
| ecommerce.items.item_category3 | NULLABLE | STRING |
| ecommerce.items.item_category4 | NULLABLE | STRING |
| ecommerce.items.item_category5 | NULLABLE | STRING |
| ecommerce.items.price_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.price_in_usd | NULLABLE | FLOAT |
| ecommerce.items.price | NULLABLE | FLOAT |
| ecommerce.items.quantity | NULLABLE | INTEGER |
| ecommerce.items.item_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_revenue | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_refund | NULLABLE | FLOAT |
| ecommerce.items.coupon | NULLABLE | STRING |
| ecommerce.items.affiliation | NULLABLE | STRING |
| ecommerce.items.item_params | REPEATED | RECORD |
| ecommerce.items.item_params.key | NULLABLE | STRING |
| ecommerce.items.item_params.value | NULLABLE | RECORD |
| ecommerce.items.item_params.value.string_value | NULLABLE | STRING |
| ecommerce.items.item_params.value.int_value | NULLABLE | INTEGER |
| ecommerce.items.item_params.value.float_value | NULLABLE | FLOAT |
| ecommerce.items.item_params.value.double_value | NULLABLE | FLOAT |
| google_ads_click_info | NULLABLE | RECORD |
| google_ads_click_info.external_customer_id | NULLABLE | STRING |
| google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| google_ads_click_info.campaign_id | NULLABLE | STRING |
| google_ads_click_info.campaign_name | NULLABLE | STRING |
| google_ads_click_info.ad_group_id | NULLABLE | STRING |
| google_ads_click_info.ad_group_name | NULLABLE | STRING |
| google_ads_click_info.creative_id | NULLABLE | STRING |
| google_ads_click_info.criteria_id | NULLABLE | STRING |
| google_ads_click_info.gclid | NULLABLE | STRING |
| google_ads_click_info.user_list_id | NULLABLE | STRING |
| google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| google_ads_click_info.page | NULLABLE | INTEGER |
| google_ads_click_info.slot | NULLABLE | STRING |
| google_ads_click_info.device | NULLABLE | STRING |
| google_ads_click_info.currency | NULLABLE | STRING |
Data schema for ga4_attribution_ua_cross_device
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| journey_id | NULLABLE | STRING |
| conversion_time | NULLABLE | TIMESTAMP |
| session_path_time | NULLABLE | TIMESTAMP |
| session_id | NULLABLE | STRING |
| event_date | NULLABLE | STRING |
| attribution_timespan | NULLABLE | STRING |
| conversion_time_micros | NULLABLE | INTEGER |
| session_path_time_micros | NULLABLE | INTEGER |
| user_pseudo_id | NULLABLE | STRING |
| event_name | NULLABLE | STRING |
| event_value | NULLABLE | FLOAT |
| session_path_traffic_source | NULLABLE | RECORD |
| session_path_traffic_source.source | NULLABLE | STRING |
| session_path_traffic_source.medium | NULLABLE | STRING |
| session_path_traffic_source.campaign | NULLABLE | STRING |
| session_path_traffic_source.campaign_id | NULLABLE | STRING |
| session_path_traffic_source.gclid | NULLABLE | STRING |
| session_path_days_from_conversion | NULLABLE | INTEGER |
| path_length | NULLABLE | INTEGER |
| path_length_days | NULLABLE | INTEGER |
| path_step_number_reverse | NULLABLE | INTEGER |
| path_step_number | NULLABLE | INTEGER |
| attribution_score | NULLABLE | RECORD |
| attribution_score.first_click | NULLABLE | INTEGER |
| attribution_score.last_click | NULLABLE | INTEGER |
| attribution_score.linear | NULLABLE | FLOAT |
| attribution_score.position_based | NULLABLE | FLOAT |
| attribution_score.timedecay | NULLABLE | FLOAT |
| attribution_direct | NULLABLE | STRING |
| ecommerce | NULLABLE | RECORD |
| ecommerce.event_timestamp_utc | NULLABLE | TIMESTAMP |
| ecommerce.transaction_id | NULLABLE | STRING |
| ecommerce.currency | NULLABLE | STRING |
| ecommerce.coupon | NULLABLE | STRING |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_duplicate_nr | NULLABLE | INTEGER |
| ecommerce.items | REPEATED | RECORD |
| ecommerce.items.item_id | NULLABLE | STRING |
| ecommerce.items.item_name | NULLABLE | STRING |
| ecommerce.items.item_brand | NULLABLE | STRING |
| ecommerce.items.item_variant | NULLABLE | STRING |
| ecommerce.items.item_category | NULLABLE | STRING |
| ecommerce.items.item_category2 | NULLABLE | STRING |
| ecommerce.items.item_category3 | NULLABLE | STRING |
| ecommerce.items.item_category4 | NULLABLE | STRING |
| ecommerce.items.item_category5 | NULLABLE | STRING |
| ecommerce.items.price_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.price_in_usd | NULLABLE | FLOAT |
| ecommerce.items.price | NULLABLE | FLOAT |
| ecommerce.items.quantity | NULLABLE | INTEGER |
| ecommerce.items.item_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_revenue | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_refund | NULLABLE | FLOAT |
| ecommerce.items.coupon | NULLABLE | STRING |
| ecommerce.items.affiliation | NULLABLE | STRING |
| ecommerce.items.item_params | REPEATED | RECORD |
| ecommerce.items.item_params.key | NULLABLE | STRING |
| ecommerce.items.item_params.value | NULLABLE | RECORD |
| ecommerce.items.item_params.value.string_value | NULLABLE | STRING |
| ecommerce.items.item_params.value.int_value | NULLABLE | INTEGER |
| ecommerce.items.item_params.value.float_value | NULLABLE | FLOAT |
| ecommerce.items.item_params.value.double_value | NULLABLE | FLOAT |
| google_ads_click_info | NULLABLE | RECORD |
| google_ads_click_info.external_customer_id | NULLABLE | STRING |
| google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| google_ads_click_info.campaign_id | NULLABLE | STRING |
| google_ads_click_info.campaign_name | NULLABLE | STRING |
| google_ads_click_info.ad_group_id | NULLABLE | STRING |
| google_ads_click_info.ad_group_name | NULLABLE | STRING |
| google_ads_click_info.creative_id | NULLABLE | STRING |
| google_ads_click_info.criteria_id | NULLABLE | STRING |
| google_ads_click_info.gclid | NULLABLE | STRING |
| google_ads_click_info.user_list_id | NULLABLE | STRING |
| google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| google_ads_click_info.page | NULLABLE | INTEGER |
| google_ads_click_info.slot | NULLABLE | STRING |
| google_ads_click_info.device | NULLABLE | STRING |
| google_ads_click_info.currency | NULLABLE | STRING |
Data schema for ga4_attribution_ua_device
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| journey_id | NULLABLE | STRING |
| conversion_time | NULLABLE | TIMESTAMP |
| session_path_time | NULLABLE | TIMESTAMP |
| session_id | NULLABLE | STRING |
| event_date | NULLABLE | STRING |
| attribution_timespan | NULLABLE | STRING |
| conversion_time_micros | NULLABLE | INTEGER |
| session_path_time_micros | NULLABLE | INTEGER |
| user_pseudo_id | NULLABLE | STRING |
| event_name | NULLABLE | STRING |
| event_value | NULLABLE | FLOAT |
| session_path_traffic_source | NULLABLE | RECORD |
| session_path_traffic_source.source | NULLABLE | STRING |
| session_path_traffic_source.medium | NULLABLE | STRING |
| session_path_traffic_source.campaign | NULLABLE | STRING |
| session_path_traffic_source.campaign_id | NULLABLE | STRING |
| session_path_traffic_source.gclid | NULLABLE | STRING |
| session_path_days_from_conversion | NULLABLE | INTEGER |
| path_length | NULLABLE | INTEGER |
| path_length_days | NULLABLE | INTEGER |
| path_step_number_reverse | NULLABLE | INTEGER |
| path_step_number | NULLABLE | INTEGER |
| attribution_score | NULLABLE | RECORD |
| attribution_score.first_click | NULLABLE | INTEGER |
| attribution_score.last_click | NULLABLE | INTEGER |
| attribution_score.linear | NULLABLE | FLOAT |
| attribution_score.position_based | NULLABLE | FLOAT |
| attribution_score.timedecay | NULLABLE | FLOAT |
| attribution_direct | NULLABLE | STRING |
| ecommerce | NULLABLE | RECORD |
| ecommerce.event_timestamp_utc | NULLABLE | TIMESTAMP |
| ecommerce.transaction_id | NULLABLE | STRING |
| ecommerce.currency | NULLABLE | STRING |
| ecommerce.coupon | NULLABLE | STRING |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_duplicate_nr | NULLABLE | INTEGER |
| ecommerce.items | REPEATED | RECORD |
| ecommerce.items.item_id | NULLABLE | STRING |
| ecommerce.items.item_name | NULLABLE | STRING |
| ecommerce.items.item_brand | NULLABLE | STRING |
| ecommerce.items.item_variant | NULLABLE | STRING |
| ecommerce.items.item_category | NULLABLE | STRING |
| ecommerce.items.item_category2 | NULLABLE | STRING |
| ecommerce.items.item_category3 | NULLABLE | STRING |
| ecommerce.items.item_category4 | NULLABLE | STRING |
| ecommerce.items.item_category5 | NULLABLE | STRING |
| ecommerce.items.price_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.price_in_usd | NULLABLE | FLOAT |
| ecommerce.items.price | NULLABLE | FLOAT |
| ecommerce.items.quantity | NULLABLE | INTEGER |
| ecommerce.items.item_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_revenue | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_refund | NULLABLE | FLOAT |
| ecommerce.items.coupon | NULLABLE | STRING |
| ecommerce.items.affiliation | NULLABLE | STRING |
| ecommerce.items.item_params | REPEATED | RECORD |
| ecommerce.items.item_params.key | NULLABLE | STRING |
| ecommerce.items.item_params.value | NULLABLE | RECORD |
| ecommerce.items.item_params.value.string_value | NULLABLE | STRING |
| ecommerce.items.item_params.value.int_value | NULLABLE | INTEGER |
| ecommerce.items.item_params.value.float_value | NULLABLE | FLOAT |
| ecommerce.items.item_params.value.double_value | NULLABLE | FLOAT |
| google_ads_click_info | NULLABLE | RECORD |
| google_ads_click_info.external_customer_id | NULLABLE | STRING |
| google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| google_ads_click_info.campaign_id | NULLABLE | STRING |
| google_ads_click_info.campaign_name | NULLABLE | STRING |
| google_ads_click_info.ad_group_id | NULLABLE | STRING |
| google_ads_click_info.ad_group_name | NULLABLE | STRING |
| google_ads_click_info.creative_id | NULLABLE | STRING |
| google_ads_click_info.criteria_id | NULLABLE | STRING |
| google_ads_click_info.gclid | NULLABLE | STRING |
| google_ads_click_info.user_list_id | NULLABLE | STRING |
| google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| google_ads_click_info.page | NULLABLE | INTEGER |
| google_ads_click_info.slot | NULLABLE | STRING |
| google_ads_click_info.device | NULLABLE | STRING |
| google_ads_click_info.currency | NULLABLE | STRING |
Data schema for ga4_conversion_events
| Field Name | Mode | Type |
|---|---|---|
| countingMethod | NULLABLE | STRING |
| deletable | NULLABLE | BOOLEAN |
| name | NULLABLE | STRING |
| custom | NULLABLE | BOOLEAN |
| eventName | NULLABLE | STRING |
| streamId | NULLABLE | INTEGER |
| createTime | NULLABLE | TIMESTAMP |
| propertyId | NULLABLE | INTEGER |
Data schema for ga4_events
| Field Name | Mode | Type |
|---|---|---|
| event_date | NULLABLE | STRING |
| user_pseudo_id | NULLABLE | STRING |
| user_id | NULLABLE | STRING |
| group_id | NULLABLE | STRING |
| event_name | NULLABLE | STRING |
| event_timestamp | NULLABLE | INTEGER |
| event_params | REPEATED | RECORD |
| event_params.key | NULLABLE | STRING |
| event_params.value | NULLABLE | RECORD |
| event_params.value.string_value | NULLABLE | STRING |
| event_params.value.int_value | NULLABLE | INTEGER |
| event_params.value.float_value | NULLABLE | FLOAT |
| event_params.value.double_value | NULLABLE | FLOAT |
| app_info | NULLABLE | RECORD |
| app_info.id | NULLABLE | STRING |
| app_info.version | NULLABLE | STRING |
| app_info.install_store | NULLABLE | STRING |
| app_info.firebase_app_id | NULLABLE | STRING |
| app_info.install_source | NULLABLE | STRING |
| device | NULLABLE | RECORD |
| device.category | NULLABLE | STRING |
| device.mobile_brand_name | NULLABLE | STRING |
| device.mobile_model_name | NULLABLE | STRING |
| device.mobile_marketing_name | NULLABLE | STRING |
| device.mobile_os_hardware_model | NULLABLE | STRING |
| device.operating_system | NULLABLE | STRING |
| device.operating_system_version | NULLABLE | STRING |
| device.vendor_id | NULLABLE | STRING |
| device.advertising_id | NULLABLE | STRING |
| device.language | NULLABLE | STRING |
| device.is_limited_ad_tracking | NULLABLE | STRING |
| device.time_zone_offset_seconds | NULLABLE | INTEGER |
| device.browser | NULLABLE | STRING |
| device.browser_version | NULLABLE | STRING |
| device.web_info | NULLABLE | RECORD |
| device.web_info.browser | NULLABLE | STRING |
| device.web_info.browser_version | NULLABLE | STRING |
| device.web_info.hostname | NULLABLE | STRING |
| ecommerce | NULLABLE | RECORD |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_id | NULLABLE | STRING |
| items | REPEATED | RECORD |
| items.item_id | NULLABLE | STRING |
| items.item_name | NULLABLE | STRING |
| items.item_brand | NULLABLE | STRING |
| items.item_variant | NULLABLE | STRING |
| items.item_category | NULLABLE | STRING |
| items.item_category2 | NULLABLE | STRING |
| items.item_category3 | NULLABLE | STRING |
| items.item_category4 | NULLABLE | STRING |
| items.item_category5 | NULLABLE | STRING |
| items.price_in_usd | NULLABLE | FLOAT |
| items.price | NULLABLE | FLOAT |
| items.quantity | NULLABLE | INTEGER |
| items.item_revenue_in_usd | NULLABLE | FLOAT |
| items.item_revenue | NULLABLE | FLOAT |
| items.item_refund_in_usd | NULLABLE | FLOAT |
| items.item_refund | NULLABLE | FLOAT |
| items.coupon | NULLABLE | STRING |
| items.affiliation | NULLABLE | STRING |
| items.location_id | NULLABLE | STRING |
| items.item_list_id | NULLABLE | STRING |
| items.item_list_name | NULLABLE | STRING |
| items.item_list_index | NULLABLE | STRING |
| items.promotion_id | NULLABLE | STRING |
| items.promotion_name | NULLABLE | STRING |
| items.creative_name | NULLABLE | STRING |
| items.creative_slot | NULLABLE | STRING |
| items.item_params | REPEATED | RECORD |
| items.item_params.key | NULLABLE | STRING |
| items.item_params.value | NULLABLE | RECORD |
| items.item_params.value.string_value | NULLABLE | STRING |
| items.item_params.value.int_value | NULLABLE | INTEGER |
| items.item_params.value.float_value | NULLABLE | FLOAT |
| items.item_params.value.double_value | NULLABLE | FLOAT |
| event_bundle_sequence_id | NULLABLE | INTEGER |
| event_dimensions | NULLABLE | RECORD |
| event_dimensions.hostname | NULLABLE | STRING |
| event_previous_timestamp | NULLABLE | INTEGER |
| event_server_timestamp_offset | NULLABLE | INTEGER |
| event_value_in_usd | NULLABLE | FLOAT |
| geo | NULLABLE | RECORD |
| geo.continent | NULLABLE | STRING |
| geo.country | NULLABLE | STRING |
| geo.region | NULLABLE | STRING |
| geo.city | NULLABLE | STRING |
| geo.sub_continent | NULLABLE | STRING |
| geo.metro | NULLABLE | STRING |
| platform | NULLABLE | STRING |
| privacy_info | NULLABLE | RECORD |
| privacy_info.analytics_storage | NULLABLE | STRING |
| privacy_info.ads_storage | NULLABLE | STRING |
| privacy_info.uses_transient_token | NULLABLE | STRING |
| stream_id | NULLABLE | STRING |
| traffic_source | NULLABLE | RECORD |
| traffic_source.name | NULLABLE | STRING |
| traffic_source.medium | NULLABLE | STRING |
| traffic_source.source | NULLABLE | STRING |
| user_first_touch_timestamp | NULLABLE | INTEGER |
| user_ltv | NULLABLE | RECORD |
| user_ltv.revenue | NULLABLE | FLOAT |
| user_ltv.currency | NULLABLE | STRING |
| user_properties | REPEATED | RECORD |
| user_properties.key | NULLABLE | STRING |
| user_properties.value | NULLABLE | RECORD |
| user_properties.value.string_value | NULLABLE | STRING |
| user_properties.value.int_value | NULLABLE | INTEGER |
| user_properties.value.float_value | NULLABLE | FLOAT |
| user_properties.value.double_value | NULLABLE | FLOAT |
| user_properties.value.set_timestamp_micros | NULLABLE | INTEGER |
| wit_session_ga4 | NULLABLE | RECORD |
| wit_session_ga4.session_id | NULLABLE | STRING |
| wit_session_ga4.session_id_group | NULLABLE | STRING |
| wit_session_ga4.traffic_source | NULLABLE | RECORD |
| wit_session_ga4.traffic_source.source | NULLABLE | STRING |
| wit_session_ga4.traffic_source.medium | NULLABLE | STRING |
| wit_session_ga4.traffic_source.campaign | NULLABLE | STRING |
| wit_session_ga4.traffic_source.term | NULLABLE | STRING |
| wit_session_ga4.traffic_source.content | NULLABLE | STRING |
| wit_session_ga4.traffic_source.campaign_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.gclid | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info | NULLABLE | RECORD |
| wit_session_ga4.traffic_source.google_ads_click_info.external_customer_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.campaign_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.campaign_name | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_group_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_group_name | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.creative_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.criteria_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.gclid | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.user_list_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.page | NULLABLE | INTEGER |
| wit_session_ga4.traffic_source.google_ads_click_info.slot | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.device | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.currency | NULLABLE | STRING |
| wit_session_ga4.attribution_details | NULLABLE | STRING |
| wit_session_ua_cross_device | NULLABLE | RECORD |
| wit_session_ua_cross_device.session_id | NULLABLE | STRING |
| wit_session_ua_cross_device.session_id_group | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source | NULLABLE | RECORD |
| wit_session_ua_cross_device.traffic_source.source | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.medium | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.campaign | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.term | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.content | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.campaign_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.gclid | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info | NULLABLE | RECORD |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.external_customer_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_name | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_name | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.creative_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.gclid | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.user_list_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.page | NULLABLE | INTEGER |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.slot | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.device | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.currency | NULLABLE | STRING |
| wit_session_ua_cross_device.attribution_details | NULLABLE | STRING |
| wit_session_ua_device | NULLABLE | RECORD |
| wit_session_ua_device.session_id | NULLABLE | STRING |
| wit_session_ua_device.session_id_group | NULLABLE | STRING |
| wit_session_ua_device.traffic_source | NULLABLE | RECORD |
| wit_session_ua_device.traffic_source.source | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.medium | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.campaign | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.term | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.content | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.campaign_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.gclid | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info | NULLABLE | RECORD |
| wit_session_ua_device.traffic_source.google_ads_click_info.external_customer_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.campaign_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.campaign_name | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_name | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.creative_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.criteria_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.gclid | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.user_list_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.page | NULLABLE | INTEGER |
| wit_session_ua_device.traffic_source.google_ads_click_info.slot | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.device | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.currency | NULLABLE | STRING |
| wit_session_ua_device.attribution_details | NULLABLE | STRING |
| attribution_timespan | NULLABLE | STRING |
| is_active_user | NULLABLE | BOOLEAN |
Data schema for ga4_sessions
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| session_id | NULLABLE | STRING |
| user_pseudo_id | NULLABLE | STRING |
| session_start_time | NULLABLE | INTEGER |
| landing_page | NULLABLE | STRING |
| totals | NULLABLE | RECORD |
| totals.event | NULLABLE | INTEGER |
| totals.page_view | NULLABLE | INTEGER |
| totals.unique_page_view | NULLABLE | INTEGER |
| totals.screen_view | NULLABLE | INTEGER |
| totals.unique_screen_view | NULLABLE | INTEGER |
| totals.engagement | NULLABLE | INTEGER |
| totals.engagement_time_seconds | NULLABLE | FLOAT |
| totals.visit_duration | NULLABLE | INTEGER |
| totals.first_visit | NULLABLE | INTEGER |
| totals.view_item | NULLABLE | INTEGER |
| totals.add_to_cart | NULLABLE | INTEGER |
| totals.begin_checkout | NULLABLE | INTEGER |
| totals.add_shipping_info | NULLABLE | INTEGER |
| totals.add_payment_info | NULLABLE | INTEGER |
| totals.purchase | NULLABLE | INTEGER |
| totals.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| totals.shipping_value_in_property_currency | NULLABLE | FLOAT |
| totals.tax_value_in_property_currency | NULLABLE | FLOAT |
| totals.refund_value_in_property_currency | NULLABLE | FLOAT |
| totals.event_count | NULLABLE | STRING |
| totals.event_value | NULLABLE | STRING |
| stream_id | NULLABLE | STRING |
| platform | NULLABLE | STRING |
| acq_traffic_source | NULLABLE | RECORD |
| acq_traffic_source.name | NULLABLE | STRING |
| acq_traffic_source.medium | NULLABLE | STRING |
| acq_traffic_source.source | NULLABLE | STRING |
| wit_session_ga4 | NULLABLE | RECORD |
| wit_session_ga4.session_id | NULLABLE | STRING |
| wit_session_ga4.session_id_group | NULLABLE | STRING |
| wit_session_ga4.traffic_source | NULLABLE | RECORD |
| wit_session_ga4.traffic_source.source | NULLABLE | STRING |
| wit_session_ga4.traffic_source.medium | NULLABLE | STRING |
| wit_session_ga4.traffic_source.campaign | NULLABLE | STRING |
| wit_session_ga4.traffic_source.term | NULLABLE | STRING |
| wit_session_ga4.traffic_source.content | NULLABLE | STRING |
| wit_session_ga4.traffic_source.campaign_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.gclid | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info | NULLABLE | RECORD |
| wit_session_ga4.traffic_source.google_ads_click_info.external_customer_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.campaign_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.campaign_name | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_group_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_group_name | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.creative_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.criteria_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.gclid | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.user_list_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.page | NULLABLE | INTEGER |
| wit_session_ga4.traffic_source.google_ads_click_info.slot | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.device | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.currency | NULLABLE | STRING |
| wit_session_ga4.attribution_details | NULLABLE | STRING |
| device | NULLABLE | RECORD |
| device.category | NULLABLE | STRING |
| device.mobile_brand_name | NULLABLE | STRING |
| device.mobile_model_name | NULLABLE | STRING |
| device.mobile_marketing_name | NULLABLE | STRING |
| device.mobile_os_hardware_model | NULLABLE | STRING |
| device.operating_system | NULLABLE | STRING |
| device.operating_system_version | NULLABLE | STRING |
| device.vendor_id | NULLABLE | STRING |
| device.advertising_id | NULLABLE | STRING |
| device.language | NULLABLE | STRING |
| device.is_limited_ad_tracking | NULLABLE | STRING |
| device.time_zone_offset_seconds | NULLABLE | INTEGER |
| device.browser | NULLABLE | STRING |
| device.browser_version | NULLABLE | STRING |
| device.web_info | NULLABLE | RECORD |
| device.web_info.browser | NULLABLE | STRING |
| device.web_info.browser_version | NULLABLE | STRING |
| device.web_info.hostname | NULLABLE | STRING |
| geo | NULLABLE | RECORD |
| geo.continent | NULLABLE | STRING |
| geo.country | NULLABLE | STRING |
| geo.region | NULLABLE | STRING |
| geo.city | NULLABLE | STRING |
| geo.sub_continent | NULLABLE | STRING |
| geo.metro | NULLABLE | STRING |
| app_info | NULLABLE | RECORD |
| app_info.id | NULLABLE | STRING |
| app_info.version | NULLABLE | STRING |
| app_info.install_store | NULLABLE | STRING |
| app_info.firebase_app_id | NULLABLE | STRING |
| app_info.install_source | NULLABLE | STRING |
| ecommerce | REPEATED | RECORD |
| ecommerce.event_timestamp_utc | NULLABLE | TIMESTAMP |
| ecommerce.transaction_id | NULLABLE | STRING |
| ecommerce.currency | NULLABLE | STRING |
| ecommerce.coupon | NULLABLE | STRING |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_duplicate_nr | NULLABLE | INTEGER |
| ecommerce.items | REPEATED | RECORD |
| ecommerce.items.item_id | NULLABLE | STRING |
| ecommerce.items.item_name | NULLABLE | STRING |
| ecommerce.items.item_brand | NULLABLE | STRING |
| ecommerce.items.item_variant | NULLABLE | STRING |
| ecommerce.items.item_category | NULLABLE | STRING |
| ecommerce.items.item_category2 | NULLABLE | STRING |
| ecommerce.items.item_category3 | NULLABLE | STRING |
| ecommerce.items.item_category4 | NULLABLE | STRING |
| ecommerce.items.item_category5 | NULLABLE | STRING |
| ecommerce.items.price_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.price_in_usd | NULLABLE | FLOAT |
| ecommerce.items.price | NULLABLE | FLOAT |
| ecommerce.items.quantity | NULLABLE | INTEGER |
| ecommerce.items.item_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_revenue | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_refund | NULLABLE | FLOAT |
| ecommerce.items.coupon | NULLABLE | STRING |
| ecommerce.items.affiliation | NULLABLE | STRING |
| ecommerce.items.item_params | REPEATED | RECORD |
| ecommerce.items.item_params.key | NULLABLE | STRING |
| ecommerce.items.item_params.value | NULLABLE | RECORD |
| ecommerce.items.item_params.value.string_value | NULLABLE | STRING |
| ecommerce.items.item_params.value.int_value | NULLABLE | INTEGER |
| ecommerce.items.item_params.value.float_value | NULLABLE | FLOAT |
| ecommerce.items.item_params.value.double_value | NULLABLE | FLOAT |
| is_true_direct | NULLABLE | BOOLEAN |
Data schema for ga4_sessions_ua_cross_device
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| session_id | NULLABLE | STRING |
| user_pseudo_id | NULLABLE | STRING |
| session_start_time | NULLABLE | INTEGER |
| landing_page | NULLABLE | STRING |
| totals | NULLABLE | RECORD |
| totals.event | NULLABLE | INTEGER |
| totals.page_view | NULLABLE | INTEGER |
| totals.unique_page_view | NULLABLE | INTEGER |
| totals.screen_view | NULLABLE | INTEGER |
| totals.unique_screen_view | NULLABLE | INTEGER |
| totals.engagement | NULLABLE | INTEGER |
| totals.engagement_time_seconds | NULLABLE | FLOAT |
| totals.visit_duration | NULLABLE | INTEGER |
| totals.first_visit | NULLABLE | INTEGER |
| totals.view_item | NULLABLE | INTEGER |
| totals.add_to_cart | NULLABLE | INTEGER |
| totals.begin_checkout | NULLABLE | INTEGER |
| totals.add_shipping_info | NULLABLE | INTEGER |
| totals.add_payment_info | NULLABLE | INTEGER |
| totals.purchase | NULLABLE | INTEGER |
| totals.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| totals.shipping_value_in_property_currency | NULLABLE | FLOAT |
| totals.tax_value_in_property_currency | NULLABLE | FLOAT |
| totals.refund_value_in_property_currency | NULLABLE | FLOAT |
| totals.event_count | NULLABLE | STRING |
| totals.event_value | NULLABLE | STRING |
| stream_id | NULLABLE | STRING |
| platform | NULLABLE | STRING |
| acq_traffic_source | NULLABLE | RECORD |
| acq_traffic_source.name | NULLABLE | STRING |
| acq_traffic_source.medium | NULLABLE | STRING |
| acq_traffic_source.source | NULLABLE | STRING |
| wit_session_ua_cross_device | NULLABLE | RECORD |
| wit_session_ua_cross_device.session_id | NULLABLE | STRING |
| wit_session_ua_cross_device.session_id_group | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source | NULLABLE | RECORD |
| wit_session_ua_cross_device.traffic_source.source | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.medium | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.campaign | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.term | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.content | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.campaign_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.gclid | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info | NULLABLE | RECORD |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.external_customer_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_name | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_name | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.creative_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.gclid | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.user_list_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.page | NULLABLE | INTEGER |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.slot | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.device | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.currency | NULLABLE | STRING |
| wit_session_ua_cross_device.attribution_details | NULLABLE | STRING |
| device | NULLABLE | RECORD |
| device.category | NULLABLE | STRING |
| device.mobile_brand_name | NULLABLE | STRING |
| device.mobile_model_name | NULLABLE | STRING |
| device.mobile_marketing_name | NULLABLE | STRING |
| device.mobile_os_hardware_model | NULLABLE | STRING |
| device.operating_system | NULLABLE | STRING |
| device.operating_system_version | NULLABLE | STRING |
| device.vendor_id | NULLABLE | STRING |
| device.advertising_id | NULLABLE | STRING |
| device.language | NULLABLE | STRING |
| device.is_limited_ad_tracking | NULLABLE | STRING |
| device.time_zone_offset_seconds | NULLABLE | INTEGER |
| device.browser | NULLABLE | STRING |
| device.browser_version | NULLABLE | STRING |
| device.web_info | NULLABLE | RECORD |
| device.web_info.browser | NULLABLE | STRING |
| device.web_info.browser_version | NULLABLE | STRING |
| device.web_info.hostname | NULLABLE | STRING |
| geo | NULLABLE | RECORD |
| geo.continent | NULLABLE | STRING |
| geo.country | NULLABLE | STRING |
| geo.region | NULLABLE | STRING |
| geo.city | NULLABLE | STRING |
| geo.sub_continent | NULLABLE | STRING |
| geo.metro | NULLABLE | STRING |
| app_info | NULLABLE | RECORD |
| app_info.id | NULLABLE | STRING |
| app_info.version | NULLABLE | STRING |
| app_info.install_store | NULLABLE | STRING |
| app_info.firebase_app_id | NULLABLE | STRING |
| app_info.install_source | NULLABLE | STRING |
| ecommerce | REPEATED | RECORD |
| ecommerce.event_timestamp_utc | NULLABLE | TIMESTAMP |
| ecommerce.transaction_id | NULLABLE | STRING |
| ecommerce.currency | NULLABLE | STRING |
| ecommerce.coupon | NULLABLE | STRING |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_duplicate_nr | NULLABLE | INTEGER |
| ecommerce.items | REPEATED | RECORD |
| ecommerce.items.item_id | NULLABLE | STRING |
| ecommerce.items.item_name | NULLABLE | STRING |
| ecommerce.items.item_brand | NULLABLE | STRING |
| ecommerce.items.item_variant | NULLABLE | STRING |
| ecommerce.items.item_category | NULLABLE | STRING |
| ecommerce.items.item_category2 | NULLABLE | STRING |
| ecommerce.items.item_category3 | NULLABLE | STRING |
| ecommerce.items.item_category4 | NULLABLE | STRING |
| ecommerce.items.item_category5 | NULLABLE | STRING |
| ecommerce.items.price_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.price_in_usd | NULLABLE | FLOAT |
| ecommerce.items.price | NULLABLE | FLOAT |
| ecommerce.items.quantity | NULLABLE | INTEGER |
| ecommerce.items.item_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_revenue | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_refund | NULLABLE | FLOAT |
| ecommerce.items.coupon | NULLABLE | STRING |
| ecommerce.items.affiliation | NULLABLE | STRING |
| ecommerce.items.item_params | REPEATED | RECORD |
| ecommerce.items.item_params.key | NULLABLE | STRING |
| ecommerce.items.item_params.value | NULLABLE | RECORD |
| ecommerce.items.item_params.value.string_value | NULLABLE | STRING |
| ecommerce.items.item_params.value.int_value | NULLABLE | INTEGER |
| ecommerce.items.item_params.value.float_value | NULLABLE | FLOAT |
| ecommerce.items.item_params.value.double_value | NULLABLE | FLOAT |
| is_true_direct | NULLABLE | BOOLEAN |
Data schema for ga4_sessions_ua_device
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| session_id | NULLABLE | STRING |
| user_pseudo_id | NULLABLE | STRING |
| session_start_time | NULLABLE | INTEGER |
| landing_page | NULLABLE | STRING |
| totals | NULLABLE | RECORD |
| totals.event | NULLABLE | INTEGER |
| totals.page_view | NULLABLE | INTEGER |
| totals.unique_page_view | NULLABLE | INTEGER |
| totals.screen_view | NULLABLE | INTEGER |
| totals.unique_screen_view | NULLABLE | INTEGER |
| totals.engagement | NULLABLE | INTEGER |
| totals.engagement_time_seconds | NULLABLE | FLOAT |
| totals.visit_duration | NULLABLE | INTEGER |
| totals.first_visit | NULLABLE | INTEGER |
| totals.view_item | NULLABLE | INTEGER |
| totals.add_to_cart | NULLABLE | INTEGER |
| totals.begin_checkout | NULLABLE | INTEGER |
| totals.add_shipping_info | NULLABLE | INTEGER |
| totals.add_payment_info | NULLABLE | INTEGER |
| totals.purchase | NULLABLE | INTEGER |
| totals.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| totals.shipping_value_in_property_currency | NULLABLE | FLOAT |
| totals.tax_value_in_property_currency | NULLABLE | FLOAT |
| totals.refund_value_in_property_currency | NULLABLE | FLOAT |
| totals.event_count | NULLABLE | STRING |
| totals.event_value | NULLABLE | STRING |
| stream_id | NULLABLE | STRING |
| platform | NULLABLE | STRING |
| acq_traffic_source | NULLABLE | RECORD |
| acq_traffic_source.name | NULLABLE | STRING |
| acq_traffic_source.medium | NULLABLE | STRING |
| acq_traffic_source.source | NULLABLE | STRING |
| wit_session_ua_device | NULLABLE | RECORD |
| wit_session_ua_device.session_id | NULLABLE | STRING |
| wit_session_ua_device.session_id_group | NULLABLE | STRING |
| wit_session_ua_device.traffic_source | NULLABLE | RECORD |
| wit_session_ua_device.traffic_source.source | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.medium | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.campaign | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.term | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.content | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.campaign_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.gclid | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info | NULLABLE | RECORD |
| wit_session_ua_device.traffic_source.google_ads_click_info.external_customer_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.campaign_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.campaign_name | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_name | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.creative_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.criteria_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.gclid | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.user_list_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.page | NULLABLE | INTEGER |
| wit_session_ua_device.traffic_source.google_ads_click_info.slot | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.device | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.currency | NULLABLE | STRING |
| wit_session_ua_device.attribution_details | NULLABLE | STRING |
| device | NULLABLE | RECORD |
| device.category | NULLABLE | STRING |
| device.mobile_brand_name | NULLABLE | STRING |
| device.mobile_model_name | NULLABLE | STRING |
| device.mobile_marketing_name | NULLABLE | STRING |
| device.mobile_os_hardware_model | NULLABLE | STRING |
| device.operating_system | NULLABLE | STRING |
| device.operating_system_version | NULLABLE | STRING |
| device.vendor_id | NULLABLE | STRING |
| device.advertising_id | NULLABLE | STRING |
| device.language | NULLABLE | STRING |
| device.is_limited_ad_tracking | NULLABLE | STRING |
| device.time_zone_offset_seconds | NULLABLE | INTEGER |
| device.browser | NULLABLE | STRING |
| device.browser_version | NULLABLE | STRING |
| device.web_info | NULLABLE | RECORD |
| device.web_info.browser | NULLABLE | STRING |
| device.web_info.browser_version | NULLABLE | STRING |
| device.web_info.hostname | NULLABLE | STRING |
| geo | NULLABLE | RECORD |
| geo.continent | NULLABLE | STRING |
| geo.country | NULLABLE | STRING |
| geo.region | NULLABLE | STRING |
| geo.city | NULLABLE | STRING |
| geo.sub_continent | NULLABLE | STRING |
| geo.metro | NULLABLE | STRING |
| app_info | NULLABLE | RECORD |
| app_info.id | NULLABLE | STRING |
| app_info.version | NULLABLE | STRING |
| app_info.install_store | NULLABLE | STRING |
| app_info.firebase_app_id | NULLABLE | STRING |
| app_info.install_source | NULLABLE | STRING |
| ecommerce | REPEATED | RECORD |
| ecommerce.event_timestamp_utc | NULLABLE | TIMESTAMP |
| ecommerce.transaction_id | NULLABLE | STRING |
| ecommerce.currency | NULLABLE | STRING |
| ecommerce.coupon | NULLABLE | STRING |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_duplicate_nr | NULLABLE | INTEGER |
| ecommerce.items | REPEATED | RECORD |
| ecommerce.items.item_id | NULLABLE | STRING |
| ecommerce.items.item_name | NULLABLE | STRING |
| ecommerce.items.item_brand | NULLABLE | STRING |
| ecommerce.items.item_variant | NULLABLE | STRING |
| ecommerce.items.item_category | NULLABLE | STRING |
| ecommerce.items.item_category2 | NULLABLE | STRING |
| ecommerce.items.item_category3 | NULLABLE | STRING |
| ecommerce.items.item_category4 | NULLABLE | STRING |
| ecommerce.items.item_category5 | NULLABLE | STRING |
| ecommerce.items.price_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.price_in_usd | NULLABLE | FLOAT |
| ecommerce.items.price | NULLABLE | FLOAT |
| ecommerce.items.quantity | NULLABLE | INTEGER |
| ecommerce.items.item_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_revenue | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_refund | NULLABLE | FLOAT |
| ecommerce.items.coupon | NULLABLE | STRING |
| ecommerce.items.affiliation | NULLABLE | STRING |
| ecommerce.items.item_params | REPEATED | RECORD |
| ecommerce.items.item_params.key | NULLABLE | STRING |
| ecommerce.items.item_params.value | NULLABLE | RECORD |
| ecommerce.items.item_params.value.string_value | NULLABLE | STRING |
| ecommerce.items.item_params.value.int_value | NULLABLE | INTEGER |
| ecommerce.items.item_params.value.float_value | NULLABLE | FLOAT |
| ecommerce.items.item_params.value.double_value | NULLABLE | FLOAT |
| is_true_direct | NULLABLE | BOOLEAN |
Data schema for ga4_users_deduplication
| Field Name | Mode | Type |
|---|---|---|
| node | NULLABLE | STRING |
| group_id | NULLABLE | INTEGER |
