CData ODBC Driver for Google Ads 2019J - Online Help

ClickPerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Click Performance report includes stats aggregated at each click level, and includes both valid and invalid clicks. The KeywordId field will return any criteria that triggered the click, not just keywords.

テーブル固有の情報

Select

Google AdWords は、一つのクエリですべてのカラムをSelect することを許容しません。これは、データによっては同時にSelect された場合に対立するからです。これにより、すべてのカラムをSelect するクエリを発行する場合には、デフォルトのメトリック、セグメント、およびアトリビュートのみが返されます。一般的に、これらのデフォルト項目は、AdWords コンソールを通じて表示されているフィールドと同じです。

デフォルト以外のフィールドを使う場合には、クエリ内で明示的にSelect してください。

WHERE 句では、フィルタを使用することができます。サポートされている処理は、=、!=、>、>=、<、<=、LIKE、NOT LIKE、IN、およびNOT IN operators です。AdWords API ではOR はサポートされていないため、すべてのフィルタはAND で結合される必要があります。

このテーブルは、過去90日間の特定の日のクエリのみをサポートします。WHERE 句でStartDate およびEndDate を同じ値に設定する必要があります。

Columns

Name Type Behavior DisplayName Description
AccountDescriptiveName String Attribute Account Account for the ClickPerformance report.
AdFormat String Attribute Ad Type Ad Type for the ClickPerformance report.

使用できる値は次のとおりです。UNKNOWN, TEXT, IMAGE, DYNAMIC_IMAGE, FLASH, VIDEO, HTML, AUDIO, COMPOSITE, PRINT

AdGroupId Long Attribute Ad Group ID Ad Group ID for the ClickPerformance report.
AdGroupName String Attribute Ad Group Ad Group for the ClickPerformance report.
AdGroupStatus String Attribute Ad Group State Ad Group State for the ClickPerformance report.

使用できる値は次のとおりです。UNKNOWN, ENABLED, PAUSED, REMOVED

AdNetworkType1 String Attribute Network Network for the ClickPerformance report.

使用できる値は次のとおりです。UNKNOWN, SEARCH, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED

AdNetworkType2 String Attribute Network (with Search Partners) Network (with Search Partners) for the ClickPerformance report.

使用できる値は次のとおりです。UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED

AdVariationControlTrialArmId Long Attribute Ad Variation Control Trial Arm ID Ad Variation Control Trial Arm ID for the ClickPerformance report.
AdVariationTreatmentTrialArmId Long Attribute Ad Variation Treatment Trial Arm ID Ad Variation Treatment Trial Arm ID for the ClickPerformance report.
AdVariationTrialId Long Attribute Ad Variation Trial ID Ad Variation Trial ID for the ClickPerformance report.
AoiCityCriteriaId Integer Attribute City (Location Of Interest) City (Location Of Interest) for the ClickPerformance report.
AoiCountryCriteriaId Integer Attribute Country Per Territory (Location Of Interest) Country Per Territory (Location Of Interest) for the ClickPerformance report.
AoiMetroCriteriaId Integer Attribute Metro Area (Location Of Interest) Metro Area (Location Of Interest) for the ClickPerformance report.
AoiMostSpecificTargetId Long Attribute Most Specific Location Target (Location Of Interest) Most Specific Location Target (Location Of Interest) for the ClickPerformance report.
AoiRegionCriteriaId Integer Attribute Region (Location Of Interest) Region (Location Of Interest) for the ClickPerformance report.
CampaignId Long Attribute Campaign ID Campaign ID for the ClickPerformance report.
CampaignLocationTargetId Long Attribute Campaign Location Target Campaign Location Target for the ClickPerformance report.
CampaignName String Attribute Campaign Campaign for the ClickPerformance report.
CampaignStatus String Attribute Campaign State Campaign State for the ClickPerformance report.

使用できる値は次のとおりです。UNKNOWN, ENABLED, PAUSED, REMOVED

Clicks Long Attribute Clicks Clicks for the ClickPerformance report.
ClickType String Attribute Click Type Click Type for the ClickPerformance report.

使用できる値は次のとおりです。URL_CLICKS, CALLS, OTHER, PRODUCT_EXTENSION_CLICKS, SITELINKS, PRODUCT_LISTING_AD_CLICKS, GET_DIRECTIONS, OFFER_PRINTS, BREADCRUMBS, CALL_TRACKING, MOBILE_CALL_TRACKING, LOCATION_EXPANSION, STORE_LOCATOR, PRODUCT_LISTING_AD_LOCAL, APP_DEEPLINK, PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL, PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE, PRODUCT_LISTING_ADS_COUPON, PRODUCT_LISTING_AD_TRANSACTABLE, PRODUCT_AD_APP_DEEPLINK, SHOWCASE_AD_CATEGORY_LINK, SHOWCASE_AD_LOCAL_STOREFRONT_LINK, SHOWCASE_AD_ONLINE_PRODUCT_LINK, SHOWCASE_AD_LOCAL_PRODUCT_LINK, PRICE_EXTENSION, VIDEO_WEBSITE_CLICKS, VIDEO_CALL_TO_ACTION_CLICKS, VIDEO_APP_STORE_CLICKS, VIDEO_CARD_ACTION_HEADLINE_CLICKS, VIDEO_END_CAP_CLICKS, CLICK_ON_ENGAGEMENT_AD, LOCATION_FORMAT_MAP, LOCATION_FORMAT_LANDING_PAGE, LOCATION_FORMAT_STORE_INFO, LOCATION_FORMAT_DIRECTIONS, LOCATION_FORMAT_CALL, LOCATION_FORMAT_TEXT, LOCATION_FORMAT_IMAGE, BROADBAND_PLAN, WIRELESS_PLAN, VISUAL_SITELINKS, PROMOTION_EXTENSION, SWIPEABLE_GALLERY_AD_HEADLINE, SWIPEABLE_GALLERY_AD_SWIPES, SWIPEABLE_GALLERY_AD_SEE_MORE, SWIPEABLE_GALLERY_AD_SITELINK_ONE, SWIPEABLE_GALLERY_AD_SITELINK_TWO, SWIPEABLE_GALLERY_AD_SITELINK_THREE, SWIPEABLE_GALLERY_AD_SITELINK_FOUR, SWIPEABLE_GALLERY_AD_SITELINK_FIVE, UNKNOWN

CreativeId Long Attribute Ad ID Ad ID for the ClickPerformance report.
CriteriaId Long Attribute Keyword ID Keyword ID for the ClickPerformance report.
CriteriaParameters String Attribute Keyword Per Placement Keyword Per Placement for the ClickPerformance report.
Date Date Attribute Day Day for the ClickPerformance report.
Device String Attribute Device Device for the ClickPerformance report.

使用できる値は次のとおりです。UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET

ExternalCustomerId Long Attribute Customer ID Customer ID for the ClickPerformance report.
GclId String Attribute Google Click ID Google Click ID for the ClickPerformance report.
KeywordMatchType String Attribute Match Type Match Type for the ClickPerformance report.

使用できる値は次のとおりです。UNKNOWN, EXACT, PHRASE, BROAD

LopCityCriteriaId Integer Attribute City (Physical Location) City (Physical Location) for the ClickPerformance report.
LopCountryCriteriaId Integer Attribute Country Per Territory (Physical Location) Country Per Territory (Physical Location) for the ClickPerformance report.
LopMetroCriteriaId Integer Attribute Metro Area (Physical Location) Metro Area (Physical Location) for the ClickPerformance report.
LopMostSpecificTargetId Long Attribute Most Specific Location Target (Physical Location) Most Specific Location Target (Physical Location) for the ClickPerformance report.
LopRegionCriteriaId Integer Attribute Region (Physical Location) Region (Physical Location) for the ClickPerformance report.
MonthOfYear String Attribute Month Of Year Month Of Year for the ClickPerformance report.

使用できる値は次のとおりです。JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER

Page Integer Attribute Page Page for the ClickPerformance report.
Slot String Attribute Top Vs Other Top Vs Other for the ClickPerformance report.

使用できる値は次のとおりです。SEARCHRHS, SEARCHTOP, SEARCHOTHER, CONTENT, AFSTOP, AFSOTHER, MIXED, UNKNOWN

UserListId Long Attribute User List ID User List ID for the ClickPerformance report.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
StartDate String Start date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.
EndDate String End date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0