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.

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.