---
title: ShopifyQL in the Shopify admin
description: >-
  Access ShopifyQL through the code editor in the Shopify admin to build custom
  reports and analyze store performance.
source_url:
  html: 'https://shopify.dev/docs/apps/build/shopifyql/shopify-admin'
  md: 'https://shopify.dev/docs/apps/build/shopifyql/shopify-admin.md'
---

ExpandOn this page

* [Code editor features](https://shopify.dev/docs/apps/build/shopifyql/shopify-admin.md#code-editor-features)
* [Natural language queries with Sidekick](https://shopify.dev/docs/apps/build/shopifyql/shopify-admin.md#natural-language-queries-with-sidekick)
* [Writing queries](https://shopify.dev/docs/apps/build/shopifyql/shopify-admin.md#writing-queries)
* [Saving and sharing reports](https://shopify.dev/docs/apps/build/shopifyql/shopify-admin.md#saving-and-sharing-reports)
* [Learn more](https://shopify.dev/docs/apps/build/shopifyql/shopify-admin.md#learn-more)

# ShopifyQL in the Shopify admin

All merchants have access to the ShopifyQL code editor directly in the Shopify admin. Navigate to **Analytics** and select **New exploration**, or open an existing report and click on the editor to expand it and edit the code.

![ShopifyQL code editor in the Shopify admin showing a query and results visualization](https://shopify.dev/assets/assets/images/apps/shopifyql/Editor_analytics-DMrGOLML.png)

***

## Code editor features

The code editor provides an interactive environment for writing and testing ShopifyQL queries:

* **Syntax highlighting and autocompletion**: The editor recognizes ShopifyQL syntax and suggests table names, column names, and keywords as you type.
* **Schema exploration**: Browse available tables and columns to understand what data you can query.
* **Real-time query validation**: The editor validates your query syntax before execution and highlights errors.
* **Visualization preview**: See your results rendered as tables, charts, or other visualizations directly in the admin.

***

## Natural language queries with Sidekick

The analytics query editor integrates with Sidekick and understands natural language, making advanced reporting accessible to everyone. Create and customize analytics reports by asking questions like "What was the best converting traffic source in September?" and Sidekick builds reports for you instantly.

Refine your queries with follow-up questions like "How many repeat versus new customers for each traffic source?" that build on your conversation history for more sophisticated insights. Sidekick remembers your conversation, so you can reference previous chats to dive deeper.

You can still write ShopifyQL directly, but you can also start with plain language and learn query building through practical examples. Sidekick translates your questions into ShopifyQL with business-friendly explanations of what each report measures.

***

## Writing queries

Enter your ShopifyQL query in the code editor. The editor executes queries when you click **Run** or press the keyboard shortcut.

## ShopifyQL query

```shopifyql
FROM sales
  SHOW total_sales, orders
  SINCE last_week
  GROUP BY day
  ORDER BY day DESC
```

***

## Saving and sharing reports

After you've written a query, you can save it as a custom report. Saved reports appear in your **Reports** list and can be:

* Scheduled for regular email delivery.
* Shared with other staff members who have analytics access.
* Exported to CSV for external analysis.

***

## Learn more

For detailed information about using the code editor, see [ShopifyQL editor](https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/shopifyql-editor) in the Shopify Help Center.

[ShopifyQL syntax reference\
\
](https://shopify.dev/docs/api/shopifyql)

[Complete reference for all ShopifyQL keywords, operators, and functions.](https://shopify.dev/docs/api/shopifyql)

***

* [Code editor features](https://shopify.dev/docs/apps/build/shopifyql/shopify-admin.md#code-editor-features)
* [Natural language queries with Sidekick](https://shopify.dev/docs/apps/build/shopifyql/shopify-admin.md#natural-language-queries-with-sidekick)
* [Writing queries](https://shopify.dev/docs/apps/build/shopifyql/shopify-admin.md#writing-queries)
* [Saving and sharing reports](https://shopify.dev/docs/apps/build/shopifyql/shopify-admin.md#saving-and-sharing-reports)
* [Learn more](https://shopify.dev/docs/apps/build/shopifyql/shopify-admin.md#learn-more)