Export your A/B test data to Snowflake

Every night, Mida puts your raw experiment data into your own Google Cloud Storage bucket, ready for Snowflake. Join it with your orders, CRM and product data, and analyze tests your own way.

Data Warehouse Data out Server-side Works with Mida A/B Testing & Personalization

About Snowflake

Snowflake is a cloud data warehouse. It loads data from cloud storage through a stage, including Google Cloud Storage, and keeps track of which files it has already loaded.

How the Snowflake integration works

Mida keeps a copy of each project's experiment data as it happens. Shortly after midnight UTC it adds the previous day to your bucket as four tables, one file per day: exposures (each visitor put into a variant, and when), events (goal conversions and your own events, such as purchases, with their properties), results_daily (the totals per variant, as your Mida report shows them that day) and tests (your tests with their variants and goals). In Snowflake, a stage over the bucket and a daily COPY load each new day; the help article has the SQL. The first delivery also includes everyone already in your live tests, so a test that was running before you turned the export on can be analyzed in full.

Requirements

  • A paid Mida plan.
  • A Google Cloud Storage bucket.
  • Access to change the bucket's permissions in Google Cloud.
  • A Snowflake account with permission to create a storage integration and a stage.
  • Owner or Admin role in Mida.

How to use Snowflake with Mida

  1. In Google Cloud, give the Mida service account shown in Mida the Storage Object User role on your bucket.
  2. In Mida, open Integrations and choose Snowflake under Data Warehouse.
  3. Enter the bucket name and, if you like, a folder, then click Check access and turn on.
  4. In Snowflake, create the storage integration, stage and tables from the help article, then run COPY each day (for example as a Snowflake task).

Use cases

Measure tests against revenue you trust

Join exposures with the orders in your own database, so a test is judged on refunds, repeat purchases or margin, not only on the conversion Mida tracked.

Follow tested visitors over time

See what visitors in each variant did weeks later: whether they upgraded, churned or came back. Exposures keep the first time each visitor saw a test, so long-term effects are easy to measure.

Report on every test in one place

Put results_daily into your dashboards next to the rest of your company's numbers, and track every running test day by day without opening Mida.

Run your own analysis

Segment results by any customer attribute you hold, or apply your own statistics. Exposures and events share the same visitor ID, so the join is a single line of SQL.

Frequently asked questions

What data does the export include?

Four tables: exposures (each visitor put into a variant), events (goal conversions and the events you track, with their properties and page), results_daily (visitors, conversions and revenue per variant for each live test) and tests (names, variants and goals). Page views and engagement pings are left out to keep the files small.

How often is the data delivered?

Once a day. Shortly after midnight UTC, Mida adds the previous day's files and a small manifest that lists how many rows each table has, so you know the day is complete.

Do I get data from before I turned it on?

The first delivery includes everyone already in your live tests. Events start from the day you turn the export on.

Can I export to Amazon S3 or Azure?

Not yet. The files go to Google Cloud Storage, which Snowflake reads directly.

Which Mida plans include it?

Every paid plan. Many testing tools keep a warehouse export for their enterprise plans only.

Does it slow down my site?

No. The export runs on Mida's servers. Nothing changes on your site or in the Mida tag.

Ship A/B tests 10x faster — connected to your stack

Mida is the lightweight A/B testing and personalization platform that integrates with the tools you already pay for.

Decorative graphic Decorative graphic Decorative graphic Decorative graphic