Shopify Query Language

The query language of the Analytics and Report APIs is called ShopifyQL. A valid ShopifyQL query consists of parts similar to a valid SQL request. The following is an example query:

SHOW sum(pageview_count) FROM visits SINCE -7d UNTIL -1d

This query will fetch the total pageviews for the last 7 days. The result would look something like:

sum_pageview_count 282778