experiment

A Google ads experiment for users to experiment changes on multiple campaigns, compare the performance, and apply the effective changes.

Attributed resources
customer

Fields from the above resources may be selected along with this resource in your SELECT and WHERE clauses. These fields will not segment metrics in your SELECT clause.

Fields/Segments/Metrics

This page shows all metrics and segments that can be put in the same SELECT clause as the fields of experiment. However, when you specify experiment in the FROM clause, some metrics and segments cannot be used. Use the following filter to show only the fields that can be used when experiment is specified in the FROM clause.

Is experiment specified in the FROM clause of your query?

 Segments
date
 Metrics
clicks
clicks_margin_of_error
clicks_p_value
clicks_point_estimate
control_clicks
control_conversion_value
control_conversion_value_per_cost
control_conversions
control_cost_micros
control_cost_per_conversion
control_impressions
conversion_value_change_point_estimate
conversion_value_margin_of_error
conversion_value_p_value
conversion_value_per_cost_change_point_estimate
conversion_value_per_cost_margin_of_error
conversion_value_per_cost_p_value
conversions
conversions_absolute_change_margin_of_error
conversions_absolute_change_p_value
conversions_absolute_change_point_estimate
conversions_value
conversions_value_per_cost
cost_micros
cost_micros_change_point_estimate
cost_micros_margin_of_error
cost_micros_p_value
cost_per_conversion
cost_per_conversion_change_point_estimate
cost_per_conversion_margin_of_error
cost_per_conversion_p_value
impressions
impressions_margin_of_error
impressions_p_value
impressions_point_estimate

experiment.description

Field description

The description of the experiment. It must have a minimum length of 1 and maximum length of 2048.

CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

experiment.end_date

Field description

Date when the experiment ends. By default, the experiment ends on the campaign's end date. If this field is set, then the experiment ends at the end of the specified date in the customer's time zone. Format: YYYY-MM-DD Example: 2019-04-18

CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

experiment.experiment_id

Field description

Output only. The ID of the experiment. Read only.

CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

experiment.goals

Field description

The goals of this experiment.

CategoryATTRIBUTE
Data TypeMESSAGE
Type URLgoogle.ads.googleads.v24.common.MetricGoal
FilterableFalse
SelectableTrue
SortableFalse
RepeatedTrue

experiment.long_running_operation

Field description

Output only. The resource name of the long-running operation that can be used to poll for completion of experiment schedule or promote. The most recent long running operation is returned.

CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableFalse
SelectableTrue
SortableFalse
RepeatedFalse

experiment.name

Field description

Required. The name of the experiment. It must have a minimum length of 1 and maximum length of 1024. It must be unique under a customer.

CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

experiment.optimize_assets_experiment.optimize_assets_experiment_subtype

Field description

The subtype of the Optimize Assets experiment.

CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.googleads.v24.enums.OptimizeAssetsExperimentSubtypeEnum.OptimizeAssetsExperimentSubtype
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

experiment.promote_status

Field description

Output only. The status of the experiment promotion process.

CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.googleads.v24.enums.AsyncActionStatusEnum.AsyncActionStatus
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

experiment.resource_name

Field description

Immutable. The resource name of the experiment. Experiment resource names have the form: customers/{customer_id}/experiments/{experiment_id}

CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

experiment.start_date

Field description

Date when the experiment starts. By default, the experiment starts now or on the campaign's start date, whichever is later. If this field is set, then the experiment starts at the beginning of the specified date in the customer's time zone. Format: YYYY-MM-DD Example: 2019-03-14

CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

experiment.status

Field description

The Advertiser-chosen status of this experiment.

CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.googleads.v24.enums.ExperimentStatusEnum.ExperimentStatus
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

experiment.suffix

Field description

For system managed experiments, the advertiser must provide a suffix during construction, in the setup stage before moving to initiated. The suffix will be appended to the in-design and experiment campaign names so that the name is base campaign name + suffix.

CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

experiment.sync_enabled

Field description

Immutable. Set to true if changes to base campaigns should be synced to the trial campaigns. Any changes made directly to trial campaigns will be preserved. This field can only be set when the experiment is being created.

CategoryATTRIBUTE
Data TypeBOOLEAN
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

experiment.type

Field description

Required. The product/feature that uses this experiment.

CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.googleads.v24.enums.ExperimentTypeEnum.ExperimentType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

experiment.video_experiment.video_experiment_subtype

Field description

The subtype of the Video experiment.

CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.googleads.v24.enums.VideoExperimentSubtypeEnum.VideoExperimentSubtype
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.date

Field description

Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.

CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.clicks

Field description

The number of clicks.

CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.clicks_margin_of_error

Field description

The margin of error when estimating the experiment's effect on clicks.

Together with clicks_point_estimate, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment / control - 1). This field specifies the radius of the confidence interval, which is centered at clicks_point_estimate.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.clicks_p_value

Field description

The p-value for the null hypothesis that the experiment has no effect on clicks. Ranges from 0 to 1.

Say if the p-value is 0.03, that means the probability of observing the data, if the experiment has no effect on clicks, is 3%.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.clicks_point_estimate

Field description

The point estimate when estimating the experiment's effect on clicks.

Together with clicks_margin_of_error, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment / control - 1). This field specifies the point estimate, which is the center of the confidence interval: (clicks_point_estimate - clicks_margin_of_error, clicks_point_estimate + clicks_margin_of_error).

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.control_clicks

Field description

The number of clicks on the control arm of an experiment. The treatment clicks value can be selected by using clicks.

CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.control_conversion_value

Field description

The conversion value metric on the control arm of the experiment. The treatment conversion value can be selected by using conversions_value.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.control_conversion_value_per_cost

Field description

The conversion value per cost metric on the control arm of the experiment. The treatment conversion value per cost value can be selected by using conversions_value_per_cost.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.control_conversions

Field description

The conversions metric on the control arm of the experiment. The treatment conversions value can be selected by using conversions.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.control_cost_micros

Field description

The cost metric on the control arm of the experiment. The treatment cost value can be selected by using cost_micros.

CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.control_cost_per_conversion

Field description

The cost per conversion metric on the control arm of the experiment. The treatment cost per conversion value can be selected by using cost_per_conversion.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.control_impressions

Field description

The impressions metric on the control arm of the experiment. The treatment impressions value can be selected by using impressions.

CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversion_value_change_point_estimate

Field description

The point estimate when estimating the experiment's effect on conversion value change.

Together with conversion_value_margin_of_error, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment / control - 1). This field specifies the point estimate, which is the center of the confidence interval: (conversion_value_change_point_estimate - conversion_value_margin_of_error, conversion_value_change_point_estimate + conversion_value_margin_of_error).

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversion_value_margin_of_error

Field description

The margin of error when estimating the experiment's effect on conversion value.

Together with conversion_value_change_point_estimate, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment / control - 1). This field specifies the radius of the confidence interval, which is centered at conversion_value_change_point_estimate.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversion_value_p_value

Field description

The p-value for the null hypothesis that the experiment has no effect on conversion value. Ranges from 0 to 1.

Say if the p-value is 0.03, that means the probability of observing the data, if the experiment has no effect on conversion value, is 3%.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversion_value_per_cost_change_point_estimate

Field description

The point estimate when estimating the experiment's effect on conversion value per cost change.

Together with conversion_value_per_cost_margin_of_error, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment / control - 1). This field specifies the point estimate, which is the center of the confidence interval: (conversion_value_per_cost_change_point_estimate - conversion_value_per_cost_margin_of_error, conversion_value_per_cost_change_point_estimate + conversion_value_per_cost_margin_of_error).

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversion_value_per_cost_margin_of_error

Field description

The margin of error when estimating the experiment's effect on conversion value per cost.

Together with conversion_value_per_cost_change_point_estimate, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment / control - 1). This field specifies the radius of the confidence interval, which is centered at conversion_value_per_cost_change_point_estimate.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversion_value_per_cost_p_value

Field description

The p-value for the null hypothesis that the experiment has no effect on conversion value per cost. Ranges from 0 to 1.

Say if the p-value is 0.03, that means the probability of observing the data, if the experiment has no effect on conversion value per cost, is 3%.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversions

Field description

The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversions_absolute_change_margin_of_error

Field description

The margin of error when estimating the experiment's effect on conversions absolute change.

Together with conversions_absolute_change_point_estimate, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment - control). This field specifies the radius of the confidence interval, which is centered at conversions_absolute_change_point_estimate.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversions_absolute_change_p_value

Field description

The p-value for the null hypothesis that the experiment has no effect on conversions absolute change. Ranges from 0 to 1.

Say if the p-value is 0.03, that means the probability of observing the data, if the experiment has no effect on conversions absolute change, is 3%.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversions_absolute_change_point_estimate

Field description

The point estimate when estimating the experiment's effect on conversions absolute change.

Together with conversions_absolute_change_margin_of_error, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment - control). This field specifies the point estimate, which is the center of the confidence interval: (conversions_absolute_change_point_estimate - conversions_absolute_change_margin_of_error, conversions_absolute_change_point_estimate + conversions_absolute_change_margin_of_error).

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversions_value

Field description

The value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.conversions_value_per_cost

Field description

The value of conversions divided by the cost of ad interactions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.cost_micros

Field description

The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.

CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.cost_micros_change_point_estimate

Field description

The point estimate when estimating the experiment's effect on cost change.

Together with cost_micros_margin_of_error, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment / control - 1). This field specifies the point estimate, which is the center of the confidence interval: (cost_micros_change_point_estimate - cost_micros_margin_of_error, cost_micros_change_point_estimate + cost_micros_margin_of_error).

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.cost_micros_margin_of_error

Field description

The margin of error when estimating the experiment's effect on cost.

Together with cost_micros_change_point_estimate, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment / control - 1). This field specifies the radius of the confidence interval, which is centered at cost_micros_change_point_estimate.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.cost_micros_p_value

Field description

The p-value for the null hypothesis that the experiment has no effect on cost. Ranges from 0 to 1.

Say if the p-value is 0.03, that means the probability of observing the data, if the experiment has no effect on cost, is 3%.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.cost_per_conversion

Field description

The cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.cost_per_conversion_change_point_estimate

Field description

The point estimate when estimating the experiment's effect on cost per conversion change.

Together with cost_per_conversion_margin_of_error, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment / control - 1). This field specifies the point estimate, which is the center of the confidence interval: (cost_per_conversion_change_point_estimate - cost_per_conversion_margin_of_error, cost_per_conversion_change_point_estimate + cost_per_conversion_margin_of_error).

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.cost_per_conversion_margin_of_error

Field description

The margin of error when estimating the experiment's effect on cost per conversion.

Together with cost_per_conversion_change_point_estimate, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment / control - 1). This field specifies the radius of the confidence interval, which is centered at cost_per_conversion_change_point_estimate.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.cost_per_conversion_p_value

Field description

The p-value for the null hypothesis that the experiment has no effect on cost per conversion. Ranges from 0 to 1.

Say if the p-value is 0.03, that means the probability of observing the data, if the experiment has no effect on cost per conversion, is 3%.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.impressions

Field description

Count of how often your ad has appeared on a search results page or website on the Google Network.

CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.impressions_margin_of_error

Field description

The margin of error when estimating the experiment's effect on impressions.

Together with impressions_point_estimate, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment / control - 1). This field specifies the radius of the confidence interval, which is centered at impressions_point_estimate.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.impressions_p_value

Field description

The p-value for the null hypothesis that the experiment has no effect on impressions. Ranges from 0 to 1.

Say if the p-value is 0.03, that means the probability of observing the data, if the experiment has no effect on impressions, is 3%.

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with

metrics.impressions_point_estimate

Field description

The point estimate when estimating the experiment's effect on impressions.

Together with impressions_margin_of_error, they describe a confidence interval with a prescribed confidence level for the difference being estimated. The quantity being estimated is (treatment / control - 1). This field specifies the point estimate, which is the center of the confidence interval: (impressions_point_estimate - impressions_margin_of_error, impressions_point_estimate + impressions_margin_of_error).

CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse
Selectable with