CData ODBC Driver for Google Ads 2019J - Online Help

AutomaticPlacementsPerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Automatic Placements Performance report includes all statistics aggregated at the placement level, one row per placement.

テーブル固有の情報

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

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

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

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

CriteriaParameters String Attribute URL URL for the AutomaticPlacementsPerformance report.
CustomerDescriptiveName String Attribute Client Name Client Name for the AutomaticPlacementsPerformance report.
DisplayName String Attribute Criteria Display Name Criteria Display Name for the AutomaticPlacementsPerformance report.
Domain String Attribute Domain Domain for the AutomaticPlacementsPerformance report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the AutomaticPlacementsPerformance report.
IsBidOnPath String Attribute Added Added for the AutomaticPlacementsPerformance report.
IsPathExcluded String Attribute Excluded Excluded for the AutomaticPlacementsPerformance report.
AdFormat String Segment Ad Type Ad Type for the AutomaticPlacementsPerformance report.

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

AdNetworkType1 String Segment Network Network for the AutomaticPlacementsPerformance report.

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

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

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

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

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

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

IsAutoOptimized String Segment Targeting Mode Targeting Mode for the AutomaticPlacementsPerformance report.

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

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

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

Quarter String Segment Quarter Quarter for the AutomaticPlacementsPerformance report.
Week String Segment Week Week for the AutomaticPlacementsPerformance report.
Year Integer Segment Year Year for the AutomaticPlacementsPerformance report.
ActiveViewCpm Decimal Metric Active View Avg CPM Active View Avg CPM for the AutomaticPlacementsPerformance report.
ActiveViewCtr Double Metric Active View Viewable CTR Active View Viewable CTR for the AutomaticPlacementsPerformance report.
ActiveViewImpressions Long Metric Active View Viewable Impressions Active View Viewable Impressions for the AutomaticPlacementsPerformance report.
ActiveViewMeasurability Double Metric Active View Measurable Impr Per Impr Active View Measurable Impr Per Impr for the AutomaticPlacementsPerformance report.
ActiveViewMeasurableCost Decimal Metric Active View Measurable Cost Active View Measurable Cost for the AutomaticPlacementsPerformance report.
ActiveViewMeasurableImpressions Long Metric Active View Measurable Impr Active View Measurable Impr for the AutomaticPlacementsPerformance report.
ActiveViewViewability Double Metric Active View Viewable Impr Per Measurable Impr Active View Viewable Impr Per Measurable Impr for the AutomaticPlacementsPerformance report.
AllConversionRate Double Metric All Conv Rate All Conv Rate for the AutomaticPlacementsPerformance report.
AllConversions Double Metric All Conv All Conv for the AutomaticPlacementsPerformance report.
AllConversionValue Double Metric All Conv Value All Conv Value for the AutomaticPlacementsPerformance report.
AverageCost Decimal Metric Avg Cost Avg Cost for the AutomaticPlacementsPerformance report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the AutomaticPlacementsPerformance report.
AverageCpe Double Metric Avg CPE Avg CPE for the AutomaticPlacementsPerformance report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the AutomaticPlacementsPerformance report.
AverageCpv Double Metric Avg CPV Avg CPV for the AutomaticPlacementsPerformance report.
Clicks Long Metric Clicks Clicks for the AutomaticPlacementsPerformance report.
ConversionRate Double Metric Conv Rate Conv Rate for the AutomaticPlacementsPerformance report.
Conversions Double Metric Conversions Conversions for the AutomaticPlacementsPerformance report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the AutomaticPlacementsPerformance report.
Cost Decimal Metric Cost Cost for the AutomaticPlacementsPerformance report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the AutomaticPlacementsPerformance report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the AutomaticPlacementsPerformance report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the AutomaticPlacementsPerformance report.
Ctr Double Metric CTR CTR for the AutomaticPlacementsPerformance report.
EngagementRate Double Metric Engagement Rate Engagement Rate for the AutomaticPlacementsPerformance report.
Engagements Long Metric Engagements Engagements for the AutomaticPlacementsPerformance report.
Impressions Long Metric Impressions Impressions for the AutomaticPlacementsPerformance report.
InteractionRate Double Metric Interaction Rate Interaction Rate for the AutomaticPlacementsPerformance report.
Interactions Long Metric Interactions Interactions for the AutomaticPlacementsPerformance report.
InteractionTypes String Metric Interaction Types Interaction Types for the AutomaticPlacementsPerformance report.
ValuePerAllConversion Double Metric Value Per All Conv Value Per All Conv for the AutomaticPlacementsPerformance report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the AutomaticPlacementsPerformance report.
VideoViewRate Double Metric View Rate View Rate for the AutomaticPlacementsPerformance report.
VideoViews Long Metric Views Views for the AutomaticPlacementsPerformance report.
ViewThroughConversions Long Metric View-through Conv View-through Conv for the AutomaticPlacementsPerformance 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