Skip to main content
menu_icon.png

Have questions about site performance or Google's upcoming search changes? Join our AMA, hosted by Michael Hood (Senior Performance Engineer) on Wednesday, July 11th at 8:30am PST.

x
Optimizely Knowledge Base

Reference for columns in CSV export files for campaigns and experiments

relevant products:
  • Optimizely X Web Experimentation
  • Optimizely X Web Personalization
  • Optimizely X Web Recommendations
  • Optimizely X Full Stack

THIS ARTICLE WILL HELP YOU:
  • Identify the columns in CSV export files for campaigns and experiments

You can export your campaign and experiment results as a CSV file using both our REST API as well as through the web app. The tables below describe each column contained in those CSV export files.

When the feature goes GA, change the "through the web app" link so it references the Results page (and not the Results beta page).

The following columns will appear in CSV export files in the order listed.

Columns in CSV export files for Personalization campaigns

Column Type Description
Start Time (UTC) datetime Start time used to calculate the results in UTC time.
End Time (UTC) datetime End time used to calculate the results in UTC time.
Is Baseline Experience boolean Indicates if the results are for the baseline experience.
Metric Event Name string The metric’s name.
Metric Event ID int The metric’s event ID.
Metric Numerator Type string The numerator of the metric, for example unique conversions.
Metric Denominator Type string The denominator of the metric. Possible values include visitor, session or conversion.
Metric Winning Direction string The winning direction of the metric. Possible values include increasing or decreasing.
Numerator Value int The value of the numerator.
Denominator Value int The value of the denominator.
Metric Value float The value of the metric after dividing the numerator value over the denominator value.
Improvement Status from Baseline string Indicates if the improvement is better, worse or n/a compared to baseline experience.
Improvement Value from Baseline float The improvement in the metric’s value compared to the baseline experience.
Statistical Significance float The improvement's statistical confidence score.
Is Improvement Significant boolean Indicates if the improvement has reached statistical significance.
Confidence Interval - Low float The lower bound of the improvement's confidence interval.
Confidence Interval - High float The upper bound of the improvement's confidence interval.
Samples Remaining to Significance integer The estimated number of samples remaining to reach statistical significance.

 

Columns in CSV export files for experiments

Column Type Description
Start Time (UTC) datetime Start time used to calculate the results in UTC time.
End Time (UTC) datetime End time used to calculate the results in UTC time.
Variation Name string The variation’s name.
Variation ID int The variation’s ID.
Is Baseline Variation boolean Indicates if the results are for the baseline variation.
Metric Event Name string The metric’s name.
Metric Event ID int The metric’s event ID.
Metric Numerator Type string The numerator of the metric, for example unique conversions.
Metric Denominator Type string The denominator of the metric. Possible values include visitor, session or conversion.
Metric Winning Direction string The winning direction of the metric. Possible values include increasing or decreasing.
Numerator Value int The value of the numerator.
Denominator Value int The value of the denominator.
Metric Value float The value of the metric after dividing the numerator value over the denominator value.
Improvement Status from Baseline string Indicates if the improvement is better, worse or n/a compared to baseline experience.
Improvement Value from Baseline float The improvement in the metric’s value compared to the baseline experience.
Statistical Significance float The improvement's statistical confidence score.
Is Improvement Significant boolean Indicates if the improvement has reached statistical significance.
Confidence Interval - Low float The lower bound of the improvement's confidence interval.
Confidence Interval - High float The upper bound of the improvement's confidence interval.
Samples Remaining to Significance integer The estimated number of samples remaining to reach statistical significance.