Abandoned checkouts

Abandoned checkouts — abandoned value and count, with recovery indicated by the completed date.

11 fields — 6 dimensions, 5 metrics. Date clauses (SINCE, UNTIL, DURING) use createdAt.

The live, authoritative list is always GET /v1/datasets — this page is regenerated from the same catalog, but the endpoint reflects exactly what is deployed.

Query it

FROM abandoned_checkouts
  SHOW checkout_count
  GROUP BY name
  SINCE -30d

See Querying with SoloQL for the language.

This dataset is queryable through SoloQL; it has no record-retrieval endpoint.

Fields

Field	Type	Role	Description
name	string	dimension	Abandoned checkout name.
region	string	dimension	Region associated with the checkout.
taxes_included	boolean	dimension	Whether taxes are included in the prices.
created_at	date	dimension	When the checkout was abandoned.
completed_at	date	dimension	When the checkout was recovered into an order (null if not recovered).
checkout_count	number	metric	Number of abandoned checkouts in the group (document count — value_count on createdAt). Sums across stores.
total_price	money	metric	Total value of the abandoned checkout including taxes and shipping.
subtotal	money	metric	Line items value before shipping and taxes.
total_tax	money	metric	Total tax on the abandoned checkout.
total_discounts	money	metric	Total discounts applied to the abandoned checkout.
store	string	dimension	The shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store.