customer_asset

Help me build a query

A link between a customer and an asset.

Attributed resources
asset
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
ad_group
campaign

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

Is customer_asset specified in the FROM clause of your query?

No Yes, it is

Resource fields asset field_type primary_status primary_status_details primary_status_reasons resource_name source status

Segments ad_network_type asset_interaction_target.asset asset_interaction_target.interaction_on_this_asset click_type conversion_action conversion_action_category conversion_action_name date day_of_week device external_conversion_source month month_of_year quarter slot week year

Metrics absolute_top_impression_percentage all_conversions all_conversions_from_interactions_rate all_conversions_value average_cost average_cpc average_cpe average_cpm average_cpv clicks conversions conversions_from_interactions_rate conversions_value cost_micros cost_per_all_conversions cost_per_conversion cross_device_conversions ctr engagement_rate engagements impressions interaction_event_types interaction_rate interactions phone_calls phone_impressions phone_through_rate top_impression_percentage value_per_all_conversions value_per_conversion video_view_rate video_views

customer_asset.asset Field description Required. Immutable. The asset which is linked to the customer. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

customer_asset.field_type Field description Required. Immutable. Role that the asset takes for the customer link. 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

customer_asset.primary_status Field description Output only. Provides the PrimaryStatus of this asset link. Primary status is meant essentially to differentiate between the plain "status" field, which has advertiser set values of enabled, paused, or removed. The primary status takes into account other signals (for assets its mainly policy and quality approvals) to come up with a more comprehensive status to indicate its serving state. Category ATTRIBUTE Data Type ENUM ELIGIBLE LIMITED NOT_ELIGIBLE PAUSED PENDING REMOVED UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v18.enums.AssetLinkPrimaryStatusEnum.AssetLinkPrimaryStatus Filterable True Selectable True Sortable True Repeated False

customer_asset.primary_status_details Field description Output only. Provides the details of the primary status and its associated reasons. Category ATTRIBUTE Data Type MESSAGE Type URL google.ads.googleads.v18.common.AssetLinkPrimaryStatusDetails Filterable False Selectable True Sortable False Repeated True

customer_asset.primary_status_reasons Field description Output only. Provides a list of reasons for why an asset is not serving or not serving at full capacity. Category ATTRIBUTE Data Type ENUM ASSET_APPROVED_LABELED ASSET_DISAPPROVED ASSET_LINK_PAUSED ASSET_LINK_REMOVED ASSET_UNDER_REVIEW UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v18.enums.AssetLinkPrimaryStatusReasonEnum.AssetLinkPrimaryStatusReason Filterable True Selectable True Sortable False Repeated True

customer_asset.resource_name Field description Immutable. The resource name of the customer asset. CustomerAsset resource names have the form: customers/{customer_id}/customerAssets/{asset_id}~{field_type} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

customer_asset.source Field description Output only. Source of the customer 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 False Repeated False

customer_asset.status Field description Status of the customer asset. Category ATTRIBUTE Data Type ENUM ENABLED PAUSED REMOVED UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v18.enums.AssetLinkStatusEnum.AssetLinkStatus Filterable True Selectable True Sortable True Repeated False

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

segments.asset_interaction_target.asset Field description The asset resource name. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.asset_interaction_target.interaction_on_this_asset Field description Only used with CustomerAsset, CampaignAsset and AdGroupAsset metrics. Indicates whether the interaction metrics occurred on the asset itself or a different asset or ad unit. Category SEGMENT Data Type BOOLEAN Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.click_type Field description Click type. Category SEGMENT Data Type ENUM AD_IMAGE APP_DEEPLINK BREADCRUMBS BROADBAND_PLAN CALLS CALL_TRACKING CLICK_ON_ENGAGEMENT_AD CROSS_NETWORK GET_DIRECTIONS HOTEL_BOOK_ON_GOOGLE_ROOM_SELECTION HOTEL_PRICE LOCATION_EXPANSION LOCATION_FORMAT_CALL LOCATION_FORMAT_DIRECTIONS LOCATION_FORMAT_IMAGE LOCATION_FORMAT_LANDING_PAGE LOCATION_FORMAT_MAP LOCATION_FORMAT_STORE_INFO LOCATION_FORMAT_TEXT MOBILE_CALL_TRACKING OFFER_PRINTS OTHER PRICE_EXTENSION PRODUCT_AD_APP_DEEPLINK PRODUCT_EXTENSION_CLICKS PRODUCT_LISTING_ADS_COUPON PRODUCT_LISTING_AD_CLICKS PRODUCT_LISTING_AD_LOCAL PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE PRODUCT_LISTING_AD_TRANSACTABLE PROMOTION_EXTENSION SHOPPING_COMPARISON_LISTING SHOWCASE_AD_CATEGORY_LINK SHOWCASE_AD_LOCAL_PRODUCT_LINK SHOWCASE_AD_LOCAL_STOREFRONT_LINK SHOWCASE_AD_ONLINE_PRODUCT_LINK SITELINKS STORE_LOCATOR SWIPEABLE_GALLERY_AD_HEADLINE SWIPEABLE_GALLERY_AD_SEE_MORE SWIPEABLE_GALLERY_AD_SITELINK_FIVE SWIPEABLE_GALLERY_AD_SITELINK_FOUR SWIPEABLE_GALLERY_AD_SITELINK_ONE SWIPEABLE_GALLERY_AD_SITELINK_THREE SWIPEABLE_GALLERY_AD_SITELINK_TWO SWIPEABLE_GALLERY_AD_SWIPES TRAVEL_ASSETS UNKNOWN UNSPECIFIED URL_CLICKS VIDEO_APP_STORE_CLICKS VIDEO_CALL_TO_ACTION_CLICKS VIDEO_CARD_ACTION_HEADLINE_CLICKS VIDEO_END_CAP_CLICKS VIDEO_WEBSITE_CLICKS VISUAL_SITELINKS WIRELESS_PLAN Type URL google.ads.googleads.v18.enums.ClickTypeEnum.ClickType 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.conversion_action_category Field description Conversion action category. Category SEGMENT Data Type ENUM ADD_TO_CART BEGIN_CHECKOUT BOOK_APPOINTMENT CONTACT CONVERTED_LEAD DEFAULT DOWNLOAD ENGAGEMENT GET_DIRECTIONS IMPORTED_LEAD OUTBOUND_CLICK PAGE_VIEW PHONE_CALL_LEAD PURCHASE QUALIFIED_LEAD REQUEST_QUOTE SIGNUP STORE_SALE STORE_VISIT SUBMIT_LEAD_FORM SUBSCRIBE_PAID UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v18.enums.ConversionActionCategoryEnum.ConversionActionCategory Filterable True Selectable True Sortable True Repeated False

segments.conversion_action_name Field description Conversion action name. Category SEGMENT Data Type STRING 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.v18.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.v18.enums.DeviceEnum.Device Filterable True Selectable True Sortable True Repeated False

segments.external_conversion_source Field description External conversion source. Category SEGMENT Data Type ENUM AD_CALL_METRICS ANALYTICS ANALYTICS_SEARCH_ADS_360 ANDROID_FIRST_OPEN ANDROID_IN_APP APP_UNSPECIFIED CLICK_TO_CALL DISPLAY_AND_VIDEO_360_FLOODLIGHT FIREBASE FIREBASE_SEARCH_ADS_360 FLOODLIGHT GOOGLE_ATTRIBUTION GOOGLE_HOSTED GOOGLE_PLAY IOS_FIRST_OPEN IOS_IN_APP SALESFORCE SEARCH_ADS_360 STORE_SALES STORE_SALES_CRM STORE_SALES_DIRECT_UPLOAD STORE_SALES_PAYMENT_NETWORK STORE_VISITS THIRD_PARTY_APP_ANALYTICS UNKNOWN UNSPECIFIED UPLOAD UPLOAD_CALLS WEBPAGE WEBSITE_CALL_METRICS Type URL google.ads.googleads.v18.enums.ExternalConversionSourceEnum.ExternalConversionSource 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.month_of_year Field description Month of the year, for example, January. Category SEGMENT Data Type ENUM APRIL AUGUST DECEMBER FEBRUARY JANUARY JULY JUNE MARCH MAY NOVEMBER OCTOBER SEPTEMBER UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v18.enums.MonthOfYearEnum.MonthOfYear 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.v18.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.absolute_top_impression_percentage Field description Search absolute top impression share is the percentage of your Search ad impressions that are shown in the most prominent Search position. Category METRIC Data Type DOUBLE 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.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.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 views. 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.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.v18.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.phone_calls Field description Number of offline phone calls. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.phone_impressions Field description Number of offline phone impressions. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.phone_through_rate Field description Number of phone calls received (phone_calls) divided by the number of times your phone number is shown (phone_impressions). Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.top_impression_percentage Field description The percent of your ad impressions that are shown adjacent to the top organic search results. 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_view_rate Field description The number of views your TrueView 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_views Field description The number of times your video ads were viewed. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False