Optimizely logo

Sync Optimizely data to Sourcetable

Optimizely

Optimizely enables businesses to deliver continuous experimentation and personalization across websites, mobile apps, and connected devices. The platform provides A/B testing and multivariate testing tools, website personalization, and feature toggle capabilities, and can be used to measure A/B testing results and cookie usage, among other important KPIs.

Sync Optimizely data to Sourcetable


Optimizely logo
Sourcetable logo

Find out how to make the most of your Optimizely data with Sourcetable

Sourcetable Benefits

Query analytics data quickly & easily

Optimizely allows users to carry out A/B testing and website personalization, using web content management and digital commerce tools. Sourcetable users can sync and combine data from Optimizely with inputs from other key platforms and databases, allowing them to keep track of key metrics and their interactions with other important activities and platforms, easily and at a glance.

Accessibility

Syncing your Optimizely data to Sourcetable allows users to query inputs from multiple analytics platforms without having to learn SQL – making your key e-commerce data readily available to all members of your team.

Automation

Sourcetable brings together key data from Optimizely and other platforms quickly and intuitively, allowing users to automate processes and freeing up time to focus on other important aspects of their websites.

An example interface to create an automation when sales surpass certain number

Visualizations

Sourcetable comes with a full suite of visualization tools for your reporting needs - from bar charts and line graphs to burn charts, mapping, scatter plots, and more. Create visually striking dashboards and share with your team to identify the metrics that matter most.

A simple flow showing how a table converts to a chart easily

Find out how to get the most from Optimizely with Sourcetable

A Magic Wand

Smart Templates

Use out of the box tried and tested templates in order to cross-reference Optimizely data and enable data collaboration across your entire organisation

A Magic Wand

Quick Analysis

Analyse and cross-reference your developer and user analytics instantly in comprehensive, dynamic reports

A Magic Wand

Ease Of use

Compile all your Optimizely data into a spreadsheet, query it and find the key business insights behind the numbers, allowing you to confidently update and improve your website.

Who uses Optimizely data in Sourcetable

👨‍💻 Developers

👩🏼‍💼 Product Managers

🚀 Founders

🏢 Ecommerce businesses

Here's a sample of Optimizely data that will be available in your Sourcetable spreadsheets:

Show all (33)

ATTRIBUTE

Attribute defines the characteristics of audiences that decide which experiences they want to be included in.

Link icon

AUDIENCE

Audience defines the persons who can be included in the experiments

Link icon

CAMPAIGN_CHANGE_DEPENDENCY_HISTORY

Contains change id, campaign id, campaign last modified and dependent change id

Link icon

CAMPAIGN_CHANGE_HISTORY

Contains the history of changes that are made to a campaign

Link icon

CAMPAIGN_HISTORY

Contains associations of campaign and page along with columns of created, earliest, holdback, latest, name, status and url targetting information

Link icon

CAMPAIGN_METRIC_HISTORY

Contains associations of campaign history and event along with columns of aggregator, field, scope, and winning direction

Link icon

CAMPAIGN_PAGE_HISTORY

Contains association of campaign history and page.

Link icon

CONVERSION

Contains visitor id, session id, account id, entity id, user ip, user agent, referer, event type and name, value, revenue, quantity, revision, client engine and version

Link icon

CONVERSION_ATTRIBUTE

Contains conversion id, type and value

Link icon

CONVERSION_EXPERIMENT

Contains conversion id, campaign id, experiment id, variation id, and is holdback

Link icon

CONVERSION_TAG

Contains conversion id, key and value

Link icon

DECISION

Contains campaign id, experiment id, variation id, timestamp, process timestamp, visitor id, session id, account id, user ip, user agent, referer, revision, and client engine and version

Link icon

DECISION_ATTRIBUTE

Contains name, decision id, type and value

Link icon

EVENT

Contains project id, page id, archived, category, description, event type, key, name, created, is classic and editable

Link icon

EXPERIMENT_CHANGE_DEPENDENCY_HISTORY

Contains associations of change id, experiment history, experiment last modified and dependent change id

Link icon

EXPERIMENT_CHANGE_HISTORY

Contains experiment id, experiment last modified, action id, allow additional redirect, async, tag attribute fields, css fields, destination, extension id, name, operatorm selector, src, type and value

Link icon

EXPERIMENT_HISTORY

Contains campaign id, project id, url targeting page id, allocation policy, audience conditions, created, description, earliest, holdback, key, latest, name, schedule time zone, start time, stop time, status, type and url target fields

Link icon

EXPERIMENT_METRIC_HISTORY

Contains experiment id, experiment last modified, experiment history, event, aggregator, field, scope, winning direction

Link icon

EXPERIMENT_PAGE_HISTORY

Contains associations of experiment id, page id and experiment last modified

Link icon

EXPERIMENT_RESULT_HISTORY

Contains experiment id, experiment last modified, metric variation id, metric name, confidence threshold, end time, metric aggregator, metric conclusion loser and winner, metric event id,metric event id, metric scope, metric variation fields

Link icon

EXPERIMENT_VARIATION_ACTION_HISTORY

Contains association of variation id, experiment id, experiment last modified, page id, share link

Link icon

EXPERIMENT_VARIATION_HISTORY

Contains experiment id, experiment last modified, archived, description, key, name, status, weight

Link icon

EXTENSION

Contains project id, archived, created, description, edit url, enabled, implementation apply js, css, html, reset js, last modified and name

Link icon

FIELD

Contains extention id, api name, default value, field type and label

Link icon

GROUP

Contains project id, archived, created, description,last modified and name

Link icon

GROUP_ENTITY

Contains group id, kind and weight

Link icon

LIST_ATTRIBUTE

Contains project id, account id, archived, aws access key, secret key,

Link icon

PAGE

Contains project id, activation code and type, archived, category, conditions, created, edit url, key, last modified, name and page type

Link icon

PLAN

Contains plan name, status and unit of measurement

Link icon

PRODUCT_USAGE

Contains plan id, allocation term in months, end time, last updated time, overage cents per visitor, product name, start time, usage, and usage allowance

Link icon

PROJECT

Contains account id, confidence threshold, created, dcp service id, description, is classicm last modified, name, platform, socket token, status and web snippet fields

Link icon

PROJECT_STATUS

Contains project id, description, platform and status

Link icon

SDK

Contains project id and sdk name

Link icon

Sample companies

Online businesses integrating Optimizely with Sourcetable have access to all relevant data on A/B testing, cookie usage and lifetime value (LTV).

  • Retail online stores

    (eCommerce)
  • Content marketing platforms

  • B2B Platforms

  • Software as a Service

    (SaaS) companies
  • B2C Marketplaces

What makes Sourcetable special?

A Magic Wand

Interconnectivity

Connect, sync and query your Optimizely data with key findings from 30+ other sources, without SQL.

A Magic Wand

Collaboration

Create views and workflow templates to drive business decisions based on data from Optimizely and other platforms

A Magic Wand

Automation

Automate your Optimizely data and make time to focus on what matters most: selling your product

Frequently Asked Questions

How do I sync Optimizely data to Sourcetable?
Sourcetable is currently in Closed Beta. Sign up to the Beta here to tell us a little about yourself and request information on how to sync your Optimizely data.
Which analytics platform works best with Sourcetable – Optimizely or Google Analytics?
Sourcetable enables users to combine data from both platforms, enabling businesses to better understand the relationships among available data, and gain new insights for making better decisions or identifying new opportunities.
How easy is it to visualize my Optimizely data using Sourcetable?
Sourcetable spreadsheets are designed to be intuitive and user-friendly, so anyone can view key data from Optimizely - and complementary platforms such as Google Analytics and AppsFlyer - at a glance without code.




Connect your Optimizely Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.