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]

UK [ Amazon Exclusive, Best Seller, Amazon's Choice, Teachers' pick, BookTrust pick] | | date | timestamp | date of data capture |