Amazon Vendor Central: Most-used fields

Amazon Vendor Central: Most-used fields#

The table below gives information about most-used fields that you can import from Amazon Vendor Central. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

FieldAdverity UI nameType
aged90PlusDaysSellableInventoryCost Dimension

The total cost of sellable inventory units that have been in stock for 90 days or more.

aged90PlusDaysSellableInventoryCost.amount Metric

The monetary value of sellable inventory units that have been in stock for 90 days or more.

aged90PlusDaysSellableInventoryCost.currencyCode Dimension

The currency code for the cost of aged sellable inventory (e.g., 'USD', 'EUR').

aged90PlusDaysSellableInventoryUnits Metric

The number of sellable inventory units that have been in stock for 90 days or more.

amountSpent Metric

Represents the monetary amount spent by the vendor, primarily related to advertising or other economic activities, as detailed in seller economics reports or seller performance reports.

amountSpentCurrencyCode Dimension

The three-digit currency code (e.g., USD, EUR) for the amount spent.

asin Dimension

The Amazon Standard Identification Number (ASIN), a unique identifier for a product in the Amazon catalog.

attributes.{PLACEHOLDER}.{ATTRIBUTE} Dimension

Various product attributes associated with the item, such as size, color, or technical specifications.

averageVendorLeadTimeDays Metric

The average number of days it takes for a vendor to deliver products after a purchase order is placed.

clickShare Metric

The percentage of total customer clicks on products within a specific category or search result that were directed to this product. This is a key marketing and traffic performance indicator.

clickShareRank Metric

The ranking of the product based on its click share within a specific category or search result.

clickedAsin Dimension

The Amazon Standard Identification Number (ASIN) of a product that was clicked by customers. This is often available in Brand Analytics Search Terms reports.

clickedItemName Dimension

The name of the product that was clicked by customers.

combinationPct Metric

The percentage of times a product is purchased in combination with other specific products, commonly found in Market Basket Analysis reports.

comparedAsin Dimension

The Amazon Standard Identification Number (ASIN) of a product that was compared by customers.

comparedPct Metric

The percentage of times a product was compared with other products by customers.

comparedRank Metric

The ranking of a product based on how often it was compared by customers.

conversionRate Metric

The percentage of customers who viewed a product and then purchased it. This metric is available in Vendor Sales or Traffic reports.

conversionShare Metric

The share of conversions for a specific product or group of products.

createdDateTime Dimension

The date and time when an entity or record was created, in ISO 8601 format.

creationDate Dimension

The date and time when the record or order was created.

customerReturns Metric

The number of units returned by customers.

demandForecastByCreationDate.demandForecastType Dimension

The type of demand forecast provided, such as Mean, P70, P80, or P90, indicating different probability levels of demand.

demandForecastByCreationDate.demandUnitsByWeek.demandUnits Metric

The forecasted number of units of customer demand for a particular product during a specific week.

demandForecastByCreationDate.demandUnitsByWeek.relativeWeek Metric

The week number relative to the forecast generation date, indicating its position in the forecasting horizon.

demandForecastByCreationDate.{NUM}.demandForecastType Dimension

The type of demand forecast provided for a specific period, such as Mean, P70, P80, or P90, indicating different probability levels of demand.

demandForecastByCreationDate.{NUM}.demandUnitsByWeek.{NUM}.demandUnits Metric

The forecasted number of units of customer demand for a particular product during a specific week.

demandForecastByCreationDate.{NUM}.demandUnitsByWeek.{NUM}.relativeWeek Metric

The week number relative to the forecast generation date, indicating its position in the forecasting horizon (e.g., Week 0 for the current week, Week 1 for the next week).

departmentName Dimension

The name of the product department or category within the Amazon catalog.

dimensions.{NUM}.item.height.unit Dimension

The unit of measurement for the item's height (e.g., inches, centimeters).

dimensions.{NUM}.item.height.value Metric

The numerical value of the item's height.

dimensions.{NUM}.item.length.unit Dimension

The unit of measurement for the item's length (e.g., inches, centimeters).

dimensions.{NUM}.item.length.value Metric

The numerical value of the item's length.

dimensions.{NUM}.item.weight.unit Dimension

The unit of measurement for the item's weight (e.g., pounds, kilograms).

dimensions.{NUM}.item.weight.value Metric

The numerical value of the item's weight.

dimensions.{NUM}.item.width.unit Dimension

The unit of measurement for the item's width (e.g., inches, centimeters).

dimensions.{NUM}.item.width.value Metric

The numerical value of the item's width.

dimensions.{NUM}.package.height.unit Dimension

The unit of measurement for the package's height (e.g., inches, centimeters).

dimensions.{NUM}.package.height.value Metric

The numerical value of the package's height.

dimensions.{NUM}.package.length.unit Dimension

The unit of measurement for the package's length (e.g., inches, centimeters).

dimensions.{NUM}.package.length.value Metric

The numerical value of the package's length.

dimensions.{NUM}.package.weight.unit Dimension

The unit of measurement for the package's weight (e.g., pounds, kilograms).

dimensions.{NUM}.package.weight.value Metric

The numerical value of the package's weight.

dimensions.{NUM}.package.width.unit Dimension

The unit of measurement for the package's width (e.g., inches, centimeters).

dimensions.{NUM}.package.width.value Metric

The numerical value of the package's width.

endDate Dimension

The end date for the reporting period or data aggregation.

endDateTime Dimension

The date and time when an event or period ends, in ISO 8601 format.

forecastGenerationDate Dimension

The date and time when the demand forecast was generated.

glanceViews Metric

The number of times customers viewed a product's detail page. This metric is available in Vendor Traffic reports.

identifiers.{NUM}.identifiers.{NUM}.identifier Metric

An identifier associated with an item in the Amazon catalog (e.g., UPC, EAN, or ASIN).

identifiers.{NUM}.identifiers.{NUM}.identifierType Dimension

The type of identifier (e.g., 'ASIN', 'UPC', 'EAN').

images.{NUM}.images.{NUM}.height Metric

The height of the product image in pixels.

images.{NUM}.images.{NUM}.link Dimension

The URL link to the product image.

images.{NUM}.images.{NUM}.variant Dimension

The variant of the product image (e.g., 'MAIN', 'PT01').

images.{NUM}.images.{NUM}.width Metric

The width of the product image in pixels.

includedProducts.asin Dimension

The Amazon Standard Identification Number (ASIN) of a product included in a list of related products, such as those from the Catalog Items API.

includedProducts.productAmountSpent Metric

The monetary amount spent on an individual product within a set of included products.

includedProducts.productAmountSpentCurrencyCode Dimension

The currency code for the amount spent on an individual product within a set of included products.

includedProducts.productGlanceViews Metric

The number of times customers viewed the detail page of an individual product within a set of included products.

includedProducts.productName Dimension

The name of an individual product within a set of included products.

includedProducts.productRevenue Metric

The revenue generated by an individual product within a set of included products.

includedProducts.productRevenueCurrencyCode Dimension

The currency code for the revenue generated by an individual product within a set of included products.

includedProducts.productUnitsSold Metric

The number of units sold for an individual product within a set of included products.

inventoryHealthMetricsByDate.aged90PlusDaysSellableAmountTrailing30DayAverage.amount Metric

The 30-day trailing average monetary value of sellable inventory aged 90 days or more.

inventoryHealthMetricsByDate.aged90PlusDaysSellableAmountTrailing30DayAverage.currencyCode Dimension

The currency code for the 30-day trailing average monetary value of sellable inventory aged 90 days or more.

inventoryHealthMetricsByDate.aged90PlusDaysSellableInventory.amount Metric

The monetary value of sellable inventory aged 90 days or more.

inventoryHealthMetricsByDate.aged90PlusDaysSellableInventory.currencyCode Dimension

The currency code for the monetary value of sellable inventory aged 90 days or more.

inventoryHealthMetricsByDate.aged90PlusDaysSellableUnits Metric

The number of sellable units aged 90 days or more.

inventoryHealthMetricsByDate.availableUnits Metric

The total number of units currently available for sale.

inventoryHealthMetricsByDate.netReceivedAmount.amount Metric

The net monetary value of inventory received.

inventoryHealthMetricsByDate.netReceivedAmount.currencyCode Dimension

The currency code for the net monetary value of inventory received.

inventoryHealthMetricsByDate.netReceivedUnits Metric

The net number of units received.

inventoryHealthMetricsByDate.openPurchaseOrderQuantity Metric

The quantity of units currently on open purchase orders.

inventoryHealthMetricsByDate.overallVendorLeadTime Metric

The overall lead time in days for products from the vendor to reach Amazon's fulfillment centers.

inventoryHealthMetricsByDate.receiveFillRate Dimension

The percentage of ordered units that were successfully received by Amazon.

inventoryHealthMetricsByDate.sellThroughRate Metric

The rate at which inventory is sold over a specified period.

inventoryHealthMetricsByDate.sellableOnHandAmountTrailing30DayAverage.amount Metric

The 30-day trailing average monetary value of sellable inventory currently on hand.

inventoryHealthMetricsByDate.sellableOnHandAmountTrailing30DayAverage.currencyCode Dimension

The currency code for the 30-day trailing average monetary value of sellable inventory currently on hand.

inventoryHealthMetricsByDate.sellableOnHandInventory.amount Metric

The monetary value of sellable inventory currently on hand.

inventoryHealthMetricsByDate.sellableOnHandInventory.currencyCode Dimension

The currency code for the monetary value of sellable inventory currently on hand.

inventoryHealthMetricsByDate.sellableOnHandUnits Metric

The number of sellable units currently on hand.

inventoryHealthMetricsByDate.unfilledCustomerOrderedUnits Metric

The number of units ordered by customers that have not yet been fulfilled.

inventoryHealthMetricsByDate.unhealthyInventory.amount Metric

The monetary value of unhealthy inventory.

inventoryHealthMetricsByDate.unhealthyInventory.currencyCode Dimension

The currency code for the monetary value of unhealthy inventory.

inventoryHealthMetricsByDate.unhealthyUnits Metric

The number of unhealthy units in inventory.

inventoryHealthMetricsByDate.unhealthyUnitsTrailing30DayAverage Metric

The 30-day trailing average of unhealthy units in inventory.

inventoryHealthMetricsByDate.unsellableOnHandAmountTrailing30DayAverage.amount Metric

The 30-day trailing average monetary value of unsellable inventory currently on hand.

inventoryHealthMetricsByDate.unsellableOnHandAmountTrailing30DayAverage.currencyCode Dimension

The currency code for the 30-day trailing average monetary value of unsellable inventory currently on hand.

inventoryHealthMetricsByDate.unsellableOnHandInventory.amount Metric

The monetary value of unsellable inventory currently on hand.

inventoryHealthMetricsByDate.unsellableOnHandInventory.currencyCode Dimension

The currency code for the monetary value of unsellable inventory currently on hand.

inventoryHealthMetricsByDate.unsellableOnHandUnits Metric

The number of unsellable units currently on hand.

inventoryHealthMetricsByDate.weeksOnHand Metric

The estimated number of weeks of inventory currently on hand, based on historical sales.

lastUpdatedDateTime Dimension

The date and time when an entity or record was last updated, in ISO 8601 format.

marketplace Dimension

The Amazon marketplace where the transaction or product is listed (e.g., 'US', 'UK', 'DE').

marketplaceId Dimension

A unique identifier for the Amazon marketplace.

meanForecastUnits Metric

The average or expected quantity of weekly customer demand units as predicted by Amazon's forecasting models.

netPureProductMargin Metric

Amazon's calculated net pure product margin for selling a vendor's items, taking into account the cost of goods, vendor funding, and sales discounts.

netReceivedInventoryCost Dimension

The cost of inventory units that have been successfully received by Amazon from the vendor.

netReceivedInventoryCost.amount Metric

The monetary value of inventory units received, excluding returns.

netReceivedInventoryCost.currencyCode Dimension

The currency code for the net received inventory cost (e.g., 'USD', 'EUR').

netReceivedInventoryUnits Metric

The total number of inventory units received, excluding returns.

openPurchaseOrderUnits Metric

The number of units on outstanding purchase orders that have not yet been received.

orderedRevenue.amount Metric

The total monetary value of products ordered by customers.

orderedRevenue.currencyCode Dimension

The currency code for the ordered revenue (e.g., 'USD', 'EUR').

orderedUnits Metric

The total number of units ordered by customers.

orders Metric

A collection of purchase order data, including details like items, quantities, and status.

p70ForecastUnits Metric

The P70 confidence interval for forecast units, meaning there is a 70% probability that the actual sales or demand will be less than or equal to this value. This is available in Vendor Forecasting reports.

p80ForecastUnits Metric

The P80 confidence interval for forecast units, meaning there is an 80% probability that the actual sales or demand will be less than or equal to this value. This is available in Vendor Forecasting reports.

p90ForecastUnits Metric

The P90 confidence interval for forecast units, meaning there is a 90% probability that the actual sales or demand will be less than or equal to this value. This is available in Vendor Forecasting reports.

productTypes.{NUM}.productType Dimension

The specific product type (e.g., 'TELEVISION') for an item, as defined in the Amazon catalog.

promotionId Metric

An identifier for a specific promotion applied to an item.

promotionName Dimension

The name or identifier of a specific promotion or advertising campaign.

purchasedAsin Dimension

The Amazon Standard Identification Number (ASIN) of a product that was purchased by customers. This is often available in Market Basket Analysis or Repeat Purchase reports.

purchasedPct Metric

The percentage of customers who purchased a specific product, often in relation to other products in Market Basket Analysis reports.

purchasedRank Metric

The ranking of a product based on its purchase frequency or volume.

purchasedWithAsin Dimension

The Amazon Standard Identification Number (ASIN) of a product frequently purchased together with another item. This is commonly found in Market Basket Analysis reports.

purchasedWithRank Metric

A ranking that indicates how frequently an item is purchased in combination with other items.

receiveFillRate Metric

The percentage of ordered units that were successfully received, indicating fulfillment efficiency.

relationships.{NUM}.relationships.{NUM}.childAsins.{NUM} Dimension

An ASIN of a child product that is part of a variation relationship with a parent product.

relationships.{NUM}.relationships.{NUM}.parentAsins.{NUM} Dimension

An ASIN of a parent product in a variation relationship, which groups related child products.

relationships.{NUM}.relationships.{NUM}.type Dimension

The type of relationship between products, such as 'VARIATION'.

relationships.{NUM}.relationships.{NUM}.variationTheme.attributes.{NUM} Dimension

An attribute that defines the variation theme (e.g., 'color', 'size') for a product relationship.

relationships.{NUM}.relationships.{NUM}.variationTheme.theme Dimension

The specific theme describing how related products vary (e.g., 'SIZE_NAME/COLOR_NAME').

repeatCustomersPctTotal Metric

The percentage of total customers who are repeat buyers.

repeatPurchaseRevenue.amount Metric

The monetary value generated from repeat purchases by customers.

repeatPurchaseRevenue.currencyCode Dimension

The currency code for repeat purchase revenue (e.g., 'USD', 'EUR').

repeatPurchaseRevenuePctTotal Metric

The percentage of total revenue generated from repeat purchases.

reportingDate Dimension

The specific date for which the data in the report is valid.

revenue Metric

The total monetary amount of sales generated. This can include ordered or shipped revenue.

revenueCurrencyCode Dimension

The three-digit currency code (e.g., USD, EUR) for the revenue amount.

salesMetricsByDate.conversionRate Metric

The rate at which product views convert into sales for a given date.

salesMetricsByDate.customerReturns Metric

The number of units returned by customers for a given date.

salesMetricsByDate.freeReplacements Metric

The number of free replacement units issued to customers for a given date.

salesMetricsByDate.glanceViews Dimension

The number of times product detail pages were viewed by customers for a given date.

salesMetricsByDate.lostBuyBox Metric

Indicates if the product lost the Buy Box for a given date, affecting sales opportunities.

salesMetricsByDate.orderedRevenue Dimension

The revenue generated from customer orders.

salesMetricsByDate.orderedRevenue.amount Metric

The monetary amount of revenue generated from customer orders.

salesMetricsByDate.orderedRevenue.currencyCode Dimension

The three-digit currency code for the ordered revenue amount.

salesMetricsByDate.orderedSubcategorySalesRank Metric

The sales rank of a product within its subcategory based on ordered units for a given date.

salesMetricsByDate.orderedUnits Metric

The total number of units ordered by customers for a given date.

salesMetricsByDate.preOrderedRevenue Dimension

The total revenue from pre-ordered items for a given date.

salesMetricsByDate.preOrderedRevenue.amount Metric

The monetary amount of revenue from pre-ordered items for a given date.

salesMetricsByDate.preOrderedRevenue.currencyCode Dimension

The currency code for the revenue from pre-ordered items for a given date.

salesMetricsByDate.preOrderedUnits Dimension

The total number of pre-ordered units for a given date.

salesMetricsByDate.replenishableOutOfStock Metric

Indicates if replenishable products were out of stock for a given date.

salesMetricsByDate.shippedCOGS Dimension

The total Cost of Goods Sold for items that have been shipped for a given date.

salesMetricsByDate.shippedCOGS.amount Metric

The monetary amount of the Cost of Goods Sold for shipped items for a given date.

salesMetricsByDate.shippedCOGS.currencyCode Dimension

The currency code for the Cost of Goods Sold for shipped items for a given date.

salesMetricsByDate.shippedRevenue Dimension

The revenue generated from products that have been shipped.

salesMetricsByDate.shippedRevenue.amount Metric

The monetary amount of revenue generated from shipped products.

salesMetricsByDate.shippedRevenue.currencyCode Dimension

The three-digit currency code for the shipped revenue amount.

salesMetricsByDate.shippedSubcategorySalesRank Metric

The sales rank of a product within its subcategory based on shipped units for a given date.

salesMetricsByDate.shippedUnits Metric

The total number of units shipped to customers for a given date.

salesRanks.{NUM}.classificationRanks.{NUM}.classificationId Metric

The identifier for a specific product classification (category) in which the product has a sales rank.

salesRanks.{NUM}.classificationRanks.{NUM}.link Dimension

A URL link to the bestsellers page for the product's classification.

salesRanks.{NUM}.classificationRanks.{NUM}.rank Metric

The sales rank of the product within its specific classification (category).

salesRanks.{NUM}.classificationRanks.{NUM}.title Dimension

The title or name of the product classification (category) for which the sales rank is provided.

salesRanks.{NUM}.displayGroupRanks.{NUM}.link Dimension

A URL link to the bestsellers page for the product's display group.

salesRanks.{NUM}.displayGroupRanks.{NUM}.rank Metric

The sales rank of the product within its website display group.

salesRanks.{NUM}.displayGroupRanks.{NUM}.title Dimension

The title or name of the website display group for which the sales rank is provided.

salesRanks.{NUM}.displayGroupRanks.{NUM}.websiteDisplayGroup Dimension

The identifier for the website display group (e.g., 'ce_display_on_website') in which the product has a sales rank.

searchFrequencyRank Metric

The ranking of a search term based on its frequency, indicating its popularity.

searchTerm Dimension

The keyword or phrase entered by a customer into the search bar.

sellThroughRate Dimension

The rate at which inventory is sold over a specific period. This metric is available in Vendor Inventory reports.

sellableOnHandInventoryCost Dimension

The total cost of sellable inventory currently available in Amazon's warehouses.

sellableOnHandInventoryCost.amount Metric

The monetary value of sellable inventory currently available in Amazon's warehouses.

sellableOnHandInventoryCost.currencyCode Dimension

The currency code for the cost of sellable on-hand inventory (e.g., 'USD', 'EUR').

sellableOnHandInventoryUnits Metric

The number of sellable inventory units currently available in Amazon's warehouses.

sellingProgramName Dimension

The name of the selling program under which a product is offered, such as Retail, Business, or Fresh.

shippedCogs.amount Metric

The Cost of Goods Sold (COGS) for products that have been shipped.

shippedCogs.currencyCode Dimension

The currency code for the shipped Cost of Goods Sold (e.g., 'USD', 'EUR').

shippedRevenue.amount Metric

The total monetary value of products that have been shipped to customers.

shippedRevenue.currencyCode Dimension

The currency code for the shipped revenue (e.g., 'USD', 'EUR').

shippedUnits Metric

The total number of units that have been shipped to customers.

startDate Dimension

The start date for the reporting period or data aggregation.

startDateTime Dimension

The date and time when an event or period begins, in ISO 8601 format.

status Dimension

The current status of an entity or process within the platform.

summaries.{NUM}.adultProduct Dimension

Indicates whether the product is classified as an adult product.

summaries.{NUM}.autographed Dimension

Indicates whether the product is autographed.

summaries.{NUM}.brand Dimension

The brand name of the product.

summaries.{NUM}.browseClassification.classificationId Metric

The unique identifier for the product's browse classification.

summaries.{NUM}.browseClassification.displayName Dimension

The display name of the product's browse classification.

summaries.{NUM}.color Dimension

The color of the product.

summaries.{NUM}.contributors.{NUM}.role.displayName Dimension

The display name of the contributor's role (e.g., 'Author', 'Artist').

summaries.{NUM}.contributors.{NUM}.role.value Dimension

The internal value of the contributor's role.

summaries.{NUM}.contributors.{NUM}.value Dimension

The name of the contributor.

summaries.{NUM}.itemClassification Dimension

The classification of the item (e.g., 'BOOK', 'ELECTRONICS').

summaries.{NUM}.itemName Dimension

The name or title of the product.

summaries.{NUM}.manufacturer Dimension

The manufacturer of the product.

summaries.{NUM}.memorabilia Dimension

Indicates whether the product is memorabilia.

summaries.{NUM}.modelNumber Dimension

The model number of the product.

summaries.{NUM}.packageQuantity Metric

The number of individual units contained in the product package.

summaries.{NUM}.partNumber Dimension

The part number of the product.

summaries.{NUM}.releaseDate Dimension

The release date of the product.

summaries.{NUM}.size Dimension

The size of the product.

summaries.{NUM}.style Dimension

The style of the product.

summaries.{NUM}.tradeInEligible Dimension

Indicates whether the product is eligible for trade-in.

summaries.{NUM}.websiteDisplayGroup Dimension

The identifier for the product's website display group.

summaries.{NUM}.websiteDisplayGroupName Dimension

The display name of the product's website display group.

type Dimension

The classification or category of an item or record, such as a report type or product type.

unfilledCustomerOrderedUnits Metric

The number of units that customers have ordered but have not yet been fulfilled.

unhealthyInventoryCost Dimension

Represents the cost associated with inventory deemed unhealthy, such as aged, excess, or otherwise problematic items, as reported in the vendor inventory reports.

unhealthyInventoryCost.amount Metric

The monetary value of inventory identified as unhealthy.

unhealthyInventoryCost.currencyCode Dimension

The currency code for the unhealthy inventory cost (e.g., 'USD', 'EUR').

unhealthyInventoryUnits Dimension

The number of inventory units identified as unhealthy.

uniqueCustomers Metric

The number of distinct customers who made a purchase.

unitsSold Metric

The total number of units of a product sold. This is available in Vendor Sales reports.

unsellableOnHandInventoryCost Dimension

The total cost of inventory units that are currently in Amazon's warehouses but are not in a sellable condition.

unsellableOnHandInventoryCost.amount Metric

The monetary value of inventory units that are currently in Amazon's warehouses but are not in a sellable condition.

unsellableOnHandInventoryCost.currencyCode Dimension

The currency code for the cost of unsellable on-hand inventory (e.g., 'USD', 'EUR').

unsellableOnHandInventoryUnits Metric

The number of inventory units that are currently in Amazon's warehouses but are not in a sellable condition.

vendorCode Dimension

An identifier for the vendor.

vendorConfirmationRate Metric

The percentage of purchase orders that have been confirmed by the vendor, indicating the vendor's reliability in accepting orders.

vendorDetails.{NUM}.brandCode Dimension

The brand code associated with a specific vendor's product.

vendorDetails.{NUM}.manufacturerCode Dimension

The manufacturer code associated with a specific vendor's product.

vendorDetails.{NUM}.manufacturerCodeParent Dimension

The manufacturer code of the parent company for the vendor's product.

vendorDetails.{NUM}.productCategory.displayName Dimension

The human-readable name of the product category as displayed by Amazon.

vendorDetails.{NUM}.productCategory.value Metric

The internal identifier or value for the product category.

vendorDetails.{NUM}.productGroup Dimension

The product group to which the vendor's product belongs (e.g., Home Entertainment).

vendorDetails.{NUM}.productSubcategory.displayName Dimension

The human-readable name of the product subcategory as displayed by Amazon.

vendorDetails.{NUM}.productSubcategory.value Metric

The internal identifier or value for the product subcategory.

vendorDetails.{NUM}.replenishmentCategory Dimension

The replenishment category for the vendor's product, indicating its supply chain status (e.g., OBSOLETE).