CData ODBC Driver for Google Ads 2019J - Online Help

GeoPerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Geo Performance report includes all statistics aggregated at the country/territory level, one row per country/territory.

テーブル固有の情報

Select

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

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

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

SELECT カラムには常にCountryCriteriaId フィールドが必要です(SELECT * はこれを自動的に説明します)。

Columns

Name Type Behavior DisplayName Description
AccountCurrencyCode String Attribute Currency Currency for the GeoPerformance report.
AccountDescriptiveName String Attribute Account Account for the GeoPerformance report.
AccountTimeZone String Attribute Time Zone Time Zone for the GeoPerformance report.
CampaignId Long Attribute Campaign ID Campaign ID for the GeoPerformance report.
CampaignName String Attribute Campaign Campaign for the GeoPerformance report.
CampaignStatus String Attribute Campaign State Campaign State for the GeoPerformance report.

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

CityCriteriaId Integer Attribute City City for the GeoPerformance report.
CountryCriteriaId Integer Attribute Country Per Territory Country Per Territory for the GeoPerformance report.
CustomerDescriptiveName String Attribute Client Name Client Name for the GeoPerformance report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the GeoPerformance report.
IsTargetingLocation String Attribute Is Targetable Is Targetable for the GeoPerformance report.

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

MetroCriteriaId Integer Attribute Metro Area Metro Area for the GeoPerformance report.
MostSpecificCriteriaId Long Attribute Most Specific Location Most Specific Location for the GeoPerformance report.
RegionCriteriaId Integer Attribute Region Region for the GeoPerformance report.
AdFormat String Segment Ad Type Ad Type for the GeoPerformance report.

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

AdGroupId Long Segment Ad Group ID Ad Group ID for the GeoPerformance report.
AdGroupName String Segment Ad Group Ad Group for the GeoPerformance report.
AdGroupStatus String Segment Ad Group State Ad Group State for the GeoPerformance report.

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

AdNetworkType1 String Segment Network Network for the GeoPerformance report.

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

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

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

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

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

Device String Segment Device Device for the GeoPerformance report.

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

ExternalConversionSource String Segment Conversion Source Conversion Source for the GeoPerformance 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

LocationType String Segment Location Type Location Type for the GeoPerformance report.

使用できる値は次のとおりです。AREA_OF_INTEREST, LOCATION_OF_PRESENCE, UNKNOWN

Month String Segment Month Month for the GeoPerformance report.
MonthOfYear String Segment Month Of Year Month Of Year for the GeoPerformance report.

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

Quarter String Segment Quarter Quarter for the GeoPerformance report.
Week String Segment Week Week for the GeoPerformance report.
Year Integer Segment Year Year for the GeoPerformance report.
AllConversionRate Double Metric All Conv Rate All Conv Rate for the GeoPerformance report.
AllConversions Double Metric All Conv All Conv for the GeoPerformance report.
AllConversionValue Double Metric All Conv Value All Conv Value for the GeoPerformance report.
AverageCost Decimal Metric Avg Cost Avg Cost for the GeoPerformance report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the GeoPerformance report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the GeoPerformance report.
AverageCpv Double Metric Avg CPV Avg CPV for the GeoPerformance report.
AveragePosition Double Metric Avg Position Avg Position for the GeoPerformance report.
Clicks Long Metric Clicks Clicks for the GeoPerformance report.
ConversionRate Double Metric Conv Rate Conv Rate for the GeoPerformance report.
Conversions Double Metric Conversions Conversions for the GeoPerformance report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the GeoPerformance report.
Cost Decimal Metric Cost Cost for the GeoPerformance report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the GeoPerformance report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the GeoPerformance report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the GeoPerformance report.
Ctr Double Metric CTR CTR for the GeoPerformance report.
Impressions Long Metric Impressions Impressions for the GeoPerformance report.
InteractionRate Double Metric Interaction Rate Interaction Rate for the GeoPerformance report.
Interactions Long Metric Interactions Interactions for the GeoPerformance report.
InteractionTypes String Metric Interaction Types Interaction Types for the GeoPerformance report.
ValuePerAllConversion Double Metric Value Per All Conv Value Per All Conv for the GeoPerformance report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the GeoPerformance report.
VideoViewRate Double Metric View Rate View Rate for the GeoPerformance report.
VideoViews Long Metric Views Views for the GeoPerformance report.
ViewThroughConversions Long Metric View-through Conv View-through Conv for the GeoPerformance 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