OTB SWB Output Depth column explanation:-
Column | Explanation | Remarks |
---|---|---|
period | period | |
channel | channel | |
store_code | store_code | |
brand | brand | |
cat | cat | |
subcat | subcat | |
gender | gender | |
brand_segment | brand_segment | |
price_bucket | price_bucket | |
attribute1 | attribute1 | |
attribute2 | attribute2 | |
attribute3 | attribute3 | |
attribute4 | attribute4 | |
attribute5 | attribute5 | |
attribute6 | attribute6 | |
attribute7 | attribute7 | |
attribute8 | attribute8 | |
attribute9 | attribute9 | |
proj_buy_qty | proj_buy_qty from OD contri and Final ASP and Store AOP | |
calculated_options | divide Projected Buy Qty with STR Adjusted Sales Depth | |
size_set_options | size_set_options input | |
min_constraint | min_constraint input | |
max_options_capacity | calculated as Min Display Capacity * Freshness Factor | |
segmented_option_count | Number of Styles at the Dynamic Store + PA level having segmentation 1 | |
final_options | If Calculated Options is in between the highest of min constraints & lowest of max constraint then the Final Option is the Calculated Options | This will be at a Dynamic Store + Primary Attribute level
|
final_depth | Divide Projected Buy Quantity with Final Options to get the final depth | |
target_mrp | Sub Module 1 Projected Buy Qty and Adj ASP value for each Store- PA |