Start qty
No. of units in stock of a certain product or group of products at the start of the selected time frame.
Cube Key: Inventory.inventoryStartQty
End qty
No. of units in stock of a certain product or group of products at the end of the selected time frame.
Cube Key: Inventory.inventoryEndQty
IN quantity
Number of units added to the inventory during the selected time frame.
No. of units that were added to the inventory.
Cube Key: Inventory.inventoryInQty
OUT quantity
Number of units subtracted from the inventory (during the selected time frame).
No. of units that were subtracted from the inventory.
Cube Key: Inventory.inventoryOutQty
Start Amount (COGS)
Amount of inventory value (calculated using cost of goods sold) at the start of the selected time frame.
COGS of units in stock of a certain product or group of products at the start of the selected time frame.
Cube Key: Inventory.inventoryStartCOGS
End Amount (COGS)
Inventory Value, in monetary units (using cost of goods sold), at the end of the time frame.
COGS of units in stock of a certain product or group of products at the end of the selected time frame.
Cube Key: Inventory.inventoryEndCOGS
In Amount (COGS)
Inventory Value, in monetary units (using cost of goods sold), added/bought in the selected time frame.
COGS of units that were added to the inventory.
Cube Key: Inventory.inventoryInAmount
Out Amount (COGS)
Amount of inventory value (using cost of goods sold) subtracted from inventory in the selected time frame.
COGS of units that were subtracted from the inventory.
Cube Key: Inventory.inventoryOutAmount
Average inventory (by qty)
The mean value of inventory over the defined time frame.
Average inventory using quantity
Cube Key: Inventory.averageInventoryQty
Inventory Turnover (by qty)
Inventory turnover using quantity
Cube Key: Inventory.inventoryTurnoverQty
Inventory Age (by qty)
Amount of days it takes for the product’s inventory to be sold.
Inventory age using quantity
Cube Key: Inventory.inventoryAgeQty
Average Inventory (by COGS amount)
Average amount of inventory value, using the cost of goods sold.
Average inventory using amount
Cube Key: Inventory.averageInventoryCOGS
Inventory Turnover (by COGS amount)
The amount of times the product’s inventory was replaced in the specified time frame.
Inventory turnover using cost of goods
Cube Key: Inventory.inventoryTurnoverCOGS
Inventory Age (by COGS amount)
Amount of days it takes for the product’s inventory to be sold.
Inventory Age using amount
Cube Key: Inventory.inventoryAgeCOGS
Percent of SKU's with cost from inventory
Percent of Variants with inventory cost associated.
Cube Key: Inventory.coverageCOGS
Sell through rate
Percentage of products sold, out of the starting inventory, in the selected time frame.
Percent of quantity that left the warehouse from the inventory quantity at the beginning of the date range. Formula: OUT quantity / Start quantity * 100
Cube Key: Inventory.sellThroughRate