channel_aggregate_asset_view

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

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.

Segmenting resources
asset

Fields from the above resources, when selected along with this resource in your SELECT and WHERE clauses, will segment metrics.

Fields/Segments/Metrics

This page shows all metrics and segments that can be put in the same SELECT clause as the fields of channel_aggregate_asset_view. However, when you specify channel_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 channel_aggregate_asset_view is specified in the FROM clause.

Is channel_aggregate_asset_view specified in the FROM clause of your query?

Resource fields
advertising_channel_type
asset
asset_source
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

channel_aggregate_asset_view.advertising_channel_type
Field description	Output only. Channel in which the asset served.
Category	`ATTRIBUTE`
Data Type	`ENUM DEMAND_GEN DISPLAY HOTEL LOCAL LOCAL_SERVICES MULTI_CHANNEL PERFORMANCE_MAX SEARCH SHOPPING SMART TRAVEL UNKNOWN UNSPECIFIED VIDEO`
Type URL	`google.ads.googleads.v18.enums.AdvertisingChannelTypeEnum.AdvertisingChannelType`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

channel_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

channel_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.v18.enums.AssetSourceEnum.AssetSource`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

channel_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.v18.enums.AssetFieldTypeEnum.AssetFieldType`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

channel_aggregate_asset_view.resource_name
Field description	Output only. The resource name of the channel aggregate asset view. Channel aggregate asset view resource names have the form: `customers/{customer_id}/channelAggregateAssetViews/{ChannelAssetV2.advertising_channel_type}~{ChannelAssetV2.asset_id}~{ChannelAssetV2.asset_source}~{ChannelAssetV2.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.v18.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

channel_aggregate_asset_view

Fields/Segments/Metrics

channel_aggregate_asset_view.advertising_channel_type

channel_aggregate_asset_view.asset

channel_aggregate_asset_view.asset_source

channel_aggregate_asset_view.field_type

channel_aggregate_asset_view.resource_name

segments.date

segments.day_of_week

segments.month

segments.quarter

segments.week

segments.year

metrics.asset_best_performance_cost_percentage

metrics.asset_best_performance_impression_percentage

metrics.asset_good_performance_cost_percentage

metrics.asset_good_performance_impression_percentage

metrics.asset_learning_performance_cost_percentage

metrics.asset_learning_performance_impression_percentage

metrics.asset_low_performance_cost_percentage

metrics.asset_low_performance_impression_percentage

metrics.asset_pinned_as_description_position_one_count

metrics.asset_pinned_as_description_position_two_count

metrics.asset_pinned_as_headline_position_one_count

metrics.asset_pinned_as_headline_position_three_count

metrics.asset_pinned_as_headline_position_two_count

metrics.asset_pinned_total_count

metrics.asset_unrated_performance_cost_percentage

metrics.asset_unrated_performance_impression_percentage

metrics.impressions

metrics.linked_entities_count

metrics.linked_sample_entities

metrics.sample_best_performance_entities

metrics.sample_good_performance_entities

metrics.sample_learning_performance_entities

metrics.sample_low_performance_entities

metrics.sample_unrated_performance_entities