NOOS Outputs: Bestseller Analysis
- Surya M
- Abhist Srivastava
- Jaikirat Singh (Unlicensed)
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 |