Dataset and events tables in BigQuery
When GA4 is linked to BigQuery a dataset is created which will be populated with events tables, one table for each day, containing the raw GA4 data. Depending on the selected export type between GA4 and BigQuery there will be 'events_date' and/or 'events_intraday_date' tables from when the linking was setup. A table can for example be named like this: 'events_20250101'. When connecting a 'GA4 via BigQuery' data source in Funnel you connect towards a whole dataset like this and data will be fetched from its belonging tables automatically.
In first hand Funnel fetches data from the events_date tables since these tables are more stable then the events_intraday_date tables. Because of this Funnel will never fetch any data for today since events tables are ready from Google first on the following day. If your historically don't have events_date tables, Funnel will look for events_intraday_date tables. As a standard 90 days of historical data will be fetched, if more is needed reach out to Funnel support.
Collected events
Since this connector in first hand is used for MTA analysis, only a subset of the data is fetched. In this case only the following events are collected:
first_visit
session_start
purchase
add_to_cart
page_view
select_item
view_item_list
view_item
This can however be changed by selecting your own subset of events during connect.
Dimensions and metrics
The following fields will be available in Funnel:
[Dimension] Campaign - from event params 'campaign'. Some cleaning might be done and '(direct)', '(not set)' and '(none)' values are removed.
[Dimension] Content - from event params 'content'.
[Dimension] Cookie ID - from 'user_pseudo_id' column, in lower case.
[Dimension] Country -populated from 'Country (custom param)' or 'Country (default dim)' see below.
[Dimension] Country (custom param) - from event params of custom dimension if specified during connect.
[Dimension] Country (default dim) - from 'geo.country' column.
[Dimension] Currency - ISO currency code parsed from event params 'currency'
[Dimension] Custom user ID from event parameters - from custom dimension with the event scope if specified during connect.
[Dimension] Custom user ID from user properties - from custom dimension with the user scope if specified during connect.
[Dimension] Default channel - event's default channel, based primarily on source and medium but other fields as well. Funnel derived. Possible values: Affiliate, Direct, Display, Email, Other Advertising, Referral, Organic Search, Paid Search, Social, Unknown
[Dimension] Event Parameters - String representation of the whole raw 'event_params' column.
[Dimension] Event currency - from event params 'currency'.
[Dimension] Event name - from 'event_name' column.
[Dimension] Event timestamp - from event_timestamp' column. Formatted in ISO 8601 format with microsecond precision.
[Dimension] Event timestamp org - from 'event_timestamp' column.
[Dimension] Event traffic source - from 'traffic_source' column.
[Dimension] File date - date of the BigQuery table from which the data was queried.
[Dimension] GA session ID - from event params 'ga_session_id'.
[Dimension] GCL ID - from event params 'gclid'.
[Dimension] Google Ads consent - from privacy_info.ads_storage column parsed as TRUE or FALSE.
[Dimension] Location - from event params 'page_location'.
[Dimension] Medium - from event params 'medium'. Some cleaning might be done and '(direct)', '(not set)' and '(none)' values are removed.
[Dimension] Page title - from event params 'page_title', in lower case.
[Dimension] Platform user ID - populated from 'Custom user ID' or 'User ID'.
[Dimension] Referrer - from event params 'page_referrer'.
[Dimension] Referrer domain - hostname part from event params 'page_referrer'.
[Dimension] Source - form event params 'source' Some cleaning might be done and '(direct)', '(not set)' and '(none)' values are removed.
[Dimension] Term - form event params 'term'.
[Dimension] Transaction ID - from event params 'transaction_id'.
[Dimension] User ID - from 'user_id' column.
[Metric] Basket value - from event params 'value'.
[Metric] GA session number - from event params 'ga_session_number'.
[Metric] Micro second time - from event params 'engagement_time_msec'.
Note: every row that misses a 'user_pseudo_id' or 'event_timestamp' are filtered out.