The Sales Estimates and ASIN Metadata datasets are getting an update with multiple new fields that better represent our data, include new fields for enhanced analysis, and improved relationships between related fields

Sales Estimates

Sales Estimates V2 Sales Estimates V3 Notes
start_date start_date no change
end_date end_date no change
asin asin no change
is_available is_available Change to boolean
category_rank — Remove in favor of category_ranks
subcategory_rank — remove in favor of category_ranks
brand brand no change
name title More accurate field name
— category_ranks (array<object>) Object to indicate all ranking categories and their associated IDs/ranks. ranking categories[ranking_category_1( category_id: {integer}, category_rank: {integer})ranking_category_2( category_id: {integer}, category_rank: {integer})]
root_category_id root_category_id no change
image_url image_url_sample More accurate field name
price average_price More accurate field name
review_count parent_rating_count more accurate field name
ratings average_rating more accurate field name
breadcrumb_path_category_ids breadcrumb_path_category_ids no change
ranking_category_ids — remove in favor of category_ranks
first_date_available first_date_available no change
revenue revenue no change
revenue_1p revenue_1p no change
revenue_3p revenue_3p no change
sales sales no change
sales_1p sales_1p no change
sales_3p sales_3p no change
seller_ids — Remove in favor of Sellers field
seller_id_mode — remove in favor of dominant_seller_id
— dominant_seller_id
seller_types — Remove in favor of Sellers field
—- 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}))

ASIN Metadata

ASIN metadata ASIN metadata V3 Notes
start_date start_date no change
end_date end_date no change
asin asin no change
is_available is_available change to boolean
category_rank — Remove in favor of category_ranks
subcategory_rank — remove in favor of category_ranks
— category_ranks (object) Object to indicate all ranking categories and their associated IDs. ranking categories(ranking_category_1( category_id: {integer}, category_rank: {integer})ranking_category_2( category_id: {integer}, category_rank: {integer}))
root_category_id root_category_id no change
breadcrumb_path_category_ids breadcrumb_path_category_ids no change
first_date_available first_date_available no change
images images_url no change
name title more accurate field name
parent_asin parent_asin no change
fees new - total fees
fee_ breakdown (array) new - fee breakdown as stored in products table
price median_buybox_price more accurate field name
— buybox_price_mode most commonly occurring price
— average_list_price new field
—— variant_rating_count new field
review_count parent_rating_count more accurate field name
ratings average_rating more accurate field name
seller_ids — Remove in favor of Sellers field
seller_types — Remove in favor of Sellers field
—- Sellers (Object) Field to show both sellers and their type. seller_1( seller_id: {string}, seller_type: {string}), seller_2( seller_id: {string}, seller_type: {string}))
— dominant_seller_id
ranking_category_ids — remove in favor of category_ranks
— ean (integer) new field
— upc array[(string)] new field
— gtin (string) new field
part_number (string) new field
— subscribe_save (boolean) new field
— discount_type (string) new field
— coupon_amount (decimal) new field
— coupon_percent (decimal) new field
— variation_theme_attributes (type: {string}, value:{string})
ex: (type:size, value: large)
— unit_count 5 (ie pack size)
marketplace marketplace no change