Sales and Traffic by Child ASIN

Table name Seller: sales_and_traffic_detail_sales_traffic_by_child_item

This report summarizes sales, revenue, traffic, and related metrics by day for every product in a Seller's catalog.

By SKU vs. by Child ASIN

There are multiple variations of this report. Sellers can view the sales and traffic by SKU or by Child ASIN.

Both reports share the same sales and traffic metrics, however, by SKU gives additional granularity of breaking out sales by SKU as some sellers may opt to try and distinguish where a product is fulfilled from (FBA vs. MFN). While sales and traffic by SKU breaks out sales granularity, it should be noted that traffic metrics become duplicative when there are many SKU's to one child ASIN.

B2B data vs. total business data

Amazon makes this somewhat confusing, but metric columns like ordered_product_sales and units_ordered are inclusive of both consumer and B2B customers. The _b2b version of each column is only B2B customer data. Therefore, you must subtract the _b2b column to get consumer data.

Data Dictionary