Export Analyze/Optimize data to ClickHouse

Learn how to export Analyze/Optimize analytics data to ClickHouse.

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 ClickHouse automatically.

Step 1: Configure ClickHouse (developers)

Before you can export data to ClickHouse, 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 ClickHouse 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 ClickHouse
4. Enter the info your developers provided (fields are context-sensitive based on what you select):
   • Host — i.e., the host name
   • Port — i.e., the port number
   • Cluster — i.e., the cluster identifier
   • Connection database — i.e., the name of the database to connect to
   • Write database — i.e., the name of the database where data will be written
   • Disable SSL — select Yes or No
   • Bucket vendor — i.e., where the bucket is hosted (e.g., S3 or GCS)
   • Bucket name — i.e., the name your developers created for the bucket
   • S3 bucket region — i.e., the location your developers selected for the bucket
   • Bucket access ID — i.e., the bucket's authentication ID
   • Bucket secret key — i.e., the bucket's authentication key
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 ClickHouse configuration doc so they can verify it's correctly configured.