Optimizely link
Optimizely is an experimentation platform, enabling businesses to deliver continuous experimentation and personalization across websites, mobile apps, and connected devices.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | ||
Custom data | check | VISITOR_ACTION and EXPERIMENT_CHANGE_HISTORY tables only |
Data blocking | check | Column level. VISITOR_ACTION , RESULT , DECISION , and CONVERSION tables. |
Column hashing | check | |
Re-sync | check | Connector level |
History | check | CAMPAIGN_HISTORY , EXPERIMENT_HISTORY , CAMPAIGN_PAGE_HISTORY,CAMPAIGN_METRIC_HISTORY , CAMPAIGN_CHANGE_HISTORY , CAMPAIGN_CHANGE_DEPENDENCY_HISTORY , EXPERIMENT_VARIATION_HISTORY , EXPERIMENT_VARIATION_ACTION_HISTORY , EXPERIMENT_PAGE_HISTORY , EXPERIMENT_METRIC_HISTORY , EXPERIMENT_CHANGE_HISTORY , and EXPERIMENT_CHANGE_DEPENDENCY_HISTORY tables only |
API configurable | check | API configuration |
Priority-first sync | check | DECISION , CONVERSION , and their child tables |
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step Optimizely setup guide to connect Optimizely with your destination using Fivetran connectors.
Sync overviewlink
Fivetran can sync historical data from Optimizely as long as it is stored in your S3 bucket.
Pack mode optionslink
Pack modes determine the form in which Fivetran delivers your data. You must choose a pack mode for enriched export tables (CONVERSION
and DECISION
) you want Fivetran to sync. There are two pack modes, packed and unpacked.
Packed modelink
In packed mode, the nested fields attributes
, experiments
, and tags
are added as JSON
columns to the corresponding parent table and no separate child tables are created.
Unpacked modelink
In unpacked mode, Fivetran unpacks the nested fields attributes
, experiments
, and tags
into the following separate child tables under the corresponding parent table:
CONVERSION
CONVERSION_ATTRIBUTE
CONVERSION_EXPERIMENT
CONVERSION_TAG
DECISION
DECISION_ATTRIBUTE
Switching pack modeslink
You can switch pack modes at any time in your Fivetran dashboard. When you change the pack mode, we automatically perform a full table re-sync of the CONVERSION
and DECISION
tables.
To change the pack mode for a table, do the following:
- In the connector dashboard, go to the Setup tab.
- Click Edit connection details.
- In the connector setup form, change the Pack Mode.
- Click Save & Test.
Schema informationlink
This schema applies to all Optimizely connectors
To zoom, open the ERD in a new window.Schema noteslink
Optimizely states that there are no duplicates in the event files, so Fivetran adds _fivetran_id
(which is a hash of the entire record) as the primary key for the VISITOR_ACTION
table. _fivetran_id
is a calculated hash that is added as the primary key in metrics as well as in the EXPERIMENT_PRIORITY
table.