CData ODBC Driver for Google Ads 2019J - Online Help

KeywordlessQuery

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Keywordless Query report includes keywordless ads (dynamic search ads) statistics based on search terms.

テーブル固有の情報

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 KeywordlessQuery report.
AccountDescriptiveName String Attribute Account Account for the KeywordlessQuery report.
AccountTimeZone String Attribute Time Zone Time Zone for the KeywordlessQuery report.
AdGroupId Long Attribute Ad Group ID Ad Group ID for the KeywordlessQuery report.
AdGroupName String Attribute Ad Group Ad Group for the KeywordlessQuery report.
AdGroupStatus String Attribute Ad Group State Ad Group State for the KeywordlessQuery report.

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

CampaignId Long Attribute Campaign ID Campaign ID for the KeywordlessQuery report.
CampaignName String Attribute Campaign Campaign for the KeywordlessQuery report.
CampaignStatus String Attribute Campaign State Campaign State for the KeywordlessQuery report.

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

CategoryPaths String Attribute Categories Categories for the KeywordlessQuery report.
CriterionId Long Attribute Keyword ID Keyword ID for the KeywordlessQuery report.
CustomerDescriptiveName String Attribute Client Name Client Name for the KeywordlessQuery report.
Domain String Attribute Domain Domain for the KeywordlessQuery report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the KeywordlessQuery report.
Line1 String Attribute Dynamically Generated Headline Dynamically Generated Headline for the KeywordlessQuery report.
Query String Attribute Search Term Search Term for the KeywordlessQuery report.
QueryTargetingStatus String Attribute Added Per Excluded Added Per Excluded for the KeywordlessQuery report.

使用できる値は次のとおりです。ADDED, EXCLUDED, BOTH, NONE

Title String Attribute Landing Page Title Landing Page Title for the KeywordlessQuery report.
Url String Attribute URL URL for the KeywordlessQuery report.
ConversionCategoryName String Segment Conversion Category Conversion Category for the KeywordlessQuery report.
ConversionTrackerId Long Segment Conversion Tracker Id Conversion Tracker Id for the KeywordlessQuery report.
ConversionTypeName String Segment Conversion Name Conversion Name for the KeywordlessQuery report.
Date Date Segment Day Day for the KeywordlessQuery report.
DayOfWeek String Segment Day Of Week Day Of Week for the KeywordlessQuery report.

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

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

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

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

Quarter String Segment Quarter Quarter for the KeywordlessQuery report.
Week String Segment Week Week for the KeywordlessQuery report.
Year Integer Segment Year Year for the KeywordlessQuery report.
AllConversionRate Double Metric All Conv Rate All Conv Rate for the KeywordlessQuery report.
AllConversions Double Metric All Conv All Conv for the KeywordlessQuery report.
AllConversionValue Double Metric All Conv Value All Conv Value for the KeywordlessQuery report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the KeywordlessQuery report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the KeywordlessQuery report.
Clicks Long Metric Clicks Clicks for the KeywordlessQuery report.
ConversionRate Double Metric Conv Rate Conv Rate for the KeywordlessQuery report.
Conversions Double Metric Conversions Conversions for the KeywordlessQuery report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the KeywordlessQuery report.
Cost Decimal Metric Cost Cost for the KeywordlessQuery report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the KeywordlessQuery report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the KeywordlessQuery report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the KeywordlessQuery report.
Ctr Double Metric CTR CTR for the KeywordlessQuery report.
Impressions Long Metric Impressions Impressions for the KeywordlessQuery report.
ValuePerAllConversion Double Metric Value Per All Conv Value Per All Conv for the KeywordlessQuery report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the KeywordlessQuery 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