CData ODBC Driver for Google Ads 2019J - Online Help

PaidOrganicQuery

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Paid and Organic Query report provides a holistic view of your search stats across ads and organic listings at the query level. This lets you analyze strengths and gaps in your overall search presence, and gives insight into how your paid and organic search listings work together to connect your business with people searching on Google.

テーブル固有の情報

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

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

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

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

CustomerDescriptiveName String Attribute Client Name Client Name for the PaidOrganicQuery report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the PaidOrganicQuery report.
KeywordId Long Attribute Keyword ID Keyword ID for the PaidOrganicQuery report.
KeywordTextMatchingQuery String Attribute Keyword Keyword for the PaidOrganicQuery report.
SearchQuery String Attribute Query Query for the PaidOrganicQuery report.
Date Date Segment Day Day for the PaidOrganicQuery report.
DayOfWeek String Segment Day Of Week Day Of Week for the PaidOrganicQuery report.

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

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

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

Quarter String Segment Quarter Quarter for the PaidOrganicQuery report.
QueryMatchType String Segment Match Type Match Type for the PaidOrganicQuery report.

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

SerpType String Segment Search Result Type Search Result Type for the PaidOrganicQuery report.

使用できる値は次のとおりです。UNKNOWN, ADS_ONLY, ORGANIC_ONLY, ADS_AND_ORGANIC

Week String Segment Week Week for the PaidOrganicQuery report.
Year Integer Segment Year Year for the PaidOrganicQuery report.
AverageCpc Decimal Metric Ad Avg CPC Ad Avg CPC for the PaidOrganicQuery report.
AveragePosition Double Metric Ad Avg Position Ad Avg Position for the PaidOrganicQuery report.
Clicks Long Metric Ad Clicks Ad Clicks for the PaidOrganicQuery report.
CombinedAdsOrganicClicks Long Metric Combined Clicks Combined Clicks for the PaidOrganicQuery report.
CombinedAdsOrganicClicksPerQuery Double Metric Combined Clicks Per Query Combined Clicks Per Query for the PaidOrganicQuery report.
CombinedAdsOrganicQueries Long Metric Combined Queries Combined Queries for the PaidOrganicQuery report.
Ctr Double Metric Ad CTR Ad CTR for the PaidOrganicQuery report.
Impressions Long Metric Ad Impressions Ad Impressions for the PaidOrganicQuery report.
OrganicAveragePosition Double Metric Organic Average Position Organic Average Position for the PaidOrganicQuery report.
OrganicClicks Long Metric Organic Clicks Organic Clicks for the PaidOrganicQuery report.
OrganicClicksPerQuery Double Metric Organic Clicks Per Query Organic Clicks Per Query for the PaidOrganicQuery report.
OrganicImpressions Long Metric Organic Listings Organic Listings for the PaidOrganicQuery report.
OrganicImpressionsPerQuery Double Metric Organic Listings Per Query Organic Listings Per Query for the PaidOrganicQuery report.
OrganicQueries Long Metric Organic Queries Organic Queries for the PaidOrganicQuery 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