Skip to main content

GA4 via BigQuery: Advanced Measurement dimensions and metrics

List of GA4 via BigQuery Advanced Measurement dimensions and metrics available in Funnel.

How to get these dimensions and metrics in your workspace?

What do you need?

  1. Go to Data > Connect.

  2. Click + Connect Data Source.

  3. Search for GA4 via BigQuery in the search bar, then select it from the search results.

  4. Select the Advanced Measurement report when you configure the data source.

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 campaign event parameter. Funnel may clean values such as (direct), (not set), and (none).

  • Content: From the content event parameter.

  • Cookie ID: From the user_pseudo_id column, in lowercase. In the GA4 BigQuery export this is user_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.country column.

  • Currency: ISO currency code parsed from the currency event 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_params column. Available when you choose to include the raw event_params field during connect.

  • Event currency: From the currency event parameter.

  • Event name: From the event_name column.

  • Event timestamp: From the event_timestamp column, formatted in ISO 8601 with microsecond precision.

  • Event timestamp org: From the event_timestamp column in its original form.

  • Event traffic source: From the traffic_source column.

  • File date: Date of the BigQuery table from which Funnel queried the data.

  • GA session ID: From the ga_session_id event parameter.

  • GCL ID: From the gclid event parameter.

  • Google Ads consent: From privacy_info.ads_storage, parsed as TRUE or FALSE.

  • Location: From the page_location event parameter.

  • Medium: From the medium event parameter. Funnel may clean values such as (direct), (not set), and (none).

  • Page title: From the page_title event parameter, in lowercase.

  • Platform user ID: Populated from Custom user ID or User ID.

  • Referrer: From the page_referrer event parameter.

  • Referrer domain: Hostname part of the page_referrer event parameter.

  • Source: From the source event parameter. Funnel may clean values such as (direct), (not set), and (none).

  • Term: From the term event parameter.

  • Transaction ID: From the transaction_id event parameter.

  • User ID: From the user_id column.

Metrics

  • Basket value: From the value event parameter.

  • GA session number: From the ga_session_number event parameter.

  • Micro second time: From the engagement_time_msec event parameter.

Notes

  • Funnel fetches data from events_YYYYMMDD tables first because they are more stable than events_intraday_YYYYMMDD tables. Funnel does not fetch data for the current day. If historical events_* tables are missing, Funnel looks for events_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, and view_item. You can change this by selecting a subset of events when you connect.

  • Funnel filters out every row that is missing user_pseudo_id or event_timestamp.

API documentation

For GA4 BigQuery export schema and field definitions, see BigQuery Export for Google Analytics.

Did this answer your question?