ShoppingProduct
A shopping product from Google Merchant Center that can be advertised by
Columns
| Name | Type | Behavior | Description |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| ShoppingProductAdGroup | String | ATTRIBUTE | Output only. An ad group of a campaign that includes the product. |
| ShoppingProductAvailability | String | ATTRIBUTE | Output only. The availability of the product as provided by the merchant.
The allowed values are IN_STOCK, OUT_OF_STOCK, PREORDER, UNKNOWN. |
| ShoppingProductBrand | String | ATTRIBUTE | Output only. The brand of the product as provided by the merchant. |
| ShoppingProductCampaign | String | ATTRIBUTE | Output only. A campaign that includes the product. |
| ShoppingProductCategoryLevel1 | String | ATTRIBUTE | Output only. The category level 1 of the product. |
| ShoppingProductCategoryLevel2 | String | ATTRIBUTE | Output only. The category level 2 of the product. |
| ShoppingProductCategoryLevel3 | String | ATTRIBUTE | Output only. The category level 3 of the product. |
| ShoppingProductCategoryLevel4 | String | ATTRIBUTE | Output only. The category level 4 of the product. |
| ShoppingProductCategoryLevel5 | String | ATTRIBUTE | Output only. The category level 5 of the product. |
| ShoppingProductChannel | String | ATTRIBUTE | Output only. The product channel describing the locality of the product.
The allowed values are LOCAL, ONLINE, UNKNOWN. |
| ShoppingProductChannelExclusivity | String | ATTRIBUTE | Output only. The channel exclusivity of the product as provided by the
The allowed values are MULTI_CHANNEL, SINGLE_CHANNEL, UNKNOWN. |
| ShoppingProductCondition | String | ATTRIBUTE | Output only. The condition of the product as provided by the merchant.
The allowed values are NEW, REFURBISHED, UNKNOWN, USED. |
| ShoppingProductCurrencyCode | String | ATTRIBUTE | Output only. The currency code as provided by the merchant, in ISO 4217 |
| ShoppingProductCustomAttribute0 | String | ATTRIBUTE | Output only. The custom attribute 0 of the product as provided by the |
| ShoppingProductCustomAttribute1 | String | ATTRIBUTE | Output only. The custom attribute 1 of the product as provided by the |
| ShoppingProductCustomAttribute2 | String | ATTRIBUTE | Output only. The custom attribute 2 of the product as provided by the |
| ShoppingProductCustomAttribute3 | String | ATTRIBUTE | Output only. The custom attribute 3 of the product as provided by the |
| ShoppingProductCustomAttribute4 | String | ATTRIBUTE | Output only. The custom attribute 4 of the product as provided by the |
| ShoppingProductEffectiveMaxCpcMicros | Long | ATTRIBUTE | Output only. The effective maximum cost-per-click (effective max. CPC) of |
| ShoppingProductFeedLabel | String | ATTRIBUTE | Output only. The product feed label as provided by the merchant. |
| ShoppingProductIssues | String | ATTRIBUTE | Output only. The list of issues affecting whether the product can show in |
| ShoppingProductItemId | String | ATTRIBUTE | Output only. The item id of the product as provided by the merchant. |
| ShoppingProductLanguageCode | String | ATTRIBUTE | Output only. The language code as provided by the merchant, in BCP 47 |
| ShoppingProductMerchantCenterId | Long | ATTRIBUTE | Output only. The id of the merchant that owns the product. |
| ShoppingProductMultiClientAccountId | Long | ATTRIBUTE | Output only. The id of the Multi Client Account of the merchant, if |
| ShoppingProductPriceMicros | Long | ATTRIBUTE | Output only. The price of the product in micros as provided by the |
| ShoppingProductProductImageUri | String | ATTRIBUTE | Output only. The URI of the product image as provided by the merchant. |
| ShoppingProductProductTypeLevel1 | String | ATTRIBUTE | Output only. The product type level 1 as provided by the merchant. |
| ShoppingProductProductTypeLevel2 | String | ATTRIBUTE | Output only. The product type level 2 as provided by the merchant. |
| ShoppingProductProductTypeLevel3 | String | ATTRIBUTE | Output only. The product type level 3 as provided by the merchant. |
| ShoppingProductProductTypeLevel4 | String | ATTRIBUTE | Output only. The product type level 4 as provided by the merchant. |
| ShoppingProductProductTypeLevel5 | String | ATTRIBUTE | Output only. The product type level 5 as provided by the merchant. |
| ShoppingProductResourceName | String | ATTRIBUTE | Output only. The resource name of the shopping product. |
| ShoppingProductStatus | String | ATTRIBUTE | Output only. The status that indicates whether the product can show in ads.
The allowed values are ELIGIBLE, ELIGIBLE_LIMITED, NOT_ELIGIBLE, UNKNOWN. |
| ShoppingProductTargetCountries | String | ATTRIBUTE | Output only. Upper-case two-letter ISO 3166-1 code of the regions where the |
| ShoppingProductTitle | String | ATTRIBUTE | Output only. The title of the product as provided by the merchant. |
| AllConversions | Double | METRIC | The total number of conversions. This includes all conversions regardless |
| AllConversionsFromInteractionsRate | Double | METRIC | All conversions from interactions (as oppose to view through conversions) |
| AllConversionsFromInteractionsValuePerInteraction | Double | METRIC | The value of all conversions from interactions divided by the total number |
| AllConversionsValue | Double | METRIC | The value of all conversions. |
| AllConversionsValuePerCost | Double | METRIC | The value of all conversions divided by the total cost of ad interactions |
| AverageCartSize | Double | METRIC | Average cart size is the average number of products in each order |
| AverageCpc | Double | METRIC | The total cost of all clicks divided by the total number of clicks |
| AverageOrderValueMicros | Long | METRIC | Average order value is the average revenue you made per order attributed to |
| Clicks | Long | METRIC | The number of clicks. |
| Conversions | Double | METRIC | The number of conversions. This only includes conversion actions which |
| ConversionsFromInteractionsRate | Double | METRIC | Conversions from interactions divided by the number of ad interactions |
| ConversionsFromInteractionsValuePerInteraction | Double | METRIC | The value of conversions from interactions divided by the number of ad |
| ConversionsValue | Double | METRIC | The value of conversions. This only includes conversion actions which |
| CostMicros | Long | METRIC | The sum of your cost-per-click (CPC) and cost-per-thousand impressions |
| CostOfGoodsSoldMicros | Long | METRIC | Cost of goods sold (COGS) is the total cost of the products you sold in |
| CostPerAllConversions | Double | METRIC | The cost of ad interactions divided by all conversions. |
| CostPerConversion | Double | METRIC | The cost of ad interactions divided by conversions. This only includes |
| CrossDeviceConversions | Double | METRIC | Conversions from when a customer clicks on a Google Ads ad on one device, |
| CrossDeviceConversionsValueMicros | Long | METRIC | The sum of the value of cross-device conversions, in micros. |
| CrossSellCostOfGoodsSoldMicros | Long | METRIC | Cross-sell cost of goods sold (COGS) is the total cost of products sold as |
| CrossSellGrossProfitMicros | Long | METRIC | Cross-sell gross profit is the profit you made from products sold as a |
| CrossSellRevenueMicros | Long | METRIC | Cross-sell revenue is the total amount you made from products sold as a |
| CrossSellUnitsSold | Double | METRIC | Cross-sell units sold is the total number of products sold as a result of |
| Ctr | Double | METRIC | The number of clicks your ad receives (Clicks) divided by the number |
| GrossProfitMargin | Double | METRIC | Gross profit margin is the percentage gross profit you made from orders |
| GrossProfitMicros | Long | METRIC | Gross profit is the profit you made from orders attributed to your ads |
| Impressions | Long | METRIC | Count of how often your ad has appeared on a search results page or |
| LeadCostOfGoodsSoldMicros | Long | METRIC | Lead cost of goods sold (COGS) is the total cost of products sold as a |
| LeadGrossProfitMicros | Long | METRIC | Lead gross profit is the profit you made from products sold as a result of |
| LeadRevenueMicros | Long | METRIC | Lead revenue is the total amount you made from products sold as a result of |
| LeadUnitsSold | Double | METRIC | Lead units sold is the total number of products sold as a result of |
| Orders | Double | METRIC | Orders is the total number of purchase conversions you received attributed |
| RevenueMicros | Long | METRIC | Revenue is the total amount you made from orders attributed to your ads. |
| SearchAbsoluteTopImpressionShare | Double | METRIC | The percentage of the customer's Shopping or Search ad impressions that are |
| UnitsSold | Double | METRIC | Units sold is the total number of products sold from orders attributed to |
| ValuePerAllConversions | Double | METRIC | The value of all conversions divided by the number of all conversions. |
| ValuePerConversion | Double | METRIC | The value of conversions divided by the number of conversions. This only |
| Date | Date | SEGMENT | Date to which metrics apply. |
| Month | Date | SEGMENT | Month as represented by the date of the first day of a month. Formatted as |
| Period | String | SEGMENT | Predefined date range.
The allowed values are TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN. |
| Quarter | Date | SEGMENT | Quarter as represented by the date of the first day of a quarter. |
| Week | Date | SEGMENT | Week as defined as Monday through Sunday, and represented by the date of |
| Year | Int | SEGMENT | Year, formatted as yyyy. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |