Table Definition

Name Type Note
keyword varchar(1000) searched keyword
asin varchar(40) Amazon Serialized Identification Number
click_rank int ASIN rank by number of clicks from given keyword search results page. Ranked ASINs are 1, 2, or 3
click_count int Modeled number of clicks of ASIN from keyword search results page
click_share decimal Percentage share of clicks attributed to ASIN from keyword search results page compared to all other ASINs in the results page
conversion_count int Modeled number of conversions of ASIN
conversion_share decimal Percentage share of conversions of ASIN from keyword search results page compared to all other ASINs in the results page
conversion_rate decimal conversion_count divided by click_count
marketplace varchar(8) Amazon marketplace (e.g. US, DE, ES)
start_date date evaluation period start date
end_date date evaluation period end date