At launch
A query language you can read.
Every Queryful report is a short query. Autocomplete suggests fields as you type, and inline validation flags a mistake before you run it. The examples below show the shape of the language.
Coming soon to the Shopify App Store
Top products last month
FROM sales
SHOW net_sales, orders
GROUP BY product
DURING last_month
ORDER BY net_sales DESC
LIMIT 20 Net sales by sales channel, against the month before
FROM sales
SHOW net_sales
GROUP BY sales_channel
DURING last_month
COMPARE TO previous_period Paid orders this week, with line item properties
FROM orders
SHOW order_name, created_at, total_price, line_item_properties
WHERE financial_status = 'paid'
DURING last_7_days Discount codes by net sales this quarter
FROM sales
SHOW net_sales, discounts
GROUP BY discount_code
DURING this_quarter
ORDER BY net_sales DESC Shopify's reports and Queryful
| ShopifyQL | queryful. | |
|---|---|---|
| Shape | FROM, SHOW, GROUP BY, DURING | FROM, SHOW, GROUP BY, DURING |
| Row-level order fields | No | Yes |
| Runs on | Shopify's analytics | Queryful's copy of your data |
| Email the result on a schedule | No | Yes |
Built for reports
Short
A report is a few lines, not a page of SQL.
Documented
The reference is published with the docs at launch.
Autocomplete
Field names and keywords as you type.
Validation
Mistakes flagged before you run the query.
FAQ
Frequently asked questions
Is it SQL?
It reads like SQL but is shorter, and built for reports: FROM a dataset, SHOW figures, GROUP BY, DURING a period.
Is it like ShopifyQL?
Similar in shape. It runs on Queryful's copy of your data, so it can report on row-level order fields that ShopifyQL can't.
Where is the reference?
Published with the docs at launch.
Are these field names final?
They show the shape of the language. The full list of fields is in the reference at launch.
Explore more
Custom reports Sales reports Order export Scheduled reports AI reports Finance reports Coming soon Sales tax by jurisdiction Coming soon Inventory reports Coming soon Customer reports Coming soon Multi-store reporting Coming soon Better Reports alternative Report Pundit alternative Data Export IO alternative Shopify's reports vs Queryful
Queryful is coming soon.
Leave your email and we'll tell you when Queryful is on the Shopify App Store.
One email when Queryful is listed. Unsubscribe any time.