How to get these dimensions and metrics in your workspace? | What do you need? |
| An Advanced Measurement plan. If you do not see the Advanced Measurement report, contact us to enable it. |
This article lists the fields available when you connect GA4 via BigQuery with the Advanced Measurement report. For the Standard report, see GA4 via BigQuery: Standard dimensions and metrics.
Advanced Measurement
The Advanced Measurement report imports event-level GA4 data from your BigQuery export for measurement and multi-touch attribution use cases. You can use the Measurement default events or choose a subset of events when you connect.
Dimensions
Campaign: From the
campaignevent parameter. Funnel may clean values such as(direct),(not set), and(none).Content: From the
contentevent parameter.Cookie ID: From the
user_pseudo_idcolumn, in lowercase. In the GA4 BigQuery export this isuser_pseudo_id.Country: Populated from Country (custom param) or Country (default dim), depending on your connect settings.
Country (custom param): From a custom event parameter if you specify one when you connect.
Country (default dim): From the
geo.countrycolumn.Currency: ISO currency code parsed from the
currencyevent parameter.Custom user ID from event parameters: From a custom dimension with event scope if you specify one when you connect.
Custom user ID from user properties: From a custom dimension with user scope if you specify one when you connect.
Default channel: Funnel-derived channel based primarily on source and medium. Possible values: Affiliate, Direct, Display, Email, Other Advertising, Referral, Organic Search, Paid Search, Social, Unknown.
Event Parameters: String representation of the whole raw
event_paramscolumn. Available when you choose to include the raw event_params field during connect.Event currency: From the
currencyevent parameter.Event name: From the
event_namecolumn.Event timestamp: From the
event_timestampcolumn, formatted in ISO 8601 with microsecond precision.Event timestamp org: From the
event_timestampcolumn in its original form.Event traffic source: From the
traffic_sourcecolumn.File date: Date of the BigQuery table from which Funnel queried the data.
GA session ID: From the
ga_session_idevent parameter.GCL ID: From the
gclidevent parameter.Google Ads consent: From
privacy_info.ads_storage, parsed as TRUE or FALSE.Location: From the
page_locationevent parameter.Medium: From the
mediumevent parameter. Funnel may clean values such as(direct),(not set), and(none).Page title: From the
page_titleevent parameter, in lowercase.Platform user ID: Populated from Custom user ID or User ID.
Referrer: From the
page_referrerevent parameter.Referrer domain: Hostname part of the
page_referrerevent parameter.Source: From the
sourceevent parameter. Funnel may clean values such as(direct),(not set), and(none).Term: From the
termevent parameter.Transaction ID: From the
transaction_idevent parameter.User ID: From the
user_idcolumn.
Metrics
Basket value: From the
valueevent parameter.GA session number: From the
ga_session_numberevent parameter.Micro second time: From the
engagement_time_msecevent parameter.
Notes
Funnel fetches data from
events_YYYYMMDDtables first because they are more stable thanevents_intraday_YYYYMMDDtables. Funnel does not fetch data for the current day. If historicalevents_*tables are missing, Funnel looks forevents_intraday_*tables.By default, Funnel downloads up to 90 days of historical data. Contact Funnel support if you need more.
Measurement default events:
first_visit,session_start,purchase,add_to_cart,page_view,select_item,view_item_list, andview_item. You can change this by selecting a subset of events when you connect.Funnel filters out every row that is missing
user_pseudo_idorevent_timestamp.
API documentation
For GA4 BigQuery export schema and field definitions, see BigQuery Export for Google Analytics.
