Power BI Connector for Google Ads

Build 24.0.9062

ClickView

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.

Table Specific Information

Select

Google Ads does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be 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. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the Ads API.

Queries to 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.

SELECT * FROM ClickView WHERE Date DURING Yesterday

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 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, GOOGLE_TV, MIXED, SEARCH, SEARCH_PARTNERS, UNKNOWN, UNSPECIFIED, YOUTUBE

ClickType String SEGMENT Click type.

使用できる値は次のとおりです。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, 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062