Orders & Customers Order Value (OV)
Revenue generated by orders, including discounts and shipping.
Cube Key: MatOrders.totalOrderAmount
Orders & Customers Current Total Tax
Current total tax, including products and shipping, adjusted for changes, refunds.
Cube Key: MatOrders.currentTotalTax
Orders & Customers Units sold
Number of product units sold.
Cube Key: MatOrders.totalOrderQty
Orders & Customers AOV
Average order value (AOV).
Cube Key: MatOrders.avgOrder
Orders & Customers Units per Order
Average number of units sold per order.
Cube Key: MatOrders.avgItemsPerOrder
Orders & Customers Products per Order
Average number of products sold per order.
Cube Key: MatOrders.avgProductsPerOrder
Orders & Customers Product Lines Value
Revenue generated by orders, without discounts and shipping.
Cube Key: MatOrders.totalOrderProductLineAmount
Orders & Customers Discounts
Discount value applied to orders.
Cube Key: MatOrders.totalDiscounts
Orders & Customers Subtotal value
The subtotal value payed by customers.
Cube Key: MatOrders.subtotalPrice
Orders & Customers COGS
COGS stands for 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: MatOrders.totalOrderCost
Orders & Customers Shipping Value
Revenue generated by shipping.
Cube Key: MatOrders.orderShippingTotalPrice
Orders & Customers No. of Orders
The number of orders in time period.
Cube Key: MatOrders.nrOrders
Orders & Customers Number of Customers
Number of customers
Cube Key: MatOrders.customerCount
Orders & Customers Purchase Frequency
Purchase Frequency of your customer base and measures how often your customers place orders. Formula: No. of Orders / No. of Customers in a selected time period.
Cube Key: MatOrders.purchaseFrequency
Orders & Customers Recurrent Customers
Recurrent Customers are customers with at least 2 orders.
Cube Key: MatOrders.recurrentCustomers
Orders & Customers New Customers
New Customers are customers with 1 order.
Cube Key: MatOrders.newCustomers
Orders & Customers OV Recurring Customers
Order Value (OV) generated by Recurring Customers.
Cube Key: MatOrders.ordersValueRecurring
Orders & Customers OV New Customers
Order Value (OV) generated by New Customers.
Cube Key: MatOrders.ordersValueNew
Orders & Customers AOV Recurring Customers
Average Order Value (AOV) generated by Recurring Customers
Cube Key: MatOrders.aovRecurring
Orders & Customers AOV New Customers
Average Order Value (AOV) generated by New Customers
Cube Key: MatOrders.aovNew
Orders & Customers Repeat Purchase Rate
Percent of Recurrent Customers from total number of Customers.
Cube Key: MatOrders.repeatCustomerPercent
Orders & Customers Refunded units
The no. of units refunded.
Cube Key: MatOrders.refundQty
Orders & Customers Refunded Value
Sum of all product refunds in selected time period (takes into account the refunded product value, without refunded shipping amount).
The value of refunds made in selected time frame.
Cube Key: MatOrders.refundAmount
Orders & Customers Total Tax
Total tax, including products and shipping.
Cube Key: MatOrders.totalTax
Orders & Customers Order Delivery Duration
Delivery duration for the whole order, calculated when all items are delivered from the order, 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: MatOrders.orderDeliveryDuration
Orders & Customers Order Fulfilment Duration
Fulfilment duration for the whole order, 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: MatOrders.orderFulfilmentDuration
Orders & Customers Order Time to Fulfilment Start
Time in DAYS from the time an order was placed until the order fulfilment has been started
Expressed in DAYS
Cube Key: MatOrders.orderTimeToFulfilmentStart
Orders & Customers Delivered Quantity
Quantity of items delivered from the order
Quantity of items delivered
Cube Key: MatOrders.deliveredQty
Orders & Customers To Be Delivered Quantity
Quantity of items to be delivered from the order
Quantity of items to be delivered
Cube Key: MatOrders.toBeDeliveredQty