CData ODBC Driver for Google Ads 2019J - Online Help

AccountPerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Account Performance report includes all statistics aggregated by default at the account level, one row per account.

テーブル固有の情報

Select

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

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

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

Columns

Name Type Behavior DisplayName Description
AccountCurrencyCode String Attribute Currency Currency for the AccountPerformance report.
AccountDescriptiveName String Attribute Account Account for the AccountPerformance report.
AccountTimeZone String Attribute Time Zone Time Zone for the AccountPerformance report.
CanManageClients String Attribute Can Manage Clients Can Manage Clients for the AccountPerformance report.

使用できる値は次のとおりです。TRUE, FALSE

ConversionAdjustment String Attribute Conversion Adjustment Conversion Adjustment for the AccountPerformance report.

使用できる値は次のとおりです。TRUE, FALSE

CustomerDescriptiveName String Attribute Client Name Client Name for the AccountPerformance report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the AccountPerformance report.
IsAutoTaggingEnabled String Attribute Auto Tagging Enabled Auto Tagging Enabled for the AccountPerformance report.

使用できる値は次のとおりです。TRUE, FALSE

IsTestAccount String Attribute Test Account Test Account for the AccountPerformance report.

使用できる値は次のとおりです。TRUE, FALSE

AdNetworkType1 String Segment Network Network for the AccountPerformance report.

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

AdNetworkType2 String Segment Network (with Search Partners) Network (with Search Partners) for the AccountPerformance report.

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

ClickType String Segment Click Type Click Type for the AccountPerformance 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

ConversionAdjustmentLagBucket String Segment Days To Conversion Or Adjustment Days To Conversion Or Adjustment for the AccountPerformance report.

使用できる値は次のとおりです。UNKNOWN, CONVERSION_0_TO_1_DAY, CONVERSION_1_TO_2_DAYS, CONVERSION_2_TO_3_DAYS, CONVERSION_3_TO_4_DAYS, CONVERSION_4_TO_5_DAYS, CONVERSION_5_TO_6_DAYS, CONVERSION_6_TO_7_DAYS, CONVERSION_7_TO_8_DAYS, CONVERSION_8_TO_9_DAYS, CONVERSION_9_TO_10_DAYS, CONVERSION_10_TO_11_DAYS, CONVERSION_11_TO_12_DAYS, CONVERSION_12_TO_13_DAYS, CONVERSION_13_TO_14_DAYS, CONVERSION_14_TO_21_DAYS, CONVERSION_21_TO_30_DAYS, CONVERSION_30_TO_45_DAYS, CONVERSION_45_TO_60_DAYS, CONVERSION_60_TO_90_DAYS, ADJUSTMENT_0_TO_1_DAY, ADJUSTMENT_1_TO_2_DAYS, ADJUSTMENT_2_TO_3_DAYS, ADJUSTMENT_3_TO_4_DAYS, ADJUSTMENT_4_TO_5_DAYS, ADJUSTMENT_5_TO_6_DAYS, ADJUSTMENT_6_TO_7_DAYS, ADJUSTMENT_7_TO_8_DAYS, ADJUSTMENT_8_TO_9_DAYS, ADJUSTMENT_9_TO_10_DAYS, ADJUSTMENT_10_TO_11_DAYS, ADJUSTMENT_11_TO_12_DAYS, ADJUSTMENT_12_TO_13_DAYS, ADJUSTMENT_13_TO_14_DAYS, ADJUSTMENT_14_TO_21_DAYS, ADJUSTMENT_21_TO_30_DAYS, ADJUSTMENT_30_TO_45_DAYS, ADJUSTMENT_45_TO_60_DAYS, ADJUSTMENT_60_TO_90_DAYS, ADJUSTMENT_90_TO_145_DAY, CONVERSION_UNKNOWN, ADJUSTMENT_UNKNOWN

ConversionCategoryName String Segment Conversion Category Conversion Category for the AccountPerformance report.
ConversionLagBucket String Segment Days To Conversion Days To Conversion for the AccountPerformance report.

使用できる値は次のとおりです。UNKNOWN, CONVERSION_0_TO_1_DAY, CONVERSION_1_TO_2_DAYS, CONVERSION_2_TO_3_DAYS, CONVERSION_3_TO_4_DAYS, CONVERSION_4_TO_5_DAYS, CONVERSION_5_TO_6_DAYS, CONVERSION_6_TO_7_DAYS, CONVERSION_7_TO_8_DAYS, CONVERSION_8_TO_9_DAYS, CONVERSION_9_TO_10_DAYS, CONVERSION_10_TO_11_DAYS, CONVERSION_11_TO_12_DAYS, CONVERSION_12_TO_13_DAYS, CONVERSION_13_TO_14_DAYS, CONVERSION_14_TO_21_DAYS, CONVERSION_21_TO_30_DAYS, CONVERSION_30_TO_45_DAYS, CONVERSION_45_TO_60_DAYS, CONVERSION_60_TO_90_DAYS

ConversionTrackerId Long Segment Conversion Tracker Id Conversion Tracker Id for the AccountPerformance report.
ConversionTypeName String Segment Conversion Name Conversion Name for the AccountPerformance report.
Date Date Segment Day Day for the AccountPerformance report.
DayOfWeek String Segment Day Of Week Day Of Week for the AccountPerformance report.

使用できる値は次のとおりです。MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY

Device String Segment Device Device for the AccountPerformance report.

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

ExternalConversionSource String Segment Conversion Source Conversion Source for the AccountPerformance report.

使用できる値は次のとおりです。UNKNOWN, WEBPAGE, ANALYTICS, UPLOAD, AD_CALL_METRICS, OFFERS, ENGAGEMENT, WEBSITE_CALL_METRICS, STORE_VISITS, ANDROID_IN_APP, ANDROID_DOWNLOAD, IOS_IN_APP, IOS_FIRST_OPEN, APP_UNSPECIFIED, ANDROID_FIRST_OPEN, UPLOAD_CALLS, FIREBASE, CLICK_TO_CALL, SALESFORCE, STORE_SALES_CRM, STORE_SALES_PAYMENT_NETWORK, GOOGLE_PLAY, THIRD_PARTY_APP_ANALYTICS, GOOGLE_ATTRIBUTION, STORE_SALES_DIRECT

HourOfDay Integer Segment Hour Of Day Hour Of Day for the AccountPerformance report.
Month String Segment Month Month for the AccountPerformance report.
MonthOfYear String Segment Month Of Year Month Of Year for the AccountPerformance report.

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

Quarter String Segment Quarter Quarter for the AccountPerformance report.
Slot String Segment Top Vs Other Top Vs Other for the AccountPerformance report.

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

Week String Segment Week Week for the AccountPerformance report.
Year Integer Segment Year Year for the AccountPerformance report.
ActiveViewCpm Decimal Metric Active View Avg CPM Active View Avg CPM for the AccountPerformance report.
ActiveViewCtr Double Metric Active View Viewable CTR Active View Viewable CTR for the AccountPerformance report.
ActiveViewImpressions Long Metric Active View Viewable Impressions Active View Viewable Impressions for the AccountPerformance report.
ActiveViewMeasurability Double Metric Active View Measurable Impr Per Impr Active View Measurable Impr Per Impr for the AccountPerformance report.
ActiveViewMeasurableCost Decimal Metric Active View Measurable Cost Active View Measurable Cost for the AccountPerformance report.
ActiveViewMeasurableImpressions Long Metric Active View Measurable Impr Active View Measurable Impr for the AccountPerformance report.
ActiveViewViewability Double Metric Active View Viewable Impr Per Measurable Impr Active View Viewable Impr Per Measurable Impr for the AccountPerformance report.
AllConversionRate Double Metric All Conv Rate All Conv Rate for the AccountPerformance report.
AllConversions Double Metric All Conv All Conv for the AccountPerformance report.
AllConversionValue Double Metric All Conv Value All Conv Value for the AccountPerformance report.
AverageCost Decimal Metric Avg Cost Avg Cost for the AccountPerformance report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the AccountPerformance report.
AverageCpe Double Metric Avg CPE Avg CPE for the AccountPerformance report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the AccountPerformance report.
AverageCpv Double Metric Avg CPV Avg CPV for the AccountPerformance report.
AveragePosition Double Metric Avg Position Avg Position for the AccountPerformance report.
Clicks Long Metric Clicks Clicks for the AccountPerformance report.
ContentBudgetLostImpressionShare Double Metric Content Lost IS (budget) Content Lost IS (budget) for the AccountPerformance report.
ContentImpressionShare Double Metric Content Impr Share Content Impr Share for the AccountPerformance report.
ContentRankLostImpressionShare Double Metric Content Lost IS (rank) Content Lost IS (rank) for the AccountPerformance report.
ConversionRate Double Metric Conv Rate Conv Rate for the AccountPerformance report.
Conversions Double Metric Conversions Conversions for the AccountPerformance report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the AccountPerformance report.
Cost Decimal Metric Cost Cost for the AccountPerformance report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the AccountPerformance report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the AccountPerformance report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the AccountPerformance report.
Ctr Double Metric CTR CTR for the AccountPerformance report.
EngagementRate Double Metric Engagement Rate Engagement Rate for the AccountPerformance report.
Engagements Long Metric Engagements Engagements for the AccountPerformance report.
Impressions Long Metric Impressions Impressions for the AccountPerformance report.
InteractionRate Double Metric Interaction Rate Interaction Rate for the AccountPerformance report.
Interactions Long Metric Interactions Interactions for the AccountPerformance report.
InteractionTypes String Metric Interaction Types Interaction Types for the AccountPerformance report.
InvalidClickRate Double Metric Invalid Click Rate Invalid Click Rate for the AccountPerformance report.
InvalidClicks Long Metric Invalid Clicks Invalid Clicks for the AccountPerformance report.
SearchBudgetLostImpressionShare Double Metric Search Lost IS (budget) Search Lost IS (budget) for the AccountPerformance report.
SearchExactMatchImpressionShare Double Metric Search Exact Match IS Search Exact Match IS for the AccountPerformance report.
SearchImpressionShare Double Metric Search Impr Share Search Impr Share for the AccountPerformance report.
SearchRankLostImpressionShare Double Metric Search Lost IS (rank) Search Lost IS (rank) for the AccountPerformance report.
ValuePerAllConversion Double Metric Value Per All Conv Value Per All Conv for the AccountPerformance report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the AccountPerformance report.
VideoViewRate Double Metric View Rate View Rate for the AccountPerformance report.
VideoViews Long Metric Views Views for the AccountPerformance report.
ViewThroughConversions Long Metric View-through Conv View-through Conv for the AccountPerformance 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