ShoppingPerformance
The Shopping Performance report provides shopping campaign statistics aggregated at the product (OfferId field) level.
Last updated
The Shopping Performance report provides shopping campaign statistics aggregated at the product (OfferId field) level.
Last updated
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.
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
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.
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.