Amazon Seller Central data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: SALES_AND_TRAFFIC_BY_DATE

average_offer_count
Display name Average offer count
Description The average number of offers listed for sale created on the particular day
Field type metric
Data type float.number.value
average_parent_items
Display name Average parent items
Description The average number of parent items listed for sale created on the particular day
Field type metric
Data type float.number.value
browser_page_views
Display name Page views - browser
Description Number of page views from desktop browsers
Field type metric
Data type int.number.value
browser_page_views_b2b
Display name Page views - browser - B2B
Description Number of page views from desktop browsers for B2B customers
Field type metric
Data type int.number.value
browser_sessions
Display name Sessions - browser
Description Number of sessions from desktop browsers
Field type metric
Data type int.number.value
browser_sessions_b2b
Display name Sessions - browser - B2B
Description Number of sessions from desktop browsers for B2B customers
Field type metric
Data type int.number.value
buy_box_percentage
Display name Featured offer (buy box) percentage
Description Percentage of time your products were displayed in the Buy Box
Field type metric
Data type float.number.percentage
buy_box_percentage_b2b
Display name Featured offer (buy box) percentage - B2B
Description Percentage of time your products were displayed in the Buy Box for B2B customers
Field type metric
Data type float.number.percentage
claims_amount
Display name Claims amount
Description Total amount of money paid out in claims
Field type metric
Data type float.currency.value
claims_granted
Display name A-to-z claims granted
Description Total number of claims granted
Field type metric
Data type int.number.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Field type dimension
Data type string.time.date
feedback_received
Display name Feedback received
Description Total number of feedback ratings received
Field type metric
Data type int.number.value
marketplace_id
Display name Marketplace ID
Description Amazon marketplace identifier
Field type dimension
Data type string.text.value
marketplace_name
Display name Marketplace name
Description Amazon marketplace name
Field type dimension
Data type string.text.value
mobile_app_page_views
Display name Page views - mobile app
Description Number of page views from mobile apps
Field type metric
Data type int.number.value
mobile_app_page_views_b2b
Display name Page views - mobile app - B2B
Description Number of page views from mobile apps for B2B customers
Field type metric
Data type int.number.value
mobile_app_sessions
Display name Sessions - mobile app
Description Number of sessions from mobile apps
Field type metric
Data type int.number.value
mobile_app_sessions_b2b
Display name Sessions - mobile app - B2B
Description Number of sessions from mobile apps for B2B customers
Field type metric
Data type int.number.value
negative_feedback_received
Display name Negative feedback received
Description Total number of negative feedback ratings received
Field type metric
Data type int.number.value
order_item_session_percentage
Display name Order item session percentage
Description Percentage of sessions that resulted in an order
Field type metric
Data type float.number.percentage
order_item_session_percentage_b2b
Display name Order item session percentage - B2B
Description Percentage of sessions that resulted in an order for B2B customers
Field type metric
Data type float.number.percentage
ordered_product_sales
Display name Ordered product sales
Description Total revenue from products ordered, excluding taxes and shipping costs
Field type metric
Data type float.currency.value
ordered_product_sales_b2b
Display name Ordered product sales - B2B
Description Total revenue from products ordered by business-to-business B2B customers, excluding taxes and shipping costs
Field type metric
Data type float.currency.value
orders_shipped
Display name Orders shipped
Description Total number of orders shipped
Field type metric
Data type int.number.value
page_views
Display name Page views - total
Description Total number of page views
Field type metric
Data type int.number.value
page_views_b2b
Display name Page views - total - B2B
Description Total number of page views for B2B customers
Field type metric
Data type int.number.value
seller_id
Display name Seller ID
Description Amazon seller ID, it is unique to a given seller
Field type dimension
Data type string.text.value
sessions
Display name Sessions - total
Description Total number of sessions
Field type metric
Data type int.number.value
sessions_b2b
Display name Sessions - total - B2B
Description Total number of sessions for B2B customers
Field type metric
Data type int.number.value
shipped_product_sales
Display name Shipped product sales
Description Total revenue from products shipped, excluding taxes and shipping costs
Field type metric
Data type float.currency.value
total_order_items
Display name Total order items
Description Total number of items ordered, including multiple quantities of the same product
Field type metric
Data type int.number.value
total_order_items_b2b
Display name Total order items - B2B
Description Total number of items ordered by B2B customers
Field type metric
Data type int.number.value
unit_session_percentage
Display name Unit session percentage
Description Percentage of sessions that resulted in a unit sale
Field type metric
Data type float.number.percentage
unit_session_percentage_b2b
Display name Unit session percentage - B2B
Description Percentage of sessions that resulted in a unit sale for B2B customers
Field type metric
Data type float.number.percentage
units_ordered
Display name Units ordered
Description Total number of units ordered, regardless of whether they were fulfilled or refunded
Field type metric
Data type int.number.value
units_ordered_b2b
Display name Units ordered - B2B
Description Total number of units ordered by B2B customers
Field type metric
Data type int.number.value
units_refunded
Display name Units refunded
Description Total number of units refunded
Field type metric
Data type int.number.value
units_shipped
Display name Units shipped
Description Total number of units shipped
Field type metric
Data type int.number.value

Table: SALES_AND_TRAFFIC_BY_ASIN

asin
Display name ASIN
Field type dimension
Data type string.text.value
brand
Display name Brand
Description Name of the brand associated with an Amazon catalog item
Field type dimension
Data type string.text.value
browser_page_views
Display name Page views - browser
Description Number of page views from desktop browsers
Field type metric
Data type int.number.value
browser_page_views_b2b
Display name Page views - browser - B2B
Description Number of page views from desktop browsers for B2B customers
Field type metric
Data type int.number.value
browser_sessions
Display name Sessions - browser
Description Number of sessions from desktop browsers
Field type metric
Data type int.number.value
browser_sessions_b2b
Display name Sessions - browser - B2B
Description Number of sessions from desktop browsers for B2B customers
Field type metric
Data type int.number.value
buy_box_percentage
Display name Featured offer (buy box) percentage
Description Percentage of time your products were displayed in the Buy Box
Field type metric
Data type float.number.percentage
buy_box_percentage_b2b
Display name Featured offer (buy box) percentage - B2B
Description Percentage of time your products were displayed in the Buy Box for B2B customers
Field type metric
Data type float.number.percentage
child_asin
Display name (Child) ASIN
Description Identifiers (ASINs) of the related items that are children of this item
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
marketplace_id
Display name Marketplace ID
Description Amazon marketplace identifier
Field type dimension
Data type string.text.value
marketplace_name
Display name Marketplace name
Description Amazon marketplace name
Field type dimension
Data type string.text.value
mobile_app_page_views
Display name Page views - mobile app
Description Number of page views from mobile apps
Field type metric
Data type int.number.value
mobile_app_page_views_b2b
Display name Page views - mobile app - B2B
Description Number of page views from mobile apps for B2B customers
Field type metric
Data type int.number.value
mobile_app_sessions
Display name Sessions - mobile app
Description Number of sessions from mobile apps
Field type metric
Data type int.number.value
mobile_app_sessions_b2b
Display name Sessions - mobile app - B2B
Description Number of sessions from mobile apps for B2B customers
Field type metric
Data type int.number.value
ordered_product_sales
Display name Ordered product sales
Description Total revenue from products ordered, excluding taxes and shipping costs
Field type metric
Data type float.currency.value
ordered_product_sales_b2b
Display name Ordered product sales - B2B
Description Total revenue from products ordered by business-to-business B2B customers, excluding taxes and shipping costs
Field type metric
Data type float.currency.value
page_views
Display name Page views - total
Description Total number of page views
Field type metric
Data type int.number.value
page_views_b2b
Display name Page views - total - B2B
Description Total number of page views for B2B customers
Field type metric
Data type int.number.value
parent_asin
Display name (Parent) ASIN
Description Identifiers (ASINs) of the related items that are parents of this item
Field type dimension
Data type string.text.value
seller_id
Display name Seller ID
Description Amazon seller ID, it is unique to a given seller
Field type dimension
Data type string.text.value
sessions
Display name Sessions - total
Description Total number of sessions
Field type metric
Data type int.number.value
sessions_b2b
Display name Sessions - total - B2B
Description Total number of sessions for B2B customers
Field type metric
Data type int.number.value
sku
Display name SKU
Description Stock Keeping Unit, a seller-specified identifier for an Amazon listing
Field type dimension
Data type string.text.value
title
Display name Title
Description Name, or title, associated with an Amazon catalog item
Field type dimension
Data type string.text.value
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
total_order_items
Display name Total order items
Description Total number of items ordered, including multiple quantities of the same product
Field type metric
Data type int.number.value
total_order_items_b2b
Display name Total order items - B2B
Description Total number of items ordered by B2B customers
Field type metric
Data type int.number.value
unit_session_percentage
Display name Unit session percentage
Description Percentage of sessions that resulted in a unit sale
Field type metric
Data type float.number.percentage
unit_session_percentage_b2b
Display name Unit session percentage - B2B
Description Percentage of sessions that resulted in a unit sale for B2B customers
Field type metric
Data type float.number.percentage
units_ordered
Display name Units ordered
Description Total number of units ordered, regardless of whether they were fulfilled or refunded
Field type metric
Data type int.number.value
units_ordered_b2b
Display name Units ordered - B2B
Description Total number of units ordered by B2B customers
Field type metric
Data type int.number.value

Table: ORDER

amazon_order_id
Display name Amazon order ID
Description Unique identifier for the order assigned by Amazon
Field type dimension
Data type string.text.value
asin
Display name ASIN
Field type dimension
Data type string.text.value
currency
Display name Currency
Description Currency in which the order was placed
Field type dimension
Data type string.currency.code
date
Display name Date
Field type dimension
Data type string.time.date
fulfillment_channel
Display name Fulfillment channel
Description Channel through which the order will be fulfilled (e.g., Seller Fulfilled Prime, Amazon Fulfilled)
Field type dimension
Data type string.text.value
gift_wrap_price
Display name Gift wrap price
Description Cost of any gift wrapping selected by the customer
Field type metric
Data type float.currency.value
gift_wrap_tax
Display name Gift wrap tax
Description Sales tax applicable to the gift wrapping cost
Field type metric
Data type float.currency.value
is_business_order
Display name Is business order
Description Indicates whether the order is a business order
Field type dimension
Data type bool
item_price
Display name Item price
Description Price of each individual item
Field type metric
Data type float.currency.value
item_promotion_discount
Display name Item promotion discount
Description Discount applied to the total price of the items
Field type metric
Data type float.currency.value
item_quantity
Display name Item quantity
Description The quantity of the item ordered
Field type metric
Data type int.number.value
item_status
Display name Item status
Description Status of the individual items in the order (e.g., Ordered, In Stock, Shipped, Delivered, Canceled)
Field type dimension
Data type string.text.value
item_tax
Display name Item tax
Description Sales tax applicable to each item
Field type metric
Data type float.currency.value
last_updated_date
Display name Last updated date
Description Date the order was last updated
Field type dimension
Data type string.time.date
last_updated_datetime
Display name Last updated datetime
Description Date and time the order was last updated
Field type dimension
Data type string.time.datetime
merchant_order_id
Display name Merchant order ID
Description Merchant-defined identifier for the order
Field type dimension
Data type string.text.value
order_channel
Display name Order channel
Description Channel through which the order was initiated (e.g., website, mobile app, third-party marketplace)
Field type dimension
Data type string.text.value
order_status
Display name Order status
Description Current status of the order (e.g., New, Pending, Shipped, Delivered, Closed)
Field type dimension
Data type string.text.value
price_designation
Display name Price designation
Description Indicates the method used to determine the price of the order (e.g., Standard Price, Configurable Price)
Field type dimension
Data type string.text.value
product_name
Display name Product name
Description Title of the product being ordered
Field type dimension
Data type string.text.value
promotion_ids
Display name Promotion IDs
Description IDs of any promotions applied to the order
Field type dimension
Data type string.text.value
purchase_date
Display name Purchase date
Description Date the order was placed
Field type dimension
Data type string.time.date
purchase_datetime
Display name Purchase datetime
Description Date and time the order was placed
Field type dimension
Data type string.time.datetime
purchase_order_number
Display name Purchase order number
Description Purchase order number associated with the order, if applicable
Field type dimension
Data type string.text.value
sales_channel
Display name Sales channel
Description Channel through which the order was placed (e.g., Amazon.com, Amazon App, Amazon Marketplace)
Field type dimension
Data type string.text.value
ship_city
Display name Ship city
Description City where the order should be shipped
Field type dimension
Data type string.geo.city
ship_country
Display name Ship country
Description Country where the order should be shipped
Field type dimension
Data type string.geo.country
ship_postal_code
Display name Ship postal code
Description Postal code where the order should be shipped
Field type dimension
Data type string.geo.zip
ship_promotion_discount
Display name Ship promotion discount
Description Discount applied to the shipping cost
Field type metric
Data type float.currency.value
ship_service_level
Display name Ship service level
Description Shipping service level chosen by the customer
Field type dimension
Data type string.text.value
ship_state
Display name Ship state
Description State or province where the order should be shipped
Field type dimension
Data type string.geo.region
shipping_price
Display name Shipping price
Description Total shipping cost for the order
Field type metric
Data type float.currency.value
shipping_tax
Display name Shipping tax
Description Sales tax applicable to the shipping cost
Field type metric
Data type float.currency.value
signature_confirmation_recommended
Display name Signature confirmation recommended
Description Indicates whether signature confirmation is recommended for the shipping address
Field type dimension
Data type bool
sku
Display name SKU
Description Stock Keeping Unit, a seller-specified identifier for an Amazon listing
Field type dimension
Data type string.text.value