Create custom reports
Retrieve any data from your store and analyze it in a single report.
Never leave admin
Your store data will stay only yours inside of Shopify store admin panel.
Get help with queries
We will help you to create a correct query if you have difficulties.
Note! ShopQL app allows creating the reports only for the Dev, Advanced Shopify and Shopify Plus users.
- Install easily.
- Free to use.
- Create thousands of report variants.
- See the entire picture of your store performance.
- Stay inside Shopify admin.
- Get help with ShopfyQL queries.
What is ShopQL?
ShopQL allows you to generate various reports using ShopifyQL right inside your admin panel. The application is using Shopify Analytics API to retrieve necessary data fast and create comprehensive tables convenient to work with. Read more about ShopifyQL in the Knowledgebase.
Why you need ShopQL
- Create sales reports
The information about customers' orders based on criteria such as sales by month, sales by channel, or sales by staff.
- Create payment reports
You can see information about the payments that you've received, including payment totals, the payment methods that your customers use, and details about the order that each payment is attributed to.
- Create taxes reports
Includes information about the taxes applied to sales, including tax totals, tax rates, and details about the order that each tax payment is attributed to.
- Create visits reports
Will tell you about your Online Store visitors, such as their landing page, the device that they use, and which marketing campaign they can be attributed to.
- Create customers reports
The customers schema gives you access to insights about your customers and makes it easy to segment your customers according to their purchase history. Insights include first-time versus returning customers, and automatic segmentation that separates your customers into promising, loyal, at-risk, and dormant.
All the data from the reports can be mixed with each other to create a necessary combination of features in a custom report.