In Performance Analytics, Power Users can create a custom metric to rank their top 10 products by sell through percentage.
This custom metric identifies products with high sell-through percentages (ST%) to quickly pinpoint items needing extra attention for maintaining adequate stock levels and supporting strong sales. This metric will also exclude any products with 100% Sell-through, as these items are often no longer being sold.
💡Don't know if you are a Power User? Determine your user status here.
This metric will work with any report or dashboard with a data grid, but is designed to help you analyze data at the product level. The below example uses the pre-made Product Performance dashboard, but you can use any pre-made or custom dashboard that includes the ST% metric.
Click on images to enlarge.
Step | Instruction | Image |
1 | Open any dashboard or report.
Example:
|
|
2 | Right-click on the ST% metric (in this example, TY WTD ST%) and select Create Metric.
|
|
3 | Click on Switch to Formula Editor at the bottom right hand side of the Metric Editor.
Delete the default formula, copy the following and paste into the Formula box: IF(([TY WTD ST%]>=1), " ", [TY WTD ST%]) |
|
4 | Enter ST% Calc as the Metric Name and click Save | |
5 | Right-click on the new metric ST% Calc and hover over Shortcut Metric and click Rank or OK (there's no need to adjust the Sort or Break settings). | |
6 | Click on the table's three-dot menu icon and Edit Filter.
Then, click Add New Qualification and enter Rank (ST% Calc) into the Based On field. Change the Operator to Less than or equal to and enter 10 as the value. Then click OK and Save. |
|
7 | Right-click on the Rank (ST% Calc) metric and Sort Ascending to view products in order by ST%. |
⛑️ SPS Analytics Support
If you have any additional questions regarding editing metrics, attributes, or Performance Analytics, please reach out to our Analytics Support team at the contact information below:
☎️ 888-739-3232, Option 2