CData ODBC Driver for Google Ads 2019J - Online Help

ProductPartition

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Product Partition report provides shopping campaign statistics aggregated at the product partition (Id field) level.

テーブル固有の情報

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

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

BiddingStrategyType String Attribute Bid Strategy Type Bid Strategy Type for the ProductPartition report.

使用できる値は次のとおりです。MANUAL_CPC, MANUAL_CPV, MANUAL_CPM, PAGE_ONE_PROMOTED, TARGET_SPEND, TARGET_CPA, TARGET_ROAS, MAXIMIZE_CONVERSIONS, MAXIMIZE_CONVERSION_VALUE, TARGET_OUTRANK_SHARE, NONE, UNKNOWN

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

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

CpcBid Decimal Attribute Max CPC Max CPC for the ProductPartition report.
CriteriaDestinationUrl String Attribute Keyword Per Placement Destination URL Keyword Per Placement Destination URL for the ProductPartition report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the ProductPartition report.
FinalUrlSuffix String Attribute Final URL Suffix Final URL Suffix for the ProductPartition report.
Id Long Attribute Criterion ID Criterion ID for the ProductPartition report.
IsNegative String Attribute Is Negative Is Negative for the ProductPartition report.

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

ParentCriterionId Long Attribute Parent Criterion ID Parent Criterion ID for the ProductPartition report.
ProductGroup String Attribute Product Group Product Group for the ProductPartition report.
TrackingUrlTemplate String Attribute Tracking Template Tracking Template for the ProductPartition report.
UrlCustomParameters String Attribute Custom Parameter Custom Parameter for the ProductPartition report.
AdNetworkType1 String Segment Network Network for the ProductPartition report.

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

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

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

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

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

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

Device String Segment Device Device for the ProductPartition report.

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

ExternalConversionSource String Segment Conversion Source Conversion Source for the ProductPartition 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 ProductPartition report.
MonthOfYear String Segment Month Of Year Month Of Year for the ProductPartition report.

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

PartitionType String Segment Partition Type Partition Type for the ProductPartition report.

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

Quarter String Segment Quarter Quarter for the ProductPartition report.
Week String Segment Week Week for the ProductPartition report.
Year Integer Segment Year Year for the ProductPartition report.
AllConversionRate Double Metric All Conv Rate All Conv Rate for the ProductPartition report.
AllConversions Double Metric All Conv All Conv for the ProductPartition report.
AllConversionValue Double Metric All Conv Value All Conv Value for the ProductPartition report.
AverageCpc Decimal Metric Avg CPC Avg CPC for the ProductPartition report.
AverageCpm Decimal Metric Avg CPM Avg CPM for the ProductPartition report.
BenchmarkAverageMaxCpc Decimal Metric Benchmark Max CPC Benchmark Max CPC for the ProductPartition report.
BenchmarkCtr Double Metric Benchmark CTR Benchmark CTR for the ProductPartition report.
Clicks Long Metric Clicks Clicks for the ProductPartition report.
ConversionRate Double Metric Conv Rate Conv Rate for the ProductPartition report.
Conversions Double Metric Conversions Conversions for the ProductPartition report.
ConversionValue Double Metric Total Conv Value Total Conv Value for the ProductPartition report.
Cost Decimal Metric Cost Cost for the ProductPartition report.
CostPerAllConversion Decimal Metric Cost Per All Conv Cost Per All Conv for the ProductPartition report.
CostPerConversion Decimal Metric Cost Per Conv Cost Per Conv for the ProductPartition report.
CrossDeviceConversions Double Metric Cross-device Conv Cross-device Conv for the ProductPartition report.
Ctr Double Metric CTR CTR for the ProductPartition report.
Impressions Long Metric Impressions Impressions for the ProductPartition report.
SearchAbsoluteTopImpressionShare Double Metric Search Abs Top IS Search Abs Top IS for the ProductPartition report.
SearchClickShare Double Metric Click Share Click Share for the ProductPartition report.
SearchImpressionShare Double Metric Search Impr Share Search Impr Share for the ProductPartition report.
ValuePerAllConversion Double Metric Value Per All Conv Value Per All Conv for the ProductPartition report.
ValuePerConversion Double Metric Value Per Conv Value Per Conv for the ProductPartition report.
ViewThroughConversions Long Metric View-through Conv View-through Conv for the ProductPartition 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