ClickViewFilteredReport
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.
Columns
| Name | Type | Behavior | Description |
| ClickViewAdGroupAd | String | ATTRIBUTE | Output only. The associated ad. |
| ClickViewAreaOfInterestCity | String | ATTRIBUTE | The city location criterion associated with the impression. |
| ClickViewAreaOfInterestCountry | String | ATTRIBUTE | The conuntry 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 corresponds to the SEARCH channel. |
| ClickViewKeywordInfoMatchType | String | ATTRIBUTE | The match type of the keyword.
使用できる値は次のとおりです。BROAD, EXACT, PHRASE, UNKNOWN, UNSPECIFIED |
| 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. Click view resource names have the form: customers/{customer_id}/clickViews/{date (yyyy-MM-dd)}~{gclid} |
| 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, MIXED, SEARCH, SEARCH_PARTNERS, UNKNOWN, UNSPECIFIED, YOUTUBE_SEARCH, YOUTUBE_WATCH |
| ClickType | String | SEGMENT | Click type.
使用できる値は次のとおりです。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, 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 |
| Date | Date | SEGMENT | Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17. |
| Device | String | SEGMENT | Device to which metrics apply.
使用できる値は次のとおりです。CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN, UNSPECIFIED |
| MonthOfYear | String | SEGMENT | Month of the year, for example, January.
使用できる値は次のとおりです。APRIL, AUGUST, DECEMBER, FEBRUARY, JANUARY, JULY, JUNE, MARCH, MAY, NOVEMBER, OCTOBER, SEPTEMBER, UNKNOWN, UNSPECIFIED |
| 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, UNSPECIFIED |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |