Skip to main content

Connect to GA4 via BigQuery with the Standard report

Connect GA4 via BigQuery using the Standard report and select events to import.

The GA4 via BigQuery connector imports raw, unsampled Google Analytics 4 event data from your BigQuery export into Funnel. This article describes how to connect it with the Standard report.

Note: GA4 via BigQuery is a Beta feature.

Google Analytics connector or GA4 via BigQuery connector?

If you want to connect to a data source from Google Analytics in Funnel, you can use one of the following connectors:

​

  • Google Analytics connector

  • GA4 via BigQuery connector

​

While these connectors complement each other, they have different features. If you want to import aggregated and pre-processed data to Funnel, use the Google Analytics connector. If you want to connect to a data source from Google Analytics and import more than 9 dimensions in your reports, use the GA4 via BigQuery connector to fetch this data. You can fetch the event-level data using this connector. Understand the differences between these two connectors before you decide to connect.

​

Data aggregation and raw event-level data

The Google Analytics connector imports aggregated and pre-processed data using Google's reporting API. This is best suited for straightforward use cases where you want summary reports and retrieve high-level metrics such as sessions and conversions.

​

The GA4 via BigQuery connector imports raw, unsampled event-level and user-level data directly. This enables deep, customized analysis with full access to event parameters, user IDs and custom dimensions.

​

Flexibility and custom use cases

The GA4 via BigQuery connector is designed for advanced, flexible reporting, such as:

​

  • Creating unique event IDs

  • Grouping conversions by landing page or other custom parameters

  • Building audiences based on behavioral or event-driven rules

  • Running real-time analysis (based on the latest data dumps)

​

These capabilities support more tailored and powerful insights, particularly for users with complex analytics needs.

​

Dimensions and metrics limitations

Google Analytics connector:

​

  • Limited to 9 dimensions per query

  • Returns only the predefined Google-reported metrics

  • May omit high-cardinality fields or niche parameters

Note: While these limitations apply to what can be requested from the Google API, Funnel also provides some derived metrics out of the box that are available through the GA4 connector.

GA4 via BigQuery connector:

​

  • No limit on the number of dimensions

  • Supports all custom event parameters, regardless of cardinality

  • Enables querying of user-scoped and session-scoped fields that aren't available through the API

​

Sampling and data completeness

The Google Analytics connector can be subject to sampling and quota limits, especially on high-traffic properties or large datasets.

​

The GA4 via BigQuery connector pulls directly from unsampled, complete BigQuery exports, so all events are captured.

Note: Funnel limits daily file size to 5 GB to ensure performance and stability.

Availability of key fields

  • The User ID field, essential for analyzing user behavior across sessions and devices, isn't available in the standard GA4 connector.

  • It's available in the GA4 via BigQuery connector, along with the Google Click ID (GCLID) tied to conversion events.

​

Which connector should you use?

Use this table to decide which connector suits your use case best.

Feature

GA4 via BigQuery connector

Google Analytics connector

Data type

Raw, unsampled event-level data

Aggregated session-level data

Sampling

Not applicable

Available

Dimension limit

None

9 per query

Access to custom parameters

Supports all parameters

Supports only limited parameters

User ID and GCLID support

Available

Not supported

Recommended scenarios

Suitable for advanced and custom analytics

Suitable for quick and standard reporting

To connect with the Google Analytics connector instead, see Connect your Google Analytics data.

​

How the GA4 via BigQuery connector imports data

The GA4 via BigQuery connector in Funnel is built for advanced analytics use cases.

​

To import your data, you first link your Google Analytics property to BigQuery and include the User ID. This collects the user-provided data. After you stream this event data to BigQuery, use the GA4 via BigQuery connector to import this data in Funnel. Funnel aggregates the event data by time period, making it easier to explore and analyze trends in the Google Analytics dataset. Since this connector doesn't require you to use SQL or ETL, it's a less expensive solution compared to other Business Intelligence (BI) tools.

Note: This article describes only the Standard report in the connector. If you use the Measure feature, see Connect your GA4 event-level data via BigQuery for Advanced Measurement.

Before you begin

  • You have a Business or Enterprise plan in Funnel.

  • You use BigQuery as your warehouse solution.

  • You link Google Analytics with BigQuery. Funnel doesn't download historical data from before this link is set up.

  • You have the necessary roles and permissions in Google Analytics and BigQuery:

  • An Editor or Administrator role for the Google Analytics account.

  • A BigQuery Data Editor or BigQuery Admin role in the BigQuery account.

​

For the complete list of dimensions and metrics, see GA4 via BigQuery: Standard dimensions and metrics.

​

Data limits and download times

  • For a quicker connection, specify the events you want to import during the configuration. The All events option is the default choice.

  • Use a comma-separated list to specify the events you need. This also reduces the amount of data that Funnel imports, makes the connection quicker and lowers your costs.

  • This connector imports data only up to 5 GB per day. If the data exceeds this limit, downloading the data is delayed. Contact Funnel Support if you notice a delay of more than 24 hours.

  • The download time depends on the number of rows, the size of the file and the granularity of data in each row. If the download takes more than 5 hours, contact Funnel Support.

  • Funnel downloads data only up to the last 90 days.

​

BigQuery costs

There may be additional costs associated with BigQuery. Read about BigQuery pricing for more details. For example, if you have 1 GiB of data per day, the initial backfill for this connection uses 90 GiB of your processing limit for that month. After the initial backfill, the connector uses 3 GiB per day. This means that the first month uses 180 GiB and the following months use 90 GiB.

​

  • Be mindful of the other instances that query your BigQuery data, since it's a shared cost pool.

  • Monitor query costs in the BigQuery console.

  • Monitor your monthly BigQuery usage in the Monitoring tab in Google Cloud Console. Make sure you select the correct project and location.

  • Collaborate with your data team to restructure large datasets where needed.

​

Connect GA4 via BigQuery to Funnel

  1. In the left menu, go to Data > Connect > Data sources, and click + Connect data source.

  2. Search for GA4 via BigQuery in the search bar, and click Connect now.

  3. In the Select Credentials section, select your BigQuery account's credentials so that you can authorize Funnel to download your data. If you select an account that you already added, go to step 5. If you're adding a new account credential, follow these substeps:

    ​

    1. Click Continue with Google. You're redirected to a screen to confirm the Google account you want to continue with.

      ​

    2. Click Continue to confirm the account.

      ​

    3. Review the access permissions for the Funnel Connector, and click Allow.

    ​

  4. Select a project that contains the data you want to import, and click Next.

    ​

    Note: You can select multiple projects per connection.

  5. Select Use a Template or Configure manually to set up your data source, and click Next. To configure a data source:

    ​

    1. If you select Use a Template: Select a saved template or create a new template. Enter a template name if you're creating a new template.

      ​

    2. Optional: If you selected multiple projects in step 5 and want to configure manually, turn on Configure Data Sources individually to configure each data source separately.

      ​

    3. Select the Standard report. For the fields, see GA4 via BigQuery: Standard dimensions and metrics. If you use the Measure feature and want to select the Advanced Measurement report, see Connect your GA4 event-level data via BigQuery for Advanced Measurement.

      ​

    4. Select the events you want Funnel to import from BigQuery in the What events do you want to collect? section. Available options are All events and Subset of events.

      ​

    5. Optional: If you selected Subset of events, enter the events you want to collect in a comma-separated list. Specifying the events speeds up the connection and downloads, and minimizes BigQuery costs because less data is transferred.

      ​

    6. Specify if you want to extract data from the event_params_key column in BigQuery. The available options are No and Yes. If you select Yes, enter the event parameters you want as dimensions and metrics in comma-separated lists in the corresponding fields.

      ​

      ​

      Follow these rules when you fill in the dimensions and metrics lists:

      ​

      • Add each event parameter to only one list. If you add the same parameter to both lists, Funnel creates a duplicate column and the download fails.

      • Put identifier parameters, such as ga_session_id, batch_page_id, batch_ordering_id and debug_mode, in the dimensions list.

      • Only add parameters to the metrics list if it makes sense to sum their values, such as value or quantity.

      ​

      Note: Funnel converts everything in the metrics list into numbers that can be summed. Large identifiers, such as ga_session_id, are too big for this conversion, and the download fails with a "Something unexpected happened" error. If you see this error, move any identifier parameters from the metrics list to the dimensions list.

    ​

  6. Review the configuration summary, and click Connect data source.

​

What to expect

Funnel starts importing data from BigQuery. Funnel doesn't download data for the current day. It downloads data at the following frequencies:

​

  • Every hour for the previous day's data

  • Every 24 hours for the data from the last 3 days

​

Manage your connection

  • Reconnect: If the connection breaks, click the warning icon on the data source and follow the re-authentication steps.

  • Pause or delete: Go to Data > Connect > Data sources, click the three-dot menu, and select Pause or Delete.

Did this answer your question?