*Event Data Integration: BigQuery Transfer

Symbiosys supports two methods for integrating event data via BigQuery (BQ):

• Direct BigQuery Dataset Transfer – transfer datasets directly in BQ.

• Google Analytics 4 (GA4) BigQuery Export – create a BQ export from GA4 data.

Option 1: Direct BigQuery Dataset Transfer

1. [Optional] Create a Filtered View

   1. If needed, create a view containing only the required visit/order event data. Here is an example view that excludes the user_properties field to prevent PII exposure.

   2. Note: Promoting the _TABLE_SUFFIX is important for efficient query execution.

CREATE VIEW GAIntraday AS  
SELECT _TABLE_SUFFIX AS suffix, * EXCEPT(user_properties)  
FROM DATASETNAME.analytics_1234.events_intraday_*

2. Grant Access to Symbiosys

   1. Share your dataset with system@symbiosys.ai and assign the following roles:

      1. BigQuery Data Viewer (roles/bigquery.dataViewer)

      2. BigQuery Job User (roles/bigquery.jobUser)

3. Set Up a Data Export Schedule

   1. Ensure data is transferred on a regular cadence (hourly or at least once daily).

Option 2: Google Analytics 4 (GA4) BigQuery Export & Sharing

1. Enable Intraday BigQuery Export in GA4

   1. Log in to Google Analytics, go to Admin, and navigate to Data Streams.

   2. Click BigQuery Export and toggle Enable Intraday.

   3. Choose a Dataset Name and Table ID, then select the fields to include.

   4. Click Link BigQuery and follow the authorization prompts.

   5. Alternatively, add symbiosys@symbiosys.ai as a user in your BigQuery dataset, allowing Symbiosys to export the data to their GCP account.

2. Share the Dataset with Symbiosys

   1. Assign system@symbiosys.ai the BigQueryDataEditor role in IAM OR create a new dataset view that excludes PII and share that dataset with Symbiosys.