click_view

Help me build a query

A click view with metrics aggregated at each click level, including both valid and invalid clicks. For non-Search campaigns, metrics.clicks represents the number of valid and invalid interactions. Queries including ClickView must have a filter limiting the results to one day and can be requested for dates back to 90 days before the time of the request.

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

Is click_view specified in the FROM clause of your query?

No Yes, it is

请选择一个选项No

• No
• Yes, it is

Resource fields ad_group_ad area_of_interest.city area_of_interest.country area_of_interest.metro area_of_interest.most_specific area_of_interest.region campaign_location_target gclid keyword keyword_info.match_type keyword_info.text location_of_presence.city location_of_presence.country location_of_presence.metro location_of_presence.most_specific location_of_presence.region page_number resource_name user_list

Segments ad_network_type click_type date device month_of_year slot

Metrics clicks

click_view.ad_group_ad Field description Output only. The associated ad. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.area_of_interest.city Field description The city location criterion associated with the impression. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.area_of_interest.country Field description The country location criterion associated with the impression. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.area_of_interest.metro Field description The metro location criterion associated with the impression. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.area_of_interest.most_specific Field description The most specific location criterion associated with the impression. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.area_of_interest.region Field description The region location criterion associated with the impression. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.campaign_location_target Field description Output only. The associated campaign location target, if one exists. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.gclid Field description Output only. The Google Click ID. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

click_view.keyword Field description Output only. The associated keyword, if one exists and the click corresponds to the SEARCH channel. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.keyword_info.match_type Field description The match type of the keyword. Category ATTRIBUTE Data Type ENUM BROAD EXACT PHRASE UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v18.enums.KeywordMatchTypeEnum.KeywordMatchType Filterable True Selectable True Sortable True Repeated False

click_view.keyword_info.text Field description The text of the keyword (at most 80 characters and 10 words). Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

click_view.location_of_presence.city Field description The city location criterion associated with the impression. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.location_of_presence.country Field description The country location criterion associated with the impression. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.location_of_presence.metro Field description The metro location criterion associated with the impression. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.location_of_presence.most_specific Field description The most specific location criterion associated with the impression. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.location_of_presence.region Field description The region location criterion associated with the impression. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.page_number Field description Output only. Page number in search results where the ad was shown. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable False Selectable True Sortable False Repeated False

click_view.resource_name Field description Output only. The resource name of the click view. Click view resource names have the form: customers/{customer_id}/clickViews/{date (yyyy-MM-dd)}~{gclid} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

click_view.user_list Field description Output only. The associated user list, if one exists. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False 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.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.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.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.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.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

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