When clicking on "Download Filtered Data" button in Seelk Studio's Catalog app
a download is prompted. Your browser downloads an .xlsx file that contains all the raw data regarding your products as seen on Amazon. Each row in the spreadsheet represents a single product.
The definitions for the columns (A through to CG) contained in the .xlsx file are as follows:
If you are an Amazon Seller your the SKU number will be available here.
ASIN stands for Amazon Identification Number — it is an 10 digit alphanumerical value specific to your product
The country that the product is y being sold in.
Which ecommerce site your product is being sold. In this case it will only be Amazon.
This is the database specific naming for which markerketplace country that your product is being sold in. It will be either:
amazon_uk (United Kingdom)
amazon_us (United States)
The parent ASIN of that product if it is variation of a main product
The overall health score for the product as calculated by Seelk Studio. It is a composite of the following scores:
- Catalog Score
- Offer (BuyBox) Score
- Review Score
The brand under which product is listed
It is a composite score based on various elements of the content on an Amazon page, include (bullet points, description, number of images, etc.)
[J ] buy_box_health_score
It is a composite score based on the Buy Box score (should be active, offer should be prime, sns option should be available and should have stock)
Reviews is a break down of the reviews rating system for individual products on Amazon based on the 0 to 5 star rating system..
You can imagine that 0 or 1 star equals a 0-20% score, and so on.
True or False — For this specific product you either own the Buy Box (True) or do not own the Buy Box (False).
True or False — Is this product consider "pantry" by Amazon - i.e. an indespensible everyday product?
True or False — Is the product available as an "Add-On" item by Amazon?
True or False — Is this product only available on Prime?
True or False — Is this product offered on Fast Track?
True or False — Does this product have A+ content?
True or False — Does this product page exist or not?
True or False — Is this product offered on a "Subscribe and Save" basis (i.e. please send me this product on a customisable frequency — ex. please send me a "Permanent Blue Marker" in the first week of every month.
There are five options for the status of your Buy-Box: Active, Prime-Only, Add-On, Inactive and Pantry
True or False — Is this product considered as "fresh produce"?
True or False — Does this product currently have an active BuyBox or not?
True or False— Is this product offered (by you!) as a Vendor
What is the merchant ID of the BuyBox owner
The currency for the BuyBox price
The minimum price offered for the product
The maximum price offered for the product
The currenty BuyBox price for the product
True or False — Are you the BuyBox owner for this product?
The Vendor price for this product
The total number of Sellers (both MFN and FBA)
The number of MFN sellers selling this product
The number of FBA sellers selling this product
True or No — Is this product in stock?
The number of size-related variations for this product
The number of color-related variations for this product
The number of style variations for this product
The title of the product
The number of images contained on the product's page
The source URL of the image 1 of the product
The source URL of the image 2 of the product
The source URL of the image 3 of the product
The source URL of the image 4 of the product
The source URL of the image 5 of the product
The source URL of the image 6 of the product
The source URL of the image 7 of the product
The number of videos on the product's page
The URL of the first video on the product's page
The URL of the second video on the product's page
The number of bullet points that appear on the product's page
[AZ] —> [BH] bullet points
The text content contained in your Bullet Points section of the product's page
The text content of the Description section of the product's page
The number of reviews the product has earned
The average rating to 2 decimal points of accuracy that (between 0 and 5) the product has earned
The number of 1 star ratings for the product
The number of 2 star ratings for the product
The number of 3 star ratings for the product
The number of 4 star ratings for the product
The number of 5 star ratings for the product
The number of questions answered regarding the product
The URL of the product page
The URL of the thumbnail image for your product
The ranking of your product within its sub-category
The product's ranking at its deepest level category
The sub-category that the product is currently listed in
The main category that the product is currently listed in
The URL of the sub-category of the product
The date that this data was last collected for the product