Disclaimer: This website requires Please enable JavaScript in your browser settings for the best experience.

The availability of features may depend on your plan type. Contact your Customer Success Manager if you have any questions.
Dev GuideAPI Reference
Dev GuideAPI ReferenceUser GuideGitHubDev CommunityOptimizely AcademySubmit a ticketLog In
Dev Guide

View data in BigQuery

Retrieve data stored by Optimizely Experimentation about your experiments using BigQuery by Google Cloud.

📘

Note

This is a third-party integration and is not an Optimizely subprocessor. See Optimizely's Third-Party Add-Ons & Platform Integration Terms.

You can use BigQuery by Google Cloud to access the data Optimizely Experimentation ingests and stores within your personal BigQuery project. BigQuery is a fully managed, serverless data warehouse. It lets you run GoogleSQL queries against large datasets. Using BigQuery offers the following advantages:

  • Availability of Optimizely Experimentation data in your BigQuery instance in real-time.
  • Ability to combine multiple datasets.
  • Query Optimizely Experimentation data in any desired manner.

Your Optimizely Experimentation data is available through an authorized view in BigQuery. Authorized views let you view query results without accessing the underlying database tables.

🚧

Important

Optimizely supports BigQuery queries within the US or EU. You must run your queries in the same region where the data resides.

For example, if your data resides in an EU BigQuery instance, all queries must be executed in the same region (EU). Regional alignment is required to ensure compliance and optimal performance. Queries cannot be run from a different region (US) against EU-hosted data.

See Google Cloud's documentation on geography and regions.