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. |
Last updated