ad_group_ad_asset_view

Help me build a query

A link between an AdGroupAd and an Asset. AdGroupAdAssetView supports AppAds, Demand Gen campaigns, and Responsive Search Ads.

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

Is ad_group_ad_asset_view specified in the FROM clause of your query?

No Yes, it is

Resource fields ad_group_ad asset enabled field_type performance_label pinned_field policy_summary resource_name source

Segments ad_format_type ad_network_type conversion_action date day_of_week device month quarter slot week year

Metrics all_conversions all_conversions_from_interactions_rate all_conversions_value all_conversions_value_per_cost average_cost average_cpc average_cpe average_cpm biddable_app_install_conversions biddable_app_post_install_conversions clicks conversions conversions_from_interactions_rate conversions_value conversions_value_per_cost cost_micros cost_per_all_conversions cost_per_conversion cross_device_conversions ctr engagement_rate engagements impressions interaction_event_types interaction_rate interactions trueview_average_cpv value_per_all_conversions value_per_conversion video_trueview_view_rate video_trueview_views view_through_conversions

ad_group_ad_asset_view.ad_group_ad Field description Output only. The ad group ad to which the asset is linked. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

ad_group_ad_asset_view.asset Field description Output only. The asset which is linked to the ad group ad. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

ad_group_ad_asset_view.enabled Field description Output only. The status between the asset and the latest version of the ad. If true, the asset is linked to the latest version of the ad. If false, it means the link once existed but has been removed and is no longer present in the latest version of the ad. Category ATTRIBUTE Data Type BOOLEAN Type URL N/A Filterable True Selectable True Sortable True Repeated False

ad_group_ad_asset_view.field_type Field description Output only. Role that the asset takes in the ad. Category ATTRIBUTE Data Type ENUM AD_IMAGE BOOK_ON_GOOGLE BUSINESS_LOGO BUSINESS_MESSAGE BUSINESS_NAME CALL CALLOUT CALL_TO_ACTION_SELECTION DEMAND_GEN_CAROUSEL_CARD DESCRIPTION HEADLINE HOTEL_CALLOUT HOTEL_PROPERTY LANDING_PAGE_PREVIEW LANDSCAPE_LOGO LEAD_FORM LOGO LONG_HEADLINE MANDATORY_AD_TEXT MARKETING_IMAGE MEDIA_BUNDLE MOBILE_APP PORTRAIT_MARKETING_IMAGE PRICE PROMOTION RELATED_YOUTUBE_VIDEOS SITELINK SQUARE_MARKETING_IMAGE STRUCTURED_SNIPPET TALL_PORTRAIT_MARKETING_IMAGE UNKNOWN UNSPECIFIED VIDEO YOUTUBE_VIDEO Type URL google.ads.googleads.v22.enums.AssetFieldTypeEnum.AssetFieldType Filterable True Selectable True Sortable True Repeated False

ad_group_ad_asset_view.performance_label Field description Output only. Performance of an asset linkage. Category ATTRIBUTE Data Type ENUM BEST GOOD LEARNING LOW PENDING UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v22.enums.AssetPerformanceLabelEnum.AssetPerformanceLabel Filterable True Selectable True Sortable True Repeated False

ad_group_ad_asset_view.pinned_field Field description Output only. Pinned field. Category ATTRIBUTE Data Type ENUM AD_IMAGE BUSINESS_LOGO BUSINESS_NAME BUSINESS_NAME_IN_PORTRAIT CALL CALLOUT CALL_TO_ACTION DESCRIPTION DESCRIPTION_1 DESCRIPTION_2 DESCRIPTION_IN_PORTRAIT DESCRIPTION_PREFIX HEADLINE HEADLINE_1 HEADLINE_2 HEADLINE_3 HEADLINE_IN_PORTRAIT LANDSCAPE_LOGO LEAD_FORM LOGO LONG_HEADLINE MARKETING_IMAGE MARKETING_IMAGE_IN_PORTRAIT MOBILE_APP PORTRAIT_MARKETING_IMAGE PRICE PROMOTION SITELINK SQUARE_MARKETING_IMAGE STRUCTURED_SNIPPET UNKNOWN UNSPECIFIED YOU_TUBE_VIDEO Type URL google.ads.googleads.v22.enums.ServedAssetFieldTypeEnum.ServedAssetFieldType Filterable True Selectable True Sortable True Repeated False

ad_group_ad_asset_view.policy_summary Field description Output only. Policy information for the ad group ad asset. Category ATTRIBUTE Data Type MESSAGE Type URL google.ads.googleads.v22.resources.AdGroupAdAssetPolicySummary Filterable False Selectable True Sortable False Repeated False

ad_group_ad_asset_view.resource_name Field description Output only. The resource name of the ad group ad asset view. Ad group ad asset view resource names have the form (Before V4): customers/{customer_id}/adGroupAdAssets/{AdGroupAdAsset.ad_group_id}~{AdGroupAdAsset.ad.ad_id}~{AdGroupAdAsset.asset_id}~{AdGroupAdAsset.field_type} Ad group ad asset view resource names have the form (Beginning from V4): customers/{customer_id}/adGroupAdAssetViews/{AdGroupAdAsset.ad_group_id}~{AdGroupAdAsset.ad_id}~{AdGroupAdAsset.asset_id}~{AdGroupAdAsset.field_type} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

ad_group_ad_asset_view.source Field description Output only. Source of the ad group ad asset. Category ATTRIBUTE Data Type ENUM ADVERTISER AUTOMATICALLY_CREATED UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v22.enums.AssetSourceEnum.AssetSource Filterable True Selectable True Sortable True Repeated False

segments.ad_format_type Field description Ad Format type. Category SEGMENT Data Type ENUM AUDIO BUMPER INFEED INSTREAM_NON_SKIPPABLE INSTREAM_SKIPPABLE MASTHEAD OTHER OUTSTREAM PAUSE SHORTS UNKNOWN UNSEGMENTED UNSPECIFIED Type URL google.ads.googleads.v22.enums.AdFormatTypeEnum.AdFormatType Filterable True Selectable True Sortable True Repeated False

segments.ad_network_type Field description Ad network type. Category SEGMENT Data Type ENUM CONTENT DISCOVER GMAIL GOOGLE_OWNED_CHANNELS GOOGLE_TV MAPS MIXED SEARCH SEARCH_PARTNERS UNKNOWN UNSPECIFIED YOUTUBE Type URL google.ads.googleads.v22.enums.AdNetworkTypeEnum.AdNetworkType Filterable True Selectable True Sortable True Repeated False

segments.conversion_action Field description Resource name of the conversion action. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A 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.day_of_week Field description Day of the week, for example, MONDAY. Category SEGMENT Data Type ENUM FRIDAY MONDAY SATURDAY SUNDAY THURSDAY TUESDAY UNKNOWN UNSPECIFIED WEDNESDAY Type URL google.ads.googleads.v22.enums.DayOfWeekEnum.DayOfWeek 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.v22.enums.DeviceEnum.Device 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.slot Field description Position of the ad. Category SEGMENT Data Type ENUM CONTENT MIXED SEARCH_OTHER SEARCH_PARTNER_OTHER SEARCH_PARTNER_TOP SEARCH_SIDE SEARCH_TOP UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v22.enums.SlotEnum.Slot 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.all_conversions Field description The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_from_interactions_rate Field description All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_value Field description The value of all conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_value_per_cost Field description The value of all conversions divided by the total cost of ad interactions (such as clicks for text ads or views for video ads). Category METRIC Data Type DOUBLE 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_cpc Field description The total cost of all clicks divided by the total number of clicks received. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.average_cpe Field description The average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.average_cpm Field description Average cost-per-thousand impressions (CPM). Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.biddable_app_install_conversions Field description Number of app installs. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.biddable_app_post_install_conversions Field description Number of in-app actions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.clicks Field description The number of clicks. Category METRIC Data Type INT64 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.conversions_from_interactions_rate Field description Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). 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.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. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

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

metrics.cost_micros Field description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.cost_per_all_conversions Field description The cost of ad interactions divided by all 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.cross_device_conversions Field description Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.ctr Field description The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.engagement_rate Field description How often people engage with your ad after it's shown to them. This is the number of ad expansions 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.engagements Field description The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.impressions Field description Count of how often your ad has appeared on a search results page or website on the Google Network. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.interaction_event_types Field description The types of payable and free interactions. Category METRIC Data Type ENUM Type URL google.ads.googleads.v22.enums.InteractionEventTypeEnum.InteractionEventType Filterable True Selectable True Sortable False Repeated True

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

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

metrics.value_per_all_conversions Field description The value of all conversions divided by the number of all conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.value_per_conversion Field description The value of conversions divided by 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.video_trueview_view_rate Field description The number of TrueView views your video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.video_trueview_views Field description The number of TrueView views your video ads received. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.view_through_conversions Field description The 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. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False