ClickView
A click view with metrics aggregated at each click level, including both
View-Specific Information
Select
Google Ads does not allow every column to be selected in a single query, as some data conflicts if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes are returned. In general, these defaults are the same fields that are exposed through the Ads console. To use the nondefault fields, explicitly select them in your query.
Filters can also be used in the WHERE clause using the following supported operators: =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, NOT IN . Note that all filters must be joined by AND, as OR is not supported by the Ads API.
In addition, queries against the ClickView view must include a filter on the Date column, limiting results to a single day.
SELECT * FROM ClickView WHERE Date DURING Yesterday
Note: Data can be requested for dates up to 90 days prior to the request. If no date filter is provided, the 本製品 defaults to today's date to ensure the query complies with API requirements and avoids errors.
Columns
| Name | Type | Behavior | Description |
| AdGroupId | Long | SEGMENT | Output only. The ID of the ad group. |
| CampaignId | Long | SEGMENT | Output only. The ID of the campaign. |
| ClickViewAdGroupAd | String | ATTRIBUTE | Output only. The associated ad. |
| ClickViewAreaOfInterestCity | String | ATTRIBUTE | The city location criterion associated with the impression. |
| ClickViewAreaOfInterestCountry | String | ATTRIBUTE | The country location criterion associated with the impression. |
| ClickViewAreaOfInterestMetro | String | ATTRIBUTE | The metro location criterion associated with the impression. |
| ClickViewAreaOfInterestMostSpecific | String | ATTRIBUTE | The most specific location criterion associated with the impression. |
| ClickViewAreaOfInterestRegion | String | ATTRIBUTE | The region location criterion associated with the impression. |
| ClickViewCampaignLocationTarget | String | ATTRIBUTE | Output only. The associated campaign location target, if one exists. |
| ClickViewGclid | String | ATTRIBUTE | Output only. The Google Click ID. |
| ClickViewKeyword | String | ATTRIBUTE | Output only. The associated keyword, if one exists and the click |
| ClickViewKeywordInfoMatchType | String | ATTRIBUTE | The match type of the keyword.
使用できる値は次のとおりです。BROAD, EXACT, PHRASE, UNKNOWN |
| ClickViewKeywordInfoText | String | ATTRIBUTE | The text of the keyword (at most 80 characters and 10 words). |
| ClickViewLocationOfPresenceCity | String | ATTRIBUTE | The city location criterion associated with the impression. |
| ClickViewLocationOfPresenceCountry | String | ATTRIBUTE | The country location criterion associated with the impression. |
| ClickViewLocationOfPresenceMetro | String | ATTRIBUTE | The metro location criterion associated with the impression. |
| ClickViewLocationOfPresenceMostSpecific | String | ATTRIBUTE | The most specific location criterion associated with the impression. |
| ClickViewLocationOfPresenceRegion | String | ATTRIBUTE | The region location criterion associated with the impression. |
| ClickViewPageNumber | Long | ATTRIBUTE | Output only. Page number in search results where the ad was shown. |
| ClickViewResourceName | String | ATTRIBUTE | Output only. The resource name of the click view. |
| ClickViewUserList | String | ATTRIBUTE | Output only. The associated user list, if one exists. |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| Clicks | Long | METRIC | The number of clicks. |
| AdNetworkType | String | SEGMENT | Ad network type.
使用できる値は次のとおりです。CONTENT, DISCOVER, GMAIL, GOOGLE_OWNED_CHANNELS, GOOGLE_TV, MAPS, MIXED, SEARCH, SEARCH_PARTNERS, UNKNOWN, YOUTUBE |
| AdSubNetworkType | String | SEGMENT | Ad sub network type. Currently only available for ads running as part of
使用できる値は次のとおりです。UNKNOWN, UNSEGMENTED, YOUTUBE_INFEED, YOUTUBE_INSTREAM, YOUTUBE_SHORTS |
| ClickType | String | SEGMENT | Click type.
使用できる値は次のとおりです。AD_IMAGE, APP_DEEPLINK, BREADCRUMBS, BROADBAND_PLAN, CALLS, CALL_TRACKING, CLICK_ON_ENGAGEMENT_AD, CLICK_TO_MESSAGE_LANDING_PAGE_CLICK, CLICK_TO_MESSAGE_THIRD_PARTY_CLICK, 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_ASSETS, 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, URL_CLICKS, VEHICLE_ASSETS, VIDEO_APP_STORE_CLICKS, VIDEO_CALL_TO_ACTION_CLICKS, VIDEO_CARD_ACTION_HEADLINE_CLICKS, VIDEO_CHANNEL_CLICK, VIDEO_END_CAP_CLICKS, VIDEO_RELATED_VIDEOS_CLICK, VIDEO_WEBSITE_CLICKS, VISUAL_SITELINKS, WIRELESS_PLAN |
| Date | Date | SEGMENT | Date to which metrics apply. |
| Device | String | SEGMENT | Device to which metrics apply.
使用できる値は次のとおりです。CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN |
| MonthOfYear | String | SEGMENT | Month of the year, for example, January.
使用できる値は次のとおりです。APRIL, AUGUST, DECEMBER, FEBRUARY, JANUARY, JULY, JUNE, MARCH, MAY, NOVEMBER, OCTOBER, SEPTEMBER, UNKNOWN |
| Period | String | SEGMENT | Predefined date range.
使用できる値は次のとおりです。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 |
| Slot | String | SEGMENT | Position of the ad.
使用できる値は次のとおりです。CONTENT, MIXED, SEARCH_OTHER, SEARCH_PARTNER_OTHER, SEARCH_PARTNER_TOP, SEARCH_SIDE, SEARCH_TOP, UNKNOWN |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |