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.

Customize an existing report using Sidekick

You can customize an existing report using Sidekick in the ShopifyQL query editor.

Steps:

  1. From your Shopify admin, go to Analytics > Reports.

  2. Click the name of any existing report that you want to customize.

  3. In the ShopifyQL query editor's Sidekick Refine query field, enter your customization request in plain language.

  4. Click Send or press Enter to submit your request to Sidekick. To stop Sidekick's answer at any time, click Stop.

  5. Optional: Continue to customize your report by submitting prompts in the Sidekick Refine query field.

  6. After you finish modifying your report, click Save as.

  7. 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:

  1. From your Shopify admin, go to Analytics > Reports.

  2. Click New exploration.

  3. In the Sidekick What do you want to explore? field, enter your report request in plain language.

  4. Click Send or press Enter to submit your request to Sidekick. To stop Sidekick's answer at any time, click Stop.

  5. Optional: Continue to customize your report by submitting prompts in the Sidekick Refine query field.

  6. After you finish generating your report, click Save.

  7. In the Save report dialog, enter a name for your custom report, and then click Save.