ShoppingPerformance
The Shopping Performance report provides shopping campaign statistics aggregated at the product (OfferId field) level.
Table Specific Information
Select
Google AdWords does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the AdWords console.
To use the nondefault fields, explicitly select them in your query.
Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the AdWords API.
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. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
AdNetworkType1 | String | Segment | Network | Network for the ShoppingPerformance report. The allowed values are UNKNOWN, SEARCH, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED. |
AdNetworkType2 | String | Segment | Network (with Search Partners) | Network (with Search Partners) for the ShoppingPerformance report. The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED. |
CampaignStatus | String | Segment | Campaign State | Campaign State for the ShoppingPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
Channel | String | Segment | Channel | Channel for the ShoppingPerformance report. The allowed values are UNKNOWN, ONLINE, LOCAL. |
ChannelExclusivity | String | Segment | Channel Exclusivity | Channel Exclusivity for the ShoppingPerformance report. The allowed values are UNKNOWN, SINGLE_CHANNEL, MULTI_CHANNEL. |
ClickType | String | Segment | Click Type | Click Type for the ShoppingPerformance report. The allowed values are 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. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. |
Device | String | Segment | Device | Device for the ShoppingPerformance report. The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET. |
ExternalConversionSource | String | Segment | Conversion Source | Conversion Source for the ShoppingPerformance report. The allowed values are 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. The allowed values are 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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
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. |
Last updated