Skip to main content

Use BigQuery as a destination

note

Data warehouse integrations are available as a premium add-on for our Web Experimentation and Feature Experimentation module. For more information, please contact your Customer Success Manager.

With the BigQuery integration, you can simplify data retrieval for targeted campaigns and personalized user experiences.

Key benefits:

  • Allows precise data collection, enhancing audience targeting for personalized campaigns tailored to specific audience needs and preferences.
  • Set up Data Ingestion Tasks and extract data from BigQuery.

Activate BigQuery as a destination​

Once you have enabled the BigQuery integration for your project, you can activate Use BigQuery as a destination to send the results of your Kameleoon campaigns to BigQuery.

To do this, follow these steps:

  1. Within the selected project's configuration, you'll find a checkbox labeled Use BigQuery as a destination. Check this checkbox to enable the feature.

  1. You'll need to provide the BigQuery project ID associated with your Google BigQuery project. Enter the project ID in the BigQuery project ID.

  1. Click Validate to save your changes.

What "Use BigQuery as a Destination" does​

Enabling Use BigQuery as a destination will send all Kameleoon experiment exposure events into Google BigQuery. The events will be saved in the "kameleoon" dataset you previously created with write access for the Kameleoon service account in a table called kameleoon_experiment_event. The SQL schema of this table is the following:

CREATE TABLE  kameleoon_experiment_event (
     nonce  BIGINT  PRIMARY KEY, // unique identifier of the event
   timestamp  BIGINT, // timestamp in millis of the event
     visitor_code  VARCHAR(255), // Kameleoon visitor identifier
   custom_visitor_id  VARCHAR(255), // Visitor identifier used by your company
     experiment_id  BIGINT, // Kameleoon id of the experiment
     variation_id  BIGINT // Kameleoon id of the variation
 );

The custom_visitor_id is read from the Cross Device Reconciliation custom data, if it has been set.