Overview

Snowflake is a data warehouse many companies use to store and analyze data.

With the Snowflake integration, Experimentation Events Export decisions and conversions display automatically in your Snowflake instance:

• Experimentation Events Export data gets pushed into Optimizely’s Snowflake instance when it finishes processing each day.
• You can query the data immediately using Snowflake’sSecure Data Sharing tool.

🚧

Important

The snowflake integration is only currently available in the followingAWS regions:

ap-southeast-2	tg19960-optimizely_ap_southeast_2
eu-central-1	tg19960-optimizely_eu_central
eu-west-1	tg19960-optimizely_eu_west.
us-east-1	tg19960-optimizely_laa60418east
us-east-2	tg19960-optimizely_us_east_2
us-west-2	tg19960-laa60418

Get started

To get started viewing your Optimizely Experimentation Events Export data in Snowflake:

• Check with your Snowflake representative thatSecure Data Sharing is available in your Snowflake plan.
• SendOptimizely Support your Snowflakeaccount name andregion. SeeAccount identifiers.
• Verify you can query your Experimentation Events Export datasets with Snowflake when Optimizely confirms the share is enabled. This typically takes a few days.

Usage examples

How many new visitors saw the updated call to action on the subscription page last week?

Exposure to the call to action (CTA) should be aligned with lifetime value predictions generated for visitors to your site. This query looks at decision events for your experiment last week to find new visitors and counts unique visitors who converted after a decision event, using the conversion event nameCTA_entered_viewport.

SELECT COUNT (distinct visitor_id) as visitor_countFROM (     SELECT c.visitor_id     FROM conversions c     INNER JOIN      (        SELECT visitor_id, MIN(timestamp) as decision_timestamp        FROM decisions        WHERE experiment_id = '10728121502'        AND variation_id = ‘38495823’        AND timestamp between '2020-08-20 00:00:00.000'         AND '2020-08-27 00:00:00.000'        AND is_holdback = false        GROUP BY visitor_id     ) d      ON c.visitor_id = d.visitor_id     WHERE parse_json(experiments[0]):list[0]['element']:experiment_id = '10728121502'     AND parse_json(experiments[0]):list[0]['element']:variation_id = ‘38495823’     AND c.timestamp  between '2020-08-20 00:00:00.000'         AND '2020-08-27 00:00:00.000'     AND c.event_name = ‘CTA_entered_viewport’     AND c.timestamp >= d.decision_timestamp)

How many times per day did visitors who saw the new call to action click on it?

Clicks on the CTA should be joined with user-level revenue averages for visitors to your site. This query looks at allCTA_clicked events for your experiment and CTA variation grouped by date.

SELECT to_date(timestamp) as timestamp, COUNT(*) as click_countFROM conversionsWHERE parse_json(experiments[0]):list[0]['element']:experiment_id ='10728121502'  AND parse_json(experiments[0]):list[0]['element']:variation_id = ‘38495823’  AND timestamp  between '2020-08-20 00:00:00.000'       AND '2020-08-27 00:00:00.000'   AND event_name = ‘CTA_clicked’GROUP BY to_date(timestamp)ORDER BY to_date(timestamp) asc

Monthly totals

You can send up to 1 billion monthly events. Eachconversion or decision event logged is considered an event in the calculation.

Updated 2 months ago