Discounts
Discounts — usage and sales driven, by method, kind, value type and purchase type.
13 fields — 10 dimensions, 3 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 discounts
SHOW discount_count
GROUP BY title
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 |
|---|---|---|---|
title | string | dimension | Discount title. |
status | string | dimension | Discount status (active, expired, scheduled). |
discount_method | string | dimension | How the discount is applied (code or automatic). |
discount_kind | string | dimension | Kind of discount (basic, bxgy, free shipping, app). |
value_type | string | dimension | How the value is expressed (percentage or fixed amount). |
purchase_type | string | dimension | One-time, subscription, or both. |
starts_at | date | dimension | When the discount becomes active. |
ends_at | date | dimension | When the discount expires. |
created_at | date | dimension | When the discount was created. |
discount_count | number | metric | Number of discounts in the group (document count — value_count on createdAt). Sums across stores. |
usage_count | number | metric | Number of times the discount has been used. |
total_sales | money | metric | Total sales driven by the discount. |
store | string | dimension | The shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store. |