Delivered as a weekly and monthly grain data set as segments_weekly and segments_monthly

Table Definition

Name Type Note
segment_name string segment name as determined in Cobalt
start_date date evaluation start date
end_date date evaluation end date
asin string Amazon Serialized Identification Number
brand string product brand
title string ASIN listing title
image_url string ASIN listing main image
category string Root category for which product ranks. If category changes throughout the reporting period, this is the last known category
primary_sub_category string The sub category for which the asin ranks - if multiple subcategories, this field returns the first in the list. If subcategories changes throughout the reporting period, this is the last known subcategory
median_price double median buy box price during evaluation period
rating double last known rating (1-5 scale)
revenue double total revenue calculated as sales times median price
revenue_1p double revenue associated with 1P sales
revenue_3p double revenue associated with 3P sales
sales double total sales
sales_1p double sales associated with 1P sales
sales_3p double sales associated with 3P sales
seller_ids double seller ids of any buy box owner during evaluation period
seller_name string name of dominant seller during evaluation period
seller_types string array of different seller types
category_rank string last known rank in ranking category
primary_sub_category_rank string last known rank in primary subcategory
is_parent boolean True: ASIN is a parent or Standalone ASIN - all sales for the variant group are grouped under the parent ASIN
False: ASIN is a variant ASIN and does not have associated sales
currency_code string code to join against currency_conversion table.
country string Amazon marketplace (e.g. us or de)
variant_count bigint number of variants under the parent ASIN
segment_id string Jungle Scout Cobalt assigned ID for each segment