campaign_experiment

Help me build a query

An A/B experiment that compares the performance of the base campaign (the control) and a variation of that campaign (the experiment).

Attributed resources
campaign
campaign_draft
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.

campaign_experiment.campaign_draft Field description Immutable. The campaign draft with staged changes to the base campaign. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

campaign_experiment.description Field description The description of the experiment. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

campaign_experiment.end_date Field description The last day of the campaign experiment. 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 Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

campaign_experiment.experiment_campaign Field description Output only. The experiment campaign, as opposed to the base campaign. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable True Repeated False

campaign_experiment.id Field description Output only. The ID of the campaign experiment. This field is read-only. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

campaign_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 create or promote. The most recent long running operation is returned. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable False Selectable True Sortable False Repeated False

campaign_experiment.name Field description The name of the campaign experiment. This field is required when creating new campaign experiments and must not conflict with the name of another non-removed campaign experiment or campaign. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

campaign_experiment.resource_name Field description Immutable. The resource name of the campaign experiment. Campaign experiment resource names have the form: customers/{customer_id}/campaignExperiments/{campaign_experiment_id} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

campaign_experiment.start_date Field description Date when the campaign 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. Cannot be changed once the experiment starts. Format: YYYY-MM-DD Example: 2019-03-14 Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

campaign_experiment.status Field description Output only. The status of the campaign experiment. This field is read-only. Category ATTRIBUTE Data Type ENUM ENABLED ENDED_MANUALLY GRADUATED INITIALIZATION_FAILED INITIALIZING PROMOTED PROMOTING PROMOTION_FAILED REMOVED UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v11.enums.CampaignExperimentStatusEnum.CampaignExperimentStatus Filterable True Selectable True Sortable True Repeated False

campaign_experiment.traffic_split_percent Field description Immutable. Share of traffic directed to experiment as a percent (must be between 1 and 99 inclusive. Base campaign receives the remainder of the traffic (100 - traffic_split_percent). Required for create. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

campaign_experiment.traffic_split_type Field description Immutable. Determines the behavior of the traffic split. Category ATTRIBUTE Data Type ENUM COOKIE RANDOM_QUERY UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v11.enums.CampaignExperimentTrafficSplitTypeEnum.CampaignExperimentTrafficSplitType Filterable True Selectable True Sortable True Repeated False