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.
Activate BigQuery as a destination
Once you have enabled the BigQuery integration for your project, you can activate Use BigQuery as a destination to seamlessly send the results of your Kameleoon campaigns to BigQuery.
To do this, follow these steps:
- Click on the checkbox: Within the selected project’s configuration, you’ll find a checkbox labeled Use BigQuery as a destination. Check this checkbox to enable the feature.
- Provide BigQuery Project ID (Required): After activating the feature, you’ll need to provide the BigQuery project ID associated with your Google BigQuery project. This project ID is a critical component for directing campaign results to the correct destination within BigQuery.
- Validate: Click Validate to save and apply your configuration settings.
What “Use BigQuery as a Destination” does
Enabling Use BigQuery as a destination will stream 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 events are streamed to this table with an approximate 30 minute delay. 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.
With campaign data stored in BigQuery, you gain the ability to perform in-depth analysis and reporting. You can leverage BigQuery’s querying capabilities to extract valuable insights from the collected data, helping you make data-driven decisions to optimize your campaigns and user experience.
By centralizing Kameleoon campaign results in BigQuery, you contribute to the enrichment of your BigQuery database, making it a comprehensive repository of user data that can be used for a variety of analytical and business intelligence purposes.
