Supermetrics isn’t able to convert data that matches dynamic time ranges for specific timezones in your data destination.
If this impacts your Shopify queries — for instance, if you get different results for a different day when you set “Yesterday” or “Today” as a query’s date range — you can edit the query’s timezone manually.
This can be especially helpful if you're seeing Shopify data discrepancies when working with data across different timezones.
Instructions
- Open the Supermetrics sidebar.
- Select the Shopify query you'd like to modify.
- Scroll down and click the Options dropdown.
- Under Reporting timezone, choose the timezone for the query.
- Click any report element from your query in Looker Studio to open the Supermetrics pane.
- Click the Edit icon next to Shopify to open the configuration page.
- Click Edit connection.
- Scroll down to Reporting timezone.
- Select the timezone that matches your Shopify's store timezone.
While you’re in this view, we recommend checking the box next to Allow “Reporting timezone” to be modified in reports. With this enabled, you can adjust the timezone only for selected data objects on your dashboard that are using the dynamic date range of “Today” or “Yesterday”.
- Open the Supermetrics sidebar.
- Select a Shopify query and click Modify.
- Go to Options.
- Under Reporting timezone, choose the timezone for the query.
- On the Supermetrics Hub, go to Destinations → Power BI.
- Select the Shopify query to modify.
- Select the connection to use.
- Go to Options.
- Under Reporting timezone, choose the timezone for the query.
- On the Supermetrics Hub, go to API.
- Select the Shopify data source and the query to modify.
- In the sidebar, go to Options.
- Under Reporting timezone, choose the timezone for the query.
- Click Run to run the query.
When setting up your data transfer, navigate to General settings and select the timezone settings to use.
