Skip to main content

​
How it’s calculated

​
Built from

  • ShopifyQL sessions
  • ShopifyQL conversion_rate

​
Known caveats

  • Use with shopify.sessions for conversion rate.
  • Aloftly reconstructs and rounds this count per day before period aggregation.
  • The Shopify sync can replace the live partial reporting day.

​
Where this appears

  • Sessions and conversions chart
  • Checkout funnel
  • Stores conversion rate
daily_snapshot; entity: store; same-day fold: last; additivity: semi_additive.Join and identity keys
  • snapshotDate
  • 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. Not applicable.Freshness. Finalized daily snapshot from Shopify.