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.

Integrations list with the Add integration button

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

Integration catalog filtered to 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).

Collect name field filled in with the example name Analytics 4 PL

Then set the attribution options on the same screen:

Collect settings with the Campaign timeout, Attribution - Time decay (days), Is User ID implemented? and Attribution - Position based fields

  • 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_deduplication table. 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.

Analytics settings step with the Authorize button next to the Select Analytics authorization field

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.

Select account drop-down open with the example account Demo Company

In Select properties, choose one or more GA4 properties.

Select properties drop-down open with three example GA4 properties

Select properties field with two example properties selected and the Next button

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.

Review step with one example property connected to BigQuery and Google Ads and one with Access denied

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.

MessageWhat it means and what to do
Access deniedWitCloud 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 disabledThe export is set up but switched off. Enable it in GA4 under Admin → BigQuery Links (Google's interface).
No BigQuery export configured in GA4The property has no BigQuery link. Set it up in GA4 under Admin → BigQuery Links (Google's interface).
Location mismatchThe export is in a different location than your WitCloud project. Both must be in the same region.
Connection failed / Detection failedThe 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.

Review step after refreshing, with both example properties connected to BigQuery and the Continue button enabled

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.

Historical Data field filled in with 365 days

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

Click Create.

Data collection settings with the Create button

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 NameModeType
dateNULLABLEDATE
journey_idNULLABLESTRING
conversion_timeNULLABLETIMESTAMP
session_path_timeNULLABLETIMESTAMP
session_idNULLABLESTRING
event_dateNULLABLESTRING
attribution_timespanNULLABLESTRING
conversion_time_microsNULLABLEINTEGER
session_path_time_microsNULLABLEINTEGER
user_pseudo_idNULLABLESTRING
event_nameNULLABLESTRING
event_valueNULLABLEFLOAT
session_path_traffic_sourceNULLABLERECORD
session_path_traffic_source.sourceNULLABLESTRING
session_path_traffic_source.mediumNULLABLESTRING
session_path_traffic_source.campaignNULLABLESTRING
session_path_traffic_source.campaign_idNULLABLESTRING
session_path_traffic_source.gclidNULLABLESTRING
session_path_days_from_conversionNULLABLEINTEGER
path_lengthNULLABLEINTEGER
path_length_daysNULLABLEINTEGER
path_step_number_reverseNULLABLEINTEGER
path_step_numberNULLABLEINTEGER
attribution_scoreNULLABLERECORD
attribution_score.first_clickNULLABLEINTEGER
attribution_score.last_clickNULLABLEINTEGER
attribution_score.linearNULLABLEFLOAT
attribution_score.position_basedNULLABLEFLOAT
attribution_score.timedecayNULLABLEFLOAT
attribution_directNULLABLESTRING
ecommerceNULLABLERECORD
ecommerce.event_timestamp_utcNULLABLETIMESTAMP
ecommerce.transaction_idNULLABLESTRING
ecommerce.currencyNULLABLESTRING
ecommerce.couponNULLABLESTRING
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_property_currencyNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_property_currencyNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_property_currencyNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_duplicate_nrNULLABLEINTEGER
ecommerce.itemsREPEATEDRECORD
ecommerce.items.item_idNULLABLESTRING
ecommerce.items.item_nameNULLABLESTRING
ecommerce.items.item_brandNULLABLESTRING
ecommerce.items.item_variantNULLABLESTRING
ecommerce.items.item_categoryNULLABLESTRING
ecommerce.items.item_category2NULLABLESTRING
ecommerce.items.item_category3NULLABLESTRING
ecommerce.items.item_category4NULLABLESTRING
ecommerce.items.item_category5NULLABLESTRING
ecommerce.items.price_in_property_currencyNULLABLEFLOAT
ecommerce.items.price_in_usdNULLABLEFLOAT
ecommerce.items.priceNULLABLEFLOAT
ecommerce.items.quantityNULLABLEINTEGER
ecommerce.items.item_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_revenue_in_usdNULLABLEFLOAT
ecommerce.items.item_revenueNULLABLEFLOAT
ecommerce.items.item_refund_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_refund_in_usdNULLABLEFLOAT
ecommerce.items.item_refundNULLABLEFLOAT
ecommerce.items.couponNULLABLESTRING
ecommerce.items.affiliationNULLABLESTRING
ecommerce.items.item_paramsREPEATEDRECORD
ecommerce.items.item_params.keyNULLABLESTRING
ecommerce.items.item_params.valueNULLABLERECORD
ecommerce.items.item_params.value.string_valueNULLABLESTRING
ecommerce.items.item_params.value.int_valueNULLABLEINTEGER
ecommerce.items.item_params.value.float_valueNULLABLEFLOAT
ecommerce.items.item_params.value.double_valueNULLABLEFLOAT
google_ads_click_infoNULLABLERECORD
google_ads_click_info.external_customer_idNULLABLESTRING
google_ads_click_info.account_descriptive_nameNULLABLESTRING
google_ads_click_info.campaign_idNULLABLESTRING
google_ads_click_info.campaign_nameNULLABLESTRING
google_ads_click_info.ad_group_idNULLABLESTRING
google_ads_click_info.ad_group_nameNULLABLESTRING
google_ads_click_info.creative_idNULLABLESTRING
google_ads_click_info.criteria_idNULLABLESTRING
google_ads_click_info.gclidNULLABLESTRING
google_ads_click_info.user_list_idNULLABLESTRING
google_ads_click_info.ad_network_type1NULLABLESTRING
google_ads_click_info.ad_network_type2NULLABLESTRING
google_ads_click_info.criteria_parametersNULLABLESTRING
google_ads_click_info.keyword_match_typeNULLABLESTRING
google_ads_click_info.pageNULLABLEINTEGER
google_ads_click_info.slotNULLABLESTRING
google_ads_click_info.deviceNULLABLESTRING
google_ads_click_info.currencyNULLABLESTRING
Data schema for ga4_attribution_ua_cross_device
Field NameModeType
dateNULLABLEDATE
journey_idNULLABLESTRING
conversion_timeNULLABLETIMESTAMP
session_path_timeNULLABLETIMESTAMP
session_idNULLABLESTRING
event_dateNULLABLESTRING
attribution_timespanNULLABLESTRING
conversion_time_microsNULLABLEINTEGER
session_path_time_microsNULLABLEINTEGER
user_pseudo_idNULLABLESTRING
event_nameNULLABLESTRING
event_valueNULLABLEFLOAT
session_path_traffic_sourceNULLABLERECORD
session_path_traffic_source.sourceNULLABLESTRING
session_path_traffic_source.mediumNULLABLESTRING
session_path_traffic_source.campaignNULLABLESTRING
session_path_traffic_source.campaign_idNULLABLESTRING
session_path_traffic_source.gclidNULLABLESTRING
session_path_days_from_conversionNULLABLEINTEGER
path_lengthNULLABLEINTEGER
path_length_daysNULLABLEINTEGER
path_step_number_reverseNULLABLEINTEGER
path_step_numberNULLABLEINTEGER
attribution_scoreNULLABLERECORD
attribution_score.first_clickNULLABLEINTEGER
attribution_score.last_clickNULLABLEINTEGER
attribution_score.linearNULLABLEFLOAT
attribution_score.position_basedNULLABLEFLOAT
attribution_score.timedecayNULLABLEFLOAT
attribution_directNULLABLESTRING
ecommerceNULLABLERECORD
ecommerce.event_timestamp_utcNULLABLETIMESTAMP
ecommerce.transaction_idNULLABLESTRING
ecommerce.currencyNULLABLESTRING
ecommerce.couponNULLABLESTRING
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_property_currencyNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_property_currencyNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_property_currencyNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_duplicate_nrNULLABLEINTEGER
ecommerce.itemsREPEATEDRECORD
ecommerce.items.item_idNULLABLESTRING
ecommerce.items.item_nameNULLABLESTRING
ecommerce.items.item_brandNULLABLESTRING
ecommerce.items.item_variantNULLABLESTRING
ecommerce.items.item_categoryNULLABLESTRING
ecommerce.items.item_category2NULLABLESTRING
ecommerce.items.item_category3NULLABLESTRING
ecommerce.items.item_category4NULLABLESTRING
ecommerce.items.item_category5NULLABLESTRING
ecommerce.items.price_in_property_currencyNULLABLEFLOAT
ecommerce.items.price_in_usdNULLABLEFLOAT
ecommerce.items.priceNULLABLEFLOAT
ecommerce.items.quantityNULLABLEINTEGER
ecommerce.items.item_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_revenue_in_usdNULLABLEFLOAT
ecommerce.items.item_revenueNULLABLEFLOAT
ecommerce.items.item_refund_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_refund_in_usdNULLABLEFLOAT
ecommerce.items.item_refundNULLABLEFLOAT
ecommerce.items.couponNULLABLESTRING
ecommerce.items.affiliationNULLABLESTRING
ecommerce.items.item_paramsREPEATEDRECORD
ecommerce.items.item_params.keyNULLABLESTRING
ecommerce.items.item_params.valueNULLABLERECORD
ecommerce.items.item_params.value.string_valueNULLABLESTRING
ecommerce.items.item_params.value.int_valueNULLABLEINTEGER
ecommerce.items.item_params.value.float_valueNULLABLEFLOAT
ecommerce.items.item_params.value.double_valueNULLABLEFLOAT
google_ads_click_infoNULLABLERECORD
google_ads_click_info.external_customer_idNULLABLESTRING
google_ads_click_info.account_descriptive_nameNULLABLESTRING
google_ads_click_info.campaign_idNULLABLESTRING
google_ads_click_info.campaign_nameNULLABLESTRING
google_ads_click_info.ad_group_idNULLABLESTRING
google_ads_click_info.ad_group_nameNULLABLESTRING
google_ads_click_info.creative_idNULLABLESTRING
google_ads_click_info.criteria_idNULLABLESTRING
google_ads_click_info.gclidNULLABLESTRING
google_ads_click_info.user_list_idNULLABLESTRING
google_ads_click_info.ad_network_type1NULLABLESTRING
google_ads_click_info.ad_network_type2NULLABLESTRING
google_ads_click_info.criteria_parametersNULLABLESTRING
google_ads_click_info.keyword_match_typeNULLABLESTRING
google_ads_click_info.pageNULLABLEINTEGER
google_ads_click_info.slotNULLABLESTRING
google_ads_click_info.deviceNULLABLESTRING
google_ads_click_info.currencyNULLABLESTRING
Data schema for ga4_attribution_ua_device
Field NameModeType
dateNULLABLEDATE
journey_idNULLABLESTRING
conversion_timeNULLABLETIMESTAMP
session_path_timeNULLABLETIMESTAMP
session_idNULLABLESTRING
event_dateNULLABLESTRING
attribution_timespanNULLABLESTRING
conversion_time_microsNULLABLEINTEGER
session_path_time_microsNULLABLEINTEGER
user_pseudo_idNULLABLESTRING
event_nameNULLABLESTRING
event_valueNULLABLEFLOAT
session_path_traffic_sourceNULLABLERECORD
session_path_traffic_source.sourceNULLABLESTRING
session_path_traffic_source.mediumNULLABLESTRING
session_path_traffic_source.campaignNULLABLESTRING
session_path_traffic_source.campaign_idNULLABLESTRING
session_path_traffic_source.gclidNULLABLESTRING
session_path_days_from_conversionNULLABLEINTEGER
path_lengthNULLABLEINTEGER
path_length_daysNULLABLEINTEGER
path_step_number_reverseNULLABLEINTEGER
path_step_numberNULLABLEINTEGER
attribution_scoreNULLABLERECORD
attribution_score.first_clickNULLABLEINTEGER
attribution_score.last_clickNULLABLEINTEGER
attribution_score.linearNULLABLEFLOAT
attribution_score.position_basedNULLABLEFLOAT
attribution_score.timedecayNULLABLEFLOAT
attribution_directNULLABLESTRING
ecommerceNULLABLERECORD
ecommerce.event_timestamp_utcNULLABLETIMESTAMP
ecommerce.transaction_idNULLABLESTRING
ecommerce.currencyNULLABLESTRING
ecommerce.couponNULLABLESTRING
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_property_currencyNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_property_currencyNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_property_currencyNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_duplicate_nrNULLABLEINTEGER
ecommerce.itemsREPEATEDRECORD
ecommerce.items.item_idNULLABLESTRING
ecommerce.items.item_nameNULLABLESTRING
ecommerce.items.item_brandNULLABLESTRING
ecommerce.items.item_variantNULLABLESTRING
ecommerce.items.item_categoryNULLABLESTRING
ecommerce.items.item_category2NULLABLESTRING
ecommerce.items.item_category3NULLABLESTRING
ecommerce.items.item_category4NULLABLESTRING
ecommerce.items.item_category5NULLABLESTRING
ecommerce.items.price_in_property_currencyNULLABLEFLOAT
ecommerce.items.price_in_usdNULLABLEFLOAT
ecommerce.items.priceNULLABLEFLOAT
ecommerce.items.quantityNULLABLEINTEGER
ecommerce.items.item_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_revenue_in_usdNULLABLEFLOAT
ecommerce.items.item_revenueNULLABLEFLOAT
ecommerce.items.item_refund_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_refund_in_usdNULLABLEFLOAT
ecommerce.items.item_refundNULLABLEFLOAT
ecommerce.items.couponNULLABLESTRING
ecommerce.items.affiliationNULLABLESTRING
ecommerce.items.item_paramsREPEATEDRECORD
ecommerce.items.item_params.keyNULLABLESTRING
ecommerce.items.item_params.valueNULLABLERECORD
ecommerce.items.item_params.value.string_valueNULLABLESTRING
ecommerce.items.item_params.value.int_valueNULLABLEINTEGER
ecommerce.items.item_params.value.float_valueNULLABLEFLOAT
ecommerce.items.item_params.value.double_valueNULLABLEFLOAT
google_ads_click_infoNULLABLERECORD
google_ads_click_info.external_customer_idNULLABLESTRING
google_ads_click_info.account_descriptive_nameNULLABLESTRING
google_ads_click_info.campaign_idNULLABLESTRING
google_ads_click_info.campaign_nameNULLABLESTRING
google_ads_click_info.ad_group_idNULLABLESTRING
google_ads_click_info.ad_group_nameNULLABLESTRING
google_ads_click_info.creative_idNULLABLESTRING
google_ads_click_info.criteria_idNULLABLESTRING
google_ads_click_info.gclidNULLABLESTRING
google_ads_click_info.user_list_idNULLABLESTRING
google_ads_click_info.ad_network_type1NULLABLESTRING
google_ads_click_info.ad_network_type2NULLABLESTRING
google_ads_click_info.criteria_parametersNULLABLESTRING
google_ads_click_info.keyword_match_typeNULLABLESTRING
google_ads_click_info.pageNULLABLEINTEGER
google_ads_click_info.slotNULLABLESTRING
google_ads_click_info.deviceNULLABLESTRING
google_ads_click_info.currencyNULLABLESTRING
Data schema for ga4_conversion_events
Field NameModeType
countingMethodNULLABLESTRING
deletableNULLABLEBOOLEAN
nameNULLABLESTRING
customNULLABLEBOOLEAN
eventNameNULLABLESTRING
streamIdNULLABLEINTEGER
createTimeNULLABLETIMESTAMP
propertyIdNULLABLEINTEGER
Data schema for ga4_events
Field NameModeType
event_dateNULLABLESTRING
user_pseudo_idNULLABLESTRING
user_idNULLABLESTRING
group_idNULLABLESTRING
event_nameNULLABLESTRING
event_timestampNULLABLEINTEGER
event_paramsREPEATEDRECORD
event_params.keyNULLABLESTRING
event_params.valueNULLABLERECORD
event_params.value.string_valueNULLABLESTRING
event_params.value.int_valueNULLABLEINTEGER
event_params.value.float_valueNULLABLEFLOAT
event_params.value.double_valueNULLABLEFLOAT
app_infoNULLABLERECORD
app_info.idNULLABLESTRING
app_info.versionNULLABLESTRING
app_info.install_storeNULLABLESTRING
app_info.firebase_app_idNULLABLESTRING
app_info.install_sourceNULLABLESTRING
deviceNULLABLERECORD
device.categoryNULLABLESTRING
device.mobile_brand_nameNULLABLESTRING
device.mobile_model_nameNULLABLESTRING
device.mobile_marketing_nameNULLABLESTRING
device.mobile_os_hardware_modelNULLABLESTRING
device.operating_systemNULLABLESTRING
device.operating_system_versionNULLABLESTRING
device.vendor_idNULLABLESTRING
device.advertising_idNULLABLESTRING
device.languageNULLABLESTRING
device.is_limited_ad_trackingNULLABLESTRING
device.time_zone_offset_secondsNULLABLEINTEGER
device.browserNULLABLESTRING
device.browser_versionNULLABLESTRING
device.web_infoNULLABLERECORD
device.web_info.browserNULLABLESTRING
device.web_info.browser_versionNULLABLESTRING
device.web_info.hostnameNULLABLESTRING
ecommerceNULLABLERECORD
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_idNULLABLESTRING
itemsREPEATEDRECORD
items.item_idNULLABLESTRING
items.item_nameNULLABLESTRING
items.item_brandNULLABLESTRING
items.item_variantNULLABLESTRING
items.item_categoryNULLABLESTRING
items.item_category2NULLABLESTRING
items.item_category3NULLABLESTRING
items.item_category4NULLABLESTRING
items.item_category5NULLABLESTRING
items.price_in_usdNULLABLEFLOAT
items.priceNULLABLEFLOAT
items.quantityNULLABLEINTEGER
items.item_revenue_in_usdNULLABLEFLOAT
items.item_revenueNULLABLEFLOAT
items.item_refund_in_usdNULLABLEFLOAT
items.item_refundNULLABLEFLOAT
items.couponNULLABLESTRING
items.affiliationNULLABLESTRING
items.location_idNULLABLESTRING
items.item_list_idNULLABLESTRING
items.item_list_nameNULLABLESTRING
items.item_list_indexNULLABLESTRING
items.promotion_idNULLABLESTRING
items.promotion_nameNULLABLESTRING
items.creative_nameNULLABLESTRING
items.creative_slotNULLABLESTRING
items.item_paramsREPEATEDRECORD
items.item_params.keyNULLABLESTRING
items.item_params.valueNULLABLERECORD
items.item_params.value.string_valueNULLABLESTRING
items.item_params.value.int_valueNULLABLEINTEGER
items.item_params.value.float_valueNULLABLEFLOAT
items.item_params.value.double_valueNULLABLEFLOAT
event_bundle_sequence_idNULLABLEINTEGER
event_dimensionsNULLABLERECORD
event_dimensions.hostnameNULLABLESTRING
event_previous_timestampNULLABLEINTEGER
event_server_timestamp_offsetNULLABLEINTEGER
event_value_in_usdNULLABLEFLOAT
geoNULLABLERECORD
geo.continentNULLABLESTRING
geo.countryNULLABLESTRING
geo.regionNULLABLESTRING
geo.cityNULLABLESTRING
geo.sub_continentNULLABLESTRING
geo.metroNULLABLESTRING
platformNULLABLESTRING
privacy_infoNULLABLERECORD
privacy_info.analytics_storageNULLABLESTRING
privacy_info.ads_storageNULLABLESTRING
privacy_info.uses_transient_tokenNULLABLESTRING
stream_idNULLABLESTRING
traffic_sourceNULLABLERECORD
traffic_source.nameNULLABLESTRING
traffic_source.mediumNULLABLESTRING
traffic_source.sourceNULLABLESTRING
user_first_touch_timestampNULLABLEINTEGER
user_ltvNULLABLERECORD
user_ltv.revenueNULLABLEFLOAT
user_ltv.currencyNULLABLESTRING
user_propertiesREPEATEDRECORD
user_properties.keyNULLABLESTRING
user_properties.valueNULLABLERECORD
user_properties.value.string_valueNULLABLESTRING
user_properties.value.int_valueNULLABLEINTEGER
user_properties.value.float_valueNULLABLEFLOAT
user_properties.value.double_valueNULLABLEFLOAT
user_properties.value.set_timestamp_microsNULLABLEINTEGER
wit_session_ga4NULLABLERECORD
wit_session_ga4.session_idNULLABLESTRING
wit_session_ga4.session_id_groupNULLABLESTRING
wit_session_ga4.traffic_sourceNULLABLERECORD
wit_session_ga4.traffic_source.sourceNULLABLESTRING
wit_session_ga4.traffic_source.mediumNULLABLESTRING
wit_session_ga4.traffic_source.campaignNULLABLESTRING
wit_session_ga4.traffic_source.termNULLABLESTRING
wit_session_ga4.traffic_source.contentNULLABLESTRING
wit_session_ga4.traffic_source.campaign_idNULLABLESTRING
wit_session_ga4.traffic_source.gclidNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_infoNULLABLERECORD
wit_session_ga4.traffic_source.google_ads_click_info.external_customer_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.account_descriptive_nameNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.campaign_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.campaign_nameNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_group_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_group_nameNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.creative_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.criteria_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.gclidNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.user_list_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type1NULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type2NULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.criteria_parametersNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.keyword_match_typeNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.pageNULLABLEINTEGER
wit_session_ga4.traffic_source.google_ads_click_info.slotNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.deviceNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.currencyNULLABLESTRING
wit_session_ga4.attribution_detailsNULLABLESTRING
wit_session_ua_cross_deviceNULLABLERECORD
wit_session_ua_cross_device.session_idNULLABLESTRING
wit_session_ua_cross_device.session_id_groupNULLABLESTRING
wit_session_ua_cross_device.traffic_sourceNULLABLERECORD
wit_session_ua_cross_device.traffic_source.sourceNULLABLESTRING
wit_session_ua_cross_device.traffic_source.mediumNULLABLESTRING
wit_session_ua_cross_device.traffic_source.campaignNULLABLESTRING
wit_session_ua_cross_device.traffic_source.termNULLABLESTRING
wit_session_ua_cross_device.traffic_source.contentNULLABLESTRING
wit_session_ua_cross_device.traffic_source.campaign_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.gclidNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_infoNULLABLERECORD
wit_session_ua_cross_device.traffic_source.google_ads_click_info.external_customer_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.account_descriptive_nameNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_nameNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_nameNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.creative_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.gclidNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.user_list_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type1NULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type2NULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_parametersNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.keyword_match_typeNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.pageNULLABLEINTEGER
wit_session_ua_cross_device.traffic_source.google_ads_click_info.slotNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.deviceNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.currencyNULLABLESTRING
wit_session_ua_cross_device.attribution_detailsNULLABLESTRING
wit_session_ua_deviceNULLABLERECORD
wit_session_ua_device.session_idNULLABLESTRING
wit_session_ua_device.session_id_groupNULLABLESTRING
wit_session_ua_device.traffic_sourceNULLABLERECORD
wit_session_ua_device.traffic_source.sourceNULLABLESTRING
wit_session_ua_device.traffic_source.mediumNULLABLESTRING
wit_session_ua_device.traffic_source.campaignNULLABLESTRING
wit_session_ua_device.traffic_source.termNULLABLESTRING
wit_session_ua_device.traffic_source.contentNULLABLESTRING
wit_session_ua_device.traffic_source.campaign_idNULLABLESTRING
wit_session_ua_device.traffic_source.gclidNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_infoNULLABLERECORD
wit_session_ua_device.traffic_source.google_ads_click_info.external_customer_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.account_descriptive_nameNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.campaign_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.campaign_nameNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_nameNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.creative_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.criteria_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.gclidNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.user_list_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type1NULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type2NULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.criteria_parametersNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.keyword_match_typeNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.pageNULLABLEINTEGER
wit_session_ua_device.traffic_source.google_ads_click_info.slotNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.deviceNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.currencyNULLABLESTRING
wit_session_ua_device.attribution_detailsNULLABLESTRING
attribution_timespanNULLABLESTRING
is_active_userNULLABLEBOOLEAN
Data schema for ga4_sessions
Field NameModeType
dateNULLABLEDATE
session_idNULLABLESTRING
user_pseudo_idNULLABLESTRING
session_start_timeNULLABLEINTEGER
landing_pageNULLABLESTRING
totalsNULLABLERECORD
totals.eventNULLABLEINTEGER
totals.page_viewNULLABLEINTEGER
totals.unique_page_viewNULLABLEINTEGER
totals.screen_viewNULLABLEINTEGER
totals.unique_screen_viewNULLABLEINTEGER
totals.engagementNULLABLEINTEGER
totals.engagement_time_secondsNULLABLEFLOAT
totals.visit_durationNULLABLEINTEGER
totals.first_visitNULLABLEINTEGER
totals.view_itemNULLABLEINTEGER
totals.add_to_cartNULLABLEINTEGER
totals.begin_checkoutNULLABLEINTEGER
totals.add_shipping_infoNULLABLEINTEGER
totals.add_payment_infoNULLABLEINTEGER
totals.purchaseNULLABLEINTEGER
totals.purchase_revenue_in_property_currencyNULLABLEFLOAT
totals.shipping_value_in_property_currencyNULLABLEFLOAT
totals.tax_value_in_property_currencyNULLABLEFLOAT
totals.refund_value_in_property_currencyNULLABLEFLOAT
totals.event_countNULLABLESTRING
totals.event_valueNULLABLESTRING
stream_idNULLABLESTRING
platformNULLABLESTRING
acq_traffic_sourceNULLABLERECORD
acq_traffic_source.nameNULLABLESTRING
acq_traffic_source.mediumNULLABLESTRING
acq_traffic_source.sourceNULLABLESTRING
wit_session_ga4NULLABLERECORD
wit_session_ga4.session_idNULLABLESTRING
wit_session_ga4.session_id_groupNULLABLESTRING
wit_session_ga4.traffic_sourceNULLABLERECORD
wit_session_ga4.traffic_source.sourceNULLABLESTRING
wit_session_ga4.traffic_source.mediumNULLABLESTRING
wit_session_ga4.traffic_source.campaignNULLABLESTRING
wit_session_ga4.traffic_source.termNULLABLESTRING
wit_session_ga4.traffic_source.contentNULLABLESTRING
wit_session_ga4.traffic_source.campaign_idNULLABLESTRING
wit_session_ga4.traffic_source.gclidNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_infoNULLABLERECORD
wit_session_ga4.traffic_source.google_ads_click_info.external_customer_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.account_descriptive_nameNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.campaign_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.campaign_nameNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_group_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_group_nameNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.creative_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.criteria_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.gclidNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.user_list_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type1NULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type2NULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.criteria_parametersNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.keyword_match_typeNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.pageNULLABLEINTEGER
wit_session_ga4.traffic_source.google_ads_click_info.slotNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.deviceNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.currencyNULLABLESTRING
wit_session_ga4.attribution_detailsNULLABLESTRING
deviceNULLABLERECORD
device.categoryNULLABLESTRING
device.mobile_brand_nameNULLABLESTRING
device.mobile_model_nameNULLABLESTRING
device.mobile_marketing_nameNULLABLESTRING
device.mobile_os_hardware_modelNULLABLESTRING
device.operating_systemNULLABLESTRING
device.operating_system_versionNULLABLESTRING
device.vendor_idNULLABLESTRING
device.advertising_idNULLABLESTRING
device.languageNULLABLESTRING
device.is_limited_ad_trackingNULLABLESTRING
device.time_zone_offset_secondsNULLABLEINTEGER
device.browserNULLABLESTRING
device.browser_versionNULLABLESTRING
device.web_infoNULLABLERECORD
device.web_info.browserNULLABLESTRING
device.web_info.browser_versionNULLABLESTRING
device.web_info.hostnameNULLABLESTRING
geoNULLABLERECORD
geo.continentNULLABLESTRING
geo.countryNULLABLESTRING
geo.regionNULLABLESTRING
geo.cityNULLABLESTRING
geo.sub_continentNULLABLESTRING
geo.metroNULLABLESTRING
app_infoNULLABLERECORD
app_info.idNULLABLESTRING
app_info.versionNULLABLESTRING
app_info.install_storeNULLABLESTRING
app_info.firebase_app_idNULLABLESTRING
app_info.install_sourceNULLABLESTRING
ecommerceREPEATEDRECORD
ecommerce.event_timestamp_utcNULLABLETIMESTAMP
ecommerce.transaction_idNULLABLESTRING
ecommerce.currencyNULLABLESTRING
ecommerce.couponNULLABLESTRING
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_property_currencyNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_property_currencyNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_property_currencyNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_duplicate_nrNULLABLEINTEGER
ecommerce.itemsREPEATEDRECORD
ecommerce.items.item_idNULLABLESTRING
ecommerce.items.item_nameNULLABLESTRING
ecommerce.items.item_brandNULLABLESTRING
ecommerce.items.item_variantNULLABLESTRING
ecommerce.items.item_categoryNULLABLESTRING
ecommerce.items.item_category2NULLABLESTRING
ecommerce.items.item_category3NULLABLESTRING
ecommerce.items.item_category4NULLABLESTRING
ecommerce.items.item_category5NULLABLESTRING
ecommerce.items.price_in_property_currencyNULLABLEFLOAT
ecommerce.items.price_in_usdNULLABLEFLOAT
ecommerce.items.priceNULLABLEFLOAT
ecommerce.items.quantityNULLABLEINTEGER
ecommerce.items.item_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_revenue_in_usdNULLABLEFLOAT
ecommerce.items.item_revenueNULLABLEFLOAT
ecommerce.items.item_refund_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_refund_in_usdNULLABLEFLOAT
ecommerce.items.item_refundNULLABLEFLOAT
ecommerce.items.couponNULLABLESTRING
ecommerce.items.affiliationNULLABLESTRING
ecommerce.items.item_paramsREPEATEDRECORD
ecommerce.items.item_params.keyNULLABLESTRING
ecommerce.items.item_params.valueNULLABLERECORD
ecommerce.items.item_params.value.string_valueNULLABLESTRING
ecommerce.items.item_params.value.int_valueNULLABLEINTEGER
ecommerce.items.item_params.value.float_valueNULLABLEFLOAT
ecommerce.items.item_params.value.double_valueNULLABLEFLOAT
is_true_directNULLABLEBOOLEAN
Data schema for ga4_sessions_ua_cross_device
Field NameModeType
dateNULLABLEDATE
session_idNULLABLESTRING
user_pseudo_idNULLABLESTRING
session_start_timeNULLABLEINTEGER
landing_pageNULLABLESTRING
totalsNULLABLERECORD
totals.eventNULLABLEINTEGER
totals.page_viewNULLABLEINTEGER
totals.unique_page_viewNULLABLEINTEGER
totals.screen_viewNULLABLEINTEGER
totals.unique_screen_viewNULLABLEINTEGER
totals.engagementNULLABLEINTEGER
totals.engagement_time_secondsNULLABLEFLOAT
totals.visit_durationNULLABLEINTEGER
totals.first_visitNULLABLEINTEGER
totals.view_itemNULLABLEINTEGER
totals.add_to_cartNULLABLEINTEGER
totals.begin_checkoutNULLABLEINTEGER
totals.add_shipping_infoNULLABLEINTEGER
totals.add_payment_infoNULLABLEINTEGER
totals.purchaseNULLABLEINTEGER
totals.purchase_revenue_in_property_currencyNULLABLEFLOAT
totals.shipping_value_in_property_currencyNULLABLEFLOAT
totals.tax_value_in_property_currencyNULLABLEFLOAT
totals.refund_value_in_property_currencyNULLABLEFLOAT
totals.event_countNULLABLESTRING
totals.event_valueNULLABLESTRING
stream_idNULLABLESTRING
platformNULLABLESTRING
acq_traffic_sourceNULLABLERECORD
acq_traffic_source.nameNULLABLESTRING
acq_traffic_source.mediumNULLABLESTRING
acq_traffic_source.sourceNULLABLESTRING
wit_session_ua_cross_deviceNULLABLERECORD
wit_session_ua_cross_device.session_idNULLABLESTRING
wit_session_ua_cross_device.session_id_groupNULLABLESTRING
wit_session_ua_cross_device.traffic_sourceNULLABLERECORD
wit_session_ua_cross_device.traffic_source.sourceNULLABLESTRING
wit_session_ua_cross_device.traffic_source.mediumNULLABLESTRING
wit_session_ua_cross_device.traffic_source.campaignNULLABLESTRING
wit_session_ua_cross_device.traffic_source.termNULLABLESTRING
wit_session_ua_cross_device.traffic_source.contentNULLABLESTRING
wit_session_ua_cross_device.traffic_source.campaign_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.gclidNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_infoNULLABLERECORD
wit_session_ua_cross_device.traffic_source.google_ads_click_info.external_customer_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.account_descriptive_nameNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_nameNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_nameNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.creative_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.gclidNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.user_list_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type1NULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type2NULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_parametersNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.keyword_match_typeNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.pageNULLABLEINTEGER
wit_session_ua_cross_device.traffic_source.google_ads_click_info.slotNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.deviceNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.currencyNULLABLESTRING
wit_session_ua_cross_device.attribution_detailsNULLABLESTRING
deviceNULLABLERECORD
device.categoryNULLABLESTRING
device.mobile_brand_nameNULLABLESTRING
device.mobile_model_nameNULLABLESTRING
device.mobile_marketing_nameNULLABLESTRING
device.mobile_os_hardware_modelNULLABLESTRING
device.operating_systemNULLABLESTRING
device.operating_system_versionNULLABLESTRING
device.vendor_idNULLABLESTRING
device.advertising_idNULLABLESTRING
device.languageNULLABLESTRING
device.is_limited_ad_trackingNULLABLESTRING
device.time_zone_offset_secondsNULLABLEINTEGER
device.browserNULLABLESTRING
device.browser_versionNULLABLESTRING
device.web_infoNULLABLERECORD
device.web_info.browserNULLABLESTRING
device.web_info.browser_versionNULLABLESTRING
device.web_info.hostnameNULLABLESTRING
geoNULLABLERECORD
geo.continentNULLABLESTRING
geo.countryNULLABLESTRING
geo.regionNULLABLESTRING
geo.cityNULLABLESTRING
geo.sub_continentNULLABLESTRING
geo.metroNULLABLESTRING
app_infoNULLABLERECORD
app_info.idNULLABLESTRING
app_info.versionNULLABLESTRING
app_info.install_storeNULLABLESTRING
app_info.firebase_app_idNULLABLESTRING
app_info.install_sourceNULLABLESTRING
ecommerceREPEATEDRECORD
ecommerce.event_timestamp_utcNULLABLETIMESTAMP
ecommerce.transaction_idNULLABLESTRING
ecommerce.currencyNULLABLESTRING
ecommerce.couponNULLABLESTRING
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_property_currencyNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_property_currencyNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_property_currencyNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_duplicate_nrNULLABLEINTEGER
ecommerce.itemsREPEATEDRECORD
ecommerce.items.item_idNULLABLESTRING
ecommerce.items.item_nameNULLABLESTRING
ecommerce.items.item_brandNULLABLESTRING
ecommerce.items.item_variantNULLABLESTRING
ecommerce.items.item_categoryNULLABLESTRING
ecommerce.items.item_category2NULLABLESTRING
ecommerce.items.item_category3NULLABLESTRING
ecommerce.items.item_category4NULLABLESTRING
ecommerce.items.item_category5NULLABLESTRING
ecommerce.items.price_in_property_currencyNULLABLEFLOAT
ecommerce.items.price_in_usdNULLABLEFLOAT
ecommerce.items.priceNULLABLEFLOAT
ecommerce.items.quantityNULLABLEINTEGER
ecommerce.items.item_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_revenue_in_usdNULLABLEFLOAT
ecommerce.items.item_revenueNULLABLEFLOAT
ecommerce.items.item_refund_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_refund_in_usdNULLABLEFLOAT
ecommerce.items.item_refundNULLABLEFLOAT
ecommerce.items.couponNULLABLESTRING
ecommerce.items.affiliationNULLABLESTRING
ecommerce.items.item_paramsREPEATEDRECORD
ecommerce.items.item_params.keyNULLABLESTRING
ecommerce.items.item_params.valueNULLABLERECORD
ecommerce.items.item_params.value.string_valueNULLABLESTRING
ecommerce.items.item_params.value.int_valueNULLABLEINTEGER
ecommerce.items.item_params.value.float_valueNULLABLEFLOAT
ecommerce.items.item_params.value.double_valueNULLABLEFLOAT
is_true_directNULLABLEBOOLEAN
Data schema for ga4_sessions_ua_device
Field NameModeType
dateNULLABLEDATE
session_idNULLABLESTRING
user_pseudo_idNULLABLESTRING
session_start_timeNULLABLEINTEGER
landing_pageNULLABLESTRING
totalsNULLABLERECORD
totals.eventNULLABLEINTEGER
totals.page_viewNULLABLEINTEGER
totals.unique_page_viewNULLABLEINTEGER
totals.screen_viewNULLABLEINTEGER
totals.unique_screen_viewNULLABLEINTEGER
totals.engagementNULLABLEINTEGER
totals.engagement_time_secondsNULLABLEFLOAT
totals.visit_durationNULLABLEINTEGER
totals.first_visitNULLABLEINTEGER
totals.view_itemNULLABLEINTEGER
totals.add_to_cartNULLABLEINTEGER
totals.begin_checkoutNULLABLEINTEGER
totals.add_shipping_infoNULLABLEINTEGER
totals.add_payment_infoNULLABLEINTEGER
totals.purchaseNULLABLEINTEGER
totals.purchase_revenue_in_property_currencyNULLABLEFLOAT
totals.shipping_value_in_property_currencyNULLABLEFLOAT
totals.tax_value_in_property_currencyNULLABLEFLOAT
totals.refund_value_in_property_currencyNULLABLEFLOAT
totals.event_countNULLABLESTRING
totals.event_valueNULLABLESTRING
stream_idNULLABLESTRING
platformNULLABLESTRING
acq_traffic_sourceNULLABLERECORD
acq_traffic_source.nameNULLABLESTRING
acq_traffic_source.mediumNULLABLESTRING
acq_traffic_source.sourceNULLABLESTRING
wit_session_ua_deviceNULLABLERECORD
wit_session_ua_device.session_idNULLABLESTRING
wit_session_ua_device.session_id_groupNULLABLESTRING
wit_session_ua_device.traffic_sourceNULLABLERECORD
wit_session_ua_device.traffic_source.sourceNULLABLESTRING
wit_session_ua_device.traffic_source.mediumNULLABLESTRING
wit_session_ua_device.traffic_source.campaignNULLABLESTRING
wit_session_ua_device.traffic_source.termNULLABLESTRING
wit_session_ua_device.traffic_source.contentNULLABLESTRING
wit_session_ua_device.traffic_source.campaign_idNULLABLESTRING
wit_session_ua_device.traffic_source.gclidNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_infoNULLABLERECORD
wit_session_ua_device.traffic_source.google_ads_click_info.external_customer_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.account_descriptive_nameNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.campaign_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.campaign_nameNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_nameNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.creative_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.criteria_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.gclidNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.user_list_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type1NULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type2NULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.criteria_parametersNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.keyword_match_typeNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.pageNULLABLEINTEGER
wit_session_ua_device.traffic_source.google_ads_click_info.slotNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.deviceNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.currencyNULLABLESTRING
wit_session_ua_device.attribution_detailsNULLABLESTRING
deviceNULLABLERECORD
device.categoryNULLABLESTRING
device.mobile_brand_nameNULLABLESTRING
device.mobile_model_nameNULLABLESTRING
device.mobile_marketing_nameNULLABLESTRING
device.mobile_os_hardware_modelNULLABLESTRING
device.operating_systemNULLABLESTRING
device.operating_system_versionNULLABLESTRING
device.vendor_idNULLABLESTRING
device.advertising_idNULLABLESTRING
device.languageNULLABLESTRING
device.is_limited_ad_trackingNULLABLESTRING
device.time_zone_offset_secondsNULLABLEINTEGER
device.browserNULLABLESTRING
device.browser_versionNULLABLESTRING
device.web_infoNULLABLERECORD
device.web_info.browserNULLABLESTRING
device.web_info.browser_versionNULLABLESTRING
device.web_info.hostnameNULLABLESTRING
geoNULLABLERECORD
geo.continentNULLABLESTRING
geo.countryNULLABLESTRING
geo.regionNULLABLESTRING
geo.cityNULLABLESTRING
geo.sub_continentNULLABLESTRING
geo.metroNULLABLESTRING
app_infoNULLABLERECORD
app_info.idNULLABLESTRING
app_info.versionNULLABLESTRING
app_info.install_storeNULLABLESTRING
app_info.firebase_app_idNULLABLESTRING
app_info.install_sourceNULLABLESTRING
ecommerceREPEATEDRECORD
ecommerce.event_timestamp_utcNULLABLETIMESTAMP
ecommerce.transaction_idNULLABLESTRING
ecommerce.currencyNULLABLESTRING
ecommerce.couponNULLABLESTRING
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_property_currencyNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_property_currencyNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_property_currencyNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_duplicate_nrNULLABLEINTEGER
ecommerce.itemsREPEATEDRECORD
ecommerce.items.item_idNULLABLESTRING
ecommerce.items.item_nameNULLABLESTRING
ecommerce.items.item_brandNULLABLESTRING
ecommerce.items.item_variantNULLABLESTRING
ecommerce.items.item_categoryNULLABLESTRING
ecommerce.items.item_category2NULLABLESTRING
ecommerce.items.item_category3NULLABLESTRING
ecommerce.items.item_category4NULLABLESTRING
ecommerce.items.item_category5NULLABLESTRING
ecommerce.items.price_in_property_currencyNULLABLEFLOAT
ecommerce.items.price_in_usdNULLABLEFLOAT
ecommerce.items.priceNULLABLEFLOAT
ecommerce.items.quantityNULLABLEINTEGER
ecommerce.items.item_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_revenue_in_usdNULLABLEFLOAT
ecommerce.items.item_revenueNULLABLEFLOAT
ecommerce.items.item_refund_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_refund_in_usdNULLABLEFLOAT
ecommerce.items.item_refundNULLABLEFLOAT
ecommerce.items.couponNULLABLESTRING
ecommerce.items.affiliationNULLABLESTRING
ecommerce.items.item_paramsREPEATEDRECORD
ecommerce.items.item_params.keyNULLABLESTRING
ecommerce.items.item_params.valueNULLABLERECORD
ecommerce.items.item_params.value.string_valueNULLABLESTRING
ecommerce.items.item_params.value.int_valueNULLABLEINTEGER
ecommerce.items.item_params.value.float_valueNULLABLEFLOAT
ecommerce.items.item_params.value.double_valueNULLABLEFLOAT
is_true_directNULLABLEBOOLEAN
Data schema for ga4_users_deduplication
Field NameModeType
nodeNULLABLESTRING
group_idNULLABLEINTEGER