Use the Shopify connector to see which products are selling the most, allowing you to optimize your marketing spend. Track your order and return ratio and create historical reports to identify seasonal changes in your store's performance.
Before you begin
Before you build reports, you need to connect the data source to Supermetrics.
Connection instructions: See our Shopify connection guide.
Available metrics and dimensions: Find the full list of fields in our Shopify field documentation.
Popular queries
These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.
Track order count and total sales last quarter
See how your order volume and total sales have evolved day by day over the last quarter. This helps you identify sales trends, spot seasonal patterns, and asses overall store performance.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last quarter |
Metrics | Orders, Total sales |
Dimensions | Date |
Suggested visualization | Time series or combo chart |
Understanding the data
Orders: The total number of orders placed within the reporting period.
Total sales: The total sales value for the reporting period.
Date: Splits results by day so you can track daily order and sales trends.
Compare order count year over year
See how your monthly order volume this year compares to the same period last year — useful for tracking growth and identifying months where performance was stronger or weaker than expected.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Year to date |
Date range comparison | Same dates a year ago or Previous year |
Metrics | Orders |
Dimensions | Year & Month |
Suggested visualization | Bar or time series chart |
Understanding the data
Orders: The total number of orders placed within the reporting period.
Year & Month: Splits results by month so you can compare order volume across the year.
Analyze sales performance with discounts, returns, and gross sales
Get a comprehensive daily view of your sales this month — including gross sales, total sales, discounts applied, and returns — so you can understand the full picture of revenue and identify where value is being lost.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | This month to date |
Metrics | Discounts, Returns, Gross sales, Total sales, Orders |
Dimensions | Date |
Suggested visualization | Table |
Understanding the data
Discounts: The total value of discounts applied to orders within the reporting period.
Returns: The total amount refunded for orders within the reporting period.
Gross sales: The total price for line items before any discounts are applied.
Total sales: The total sales value after discounts and returns.
Orders: The total number of orders placed within the reporting period.
Date: Splits results by day so you can track daily sales performance.
Troubleshooting
If you encounter a 403 Forbidden error when connecting to a Shopify store, or an Authentication failed error after reconnecting, follow our Shopify connection guide to make sure you have all the necessary permissions.
More resources
See the Supermetrics blog for practical tips for ecommerce analytics and how to build a Shopify dashboard in Looker Studio.
You might also be interested in: