campaign_aggregate_asset_view

Help me build a query

A campaign-level aggregate asset view that shows where the asset is linked, performamce of the asset and stats.

Attributed resources
asset
campaign

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

Is campaign_aggregate_asset_view specified in the FROM clause of your query?

No Yes, it is

Resource fields asset asset_source campaign field_type resource_name

Segments date day_of_week month quarter week year

Metrics asset_best_performance_cost_percentage asset_best_performance_impression_percentage asset_good_performance_cost_percentage asset_good_performance_impression_percentage asset_learning_performance_cost_percentage asset_learning_performance_impression_percentage asset_low_performance_cost_percentage asset_low_performance_impression_percentage asset_pinned_as_description_position_one_count asset_pinned_as_description_position_two_count asset_pinned_as_headline_position_one_count asset_pinned_as_headline_position_three_count asset_pinned_as_headline_position_two_count asset_pinned_total_count asset_unrated_performance_cost_percentage asset_unrated_performance_impression_percentage impressions linked_entities_count linked_sample_entities sample_best_performance_entities sample_good_performance_entities sample_learning_performance_entities sample_low_performance_entities sample_unrated_performance_entities

campaign_aggregate_asset_view.asset Field description Output only. The ID of the asset. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

campaign_aggregate_asset_view.asset_source Field description Output only. Source of the asset link. Category ATTRIBUTE Data Type ENUM ADVERTISER AUTOMATICALLY_CREATED UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v17.enums.AssetSourceEnum.AssetSource Filterable True Selectable True Sortable True Repeated False

campaign_aggregate_asset_view.campaign Field description Output only. Campaign in which the asset served. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

campaign_aggregate_asset_view.field_type Field description Output only. FieldType of the asset. Category ATTRIBUTE Data Type ENUM AD_IMAGE BOOK_ON_GOOGLE BUSINESS_LOGO BUSINESS_NAME CALL CALLOUT CALL_TO_ACTION_SELECTION DEMAND_GEN_CAROUSEL_CARD DESCRIPTION HEADLINE HOTEL_CALLOUT HOTEL_PROPERTY LANDSCAPE_LOGO LEAD_FORM LOGO LONG_HEADLINE MANDATORY_AD_TEXT MARKETING_IMAGE MEDIA_BUNDLE MOBILE_APP PORTRAIT_MARKETING_IMAGE PRICE PROMOTION SITELINK SQUARE_MARKETING_IMAGE STRUCTURED_SNIPPET UNKNOWN UNSPECIFIED VIDEO YOUTUBE_VIDEO Type URL google.ads.googleads.v17.enums.AssetFieldTypeEnum.AssetFieldType Filterable True Selectable True Sortable True Repeated False

campaign_aggregate_asset_view.resource_name Field description Output only. The resource name of the campaign aggregate asset view. Campaign aggregate asset view resource names have the form: customers/{customer_id}/campaignAggregateAssetViews/{Campaign.campaign_id}~{Asset.asset_id}~{AssetLinkSource.asset_link_source}~{AssetFieldType.field_type} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False 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.v17.enums.DayOfWeekEnum.DayOfWeek 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.asset_best_performance_cost_percentage Field description Percentage of cost the asset received in ads with AssetPerformanceLabel.BEST. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Performance Max channel. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_best_performance_impression_percentage Field description Percentage of impressions the asset received in ads with AssetPerformanceLabel.BEST. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Search channel. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_good_performance_cost_percentage Field description Percentage of cost the asset received in ads with AssetPerformanceLabel.GOOD. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Performance Max channel. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_good_performance_impression_percentage Field description Percentage of impressions the asset received in ads with AssetPerformanceLabel.GOOD. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Search channel. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_learning_performance_cost_percentage Field description Percentage of cost the asset received in ads with AssetPerformanceLabel.LEARNING. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Performance Max channel. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_learning_performance_impression_percentage Field description Percentage of impressions the asset received in ads with AssetPerformanceLabel.LEARNING. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Search channel. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_low_performance_cost_percentage Field description Percentage of cost the asset received in ads with AssetPerformanceLabel.LOW. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Performance Max channel. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_low_performance_impression_percentage Field description Percentage of impressions the asset received in ads with AssetPerformanceLabel.LOW. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Search channel. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_pinned_as_description_position_one_count Field description Number of entities in which the asset is pinned to description 1. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Search channel. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_pinned_as_description_position_two_count Field description Number of entities in which the asset is pinned to description 2. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Search channel. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_pinned_as_headline_position_one_count Field description Number of entities in which the asset is pinned to headline 1. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Search channel. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_pinned_as_headline_position_three_count Field description Number of entities in which the asset is pinned to headline 3. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Search channel. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_pinned_as_headline_position_two_count Field description Number of entities in which the asset is pinned to headline 2. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Search channel. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_pinned_total_count Field description Number of total usages in which the asset is pinned. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Search channel. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_unrated_performance_cost_percentage Field description Percentage of cost the asset received in ads with AssetPerformanceLabel other than BEST, GOOD, LOW, and LEARNING. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Performance Max channel. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.asset_unrated_performance_impression_percentage Field description Percentage of impressions the asset received in ads with AssetPerformanceLabel other than BEST, GOOD, LOW, and LEARNING. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. This metric is only supported in Search channel. Category METRIC Data Type DOUBLE 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.linked_entities_count Field description Number of linked resources in which the asset is used. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.linked_sample_entities Field description A list of up to 20 sample linked resources in which the asset is used. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. Category METRIC Data Type STRING Type URL N/A Filterable False Selectable True Sortable False Repeated True

metrics.sample_best_performance_entities Field description A list of up to 20 sample linked resources with impressions in the last 30 days where the asset had the AssetPerformanceLabel.BEST performance label. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. Category METRIC Data Type STRING Type URL N/A Filterable False Selectable True Sortable False Repeated True

metrics.sample_good_performance_entities Field description A list of up to 20 sample linked resources with impressions in the last 30 days where the asset had the AssetPerformanceLabel.GOOD performance label. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. Category METRIC Data Type STRING Type URL N/A Filterable False Selectable True Sortable False Repeated True

metrics.sample_learning_performance_entities Field description A list of up to 20 sample linked resources with impressions in the last 30 days where the asset had the AssetPerformanceLabel.LEARNING performance label. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. Category METRIC Data Type STRING Type URL N/A Filterable False Selectable True Sortable False Repeated True

metrics.sample_low_performance_entities Field description A list of up to 20 sample linked resources with impressions in the last 30 days where the asset had the AssetPerformanceLabel.LOW performance label. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. Category METRIC Data Type STRING Type URL N/A Filterable False Selectable True Sortable False Repeated True

metrics.sample_unrated_performance_entities Field description A list of up to 20 sample linked resources with impressions in the last 30 days where the assets had AssetPerformanceLabel performance label other than BEST, GOOD, LOW, and LEARNING. This metric can only be selected with ChannelAggregateAssetView and CampaignAggregateAssetView. Category METRIC Data Type STRING Type URL N/A Filterable False Selectable True Sortable False Repeated True