Export Analyze/Optimize data to Google BigQuery

Learn how to export Analyze/Optimize analytics data to Google BigQuery.

Connect Analyze/Optimize to your data warehouse so your analytics data flows straight into your existing infrastructure. Exporting your data gives you more control over reporting and lets your team run deeper analysis by keeping everything in one place. Once your developers configure the integration, you'll plug in the credentials they provide to start sending newly collected site data to BigQuery automatically.

Step 1: Configure BigQuery (developers)

Before you can export data to BigQuery, your developers need to configure it and provide you with some info that you'll enter in your Analyze/Optimize settings during step 2.

Provide this document to your developers: Configure BigQuery as a data export destination

Step 2: Configure Analyze/Optimize

Use the following steps only after your developers have confirmed they've configured your data warehouse and provided you with the required authentication info.

Open your site in Webflow, then:

1. Go to the Insights tab > Integrations > Data Export integrations tab
2. Click Connect data destination under "Data Exports"
3. Select BigQuery
4. Enter the info your developers provided (fields are context-sensitive based on what you select):
   • Auth method — select either IAM Role or User/Password
   • Project ID — i.e., the BigQuery Project ID
   • Dataset — i.e., the name of the dataset to create and write data to
   • Destination service account email — i.e., email address associated with IAM Role
   • JSON Token — i.e., credentials for the User/Password account
   • GCS bucket name — i.e., the name your developers created for the GCS bucket
   • GCS bucket region — i.e., the location your developers selected for the GCS bucket
5. Click Test connection (review the troubleshooting info if the test fails)
6. Click Save if the test was successful

Newly collected data will be exported on a nightly basis (every 24 hours). Historic data is not exported.

Troubleshooting

If Test connection produces an error, it means the authentication info you entered is invalid or the developers didn't configure your data warehouse according to the provided documentation.

If the authentication info was copied from certain sources (e.g., web page or email), extra HTML formatting associated with that source can introduce hidden characters when you paste into Webflow. Try the following to remove any hidden characters:

1. Paste the info into a plain text editor (e.g., Notepad on Windows or TextEdit on Mac)
2. Copy the info directly from that plain text editor
3. Paste the "clean" version of the info directly into the Webflow fields
4. Click Test connection again

If the issue persists, check with the developers to see if the info they provided you is accurate and provide them with the BigQuery configuration doc so they can verify it's correctly configured.