Amazon Seller Central data warehouse table groups

Prev Next

Table: SALES_AND_TRAFFIC_BY_DATE

average_offer_count
average_parent_items
browser_page_views
browser_page_views_b2b
browser_sessions
browser_sessions_b2b
buy_box_percentage
buy_box_percentage_b2b
claims_amount
claims_granted
dataSourceName
date
feedback_received
marketplace_id
marketplace_name
mobile_app_page_views
mobile_app_page_views_b2b
mobile_app_sessions
mobile_app_sessions_b2b
negative_feedback_received
order_item_session_percentage
order_item_session_percentage_b2b
ordered_product_sales
ordered_product_sales_b2b
orders_shipped
page_views
page_views_b2b
seller_id
sessions
sessions_b2b
shipped_product_sales
total_order_items
total_order_items_b2b
unit_session_percentage
unit_session_percentage_b2b
units_ordered
units_ordered_b2b
units_refunded
units_shipped

Table: SALES_AND_TRAFFIC_BY_ASIN

asin
brand
browser_page_views
browser_page_views_b2b
browser_sessions
browser_sessions_b2b
buy_box_percentage
buy_box_percentage_b2b
child_asin
dataSourceName
marketplace_id
marketplace_name
mobile_app_page_views
mobile_app_page_views_b2b
mobile_app_sessions
mobile_app_sessions_b2b
ordered_product_sales
ordered_product_sales_b2b
page_views
page_views_b2b
parent_asin
seller_id
sessions
sessions_b2b
sku
title
today
total_order_items
total_order_items_b2b
unit_session_percentage
unit_session_percentage_b2b
units_ordered
units_ordered_b2b

Table: ORDER

amazon_order_id
asin
currency
date
fulfillment_channel
gift_wrap_price
gift_wrap_tax
is_business_order
item_price
item_promotion_discount
item_quantity
item_status
item_tax
last_updated_date
last_updated_datetime
merchant_order_id
order_channel
order_status
price_designation
product_name
promotion_ids
purchase_date
purchase_datetime
purchase_order_number
sales_channel
ship_city
ship_country
ship_postal_code
ship_promotion_discount
ship_service_level
ship_state
shipping_price
shipping_tax
signature_confirmation_recommended
sku