ADO.NET Provider for Google Ads

Build 26.0.9655

ChannelAggregateAssetView

A channel-level aggregate asset view that shows where the asset is linked,

Columns

Name Type Behavior Description
AssetDynamicCustomAsset String SEGMENT Required. ID which can be any sequence of letters and digits, and must be unique and match the values of remarketing tag, for example, sedan. Required.
ChannelAggregateAssetViewAdvertisingChannelType String ATTRIBUTE Output only. Channel in which the asset served.

The allowed values are DEMAND_GEN, DISPLAY, HOTEL, LOCAL, LOCAL_SERVICES, MULTI_CHANNEL, PERFORMANCE_MAX, SEARCH, SHOPPING, SMART, TRAVEL, UNKNOWN, VIDEO.

ChannelAggregateAssetViewAsset String ATTRIBUTE Output only. The ID of the asset.
ChannelAggregateAssetViewAssetSource String ATTRIBUTE Output only. Source of the asset link.

The allowed values are ADVERTISER, AUTOMATICALLY_CREATED, UNKNOWN.

ChannelAggregateAssetViewFieldType String ATTRIBUTE Output only. FieldType of the asset.

The allowed values are AD_IMAGE, BOOK_ON_GOOGLE, BUSINESS_LOGO, BUSINESS_MESSAGE, BUSINESS_NAME, CALL, CALLOUT, CALL_TO_ACTION, CALL_TO_ACTION_SELECTION, DEMAND_GEN_CAROUSEL_CARD, DESCRIPTION, HEADLINE, HOTEL_CALLOUT, HOTEL_PROPERTY, LANDING_PAGE_PREVIEW, LANDSCAPE_LOGO, LEAD_FORM, LOGO, LONG_DESCRIPTION, 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, VIDEO, YOUTUBE_VIDEO.

ChannelAggregateAssetViewResourceName String ATTRIBUTE Output only. The resource name of the channel aggregate asset view.
CustomerId Long ATTRIBUTE Output only. The ID of the customer.
AllConversions Double METRIC The total number of conversions. This includes all conversions regardless
AllConversionsFromInteractionsRate Double METRIC All conversions from interactions (as oppose to view through conversions)
AllConversionsFromInteractionsValuePerInteraction Double METRIC The value of all conversions from interactions divided by the total number
AllConversionsValue Double METRIC The value of all conversions.
AllConversionsValuePerCost Double METRIC The value of all conversions divided by the total cost of ad interactions
AssetPinnedAsDescriptionPositionOneCount Long METRIC Number of entities in which the asset is pinned to description 1.
AssetPinnedAsDescriptionPositionTwoCount Long METRIC Number of entities in which the asset is pinned to description 2.
AssetPinnedAsHeadlinePositionOneCount Long METRIC Number of entities in which the asset is pinned to headline 1.
AssetPinnedAsHeadlinePositionThreeCount Long METRIC Number of entities in which the asset is pinned to headline 3.
AssetPinnedAsHeadlinePositionTwoCount Long METRIC Number of entities in which the asset is pinned to headline 2.
AssetPinnedTotalCount Long METRIC Number of total usages in which the asset is pinned.
AverageCost Double METRIC The average amount you pay per interaction. This amount is the total cost
AverageCpc Double METRIC The total cost of all clicks divided by the total number of clicks
Clicks Long METRIC The number of clicks.
Conversions Double METRIC The number of conversions. This only includes conversion actions which
ConversionsFromInteractionsRate Double METRIC Conversions from interactions divided by the number of ad interactions
ConversionsFromInteractionsValuePerInteraction Double METRIC The value of conversions from interactions divided by the number of ad
ConversionsValue Double METRIC The value of conversions. This only includes conversion actions which
ConversionsValuePerCost Double METRIC The value of conversions divided by the cost of ad interactions. This only
CostMicros Long METRIC The sum of your cost-per-click (CPC) and cost-per-thousand impressions
CostPerAllConversions Double METRIC The cost of ad interactions divided by all conversions.
CostPerConversion Double METRIC The cost of ad interactions divided by conversions. This only includes
CrossDeviceConversions Double METRIC Conversions from when a customer clicks on a Google Ads ad on one device,
CrossDeviceConversionsValue Double METRIC The sum of the value of cross-device conversions.
Ctr Double METRIC The number of clicks your ad receives (Clicks) divided by the number
EngagementRate Double METRIC How often people engage with your ad after it's shown to them. This is the
Engagements Long METRIC The number of engagements.
Impressions Long METRIC Count of how often your ad has appeared on a search results page or
InteractionRate Double METRIC How often people interact with your ad after it is shown to them.
Interactions Long METRIC The number of interactions.
LinkedEntitiesCount Long METRIC Number of linked resources in which the asset is used.
LinkedSampleEntities String METRIC A list of up to 20 sample linked resources in which the asset is used.
ValuePerAllConversions Double METRIC The value of all conversions divided by the number of all conversions.
ValuePerConversion Double METRIC The value of conversions divided by the number of conversions. This only
ViewThroughConversions Long METRIC The total number of view-through conversions.
Date Date SEGMENT Date to which metrics apply.
DayOfWeek String SEGMENT Day of the week, for example, MONDAY.

The allowed values are FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, UNKNOWN, WEDNESDAY.

Month Date SEGMENT Month as represented by the date of the first day of a month. Formatted as
Period String SEGMENT Predefined date range.

The allowed values are TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN.

Quarter Date SEGMENT Quarter as represented by the date of the first day of a quarter.
Week Date SEGMENT Week as defined as Monday through Sunday, and represented by the date of
Year Int SEGMENT Year, formatted as yyyy.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655