What is the BigQuery Event Connection?
The BigQuery Event Connection allows you to import data from your own BigQuery tables directly into adtribute as events. This is useful when you have custom event data stored in BigQuery that you want to analyze alongside your other marketing data in adtribute.
Unlike the BigQuery Lookup Attribute which pulls individual values from a table, the BigQuery Connection imports entire event datasets. This means you can bring in custom conversion events, user actions, or any other time-based data that lives in your BigQuery warehouse.
Common use cases:
Import offline conversions that are stored in your data warehouse
Connect custom event data from your product or CRM
Add supplementary user behavior data to your marketing analytics
Access Connection in adtribute
Open the adtribute app
Navigate to Sources in the main navigation
Click on Connections
Search/select BigQuery from the available connection options
Add a descriptive name and description for the connection at the top
Describe "Event Source" and "Event Object"
Click "Next"
Grant View Access to BQ Project
Before entering your project, dataset, and table details, grant adtribute access to your BigQuery project.
Please make sure to use a resource located in a "multi-region EU" cluster.
Login to your GCP (Google Cloud Plattform) Account
Go to your according GCP Project
Navigate to the "IAM" section
Click "Grant access"
Grant our email access: [email protected]
Provide it with the Role "BigQuery Data Viewer" and save ("Data Editor" access is not necessary in this case):
Important: If your table has dependencies on another BigQuery project (such as nested table references), you will need to grant view access to that project as well.
Map your BQ Data
Once you've granted the necessary permissions, you can continue the connection flow in adtribute.
Fill out the following columns and make sure you fill in the IDs and names exactly as they are in your BQ:
Project ID: Your GCP project ID
Dataset ID: The BigQuery dataset that contains your table
Table ID: The specific table name you want to connect
Event ID: The column name that contains a unique identifier for each event
Timestamp: The column name that contains the event timestamp
Email: The column name that contains user email addresses
CDD Parameter (optional): Enter if needed for your use case
After filling these out, it will look similar to this:
Complete the Connection
Lastly, click "Connect".
After that, the status will show as Awaiting Data initially
adtribute creates a sync process that runs every 15 minutes in the background
Once the first successful data sync completes, the status changes to Connected
Your BigQuery data will continue to sync automatically every 15 minutes