Use BigQuery as a destination

Written by Julie Trenque

Updated on 07/17/2024

1 min

Advanced

Manage your integrations

Analytics

Automation

CDP

CMP

CMS/CRM

Data Warehouses

Developers

Was this content useful?

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:

  1. 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.
  1. 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.
  1. 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.

  • In this article :