Open the Excel file named “Product Portrait”.
The data table has 13 dimensions, including “Sequence”, “Product Title”, “Rating”, and “Number of Ratings”, with a total of 19,152 ASIN data. These ASINs are the top 400 pages of products under the search keyword “Sort by: Featured” in the “Clothing, Shoes & Jewelry” category “dress” on the Amazon platform US site on November 22, 2020. The meaning of each different dimension will be introduced one by one.
1 Sequence: refers to the search ranking order of ASIN. Because the data in this table is captured by the author using Python scripts, the sequence starts at 0. The actual search ranking of each ASIN under the search keyword “dress” in the “Clothing, Shoes & Jewelry” category is “Sequence + 1”. For example, when the sequence is equal to 0, the ASIN search ranking corresponding to the sequence number is 0+1=1, when the sequence is 100, the ASIN search ranking corresponding to the sequence number is 100+1=101, and so on.
2 Product title: refers to the listing title of different ASINs.
3 Rating: refers to the review rating of different ASINs.
4 Number of ratings: refers to the number of review ratings of different ASINs.
5 Exposure price: refers to the exposure price of listings under the search keyword “dress” in the “Clothing, Shoes & Jewelry” category of different ASINs.
6 Product price range (lowest price): refers to the lowest price displayed on the product details page of different ASINs. If there is only one price on the product details page, it is the price itself.
7 Product price range (highest price): refers to the highest price displayed on the product details page of different ASINs. If there is only one price on the product details page, it is the price itself.
8 Color name: refers to the color name corresponding to the product variants that different ASINs have exposed on the exposure page.
9 Number of variants: refers to the number of variants that different ASINs have on the product details page.
10ASIN: refers to the parent ASIN code of different products.
11 Clothing, Shoes & Jewelry: refers to the ranking data of different ASINs displayed in “Clothing, Shoes & Jewelry”.
12 Women’s Shops: refers to the ranking data of different ASINs displayed in “Women’s Shops”.
13 URL: refers to the URL of the listing link corresponding to different ASINs.