CData ODBC Driver for Google Ads 2019J - Online Help

ShoppingPerformance

CData ODBC Driver for Google Ads 2019J - Build 19.0.7354

The Shopping Performance report provides shopping campaign statistics aggregated at the product (OfferId 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 ShoppingPerformance report.
AdGroupId Long Attribute Ad Group ID Ad Group ID for the ShoppingPerformance report.
AdGroupName String Attribute Ad Group Ad Group for the ShoppingPerformance report.
AggregatorId Long Attribute MCA Id MCA Id for the ShoppingPerformance report.
Brand String Attribute Brand Brand for the ShoppingPerformance report.
CampaignId Long Attribute Campaign ID Campaign ID for the ShoppingPerformance report.
CampaignName String Attribute Campaign Campaign for the ShoppingPerformance report.
CategoryL1 String Attribute Category (1st Level) Category (1st Level) for the ShoppingPerformance report.
CategoryL2 String Attribute Category (2nd Level) Category (2nd Level) for the ShoppingPerformance report.
CategoryL3 String Attribute Category (3rd Level) Category (3rd Level) for the ShoppingPerformance report.
CategoryL4 String Attribute Category (4th Level) Category (4th Level) for the ShoppingPerformance report.
CategoryL5 String Attribute Category (5th Level) Category (5th Level) for the ShoppingPerformance report.
CountryCriteriaId Integer Attribute Country Per Territory Country Per Territory for the ShoppingPerformance report.
CustomAttribute0 String Attribute Custom Label 0 Custom Label 0 for the ShoppingPerformance report.
CustomAttribute1 String Attribute Custom Label 1 Custom Label 1 for the ShoppingPerformance report.
CustomAttribute2 String Attribute Custom Label 2 Custom Label 2 for the ShoppingPerformance report.
CustomAttribute3 String Attribute Custom Label 3 Custom Label 3 for the ShoppingPerformance report.
CustomAttribute4 String Attribute Custom Label 4 Custom Label 4 for the ShoppingPerformance report.
ExternalCustomerId Long Attribute Customer ID Customer ID for the ShoppingPerformance report.
LanguageCriteriaId Integer Attribute Language Language for the ShoppingPerformance report.
MerchantId Long Attribute MC Id MC Id for the ShoppingPerformance report.
OfferId String Attribute Item Id Item Id for the ShoppingPerformance report.
ProductTitle String Attribute Product Title Product Title for the ShoppingPerformance report.
ProductTypeL1 String Attribute Product Type (1st Level) Product Type (1st Level) for the ShoppingPerformance report.
ProductTypeL2 String Attribute Product Type (2nd Level) Product Type (2nd Level) for the ShoppingPerformance report.
ProductTypeL3 String Attribute Product Type (3rd Level) Product Type (3rd Level) for the ShoppingPerformance report.
ProductTypeL4 String Attribute Product Type (4th Level) Product Type (4th Level) for the ShoppingPerformance report.
ProductTypeL5 String Attribute Product Type (5th Level) Product Type (5th Level) for the ShoppingPerformance report.
StoreId String Attribute Store Id Store Id for the ShoppingPerformance report.
AdGroupStatus String Segment Ad Group State Ad Group State for the ShoppingPerformance report.

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

AdNetworkType1 String Segment Network Network for the ShoppingPerformance report.

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

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

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

CampaignStatus String Segment Campaign State Campaign State for the ShoppingPerformance report.

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

Channel String Segment Channel Channel for the ShoppingPerformance report.

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

ChannelExclusivity String Segment Channel Exclusivity Channel Exclusivity for the ShoppingPerformance report.

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

ClickType String Segment Click Type Click Type for the ShoppingPerformance 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 ShoppingPerformance report.
ConversionTrackerId Long Segment Conversion Tracker Id Conversion Tracker Id for the ShoppingPerformance report.
ConversionTypeName String Segment Conversion Name Conversion Name for the ShoppingPerformance report.
Date Date Segment Day Day for the ShoppingPerformance report.
DayOfWeek String Segment Day Of Week Day Of Week for the ShoppingPerformance report.

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

Device String Segment Device Device for the ShoppingPerformance report.

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

ExternalConversionSource String Segment Conversion Source Conversion Source for the ShoppingPerformance 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 ShoppingPerformance report.
ProductCondition String Segment Condition Condition for the ShoppingPerformance report.

使用できる値は次のとおりです。UNKNOWN, NEW, REFURBISHED, USED

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