ad_group_ad

An ad group ad.

Attributed resources
ad_group
campaign
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 ad_group_ad. However, when you specify ad_group_ad 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 ad_group_ad is specified in the FROM clause.

Is ad_group_ad specified in the FROM clause of your query?

 Resource fields
ad.display_url
ad.expanded_dynamic_search_ad.ad_tracking_id
ad.expanded_dynamic_search_ad.description1
ad.expanded_dynamic_search_ad.description2
ad.expanded_text_ad.ad_tracking_id
ad.expanded_text_ad.description1
ad.expanded_text_ad.description2
ad.expanded_text_ad.headline
ad.expanded_text_ad.headline2
ad.expanded_text_ad.headline3
ad.expanded_text_ad.path1
ad.expanded_text_ad.path2
ad.final_urls
ad.id
ad.name
ad.resource_name
ad.responsive_search_ad.ad_tracking_id
ad.responsive_search_ad.descriptions
ad.responsive_search_ad.headlines
ad.responsive_search_ad.path1
ad.responsive_search_ad.path2
ad.text_ad.ad_tracking_id
ad.text_ad.description1
ad.text_ad.description2
ad.text_ad.display_mobile_url
ad.text_ad.display_url
ad.text_ad.headline
ad.type
creation_time
engine_id
engine_status
labels
last_modified_time
resource_name
status
 Segments
ad_network_type
conversion_action_name
date
device
keyword.ad_group_criterion
keyword.info.match_type
keyword.info.text
month
quarter
week
year
 Metrics
all_conversions
all_conversions_by_conversion_date
all_conversions_value
all_conversions_value_by_conversion_date
average_cpc
average_cpm
clicks
client_account_conversions
client_account_conversions_value
client_account_view_through_conversions
conversions
conversions_value
cost_micros
cross_device_conversions
cross_device_conversions_by_conversion_date
cross_device_conversions_value
cross_device_conversions_value_by_conversion_date
ctr
impressions
visits

ad_group_ad.ad.display_url

Field descriptionThe URL that appears in the ad description for some ad formats.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.expanded_dynamic_search_ad.ad_tracking_id

Field descriptionThe tracking id of the ad.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.expanded_dynamic_search_ad.description1

Field descriptionThe first line of the ad's description.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.expanded_dynamic_search_ad.description2

Field descriptionThe second line of the ad's description.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.expanded_text_ad.ad_tracking_id

Field descriptionThe tracking id of the ad.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.expanded_text_ad.description1

Field descriptionThe first line of the ad's description.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.expanded_text_ad.description2

Field descriptionThe second line of the ad's description.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.expanded_text_ad.headline

Field descriptionThe headline of the ad.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.expanded_text_ad.headline2

Field descriptionThe second headline of the ad.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.expanded_text_ad.headline3

Field descriptionThe third headline of the ad.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.expanded_text_ad.path1

Field descriptionText appended to the auto-generated visible URL with a delimiter.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.expanded_text_ad.path2

Field descriptionText appended to path1 with a delimiter.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.final_urls

Field descriptionThe list of possible final URLs after all cross-domain redirects for the ad.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedTrue

ad_group_ad.ad.id

Field descriptionThe ID of the ad.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.name

Field descriptionThe name of the ad. This is only used to be able to identify the ad. It does not need to be unique and does not affect the served ad. The name field is currently only supported for DisplayUploadAd, ImageAd, ShoppingComparisonListingAd and VideoAd.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.resource_name

Field descriptionThe resource name of the ad. Ad resource names have the form: customers/{customer_id}/ads/{ad_id}
CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

ad_group_ad.ad.responsive_search_ad.ad_tracking_id

Field descriptionThe tracking id of the ad.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.responsive_search_ad.descriptions

Field descriptionList of text assets for descriptions. When the ad serves the descriptions will be selected from this list.
CategoryATTRIBUTE
Data TypeMESSAGE
Type URLgoogle.ads.searchads360.v0.common.AdTextAsset
FilterableFalse
SelectableTrue
SortableFalse
RepeatedTrue

ad_group_ad.ad.responsive_search_ad.headlines

Field descriptionList of text assets for headlines. When the ad serves the headlines will be selected from this list.
CategoryATTRIBUTE
Data TypeMESSAGE
Type URLgoogle.ads.searchads360.v0.common.AdTextAsset
FilterableFalse
SelectableTrue
SortableFalse
RepeatedTrue

ad_group_ad.ad.responsive_search_ad.path1

Field descriptionText appended to the auto-generated visible URL with a delimiter.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.responsive_search_ad.path2

Field descriptionText appended to path1 with a delimiter.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.text_ad.ad_tracking_id

Field descriptionThe tracking id of the ad.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.text_ad.description1

Field descriptionThe first line of the ad's description.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.text_ad.description2

Field descriptionThe second line of the ad's description.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.text_ad.display_mobile_url

Field descriptionThe displayed mobile URL of the ad.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.text_ad.display_url

Field descriptionThe displayed URL of the ad.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.text_ad.headline

Field descriptionThe headline of the ad.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.ad.type

Field descriptionThe type of ad.
CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.searchads360.v0.enums.AdTypeEnum.AdType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.creation_time

Field descriptionThe timestamp when this ad_group_ad was created. The datetime is in the customer's time zone and in "yyyy-MM-dd HH:mm:ss.ssssss" format.
CategoryATTRIBUTE
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.engine_id

Field descriptionID of the ad in the external engine account. This field is for Search Ads 360 account only, for example, Yahoo Japan, Microsoft, Baidu etc. For non-Search Ads 360 entity, use "ad_group_ad.ad.id" instead.
CategoryATTRIBUTE
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.engine_status

Field descriptionAdditional status of the ad in the external engine account. Possible statuses (depending on the type of external account) include active, eligible, pending review, etc.
CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.searchads360.v0.enums.AdGroupAdEngineStatusEnum.AdGroupAdEngineStatus
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.labels

Field descriptionThe resource names of labels attached to this ad group ad.
CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedTrue

ad_group_ad.last_modified_time

Field descriptionThe datetime when this ad group ad was last modified. The datetime is in the customer's time zone and in "yyyy-MM-dd HH:mm:ss.ssssss" format.
CategoryATTRIBUTE
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

ad_group_ad.resource_name

Field descriptionThe resource name of the ad. Ad group ad resource names have the form: customers/{customer_id}/adGroupAds/{ad_group_id}~{ad_id}
CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

ad_group_ad.status

Field descriptionThe status of the ad.
CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.searchads360.v0.enums.AdGroupAdStatusEnum.AdGroupAdStatus
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.ad_network_type

Field descriptionAd network type.
CategorySEGMENT
Data Type
Type URLgoogle.ads.searchads360.v0.enums.AdNetworkTypeEnum.AdNetworkType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.conversion_action_name

Field descriptionConversion action name.
CategorySEGMENT
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.date

Field descriptionDate to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.device

Field descriptionDevice to which metrics apply.
CategorySEGMENT
Data Type
Type URLgoogle.ads.searchads360.v0.enums.DeviceEnum.Device
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.keyword.ad_group_criterion

Field descriptionThe AdGroupCriterion resource name.
CategorySEGMENT
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

segments.keyword.info.match_type

Field descriptionThe match type of the keyword.
CategorySEGMENT
Data Type
Type URLgoogle.ads.searchads360.v0.enums.KeywordMatchTypeEnum.KeywordMatchType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.keyword.info.text

Field descriptionThe text of the keyword (at most 80 characters and 10 words).
CategorySEGMENT
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.month

Field descriptionMonth as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.quarter

Field descriptionQuarter 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.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.week

Field descriptionWeek as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.year

Field descriptionYear, formatted as yyyy.
CategorySEGMENT
Data TypeINT32
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.all_conversions

Field descriptionThe total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.all_conversions_by_conversion_date

Field descriptionThe total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.all_conversions_value

Field descriptionThe value of all conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.all_conversions_value_by_conversion_date

Field descriptionThe value of all conversions. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.average_cpc

Field descriptionThe total cost of all clicks divided by the total number of clicks received. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.average_cpm

Field descriptionAverage cost-per-thousand impressions (CPM). This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.clicks

Field descriptionThe number of clicks.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.client_account_conversions

Field descriptionThe number of client account conversions. This only includes conversion actions which include_in_client_account_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

metrics.client_account_conversions_value

Field descriptionThe value of client account conversions. This only includes conversion actions which include_in_client_account_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

metrics.client_account_view_through_conversions

Field descriptionThe total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (for example, clicking on) another ad.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.conversions

Field descriptionThe 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

metrics.conversions_value

Field descriptionThe sum of conversion values for the conversions included in the "conversions" field. This metric is useful only if you entered a value for your conversion actions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cost_micros

Field descriptionThe sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cross_device_conversions

Field descriptionConversions from when a customer clicks on an ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cross_device_conversions_by_conversion_date

Field descriptionThe number of cross-device conversions by conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cross_device_conversions_value

Field descriptionThe sum of the value of cross-device conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cross_device_conversions_value_by_conversion_date

Field descriptionThe sum of cross-device conversions value by conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.ctr

Field descriptionThe number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.impressions

Field descriptionCount 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

metrics.visits

Field descriptionClicks that Search Ads 360 has successfully recorded and forwarded to an advertiser's landing page.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse