Overview
Integrating your VWO account with BigQuery (BQ) will enable you to stream your VWO experiment data directly to BigQuery. This allows you to consolidate your experiment data in a powerful, scalable data warehouse, providing the ability to run complex SQL queries and perform advanced data analysis.
For example, if you’re exporting both GA and VWO data to BQ, you can combine historical website traffic data from GA with A/B test results from VWO. This enables you to analyze long-term trends, understand how A/B tests affect visitor behavior over time, and build more sophisticated attribution models to measure the effectiveness of your overall marketing strategy.
Enabling the Integration
Enabling this integration is a two-step process:
Step 1: Grant VWO Access to Your BQ Data
- Log in to your Google Cloud account and select the project where you want to store your VWO experiment data in BigQuery.
- From the main menu panel on the left, go to IAM & Admin > IAM. The IAM page appears.
- Under PERMISSIONS, click GRANT ACCESS to add VWO as a member and grant permission to access the target BQ dataset.
- Specify the data in the following fields:
| Field | Input |
| New principals | vwo-integrations@wingify-integrations.iam.gserviceaccount.com |
| Select a role | Under By product or service, select BigQuery > BigQuery Data Editor |
| ADD ANOTHER ROLE > Select a role | Under By product or service, select BigQuery > BigQuery User |
- Click SAVE to save your changes.
- Upon successful addition, VWO will be listed as a member in the PERMISSIONS tab in the corresponding project.
Step 2: Turn On the Integration at VWO
- Log in to your VWO account.
- From the left panel of your VWO dashboard, go to Configurations > Integrations. This menu provides integrations that can be enabled at the account level.
- Browse for the BigQuery integration, click on it and turn on the toggle switch to enable it.
- Now, you’ll be taken to the Config tab to connect your BigQuery account with VWO.
Enter the details in the following fields and click Create Connection:
| Field | Input |
| Project ID | Specify the Google Cloud Project ID, where the required BigQuery dataset is present |
| Dataset Location | Specify the location of the required BigQuery dataset |
| Dataset ID | Specify the ID of the required BigQuery dataset |
Once the connection is established, your VWO experiment data will start streaming to your BigQuery account.
If you wish to enable the BigQuery integration for your campaigns, select the campaign, go to Configuration > Integrations, and select BigQuery.