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.