Enterprise real-time analytics with BigQuery
Get channel behavior metrics (POS, App, Kiosk, Delivery, QR)
query Parameters
locationIdLocation ID
startDateStart date (ISO 8601)
endDateEnd date (ISO 8601)
includeChildrenInclude child locations
Responses
Default Response
statusGet comprehensive dashboard metrics in a single call. Returns sales inc/ex VAT, orders, products, tips, refunds, discounts, AOV, VAT breakdown, time series, top products, top categories, and channel breakdown.
query Parameters
locationIdLocation ID
startDateStart date (ISO 8601)
endDateEnd date (ISO 8601)
includeChildrenInclude child locations
granularityTime series granularity
productSearchSearch filter for product titles
productLimitMax products to return (default 10, max 500)
tableGroupIdsComma-separated list of table group IDs (storefront_qr_code_groups.id) to restrict results to. When set, excludes orders without a QR code (e.g. pickup, delivery).
costCenterIdsComma-separated list of cost center IDs (cost_centers.id) to restrict results to. Matches on COALESCE(tabs.cost_center_id, storefront_qr_codes.cost_center_id) — tab override beats table default. Orders without a cost center are excluded when this filter is active.
Responses
Default Response
statusGet drill-down analytics (Location → Hour → Item)
query Parameters
locationIdLocation ID
startDateStart date (ISO 8601)
endDateEnd date (ISO 8601)
hourHour of day (0-23)
itemIdItem ID for detailed orders
Responses
Default Response
statusGet location performance with hierarchy
query Parameters
locationIdParent location ID
startDateStart date (ISO 8601)
endDateEnd date (ISO 8601)
includeChildrenInclude child locations
Responses
Default Response
statusGet overview dashboard with summary and charts
query Parameters
locationIdLocation ID
startDateStart date (ISO 8601)
endDateEnd date (ISO 8601)
includeChildrenInclude child locations
Responses
Default Response
statusGet sales metrics with hourly breakdown
query Parameters
locationIdLocation ID
startDateStart date (ISO 8601)
endDateEnd date (ISO 8601)
includeChildrenInclude child locations
granularityTime granularity
Responses
Default Response
statusGet tips totals per staff for the period. Tips are split proportionally across staff based on each staff member's share of committed-item revenue on the same tab. Unattributed share (no staff on tab) is returned with retailUserId = null.
query Parameters
locationIdLocation ID
startDateStart date (ISO 8601)
endDateEnd date (ISO 8601)
includeChildrenInclude child locations
tableGroupIdsComma-separated list of table group IDs to restrict to.
Responses
Default Response
status