campaign_group

Help me build a query

A campaign group.

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 campaign_group. However, when you specify campaign_group 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 campaign_group is specified in the FROM clause.

Is campaign_group specified in the FROM clause of your query?

No Yes, it is

Resource fields id name resource_name status

Segments ad_destination_type date device hour month quarter week year

Metrics average_cost average_cpv conversions cost_per_conversion interaction_rate interactions

campaign_group.id Field description Output only. The ID of the campaign group. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

campaign_group.name Field description The name of the campaign group. This field is required and should not be empty when creating new campaign groups. 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_group.resource_name Field description Immutable. The resource name of the campaign group. Campaign group resource names have the form: customers/{customer_id}/campaignGroups/{campaign_group_id} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

campaign_group.status Field description The status of the campaign group. When a new campaign group is added, the status defaults to ENABLED. Category ATTRIBUTE Data Type ENUM ENABLED REMOVED UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v16.enums.CampaignGroupStatusEnum.CampaignGroupStatus Filterable True Selectable True Sortable True Repeated False

segments.ad_destination_type Field description Ad Destination type. Category SEGMENT Data Type ENUM APP_DEEP_LINK APP_STORE LEAD_FORM LOCATION_LISTING MAP_DIRECTIONS MESSAGE NOT_APPLICABLE PHONE_CALL UNKNOWN UNMODELED_FOR_CONVERSIONS UNSPECIFIED WEBSITE YOUTUBE Type URL google.ads.googleads.v16.enums.AdDestinationTypeEnum.AdDestinationType Filterable True Selectable True Sortable True Repeated False

segments.date Field description Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.device Field description Device to which metrics apply. Category SEGMENT Data Type ENUM CONNECTED_TV DESKTOP MOBILE OTHER TABLET UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v16.enums.DeviceEnum.Device Filterable True Selectable True Sortable True Repeated False

segments.hour Field description Hour of day as a number between 0 and 23, inclusive. Category SEGMENT Data Type INT32 Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.month Field description Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.quarter Field description Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, for example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.week Field description Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.year Field description Year, formatted as yyyy. Category SEGMENT Data Type INT32 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.average_cost Field description The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.average_cpv Field description The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

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. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

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. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.interaction_rate Field description How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.interactions Field description The number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False