Docs
Amazon Seller Fields List
133 fields · 107 metrics · 26 dimensions
BigQuery
Looker Studio
Google Sheets
Power BI| Field Name | Label | Type | Description | Group |
|---|---|---|---|---|
| Buyers6 fields | ||||
BuyerCounty |
Buyer County | Metric | The total count of buyer y recorded during the reporting period. | Buyers |
BuyerEmail |
Buyer Email | Metric | The email address of the buyer. | Buyers |
BuyerName |
Buyer Name | Dimension | The display name of the buyer as configured in Amazon Seller. | Buyers |
BuyerPurchaseOrderNumber |
Buyer Purchase Order Number | Metric | The purchase order (PO) number entered by the buyer at checkout. Returned only for orders where the buyer entered a PO number at checkout. | Buyers |
BuyerTaxInfoCompanyLegalName |
Buyer Tax Company Legal Name | Dimension | The legal name of the company. | Buyers |
BuyerTaxInfoTaxingRegion |
Buyer Taxing Region | Metric | Buyer Taxing Region metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Buyers |
| Date10 fields | ||||
Date |
Date | Dimension | Timestamp or date value for date. Used for time-series analysis and filtering. | Date |
day_of_week |
Day of week (Mon – Sun) | Metric | Day of week (Mon – Sun) metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Date |
hour |
Hour of day | Metric | Hour of day metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Date |
month |
Month | Metric | Month metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Date |
quarter |
Quarter | Metric | Quarter metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Date |
week |
Week | Metric | Week metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Date |
year |
Year | Metric | Year metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Date |
year_month |
Month and year | Metric | Month and year metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Date |
year_quarter |
Quarter and year | Metric | Quarter and year metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Date |
year_week |
Week and year | Metric | Week and year metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Date |
| FBA Inventory21 fields | ||||
InventorylastUpdatedTime |
Inventory Last Updated Time | Dimension | The last updated time of the inventory. | FBA Inventory |
carrierDamagedQuantity |
Carrier Damaged Quantity | Metric | The number of units in carrier damaged disposition. | FBA Inventory |
customerDamagedQuantity |
Customer Damaged Quantity | Metric | The number of units in customer damaged disposition. | FBA Inventory |
defectiveQuantity |
Defective Quantity | Metric | The number of units in defective disposition. | FBA Inventory |
distributorDamagedQuantity |
Distributor Damaged Quantity | Metric | The number of units in distributor damaged disposition. | FBA Inventory |
expiredQuantity |
Expired Quantity | Metric | The number of units in expired disposition. | FBA Inventory |
fcProcessingQuantity |
FC Processing Quantity | Metric | The number of units in Amazon fulfillment centers that are being processed for customer orders. | FBA Inventory |
fnSku |
Fulfillment Network SKU | Metric | Fulfillment Network SKU metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | FBA Inventory |
fulfillableQuantity |
Fulfillable Quantity | Metric | The number of units in an inbound shipment or in Amazon fulfillment centers that are available for fulfillment. | FBA Inventory |
inboundReceivingQuantity |
Inbound Receiving Quantity | Metric | The number of units in an inbound shipment that are being received at Amazon fulfillment centers. | FBA Inventory |
inboundShippedQuantity |
Inbound Shipped Quantity | Metric | The number of units in an inbound shipment that have been received at Amazon fulfillment centers. | FBA Inventory |
inboundWorkingQuantity |
Inbound Working Quantity | Metric | The number of units in an inbound shipment that are being processed for placement into fulfillment centers. | FBA Inventory |
pendingCustomerOrderQuantity |
Pending Customer Order Quantity | Metric | The number of units in Amazon fulfillment centers that are reserved for customer orders. | FBA Inventory |
pendingTransshipmentQuantity |
pending Transshipment Quantity | Metric | The number of units being transferred from one fulfillment center to another. | FBA Inventory |
productName |
Product Name | Dimension | The display name of the product as configured in Amazon Seller. | FBA Inventory |
productType |
Product Type | Dimension | Product Type metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | FBA Inventory |
totalQuantity |
Total Quantity | Metric | The total number of units in an inbound shipment or in Amazon fulfillment centers. | FBA Inventory |
totalResearchingQuantity |
Total Researching Quantity | Metric | The total number of units in an inbound shipment or in Amazon fulfillment centers that are being researched. | FBA Inventory |
totalReservedQuantity |
Total Reserved Quantity | Metric | The total number of units in an inbound shipment or in Amazon fulfillment centers that are reserved for orders. | FBA Inventory |
totalUnfulfillableQuantity |
Total Unfulfillable Quantity | Metric | The total number of units in Amazon’s fulfillment network in unsellable condition.. | FBA Inventory |
warehouseDamagedQuantity |
Warehouse Damaged Quantity | Metric | The number of units in warehouse damaged disposition. | FBA Inventory |
| Items35 fields | ||||
ASIN |
ASIN | Metric | The Amazon Standard Identification Number (ASIN) of the item. | Items |
CODFee |
COD Fee | Metric | COD Fee metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
CODFeeDiscount |
COD Fee Discount | Metric | The total count of cod fee dis recorded during the reporting period. | Items |
ConditionId |
Condition Id | Dimension | Unique identifier for the condition in Amazon Seller. | Items |
ConditionNote |
Condition Note | Metric | Condition Note metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
ConditionSubtypeId |
Condition Subtype Id | Dimension | Unique identifier for the condition subtype in Amazon Seller. | Items |
DeemedResellerCategory |
Deemed Reseller Category | Metric | Deemed Reseller Category metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
IossNumber |
Ioss Number | Metric | Ioss Number metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
IsGift |
Is Gift | Metric | Is Gift metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
IsTransparency |
Is Transparency | Metric | Whether the item is a Transparency item. | Items |
ItemPrice |
Item Price | Metric | Item Price metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
ItemTax |
Item Tax | Metric | Item Tax metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
MonetaryValueOfPointsGranted |
Monetary Value Of Points Granted | Metric | The monetary value of the points granted. | Items |
NumberOfItems |
Number Of Items | Metric | The total number of items that are included in the ASIN. | Items |
NumbersOfPointsGranted |
Numbers Of Points Granted | Metric | Numbers Of Points Granted metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
OrderItemId |
Order Item Id | Dimension | The Amazon-defined identifier for an item in an order. | Items |
PriceDesignation |
Price Designation | Metric | Indicates that the selling price is a special price that is available only for Amazon Business orders. | Items |
PromotionDiscount |
Promotion Discount | Metric | The total count of promotion dis recorded during the reporting period. | Items |
PromotionDiscountTax |
Promotion Discount Tax | Metric | The tax on the promotion discount. | Items |
PromotionIds |
Promotion Ids | Metric | Unique identifier for the promotion s in Amazon Seller. | Items |
QuantityOrdered |
Quantity Ordered | Metric | Quantity Ordered metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
QuantityShipped |
Quantity Shipped | Metric | Quantity Shipped metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
ScheduledDeliveryEndDate |
Scheduled Delivery End Date | Metric | Timestamp or date value for scheduled delivery end date. Used for time-series analysis and filtering. | Items |
ScheduledDeliveryStartDate |
Scheduled Delivery Start Date | Metric | Timestamp or date value for scheduled delivery start date. Used for time-series analysis and filtering. | Items |
SellerSKU |
Seller SKU | Metric | Seller SKU metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
SerialNumberRequired |
Serial Number Required | Metric | Whether the item requires a serial number. | Items |
SerialNumbers |
Serial Numbers | Metric | Serial Numbers metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
ShippingDiscount |
Shipping Discount | Metric | The total count of shipping dis recorded during the reporting period. | Items |
ShippingDiscountTax |
Shipping Discount Tax | Metric | The tax on the shipping discount. | Items |
ShippingPrice |
Shipping Price | Metric | Shipping Price metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
ShippingTax |
Shipping Tax | Metric | The tax on the shipping price. | Items |
StoreChainStoreId |
Store Chain Store Id | Dimension | Unique identifier for the store chain store in Amazon Seller. | Items |
TaxCollectionModel |
Tax Collection Model | Metric | Tax Collection Model metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
TaxCollectionResponsibleParty |
Tax Collection Responsible Party | Metric | Tax Collection Responsible Party metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
Title |
Title | Dimension | Title metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Items |
| Listing Items4 fields | ||||
listing_created_date |
Listing Created Date | Dimension | The date when the listing was created. | Listing Items |
listing_item_status |
Listing Item Status | Dimension | The status of the listing item. | Listing Items |
mainImage |
Main Image | Metric | Main Image metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Listing Items |
mainImageURL |
Main Image URL | Metric | Main Image URL metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Listing Items |
| Orders37 fields | ||||
AmazonOrderId |
Amazon Order Id | Dimension | An Amazon-defined order identifier, in 3-7-7 format. | Orders |
BuyerInvoicePreference |
Buyer Invoice Preference | Metric | The buyer’s invoicing preference. Available only in the TR marketplace. | Orders |
CbaDisplayableShippingLabel |
Cba Displayable Shipping Label | Metric | Custom ship label for Checkout by Amazon (CBA). | Orders |
Currency |
Currency code | Metric | Currency code metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Orders |
EarliestDeliveryDate |
Earliest Delivery Date | Metric | The start of the time period within which you have committed to fulfill the order. | Orders |
EarliestShipDate |
Earliest Ship Date | Metric | The start of the time period within which you have committed to ship the order. | Orders |
EasyShipShipmentStatus |
Easy Ship Shipment Status | Dimension | The status of the Easy Ship order. | Orders |
ElectronicInvoiceStatus |
Electronic Invoice Status | Dimension | The status of the electronic invoice. | Orders |
FulfillmentChannel |
Fulfillment Channel | Metric | Indicates whether the order was fulfilled by Amazon (AFN) or by the seller (MFN). | Orders |
HasRegulatedItems |
Has Regulated Items | Metric | Whether the order contains regulated items which may require additional approval steps before being fulfilled. | Orders |
IsAccessPointOrder |
Is Access Point Order | Metric | Indicates whether the order is an Amazon Hub Counter order. | Orders |
IsBusinessOrder |
Is Business Order | Metric | Indicates whether the order is a business order. | Orders |
IsEstimatedShipDateSet |
Is Estimated Ship Date Set | Metric | Indicates whether the seller has set the estimated ship date. | Orders |
IsGlobalExpressEnabled |
Is Global Express Enabled | Metric | Indicates whether the order is a Global Express order. | Orders |
IsIBA |
Is IBA | Metric | Indicates whether the order is an Individual Buyer Agreement (IBA) order. | Orders |
IsISPU |
Is ISPU | Metric | Indicates whether the order is an In-Store Pickup (ISPU) order. | Orders |
IsPremiumOrder |
Is Premium Order | Metric | When true, the order has a Premium Shipping Service Level Agreement. | Orders |
IsPrime |
Is Prime | Metric | Indicates whether the order is a seller-fulfilled Amazon Prime order. | Orders |
IsReplacementOrder |
Is Replacement Order | Metric | Indicates whether the order is a replacement order. | Orders |
IsSoldByAB |
Is Sold By AB | Metric | Indicates whether the order is sold by Amazon Business. | Orders |
LastUpdateDate |
Last Update Date | Dimension | The date when the order was last updated. Note that an order update is defined as any change in order status, including the creation of a new order. | Orders |
LatestDeliveryDate |
Latest Delivery Date | Metric | The end of the time period within which you have committed to fulfill the order. | Orders |
LatestShipDate |
Latest Ship Date | Metric | The end of the time period within which you have committed to ship the order. | Orders |
MarketplaceId |
Marketplace Id | Dimension | The identifier for the marketplace where the order was placed. | Orders |
NumberOfItemsShipped |
Number Of Items Shipped | Metric | Number Of Items Shipped metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Orders |
NumberOfItemsUnshipped |
Number Of Items Unshipped | Metric | Number Of Items Unshipped metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Orders |
OrderChannel |
Order Channel | Metric | The order channel of the first item in the order. | Orders |
OrderStatus |
Order Status | Dimension | The current status of the order. | Orders |
OrderTotalAmount |
Order Total Amount | Metric | The total charge for the order. | Orders |
OrderType |
Order Type | Dimension | Order Type metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Orders |
PromiseResponseDueDate |
Promise Response Due Date | Metric | The date by which the seller must respond to the buyer with an estimated ship date. | Orders |
PurchaseDate |
Purchase Date | Metric | The date when the order was created. | Orders |
ReplacedOrderId |
Replaced Order Id | Dimension | The order ID value for the order that is being replaced. | Orders |
SalesChannel |
Sales Channel | Metric | The sales channel of the first item in the order. | Orders |
SellerOrderId |
Seller Order Id | Dimension | A seller-defined order identifier. | Orders |
ShipServiceLevel |
Ship Service Level | Metric | The shipment service level of the order. | Orders |
ShipmentServiceLevelCategory |
Shipment Service Level Category | Metric | The shipment service level category of the order. | Orders |
| Sales5 fields | ||||
averageUnitPrice |
Average Unit Price | Metric | Average Unit Price metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Sales |
orderCount |
Order Count | Metric | The total count of order recorded during the reporting period. | Sales |
orderItemCount |
Order Item Count | Metric | The total count of order item recorded during the reporting period. | Sales |
totalSales |
Total Sales | Metric | The total count of sales recorded during the reporting period. | Sales |
unitCount |
Unit Count | Metric | The total count of unit recorded during the reporting period. | Sales |
| Sellers1 fields | ||||
SellerDisplayName |
Seller Display Name | Dimension | The displayable name of the seller. | Sellers |
| Shipping Addresses14 fields | ||||
ShippingAddressAddressLine1 |
Shipping Address Line 1 | Metric | The first line of the address. | Shipping Addresses |
ShippingAddressAddressLine2 |
Shipping Address Line 2 | Metric | The first line of the address. | Shipping Addresses |
ShippingAddressAddressLine3 |
Shipping Address Line 3 | Metric | The first line of the address. | Shipping Addresses |
ShippingAddressAddressType |
Shipping Address Address Type | Dimension | Shipping Address Address Type metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Shipping Addresses |
ShippingAddressCity |
Shipping Address City | Metric | Shipping Address City metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Shipping Addresses |
ShippingAddressCountryCode |
Shipping Address Country Code | Metric | The total count of shipping address ry code recorded during the reporting period. | Shipping Addresses |
ShippingAddressCountryName |
Shipping Address Country Name | Dimension | The display name of the shipping address country as configured in Amazon Seller. | Shipping Addresses |
ShippingAddressCounty |
Shipping Address County | Metric | The total count of shipping address y recorded during the reporting period. | Shipping Addresses |
ShippingAddressDistrict |
Shipping Address District | Metric | Shipping Address District metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Shipping Addresses |
ShippingAddressMunicipality |
Shipping Address Municipality | Metric | Shipping Address Municipality metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Shipping Addresses |
ShippingAddressName |
Shipping Address Name | Dimension | The display name of the shipping address as configured in Amazon Seller. | Shipping Addresses |
ShippingAddressPhone |
Shipping Address Phone | Metric | Shipping Address Phone metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Shipping Addresses |
ShippingAddressPostalCode |
Shipping Address Postal Code | Metric | Shipping Address Postal Code metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Shipping Addresses |
ShippingAddressStateOrRegion |
Shipping Address State Or Region | Metric | Shipping Address State Or Region metric from Amazon Seller. This field provides data for reporting and analysis in your marketing dashboards. | Shipping Addresses |