Skip to main content

​
How it’s calculated

​
Built from

  • shopify.gross_sales
  • shopify.discounts
  • shopify.sales_orders

​
Known caveats

  • Ratio of sums; never average daily AOV rows.

​
Where this appears

  • Overview KPI strip
  • Dashboard builder
derived_period; entity: store; same-day fold: sum; additivity: non_additive.Join and identity keys: none.
  • Organization and store are resolved from the authenticated request.
  • Reads use a half-open interval: recorded_at >= start and recorded_at < end.
  • ShopifyQL sales values are used as reported; no extra paid-order filter is added by Aloftly.
Timezone. ShopifyQL groups by the shop reporting date; Aloftly stores that date as a UTC-midnight label. Order lifecycle events retain their provider timestamp.Currency. Currency values use Shopify shop-money amounts. Aloftly does not perform foreign-exchange conversion; mixed-currency all-store totals must not be interpreted as converted currency.Freshness. Computed by Cube at read time.