Advanced Configuration - GA4 BigQuery Pipeline.

There are several advanced settings for your GA4 BigQuery pipeline.

Where is this in the Pipeline Interface?

What are you setting up here?

These settings allow you to fine-tune how your GA4 data is processed and stored.

1. Converting GA Session ID to a string
2. Adjusting the rolling recalculation window
3. Adding first open events to a session

This is what it looks like:

Let's break them down.

1. Converting GA Session ID to a string

GA Session ID is a number by default. Depending on how you ingest the data, though this may add it as a sting.

This setting allows you co coerce all GA Session IDs to a string.

2. Adjusting the rolling recalculation window

It can take up to 72 hours for raw GA4 data to fully finalize.

Pipeline automatically recalculates GA4 data for the most recent 3 days to ensure the data is complete and accurate.

If you’re managing a very large site, you can shorten this recalculation window to help reduce your GA4 BigQuery costs.

3. Adding first open events to a session

Occasionally the GA4 raw data can include a first_open event in isolation without a session.

What we can do is stitch them back into a session when this is possible to do.