Table Definition

Name Type Note
start_date date Start date of the evaluation period. Amazon’s weekly sales period is Sunday through Saturday
end_date date End date of the evaluation period. Amazon’s weekly sales period is Sunday through Saturday
asin string Amazon Standardized Identification Number. This data sets is indexed on a Parent ASIN, not individual variants/children ASINs. View asin_metadata for a variant level view.
is_available boolean Indicates a product being available for purchase. Unavailable can be due to out of stock, restricted listing, offline, or other reasons.
brand string
title string
category_ranks (array<object>) array<object> Object to indicate all ranking categories and their associated IDs/ranks. Ranks are the last known during the evaluation period.

category_ranks[ ranking_category_1 (category_id: {integer},category_rank: {integer}) ranking_category_2 (category_id: {integer},category_rank: {integer})] | | root_category_id | Integer | ID of the root (main/department) category | | image_url_sample | string | Sample image from list of asins within variant group. Typically the hero image from the main variant | | average_price | decimal | average price across the evaluation period | | parent_rating_count | integer | Rating count of the variant group. This is the value normally seen on the Product Detail page on Amazon | | average_rating | decimal | Average rating - aka Star rating | | breadcrumb_path_category_ids | array<object> | breadcrumb path ordered from root category(main category/department) to leaf node subcategory | | first_date_available | date | determined as either the first date as listed on the product detail page, else the first known rating/review date | | revenue | decimal | | | revenue_1p | decimal | | | revenue_3p | decimal | | | sales | decimal | | | sales_1p | decimal | | | sales_3p | decimal | | | dominant_seller_id | string | The most commonly identified seller_id across all variants | | Sellers (array<Object>) | Sellers (array<Object>) | Field to show both sellers and their type.

sellers [ seller_1 (seller_id: {string}, seller_type: {string}),
seller_ 2( seller_id: {string},seller_type: {string})] |