Access Optimizely X in Excel

Projects List

Fields

  • ID
  • Name
  • Description
  • Status
  • Confidence Threshold
  • Platform
  • Account ID
  • Created
  • Last Modified
  • Classic Project

Campaigns List

Parameters

  • Project ID

Fields

  • ID
  • Name
  • Percent Excluded
  • Project ID
  • Status
  • Created
  • Last Modified
  • First Activated
  • Last Activated

  • Project ID

Fields

  • ID
  • Name
  • Percent Excluded
  • Project ID
  • Status
  • Created
  • Last Modified
  • First Activated
  • Last Activated

Experiments List

Parameters

  • Project ID

Fields

  • ID
  • Name
  • Type
  • Percent Excluded
  • Project ID
  • Status
  • Created
  • Last Modified
  • First Activated
  • Last Activated
  • URL in Editor
  • Targetting Conditions
  • Key

Audiences List

Parameters

  • Project ID

Fields

  • Project ID
  • ID
  • Name
  • Description
  • Archived
  • Created
  • Last Modified
  • Available for Segmentation
  • Is Classic Audience
  • Conditions

Pages List

Parameters

  • Project ID

Fields

  • Project ID
  • ID
  • Name
  • Description
  • URL
  • Archived
  • Created
  • Page Type
  • Category
  • Last Modified
  • Key
  • Conditions

Events List

Parameters

  • Project ID

Fields

  • Project ID
  • ID
  • Page ID
  • Name
  • Description
  • Category
  • Event Type
  • Key
  • Created
  • Is Classic

Experiment Results

Parameters

  • Project ID
  • Experiment ID

Fields

  • Metric name
  • Metric field
  • Metric aggregator
  • Variation Name
  • Variation ID
  • Is Baseline
  • Level
  • Rate
  • Samples
  • Value
  • Variance
  • Lift is Significant
  • Lift Status
  • Lift Significance
  • Lift Value
  • Visitors Remaining
  • Metric Scope
  • Metric Winning Direction

Access

Follow these steps to create an API key Once you create a key, click Settings in the connector interface and paste the key in the API Key field.

Add from Manager

The Optimizely X Connector is available in the Connectors Manager in the top ribbon:

Select the Business Intelligence category and install Optimizely X:


Contribute

This connector suite is open-sourced on GitHub.


See

Official Documentation

Optimizely X v2 REST API

Resources


Get help with this function in the community →