Amazon Seller Metrics and Dimensions

Field group
Field
Type
Data type
Description
SalesUnits
METRIC
INTEGERThe number of units in orders
SalesOrder Items
METRIC
INTEGERThe number of order items
SalesOrders
METRIC
INTEGERThe number of orders
SalesAvg Unit Price
METRIC
FLOATThe average price for an item
SalesTotal Sales
METRIC
FLOATThe total ordered product sales for all orders
InventoryFulfillable Quantity
METRIC
INTEGERThe item quantity that can be picked, packed, and shipped
InventoryInbound Working Quantity
METRIC
INTEGERThe number of units in an inbound shipment for which you have notified Amazon
InventoryInbound Shipped Quantity
METRIC
INTEGERThe number of units in an inbound shipment that you have notified Amazon about and have provided a tracking number
InventoryInbound Receiving Quantity
METRIC
INTEGERThe number of units that have not yet been received at an Amazon fulfillment center for processing, but are part of an inbound shipment with some units that have already been received and processed
InventoryTotal Reserved Quantity
METRIC
INTEGERThe total number of units in Amazon's fulfillment network that are currently being picked, packed, and shipped; or are sidelined for measurement, sampling, or other internal processes
InventoryPending Customer Order Quantity
METRIC
INTEGERThe number of units reserved for customer orders
InventoryPending Trans Shipment Quantity
METRIC
INTEGERThe number of units being transferred from one fulfillment center to another
InventoryFC Processing Quantity
METRIC
INTEGERThe number of units that have been sidelined at the fulfillment center for additional processing
InventoryResearching Quantity
METRIC
INTEGERThe total number of units currently being researched in Amazon's fulfillment network
InventoryUnfulfillable Quantity
METRIC
INTEGERThe total number of units in Amazon's fulfillment network in unsellable condition
InventoryCustomer Damaged Quantity
METRIC
INTEGERThe number of units in customer damaged disposition
InventoryWarehouse Damaged Quantity
METRIC
INTEGERThe number of units in warehouse damaged disposition
InventoryDistributor Damaged Quantity
METRIC
INTEGERThe number of units in distributor damaged disposition
InventoryCarrier Damaged Quantity
METRIC
INTEGERThe number of units in carrier damaged disposition
InventoryDefective Quantity
METRIC
INTEGERThe number of units in defective disposition
InventoryExpired Quantity
METRIC
INTEGERThe number of units in expired disposition
InventoryTotal Quantity
METRIC
INTEGERTotal quantity
OrderTotal Amount
METRIC
FLOATThe total charge for this order
OrderShipped Items
METRIC
INTEGERThe number of items shipped
OrderUnshipped Items
METRIC
INTEGERThe number of items unshipped
MarketplaceMarketplace ID
DIMENSION
STRINGThe encrypted unique ID of the marketplace
MarketplaceMarketplace name
DIMENSION
STRINGThe name of the marketplace
MarketplaceMarketplace host name
DIMENSION
URLThe host name of the marketplace
MarketplaceMarketplace country code
DIMENSION
COUNTRY_CODEThe country code of the marketplace
SalesCurrency Code (Avg unit price)
DIMENSION
STRINGThree-digit currency code of average unit price. In ISO 4217 format
SalesCurrency Code (Total sales)
DIMENSION
STRINGThree-digit currency code of total sales. In ISO 4217 format
InventoryASIN
DIMENSION
STRINGThe Amazon Standard Identification Number (ASIN) of the item
Inventoryfn SKU
DIMENSION
STRINGA unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center
InventorySeller SKU
DIMENSION
STRINGThe stock keeping unit (SKU) of the item
InventoryItem Condition
DIMENSION
STRINGThe condition of the item
InventoryProduct Name
DIMENSION
STRINGProduct name
OrderAmazon Order Id
DIMENSION
STRINGAn Amazon-defined order identifier, in 3-7-7 format
OrderSeller Order Id
DIMENSION
STRINGA seller-defined order identifier
OrderPurchase Datetime
DIMENSION
DATETIMEThe date when the order was created
OrderLast Update Datetime
DIMENSION
DATETIMEThe date when the order was last updated
OrderOrder Status
DIMENSION
STRINGThe current order status. (Pending,Unshipped,PartiallyShipped,Shipped,Canceled,Unfulfillable,InvoiceUnconfirmed,PendingAvailability)
OrderSales Channel
DIMENSION
STRINGThe sales channel of the first item in the order
OrderOrder Channel
DIMENSION
STRINGThe order channel of the first item in the order
OrderShipment Service Level
DIMENSION
STRINGThe shipment service level of the order
OrderPayment Method
DIMENSION
STRINGThe payment method for the order (COD - Cash On Delivery,CVS - Convenience Store or Other)
OrderShipment Service Level Category
DIMENSION
STRINGThe shipment service level category of the order (Possible values: Expedited, FreeEconomy, NextDay, SameDay, SecondDay, Scheduled, Standard)
OrderShipping Label (CBA)
DIMENSION
STRINGCustom shipping label for Checkout by Amazon (CBA)
OrderOrder Type
DIMENSION
STRINGThe type of the order (StandardOrder,LongLeadTimeOrder,Preorder,BackOrder or SourcingOnDemandOrder)
OrderEarliest Ship Datetime
DIMENSION
DATETIMEThe start of the time period within which you have committed to ship the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders
OrderLatest Ship Datetime
DIMENSION
DATETIMEThe end of the time period within which you have committed to ship the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders
OrderEarliest Delivery Datetime
DIMENSION
DATETIMEThe start of the time period within which you have committed to fulfill the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders
OrderLatest Delivery Datetime
DIMENSION
DATETIMEThe end of the time period within which you have committed to fulfill the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders that do not have a PendingAvailability, Pending, or Canceled status
OrderEstimated Shipping Date
DIMENSION
DATETIMEIndicates the date by which the seller must respond to the buyer with an estimated ship date. Returned only for Sourcing on Demand orders
OrderIs Business Order
DIMENSION
BOOLEANWhen true, the order is an Amazon Business order. An Amazon Business order is an order where the buyer is a Verified Business Buyer
OrderIs Prime
DIMENSION
BOOLEANWhen true, the order is a seller-fulfilled Amazon Prime order
OrderIs Premium Order
DIMENSION
BOOLEANWhen true, the order has a Premium Shipping Service Level Agreement
OrderIs Global Express Enabled
DIMENSION
BOOLEANWhen true, the order is a GlobalExpress order
OrderReplacement Order Id
DIMENSION
STRINGThe order ID value for the order that is being replaced. Returned only if IsReplacementOrder = true
OrderIs Replacement Order
DIMENSION
BOOLEANWhen true, this is a replacement order
OrderIs Shipping Date Set
DIMENSION
BOOLEANWhen true, the estimated shipping date is set for the order. Returned only for Sourcing on Demand orders
OrderIs Sold By AB
DIMENSION
BOOLEANWhen true, the item within this order was bought and re-sold by Amazon Business EU SARL (ABEU). By buying and instantly re-selling your items, ABEU becomes the seller of record, making your inventory available for sale to customers who would not otherwise purchase from a third-party seller
OrderFulfillment Supply SourceId
DIMENSION
STRINGDenotes the recommended sourceId where the order should be fulfilled from
OrderIs Store Pickup
DIMENSION
BOOLEANWhen true, this order is marked to be picked up from a store rather than delivered
OrderCurrency Code (Order Amount)
DIMENSION
STRINGThe three-digit currency code
OrderPayment Method Details
DIMENSION
STRINGA list of payment method detail items
OrderShipping From Location
DIMENSION
STRINGThe recommended location name for the seller to ship the items from. It is calculated at checkout.
OrderShipping From AddressLine2
DIMENSION
STRINGThe recommended location addressline for the seller to ship the items from. It is calculated at checkout.
OrderShipping From AddressLine2
DIMENSION
STRINGThe recommended location addressline for the seller to ship the items from. It is calculated at checkout.
OrderShipping From AddressLine3
DIMENSION
STRINGThe recommended location addressline for the seller to ship the items from. It is calculated at checkout.
OrderShipping From City
DIMENSION
STRINGThe recommended location city for the seller to ship the items from. It is calculated at checkout.
OrderShipping From Country
DIMENSION
STRINGThe recommended location country for the seller to ship the items from. It is calculated at checkout.
OrderShipping From District
DIMENSION
STRINGThe recommended location district for the seller to ship the items from. It is calculated at checkout.
OrderShipping From State or Region
DIMENSION
STRINGThe recommended location state or region for the seller to ship the items from. It is calculated at checkout.
OrderShipping From Municipality
DIMENSION
STRINGThe recommended location municipality for the seller to ship the items from. It is calculated at checkout.
OrderShipping From PostalCode
DIMENSION
STRINGThe recommended location postal code for the seller to ship the items from. It is calculated at checkout.
OrderCountry Code (Shipping From Location)
DIMENSION
STRINGThe recommended location country code for the seller to ship the items from. It is calculated at checkout.
OrderPhone number (Shipping From Location)
DIMENSION
STRINGThe recommended location contact no for the seller to ship the items from. It is calculated at checkout.
OrderShipping From Address-type
DIMENSION
STRINGThe recommended location address type for the seller to ship the items from. It is calculated at checkout.