By default, Supermetrics requests EET (UTC+2) timezones for Klaviyo queries. Users outside this timezone can see discrepancies with their Klaviyo data if their Klaviyo instance is set to a different timezone and the queries contain timezone data.
To get the correct timezone data, you can either set the timezone in the query settings or automatically set your Klaviyo account timezone.
Instructions
Set timezone in query settings
In version 3 of the Klaviyo API, you can set a timezone for your queries to make sure the data matches the native Klaviyo UI.
To set the timezone:
- Select a Klaviyo query to edit.
- In the query settings, go to Options.
- Select a timezone to use for the query.
Get automatic account timezone
Version 3 of the Klaviyo API has a new endpoint that allows Supermetrics to get the default timezone for a given account for users with the correct access rights. Users with new API keys created after June 15, 2023, have access to the account's default timezone. Users with API keys created before June 15, 2023, don't have sufficient access for accessing the account timezones.
To check if you have the right access scope:
- Go to Klaviyo and navigate to Settings → Account → API keys.
- In the Private API keys view, click the arrow to expand the details of a private API key you use with Supermetrics.
- If the access scope contains "Accounts", the timezone will be fetched automatically.
- If the "Accounts" scope is missing, create a new API key. It's not possible to update an API key in Klaviyo. Our Klaviyo connection guide tells more about how to create the API key.