Product inventory levels at the Store, or Warehouse/Distribution Center (DC) level can be seen in Performance Analytics by adding two On Hand (OH) metrics in just a few steps!
💡The TY UNITS OH STORE (This Year Units On Hand at Brick and Mortar Stores) and TY UNITS OH WAREHOUSE (This Year Units On Hand at the Warehouse or Distribution Center) metrics utilize the SPS_Location_Type attribute to calculate and will only work for retailers who share location data.
To add these metrics to a new or existing report, follow the steps below as a Power User:
Step | Instruction | Image |
1 | Open a new or existing report and access the All Object folder.
For this example, we will open a To-Date report. | 
|
2 | Open the To-Date Analysis Metrics folder > Week to Date folder > This Year folder | 
|
3 | Scroll down and click on Next 60 items. | 
|
4 | Double-click, or drag and drop to add in:
| 
|
5 | 💡Tip: Use the Search box in the ALL OBJECTS folder to search for UNITS OH.
This will display all On Hand inventory metric options for your report style at the bottom. | 
|
6 | Add in any other metrics or attributes desired for your report.
(Ex: Style, Style Description and UPC). | 
|
7 | Click on the Spreadsheet with Lightning Bolt Icon in the upper left-hand corner to run the report. | 
|
8 | Viola!
Now you can review your OH inventory across location types. | 
|
⛑️ SPS Analytics Support
If you have any additional questions regarding Performance Analytics, please reach out to our Analytics Support team at:
☎️ 888-739-3232, Option 2