ShoppingPerformanceView

Shopping performance view. Provides Shopping campaign statistics aggregated at several product dimension levels. Product dimension values from Merchant Center such as brand, category, custom attributes, product condition and product type will reflect the state of each dimension as of the date and time when the corresponding event was recorded.

Table Specific Information

Select

Google Ads 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 Ads 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 Ads API.

Columns

Name	Type	Behavior	Description
ShoppingPerformanceViewResourceName	String	Attribute	ResourceName column for table ShoppingPerformanceView
CustomerId	Long	Attribute	ClientCustomerId column for table ShoppingPerformanceView
AllConversions	Double	Metric	AllConversions column for table Metrics
AllConversionsFromInteractionsRate	Double	Metric	AllConversionsFromInteractionsRate column for table Metrics
AllConversionsValue	Double	Metric	AllConversionsValue column for table Metrics
AverageCpc	Double	Metric	AverageCpc column for table Metrics
Clicks	Long	Metric	Clicks column for table Metrics
Conversions	Double	Metric	Conversions column for table Metrics
ConversionsFromInteractionsRate	Double	Metric	ConversionsFromInteractionsRate column for table Metrics
ConversionsValue	Double	Metric	ConversionsValue column for table Metrics
CostMicros	Long	Metric	CostMicros column for table Metrics
CostPerAllConversions	Double	Metric	CostPerAllConversions column for table Metrics
CostPerConversion	Double	Metric	CostPerConversion column for table Metrics
CrossDeviceConversions	Double	Metric	CrossDeviceConversions column for table Metrics
Ctr	Double	Metric	Ctr column for table Metrics
Impressions	Long	Metric	Impressions column for table Metrics
SearchAbsoluteTopImpressionShare	Double	Metric	SearchAbsoluteTopImpressionShare column for table Metrics
SearchClickShare	Double	Metric	SearchClickShare column for table Metrics
SearchImpressionShare	Double	Metric	SearchImpressionShare column for table Metrics
ValuePerAllConversions	Double	Metric	ValuePerAllConversions column for table Metrics
ValuePerConversion	Double	Metric	ValuePerConversion column for table Metrics
AdNetworkType	String	Segment	AdNetworkType column for table Segments
ClickType	String	Segment	ClickType column for table Segments
ConversionAction	String	Segment	ConversionAction column for table Segments
ConversionActionCategory	String	Segment	ConversionActionCategory column for table Segments
ConversionActionName	String	Segment	ConversionActionName column for table Segments
Date	Date	Segment	Date column for table Segments
DayOfWeek	String	Segment	DayOfWeek column for table Segments
Device	String	Segment	Device column for table Segments
ExternalConversionSource	String	Segment	ExternalConversionSource column for table Segments
Month	Date	Segment	Month column for table Segments
ProductAggregatorId	Long	Segment	ProductAggregatorId column for table Segments
ProductBiddingCategoryLevel1	String	Segment	ProductBiddingCategoryLevel1 column for table Segments
ProductBiddingCategoryLevel2	String	Segment	ProductBiddingCategoryLevel2 column for table Segments
ProductBiddingCategoryLevel3	String	Segment	ProductBiddingCategoryLevel3 column for table Segments
ProductBiddingCategoryLevel4	String	Segment	ProductBiddingCategoryLevel4 column for table Segments
ProductBiddingCategoryLevel5	String	Segment	ProductBiddingCategoryLevel5 column for table Segments
ProductBrand	String	Segment	ProductBrand column for table Segments
ProductChannel	String	Segment	ProductChannel column for table Segments
ProductChannelExclusivity	String	Segment	ProductChannelExclusivity column for table Segments
ProductCondition	String	Segment	ProductCondition column for table Segments
ProductCountry	String	Segment	ProductCountry column for table Segments
ProductCustomAttribute0	String	Segment	ProductCustomAttribute0 column for table Segments
ProductCustomAttribute1	String	Segment	ProductCustomAttribute1 column for table Segments
ProductCustomAttribute2	String	Segment	ProductCustomAttribute2 column for table Segments
ProductCustomAttribute3	String	Segment	ProductCustomAttribute3 column for table Segments
ProductCustomAttribute4	String	Segment	ProductCustomAttribute4 column for table Segments
ProductItemId	String	Segment	ProductItemId column for table Segments
ProductLanguage	String	Segment	ProductLanguage column for table Segments
ProductMerchantId	Long	Segment	ProductMerchantId column for table Segments
ProductStoreId	String	Segment	ProductStoreId column for table Segments
ProductTitle	String	Segment	ProductTitle column for table Segments
ProductTypeL1	String	Segment	ProductTypeL1 column for table Segments
ProductTypeL2	String	Segment	ProductTypeL2 column for table Segments
ProductTypeL3	String	Segment	ProductTypeL3 column for table Segments
ProductTypeL4	String	Segment	ProductTypeL4 column for table Segments
ProductTypeL5	String	Segment	ProductTypeL5 column for table Segments
Quarter	Date	Segment	Quarter column for table Segments
Week	Date	Segment	Week column for table Segments
Year	Int	Segment	Year column for table Segments

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
ManagerId	Long	Id of the manager account on behalf of which you are requesting customer data.