cleaning_services
Sales Data Cleanup
Module Description

Sales Data Cleanup module is for loading daily sales data across stores and cleaning it up. Often heavy discounts are given on products to bump up sales and liquidate excess inventory. Such sales should not be considered for forecasting, as it distorts real demand. This module cleans up such sales for better analysis of data. Also, having right product sizes at stores is important for good sales. This module also finds out which sizes are not selling well at stores and cleans up that sales data.

If wrong data has been uploaded by mistake, then the Data Deletion feature can be used to delete the data. This data will be lost for-ever, so ensure that a backup has been taken before deletion.

Algo Parameters
Start Date
Only data between start-date and end-date (both dates included) will be considered for analysis. You can also use to analyze data for last season
End Date
Only data between start-date and end-date (both dates included) will be considered for analysis. You can also use to analyze data for last season
Max Liquidation Cleanup %
How much revenue % is one willing to forgo (at a partner+category level) while doing liquidation sales data cleanup. For e.g., in EBO+Jeans, removal of bottom 10% revenue sales data. Keeping it at 0% does not clean any sales data
Exit Sizes Revenue Contribution %
If revenue contribution in a store for a size is below this %, then it is considered as an exit size. For e.g., for each store+category, remove all sizes which contribute to bottom 3% revenue are removed. Keeping it at 0% does not clean any sales data
error_outline

Note : Please check file formats page for input formats

clear