Table Definition

Name	Type	Note
keyword	varchar(1000)	Indexed keyword
asin	varchar(1000)	Amazon Serialized Identification Number
parent_asin	varchar(1000)	Amazon Serialized Identification Number of the Parent product. If equal to `asin` field or null, then asin is a standalone.
brand	varchar(1000)	ASIN brand
page	num	page number as viewed from a desktop
rank	num	Page rank for product listings with 1 being the first organic or sponsored listing on the indicated page. Rank is limited to the associated page, i.e. on page 2, listing ranks start a 1 again.
crosspage_rank	num	Page rank for product listings with 1 being the first organic or sponsored listing on the indicated page. Rank is across all recorded pages and does not reset at each page.
overall_rank	num	Page rank including sponsored brand display, sponsored brand video, and sponsored carousel sections. Sponsored Brand Headline sections will be listed as rank 1. Rank is within the associated page.
Reference the `display_type` field to determine which type of display.
crosspage_overall_rank	num	Page rank including sponsored brand display, sponsored brand video, and sponsored carousel sections. Sponsored Brand Headline sections will be listed as rank 1. Rank is across all recorded pages and does not reset on each page
Reference the `display_type` field to determine which type of display.
type	varchar(1000)	type of listing: `organic` , `sponsored`
display_type	varchar(1000)	type of display: `search_result` , `sponsored_headline` , `sponsored_video`, `sponsored_carousel`
badge	varchar(1000)	US [ `Best Seller`,`Amazon's Choice`, `Overall Pick`, `Popular Brand Pick`, `Editors' pick`, `Goodreads Choice`, `Teachers' pick`, `New Arrival Pick`, `Prescription Required` ]

DE [ Amazons Tipp , Bestseller, Exklusiv bei Amazon, Lehrerempfehlung, Kinderbuchtipp]

ES [ Opción Amazon, Exclusivo en Amazon, Más vendido]

FR [ Choix d'Amazon , N°1 des ventes, Exclusivité Amazon]

IT [ Scelta Amazon, Più venduto, Esclusiva Amazon]