Skip to main content
This page is the reference for every metric Retailgrid computes. Use it to confirm what a column means before you act on it. Metrics are available as Analytical metric columns (added via Add Column or the Metrics toolbar button) and as outputs of agents like Dynamic Pricing.

​
Metric grain

When store-level data is loaded, metrics are computed at the SKU-Store grain: each store’s KPIs (margin, price index, competitor gap) use that store’s own price, cost, and competitor set. In the grid’s Product view, a product-level rollup of the same metrics is shown. See Product and SKU-Store grid views.

​
Margin metrics

​
Margin

Absolute monetary margin per unit, gross of tax.
Use it for: quick eyeballing of which SKUs make money.

​
Margin %

Margin as a percentage of selling price.
Use it for: comparing margin across SKUs at different price points.

​
New Unit Margin %

Net-of-tax margin on the price calculated by Dynamic Pricing.
Use it for: seeing the margin you’d land at if you accepted the agent’s recommended price.

​
Unit Margin % change

Percentage-point change between current Margin % and New Unit Margin %.
Use it for: spotting the rules that move margin the most (positive or negative).

​
Competitive metrics

​
Price Index (PI)

Your price relative to a single competitor or competitor reference.
100 = parity, less than 100 = you’re cheaper, greater than 100 = you’re more expensive.

​
CPI (Min)

CPI (Competitive Price Index) compares your price to a competitor reference; the variants below differ only in which competitor price they benchmark against. Competitive price index against the cheapest competitor.
Use it for: tracking how aggressive the cheapest competitor is per SKU.

​
CPI (Mode)

Competitive price index against the most common competitor price.
The mode often represents the “market price” better than the min, because outlier-cheap competitors don’t dominate it.

​
CPI (Weighted)

Competitive price index weighted by each SKU’s sales value, so the SKUs you actually sell dominate the index.
Use it for: the single best summary of overall price position across a category or the whole grid - high-volume SKUs count most. This is the CPI variant surfaced on the built-in Competitive Position dashboard.

​
Price Gap

Absolute monetary gap to a competitor reference.
Use it for: understanding the literal euros / dollars between you and a competitor.

​
Cheapest Flag

Boolean. true if your price is the cheapest among the available competitors, otherwise false.
Use it for: filtering grids to “where am I winning on price.”

​
Price Range

Visual column showing the min/max of competitor prices and where the current price sits in that range. This is a UI affordance rather than a numeric metric - use it for at-a-glance market positioning, then drill in with CPI variants for precision.

​
Inventory & realized-pricing metrics

Added to the metrics library in July 2026. These show how much of the list price you actually realize and how much capital is tied up in stock. Prices here are ex-VAT (price_ex_vat = price / (1 + tax_rate)). The inventory metrics need a stock value on your Products data; the sell-through, turnover, and GMROI metrics need Transactions.

​
Markup %

Margin over cost, on the ex-VAT price.

​
Realized Discount %

How far the current selling price sits below the regular (list) price - the discount you’re actually giving.

​
Value of Inventory

Stock on hand valued at the ex-VAT selling price.

​
Cost of Inventory

Stock on hand valued at unit cost - the capital tied up in stock.

​
Inventory-productivity metrics

The picker also exposes GMROI, Sell-through %, Inventory Turnover, and Average Selling Price, computed from your Transactions over the selected window - gross margin return on inventory investment, the share of available stock sold, how many times stock turns over, and the realized average price per unit. Each needs enough sales history in the window to be meaningful; a product with no transactions in the window shows blank.

​
Refresh cadence

Most metrics are computed in BigQuery and refresh in near real-time as your underlying data (Products, Transactions, Competitors) changes. Specifically:
  • Margin / Margin % refresh whenever price or unit_cost changes on a product.
  • CPI variants and Price Index refresh whenever the relevant Competitors dataset row updates.
  • Dynamic Pricing output columns (Rules Based Price, New Unit Margin %, Unit Margin % change) update on demand when the Dynamic Pricing agent runs.
Static metrics like margin, unit cost, and price also keep a daily history in BigQuery alongside the time-series metrics. That history isn’t surfaced as its own grid column, but you can see how a SKU’s price, competitors, sales, and profit have moved over time in the SKU time-series analytics panel. If a metric column looks stale, replace the source dataset on the Datasets page - that triggers a downstream refresh.