What is abandoned cart value?
Abandoned cart value is the contribution margin you could still earn from carts that were started and not bought. Most tools report the revenue of those carts; that overstates what recovery is worth, because a recovered order also carries its cost of goods. This figure subtracts it.
Formula
recoverable margin (line) = quantity × unit price − quantity × unit cost
abandoned cart value = Σ recoverable margin over open + abandoned lines
The quantity and the tax-exclusive unit price are the ones the store reported when the shopper added the product (Saldo Metrics module 1.2.0 or newer). A cart line is recovered if the same visitor or customer purchases within 30 days of adding to cart, open while that window is still running, and abandoned once it has closed. Only open and abandoned lines count.
Worked example
Twelve sessions this week added two €50 lamps each (unit cost €30) and did not buy. Recoverable margin is 12 × 2 × €20 = €480, not 12 × 2 × €50 = €1,200. If four of them also added a shade with no confirmed cost, those four lines show no margin and the tile's coverage note says how much at-risk revenue is uncosted.
What is deliberately left out
- Order-level discounts, shipping and fees. A cart is not an order; there is nothing to allocate. This is line-level margin.
- Uncosted products. Their margin is unknown and stays NULL, following the same rule as every margin figure in Saldo Metrics.
- Lines from a module older than 1.2.0. Those events carry no price or quantity; the tile reports how many such lines it saw instead of guessing.
How Saldo Metrics computes it
v_abandoned_cart starts from v_pixel_session rows with a cart or checkout
event and no purchase in that session, resolves each add-to-cart product id
against the catalogue, sums the reported quantity and value per product,
takes the winning confirmed cost record as the unit cost, then looks 30
days ahead for a purchase by the same visitor or customer.