Overview of the new Shopify reports
You can adjust the new default reports in Shopify to display the data that you want. You can filter data, select the metrics and dimensions, choose your preferred visualization, and select different time ranges or comparisons. You can also export your reports for analysis in spreadsheet programs.
The new default Shopify reports are the same as the existing reports that are pre-formatted and ready to use in your Shopify admin. Default reports are considered to be authored by Shopify. You can filter your Reports list by Created by, and select only Shopify as an option to view a list of only default reports.
You can filter and edit the new default Shopify reports to display different information as you want. You can save your changes as custom data explorations, regardless of your Shopify subscription.
New Shopify reports have the following main components:
- the ShopifyQL query editor
- the quick filters
- the configuration panel
- a data visualization
- the data table
On this page
ShopifyQL query editor
The ShopifyQL query editor represents the report as a database query using ShopifyQL, or Shopify Query Language. Every default report has a pre-written query already displayed in the query editor, so you can read how the report is generated from the information in your store's database. You can also create a completely custom query from a new data exploration.
Changes that you make to the report using the configuration panel or the data table are reflected in the query editor in real-time. When you make a change to the pre-written query, you must select ▹ Run in the query editor for the report, configuration panel, visualization, and data table to update with your changes. You can also have Sidekick generate or customize a ShopifyQL query for you based on your prompt.
If a query isn't valid, then an error message displays at the bottom of the query editor to indicate which line the error is on. Errors in the query are underlined in red, and you can hover your cursor over the error to get tips on how to resolve the issue.
When the query editor is hidden, click or tap the down chevron ⌄ to display it. To hide the query editor content in the report, click or tap the up chevron ⌃.
Learn more about using ShopifyQL and building queries.
Quick filters in Shopify reports
The quick filters are a collection of menus across the top of a Shopify report that let you filter and format your report data in the way that makes the most sense to your business.
Shopify reports include the following quick filter menus:
- Date range menu: Filter your report data by date and time ranges. Select from preset date ranges, such as Last 7 days, Month to date, or Black Friday Cyber Monday, or set your own custom date range. Learn more about setting a date or time range for a report.
- Comparison menu: Compare your report data across 2 different time periods or against a target. For example, comparing Net sales over the last 30 days to the previous 30-day period, or to the same period last year.
- Currency menu: Display your report data in a currency other than your store currency. The currency conversion rate used is based on the historical rate on the day of the transaction.
- Store menu: For organizations with access to multi-store reporting, display report data from multiple stores within an organization in a single report.
Configuration panel
New Shopify reports can be customized using the configuration panel on the right side of the report. There are 2 available exploration methods that you can switch between using the tabs at the top of the configuration panel: Freeform and Cohorts
.
Each tab works independently, so switching between exploration methods won't affect your existing configurations in the other tab. This makes it easy to explore your data from different angles within the same report, without losing the changes you make when switching between tabs. However, only 1 configuration is saved for a report based on the current open exploration method tab. If you want to save the configurations that you've created for both exploration methods, then you must save each exploration method as a separate custom report.
The options available in the menus in the configuration panel update dynamically based on your selections. Certain combinations of data become unavailable to select when the data can't be viewed together.
The default reports can be edited temporarily by adding or removing metrics, dimensions, or filters, but these edits don't override the original configuration of these reports. To keep modifications to an existing default report, you must save the data exploration as a custom report.
Learn more about creating data explorations.
Freeform method
The Freeform method tab is the default report experience to explore trends and compare data across dimensions selected by you. This tab contains menus for selecting the following report criteria:
- Metrics: A sum or value represented in the report. You must always have at least 1 metric selected, but you can add multiple metrics and switch between them in the same report. For example, Net sales or Average order value are both metrics. When you add more than one metric, you can change which one you want to have visualized by clicking on the desired metric in the configuration panel. A checkmark indicates which metric is the one being visualized.
- Dimensions: The property by which the selected metric is divided and organized. For example, in the Add to cart rate over time report, the Add to cart rate is the metric and time is the dimension. You can add multiple dimensions in the same report.
- Visualization: A visual representation of your data. The most appropriate visualization is automatically selected, though you can manually override the selection as you want.
- (Optional) Attribution: A section that displays only when sales metrics and marketing dimensions are used in the report. Use this to select the attribution models for your report data. Learn more about marketing attribution data in reports.
- Filters: A method to reduce your report's data and to include only specific criteria. By default, the Date range filter is set to include data from the last 30 days. You can add multiple filters in the same report.
Cohorts method
The Cohorts method tab lets you review your report data to better determine how customer retention and cohorts behave over time.
This tab contains menus for selecting the following report criteria:
- Metric: A sum or value represented in the report. You must always have at least 1 metric selected, and can only select 1 retention metric at a time. For example, Net sales or Amount spent per customer are both retention metrics.
- Cohort definition: A menu to apply filters to determine which customers are included in the cohort analysis based on their first order. For example, you can filter to include only customers whose first order was placed from the Shop sales channel.
- Visualization: A visual representation of your data. The most appropriate visualization is automatically selected, though you can manually override the selection as you want.
- Interval: The option to select the time periods that cohorts are grouped by. For example, you can divide cohorts by Month.
- Filters: A method to reduce your report's data and to include only specific criteria. By default, the Date range filter is set to include data from the last 12 months. You can add multiple filters in the same report.
Learn more about customizing customer cohort analysis data.
Annotations panel
You can add annotations to reports that use a time dimension to help you analyze why changes in a metric occurred. Annotations are color-coded visual markers on a report's visualization at the dates when events occurred. Some annotations are generated from store events, such as a product being published, a theme being deployed, or an app being installed. Apps can also add annotations, and you and your staff can create annotations for your own business events, such as a campaign launch or a supplier delay.
To activate annotations, click Annotations, and then click . The configuration panel changes into the annotations panel, which lists all annotations for the report's timeframe. From the annotations panel, you can create, edit, and delete your own annotations, search annotations, and filter them by activity type or by who created them, such as Shopify, an app, or a staff member. To return to the configuration panel, click Controls.
Learn more about using annotations in your Shopify reports.
Visualizations
You can control the way your data is visually represented in a Shopify report. Visualizations include graphs, such as line or bar graphs, as well as lists, tables, heatmaps, and histograms.
By default, the recommended visualization for the primary metric in the report is automatically selected in the configuration panel. Shopify default reports come with a pre-selected visualization which can be different than the recommended visualization with similar dimensions. You can deactivate the Recommended setting by manually selecting a different visualization type based on your preference. Learn more about choosing the right visualization for your Shopify report.
If the selected visualization isn't available for a particular dataset, then a visualization won't display. For example, line graphs display only when time is a selected dimension. To get a visualization to display, you can adjust your report to include any missing or compatible metrics or dimensions, or you can manually reactivate the Recommended setting.
Visualizations display a default number of items for the primary dimension in the report. For example, the Total sales by product report displays up to 5 products in the default simple horizontal bar graph visualization. Using the configuration panel, you can display a custom number of items when selecting a supported visualization type. Learn more about customizing the number of items in visualizations.
Data table
The data table is available at the bottom of all reports and displays your selected metrics and dimensions in a tabular format. The first row of every table is the Summary, which displays numerical totals for all included metrics.
The table can be organized in 2 ways: flat or nested. How you decide to display your data depends on what information you want to gain from the report.
Click or tap the table option icon to switch between Flat or Nested versions of the data table:
Flat table
A flat table displays a single row for every line in your data table. When you choose to sort a flat table by a particular metric, it sorts the data across all individual, separate rows regardless of dimension.
Review the following example on how data might display in a flat table when sorted by net sales in descending order:
| Sales channel | Product title | Net sales ⌄ |
|---|---|---|
| Summary | $2,760 | |
| Online Store | Bamboo Towel | $575 |
| Online Store | Beach Sandals | $450 |
| Point of Sale | Red Sunglasses | $425 |
| Point of Sale | Bamboo Towel | $380 |
| Online Store | Red Sunglasses | $300 |
| Point of Sale | Coconut Sunscreen | $275 |
| Online Store | Coconut Sunscreen | $210 |
| Point of Sale | Beach Sandals | $145 |
Nested table
A nested table groups the data in your table by the dimensions selected. For example, if you have a net sales report with 2 dimensions selected, such as Sales channel and then Product title, then the nested table groups the data by sales channel and then by product title within each sales channel. If you choose to sort your sales in descending order, then the nested table displays the top-selling sales channels first, and within each sales channel, displays the top-selling product titles first.
Review the following example on how data might display in a nested table when sorted by net sales in descending order:
| Sales channel | Product title | Net sales ⌄ |
|---|---|---|
| Summary | $2,760 | |
| Online Store | - | $1,535 |
| Bamboo Towel | $575 | |
| Beach Sandals | $450 | |
| Red Sunglasses | $300 | |
| Coconut Sunscreen | $210 | |
| Point of Sale | - | $1,225 |
| Red Sunglasses | $425 | |
| Bamboo Towel | $380 | |
| Coconut Sunscreen | $275 | |
| Beach Sandals | $145 |
The order of dimensions in a nested table is relevant, because nested tables group data based on the order of selected dimensions in the configuration panel. For example, if the dimensions in the previous example were reversed, with Product title being the primary dimension, then this is how the same data might display when sorted by net sales in descending order:
| Product title | Sales channel | Net sales ⌄ |
|---|---|---|
| Summary | $2,760 | |
| Bamboo Towel | - | $955 |
| Online Store | $575 | |
| Point of Sale | $380 | |
| Red Sunglasses | - | $725 |
| Point of Sale | $425 | |
| Online Store | $300 | |
| Beach Sandals | - | $595 |
| Online Store | $450 | |
| Point of Sale | $145 | |
| Coconut Sunscreen | - | $485 |
| Point of Sale | $275 | |
| Online Store | $210 |