Product level stats No. of Products
Number of distinct products
Cube Key: ProductStats.productCount
Product level stats Transactions (px)
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: ProductStats.transactionsPx
Product level stats OOS PLP Impressions (px)
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: ProductStats.productImpressionsOOS
Product level stats PDP Views (px)
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.
Example: Whenever a customer opens a product’s page and reads its description, details, specifications etc., a PDP View is generated.
Cube Key: ProductStats.productViews
Product level stats OOS PDP View (px)
Number of times a product detail page has been viewed while out of stock.
Cube Key: ProductStats.productViewsOOS
Product level stats Units Sold (px)
Pixel tracked. Quantity of units sold in the given time frame.
No. of units sold.
Cube Key: ProductStats.productQtyPx
Product level stats Add to Cart (px)
Number of times a product has been added to cart.
Cube Key: ProductStats.addToCart
Product level stats Product Revenue (px)
Pixel tracked. Total product sales over a period of time, including taxes.
Total product sales over a period of time, including taxes.
Cube Key: ProductStats.productRevenuePx
Product level stats PLP Impressions (px)
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: ProductStats.productImpressions
Product level stats Transactions
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: ProductStats.transactions
Product level stats Product Revenue
Total product sales over a period of time, including taxes.
Total product sales over a period of time, including taxes.
Cube Key: ProductStats.productRevenue
Product level stats COGS
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: ProductStats.productCost
Product level stats Units Sold
Quantity of units sold in the given time frame.
No. of units sold.
Cube Key: ProductStats.productQty
Product level stats 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: ProductStats.refundAmount
Product level stats Refunded units
The no. of units refunded.
Cube Key: ProductStats.refundQty
Product level stats Net Product Revenue
Total product sales minus refunded amount over a period of time, including taxes.
Cube Key: ProductStats.productRevenueNet
Product level stats Units Sold (Net)
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: ProductStats.productQtyNet
Product level stats Product CR (px)
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: ProductStats.productCR
Product level stats Product ASP
The Average Selling Price (ASP) for the product from transactions in the defined period.
The average selling price for the product.
Cube Key: ProductStats.productASP
Product level stats Impression CR (px)
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: ProductStats.impressionsCR
Product level stats Impression CTR (px)
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: ProductStats.impressionsCTR
Product level stats Cart abandonment rate (px)
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.
Example: 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: ProductStats.abandonmentCartRate
Product level stats Product APP
The current Average Price of the product.
The current product price average.
Cube Key: ProductStats.productAPP
Product level stats Compare Discount Percent
The percentage of discount offered for the product.
Percent of discount offered from Compare Price.
Cube Key: ProductStats.productComparePricePercent
Product level stats Average Compare Price
The average value of the Compare Price shown to your customers.
Average of compared prices seen by your customers.
Cube Key: ProductStats.productComparePriceAverage
Product level stats Refund Rate
Percentage of refunded products from orders in the selected time frame.
No. of times refunds generated, in average, per 100 transactions.
Cube Key: ProductStats.refundRate
Product level stats Product Margin
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: ProductStats.grossMargin
Product level stats Product Gross Profit
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: ProductStats.grossProfit
Product level stats Inventory quantity
The total number of products in stock.
No. of units in stock of a certain product or group of products.
Cube Key: ProductStats.inventoryQty
Product level stats 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: ProductStats.inventoryValue
Product level stats ATC rate (px)
The no. of Add to Carts generated by a Product Detail Page. Formula: No. of Add to Cart / PDP Views * 100
Example: 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: ProductStats.addToCartRate
Product level stats Revenue per view (px)
Amount of monetary units generated by one PDP View.
Revenue per product view. Formula: Product Revenue / Product Views.
Cube Key: ProductStats.revenuePerView
Product level stats Revenue per impression (px)
Amount of revenue generated by one PLP Impression.
Revenue per product impression. Formula: Product Revenue / Product Impressions.
Cube Key: ProductStats.revenuePerImpression