Number of distinct products
​
Cube Key: MatProductStatsHour.productCount
​
​

Quantity of units sold in the given time frame.
No. of units sold.
​
Cube Key: MatProductStatsHour.productQty
​
​

Pixel tracked. Quantity of units sold in the given time frame.
No. of units sold.
​
Cube Key: MatProductStatsHour.productQtyPx
​
​

Quantity of units sold in a given timeframe after deducting returns (refunded units).
No. of units sold minus refunded units in the same period.
​
Cube Key: MatProductStatsHour.productQtyNet
​
​

Cost of product from Seller (or the cost to make the product).
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: MatProductStatsHour.productCost
​
​

Number of times a product has been added to cart.
​
Cube Key: MatProductStatsHour.addToCart
​
​

Total product sales over a period of time, including taxes.
Total product sales over a period of time, including taxes.
​
Cube Key: MatProductStatsHour.productRevenue
​
​

Pixel tracked. Total product sales over a period of time, including taxes.
Total product sales over a period of time, including taxes.
​
Cube Key: MatProductStatsHour.productRevenuePx
​
​

Total product sales minus refunded amount over a period of time, including taxes.
​
Cube Key: MatProductStatsHour.productRevenueNet
​
​

PLP (Product Listing Page) Impressions present how many times a product has been viewed while being part of a list.
Number of times a product has been in view in a Product Listing Page (PLP).
​
Cube Key: MatProductStatsHour.productImpressions
​
​

Impression CR (Conversion Rate) - Percent of Transactions made out of 100 Impressions PLP.*
The no. of transactions made per 100 PLP Impressions in any listing.
​
Cube Key: MatProductStatsHour.impressionsCR
​
​

The number of Product Detail Views generated on average by 100 Product Listing Page (PLP) Impressions.
No. of Product Detail Views generated in average by 100 Product Listing Page Impressions.
​
Cube Key: MatProductStatsHour.impressionsCTR
​
​

Number of appearance of an Out of Stock (OOS) product shown in a Product Listing Page (PLP) like collection pages or search results.
Appearance of products in listings when out of stock.
​
Cube Key: MatProductStatsHour.productImpressionsOOS
​
​

Amount of times a user stays (at least 1 second) on a Product’s Detail Page (PDP)
Product Detail Page View is counted when a visitor stays on the product page for at least one second.
Whenever a customer opens a product’s page and reads its description, details, specifications etc., a PDP View is generated.
Cube Key: MatProductStatsHour.productViews
​
​

Number of times a product detail page has been viewed while out of stock.
​
Cube Key: MatProductStatsHour.productViewsOOS
​
​

Percentage showing how many products, out of all those added to cart, were abandoned.
Cart abandonment rate. Formula: (1 - (product transactions / product add to cart)) * 100.
A product was added to cart 200 times in the past 2 weeks. We can identify it as a Serpent Ring. It looks popular, although, through these 2 weeks there were 91 finalized product transactions. Some have their products still inside the cart or were removed, replaced for something else.
Cube Key: MatProductStatsHour.abandonmentCartRate
​
​

Number of orders containing the product or variant in the defined time frame.
Number of times a product or variant has appeared in an order. Quantity sold is not taken into account.
​
Cube Key: MatProductStatsHour.transactions
​
​

Pixel tracked. Number of orders containing the product or variant in the defined time frame.
Pixel tracked. Number of times a product or variant has appeared in an order. Quantity sold is not taken into account.
​
Cube Key: MatProductStatsHour.transactionsPx
​
​

The number, in percentages, of views of a PDP (product detail page) that generated a purchase (transaction).
Product conversion rate. Formula: no. of transactions / no. of product detail page views * 100.
​
Cube Key: MatProductStatsHour.productCR
​
​

The Average Selling Price (ASP) for the product from transactions in the defined period.
The average selling price for the product.
​
Cube Key: MatProductStatsHour.productASP
​
​

The current Average Price of the product.
The current product price average.
​
Cube Key: MatProductStatsHour.productAPP
​
​

The percentage of discount offered for the product.
Percent of discount offered from Compare Price.
​
Cube Key: MatProductStatsHour.productComparePricePercent
​
​

The average value of the Compare Price shown to your customers.
Average of compared prices seen by your customers.
​
Cube Key: MatProductStatsHour.productComparePriceAverage
​
​

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: MatProductStatsHour.refundAmount
​
​

The no. of units refunded.
​
Cube Key: MatProductStatsHour.refundQty
​
​

No. of refunded orders.
​
Cube Key: MatProductStatsHour.refundOrders
​
​

Percentage of refunded products from orders in the selected time frame.
No. of times refunds generated, in average, per 100 transactions.
​
Cube Key: MatProductStatsHour.refundRate
​
​

Profitability of a product. Percentage of profit made by the product (from buying/making to selling; refunds included)
Total product revenue minus cost of goods sold including refunds, divided by product revenue. Basically, product related revenue minus costs generated by a sale.
​
Cube Key: MatProductStatsHour.grossMargin
​
​

Amount of monetary units earned by the product from sales (revenue) excluding its COGS value.
Total product revenue minus cost of goods sold.
​
Cube Key: MatProductStatsHour.grossProfit
​
​

The total number of products in stock.
No. of units in stock of a certain product or group of products.
​
Cube Key: MatProductStatsHour.inventoryQty
​
​

The monetary representation of the total number of products in stock.
Cost of goods multiplied by inventory quantity for each item.
​
Cube Key: MatProductStatsHour.inventoryValue
​
​

The no. of Add to Carts generated by a Product Detail Page. Formula: No. of Add to Cart / PDP Views * 100
A flower was added to cart fifty-five (55) times while its number of pdp views were three hundred ninety four (394). (Period: June 12 - June 28). The Add to Cart Rate will be: 55 / 394 * 100 = ~13.96%
Cube Key: MatProductStatsHour.addToCartRate
​
​

Amount of monetary units generated by one PDP View.
Revenue per product view. Formula: Product Revenue / Product Views.
​
Cube Key: MatProductStatsHour.revenuePerView
​
​

Amount of revenue generated by one PLP Impression.
Revenue per product impression. Formula: Product Revenue / Product Impressions.
​
Cube Key: MatProductStatsHour.revenuePerImpression
​
​