Reference for columns in CSV export files for campaigns and experiments

2 min

Optimizely Web Experimentation

Optimizely Personalization

You can export your campaign and experiment results as a CSV file using the Optimizely REST APIOptimizely REST API and through the web app for Optimizely Web ExperimentationOptimizely Web Experimentation and Optimizely Personalization.

The following columns display in CSV export files in the order listed.

Columns in CSV export files for Optimizely Personalization campaigns

Column	Description	Type
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 significancestatistical significance.
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 significancestatistical significance.
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.