Generating ShopifyQL queries with Sidekick
You can use Sidekick to create and edit reports by describing what you want in plain language. Sidekick uses the report that you're viewing as context, whether it's a default report or a custom exploration that you created. It then generates a ShopifyQL query that matches your request.
The ShopifyQL query editor isn't displayed on mobile devices or in the Shopify app, so use a desktop browser for the steps on this page.
On this page
Customize an existing report using Sidekick
You can customize an existing report using Sidekick in the ShopifyQL query editor.
Steps:
From your Shopify admin, go to Analytics > Reports.
Click the name of any existing report that you want to customize.
In the ShopifyQL query editor's
Refine query field, enter your customization request in plain language.
Click
or press
Enterto submit your request to Sidekick. To stop Sidekick's answer at any time, click.
Optional: Continue to customize your report by submitting prompts in the
Refine query field.
After you finish modifying your report, click Save as.
In the Save copy as new report dialog, enter a name for your custom report, and then click Save copy.
Generate a new data exploration using Sidekick
You can create a new data exploration using Sidekick in the ShopifyQL query editor.
Steps:
From your Shopify admin, go to Analytics > Reports.
Click New exploration.
In the
What do you want to explore? field, enter your report request in plain language.
Click
or press
Enterto submit your request to Sidekick. To stop Sidekick's answer at any time, click.
Optional: Continue to customize your report by submitting prompts in the
Refine query field.
After you finish generating your report, click Save.
In the Save report dialog, enter a name for your custom report, and then click Save.