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:
[A] sku
If you are an Amazon Seller your the SKU number will be available here.
[B] asin
ASIN stands for Amazon Identification Number — it is an 10 digit alphanumerical value specific to your product
[C] country
The country that the product is y being sold in.
[D] marketplace
Which ecommerce site your product is being sold. In this case it will only be Amazon.
[E] marketplace_name
This is the database specific naming for which markerketplace country that your product is being sold in. It will be either:
Europe
amazon_fr (France)
amazon_uk (United Kingdom)
amazon_es (Spain)
amazon_de (Germany)
amazon_it (Italy)
North America
amazon_us (United States)
amazon_ca (Canada)
amazon_mx (Mexico)
Asia
amazon_jp (Japan)
amazon_cn (China)
amazon_in (India)
[F] parent_asin
The parent ASIN of that product if it is variation of a main product
[G] health_score
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
[H] brand
The brand under which product is listed
[I] catalogue_health_score
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)
[K] review_health_score
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.
[L] is_buy_box_owner
True or False — For this specific product you either own the Buy Box (True) or do not own the Buy Box (False).
[M] is_pantry
True or False — Is this product consider "pantry" by Amazon - i.e. an indespensible everyday product?
[N] is_add_on_item
True or False — Is the product available as an "Add-On" item by Amazon?
[O] is_prime_only
True or False — Is this product only available on Prime?
[P] is_fast_track
True or False — Is this product offered on Fast Track?
[P] has_a_plus
True or False — Does this product have A+ content?
[R] is_404
True or False — Does this product page exist or not?
[S] is_sns
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.
[T] is_prime
There are five options for the status of your Buy-Box: Active, Prime-Only, Add-On, Inactive and Pantry
[U] is_fresh
True or False — Is this product considered as "fresh produce"?
[V] has_active_buy_box
True or False — Does this product currently have an active BuyBox or not?
[W] has_vendor_offer
True or False— Is this product offered (by you!) as a Vendor
[X] merchant_id
What is the merchant ID of the BuyBox owner
[Y] buy_box_currency
The currency for the BuyBox price
[Z] min_price
The minimum price offered for the product
[AA] max_price
The maximum price offered for the product
[AB] buy_box_price
The currenty BuyBox price for the product
[AC] buy_box_owner
True or False — Are you the BuyBox owner for this product?
[AD] vendor_price
The Vendor price for this product
[AE] nb_sellers
The total number of Sellers (both MFN and FBA)
[AF] nb_mfn_sellers
The number of MFN sellers selling this product
[AG] nb_fba_sellers
The number of FBA sellers selling this product
[AH] has_stock
True or No — Is this product in stock?
[AI] nb_size_variations
The number of size-related variations for this product
[AJ] nb_color_variations
The number of color-related variations for this product
[AK] nb_style_variations
The number of style variations for this product
[AL] title
The title of the product
[AM] nb_images
The number of images contained on the product's page
[AN] images_url_1
The source URL of the image 1 of the product
[AO] images_url_2
The source URL of the image 2 of the product
[AP] images_url_3
The source URL of the image 3 of the product
[AQ] images_url_4
The source URL of the image 4 of the product
[AR] images_url_5
The source URL of the image 5 of the product
[AS] images_url_6
The source URL of the image 6 of the product
[AT] images_url_7
The source URL of the image 7 of the product
[AU] nb_videos
The number of videos on the product's page
[AV] videos_url_1
The URL of the first video on the product's page
[AW] videos_url_2
The URL of the second video on the product's page
[AX] bullet_points
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
[BI] description
The text content of the Description section of the product's page
[BJ] nb_reviews
The number of reviews the product has earned
[BK] weighting_average_rating
The average rating to 2 decimal points of accuracy that (between 0 and 5) the product has earned
[BL] nb_1_star
The number of 1 star ratings for the product
[BM] nb_2_star
The number of 2 star ratings for the product
[BN] nb_3_star
The number of 3 star ratings for the product
[BO] nb_4_star
The number of 4 star ratings for the product
[BP] nb_5_star
The number of 5 star ratings for the product
[BQ] nb_answered_questions
The number of questions answered regarding the product
[BR] page_url
The URL of the product page
[BS] image
The URL of the thumbnail image for your product
[BT] ranking
The ranking of your product within its sub-category
[BU] finest_sales_ranking
The product's ranking at its deepest level category
[BV] category
The sub-category that the product is currently listed in
[BW] top_category
The main category that the product is currently listed in
[BX] sub_category_url
The URL of the sub-category of the product
[BY] scraping_date
The date that this data was last collected for the product