Column Description
style_code Style code of the article
description Short description of the article
theme Theme (Bestseller 1, Bestseller 2 or Fashion) which is identified for the style
master_category Master category of the article
category Category of the article
subcategory Sub Category of the article
gender Gender to which the article belongs
mrp_bucket MRP bucket that the article falls under
brand Brand of the article
brand_segment Brand Segment of the article
attribute1 Merchandising attribute 1 of the article
attribute2 Merchandising attribute 2 of the article
attribute3 Merchandising attribute 3 of the article
attribute4 Merchandising attribute 4 of the article
attribute5 Merchandising attribute 5 of the article
mrp MRP of the article
sales_qty The quantity sold of that article in the analysis period
revenue The revenue generated by the article
discount Discount on the article
mrp_sales The mrp sales value of the article (sales qty * mrp)
stores_live The number of stores in which the article was live in the analysis duration
avg_style_discount The average discount on the article in the analysis duration
discount_benchmark Discount benchmark (in % ) for the article to be considered for bestseller analysis. The avg style discount to be less than discount benchmark for bestseller classification
style_revenue_per_day The revenue per days generated by the article
revenue_per_day_benchmark The revenue per day benchmark for the article to be considered for bestseller classification. The style rev per day to be greater than rev per day benchmark for bestseller classification
cutoff_revenue Cutoff revenue for any style to be considered for bestseller classification. The style revenue to be greater than cut off revenue for bestseller classification
style_revenue_per_day_per_store The revenue per day per store generated by the article
revenue_per_day_per_store_benchmark The revenue per day per store benchmark for the article to be considered for bestseller 2 classification. The style rev per day per store to be greater than rev per day per store of already identified bestseller 1 in the same cat, subcat, brand, segment, price bucket level for bestseller 2 classification
raw_quantity The raw quantity sold of that article in the analysis period
raw_revenue The raw revenue generated by the article