Order Products No. of Products
Number of distinct products
Cube Key: MatOrderProducts.productCount
Order Products Number of Customers
Number of customers
Cube Key: MatOrderProducts.customerCount
Order Products Units Sold
No. of units sold.
Cube Key: MatOrderProducts.productQty
Order Products Product Revenue
Total product sales over a period of time, including taxes, excluding discounts.
Cube Key: MatOrderProducts.productRevenue
Order Products Product Revenue (Net)
Total product revenue minus refunded amount over a period of time, excluding taxes, excluding discounts.
Cube Key: MatOrderProducts.productRevenueNet
Order Products COGS
Cost of goods sold. The cost is imported directly from Shopify. Make sure to fill it when adding products to your catalogue in order to have more precise business reports.
Cube Key: MatOrderProducts.productCost
Order Products Refund Tax
Tax for refunded products.
Cube Key: MatOrderProducts.refundTax
Order Products COGS (Net)
Net cost of goods sold. Adjusted for refunds.
Cube Key: MatOrderProducts.productCostNet
Order Products Product Margin
Net product revenue minus cost of goods sold (adjusted for refunds), divided by net product revenue. Basically, product related revenue minus costs generated by a sale.
Cube Key: MatOrderProducts.grossMargin
Order Products Transactions
Number of times a product or variant has appeared in an order. Quantity sold is not taken into account.
Cube Key: MatOrderProducts.transactions
Order Products Product Avg Sell Price
The average product selling price
Cube Key: MatOrderProducts.productAvgSellPrice
Order Products Product Discount
Discount applied on product
Cube Key: MatOrderProducts.productDiscount
Order Products Product Delivery Duration
Delivery duration for the product, calculated when all items are delivered, expressed in DAYS. Duration is calculated from when the order was placed until the last item has been delivered.
Duration expressed in DAYS
Cube Key: MatOrderProducts.productDeliveryDuration
Order Products Product Fulfilment Duration
Fulfilment duration for the product, calculated when all items are fulfilled from the order, expressed in DAYS. Duration is calculated from when the first item started processing to the last item getting delivered.
Duration expressed in DAYS
Cube Key: MatOrderProducts.productFulfilmentDuration
Order Products Product Time to Fulfilment Start
Time in DAYS from the time an order was placed until the product fulfilment has been started
Expressed in DAYS
Cube Key: MatOrderProducts.productTimeToFulfilmentStart
Order Products Delivered Quantity
Quantity of items delivered from the order
Quantity of items delivered
Cube Key: MatOrderProducts.deliveredQty
Order Products To Be Delivered Quantity
Quantity of items to be delivered from the order
Quantity of items to be delivered
Cube Key: MatOrderProducts.toBeDeliveredQty
Order Products Single Product Order
Whether the order contains only one product.
Cube Key: MatOrderProducts.singleProductOrder
Order Products Multiple Product Order
Whether the order contains multiple products.
Cube Key: MatOrderProducts.multipleProductOrder
Order Products Single Product Order Qty
Units sold in single orders containing a single product.
Cube Key: MatOrderProducts.singleProductOrderQty
Order Products Multiple Product Order Qty
Units sold in orders containing multiple products.
Cube Key: MatOrderProducts.multipleProductOrderQty
Order Products Refunded units
Refund quantity associated with the orders/products sold in the selected time frame.
Cube Key: MatOrderProducts.refundQty
Order Products Refunded Value
Refund amount associated with the orders/products sold in the selected time frame.
Cube Key: MatOrderProducts.refundAmount
Order Products Refund COGS
Cost of goods of the refunded products associated with the orders/products sold in the selected time frame.
Cube Key: MatOrderProducts.refundCOGS
Order Products Inventory quantity
The total number of products in stock.
No. of units in stock of a certain product or group of products.
Cube Key: MatOrderProducts.inventoryQty
Order Products Inventory value
The monetary representation of the total number of products in stock.
Cost of goods multiplied by inventory quantity for each item.
Cube Key: MatOrderProducts.inventoryValue