In this article, we will explain everything you need to know to start working properly with our Klaviyo connector.
How does the Klaviyo connector work?
The Klaviyo connector is designed to give you quick and secure access to your Klaviyo data. Once you've logged into Dataslayer and connected your Klaviyo account, you’ll be able to pull key metrics and dimensions directly into your reports.
We'll explain some important details to help you set up your queries correctly from the start.
Key considerations when using the Klaviyo connector
Multiple account access
Depending on your Dataslayer plan, you can access multiple Klaviyo accounts using the same email address.
Identifying accounts
Klaviyo's API only returns the Public API Key, so the company name won’t appear during the connection process. However, you will see the account name in the "Your Accounts" section.
Combining metrics and dimensions
Klaviyo’s API restricts how you combine certain metrics and dimensions. Here is what you need to know to avoid errors:
-
Do not mix metrics from different report types.
For example, you cannot combine Event metrics and Performance metrics in the same query. This will result in an invalid combination error. -
You can combine dimensions from groups like Account and Time with one additional group of dimensions, such as Profile or List.
However, combining multiple additional groups in the same query is not supported by the Klaviyo API:-
Valid combinations: Account + Time + one group of dimensions.
Example: Account name + Year + Profile ID -
Invalid combination: Account + Time + multiple groups of dimensions.
Example: Account name + Year + Profile ID + List type
-
This behavior comes from how Klaviyo structures its data and is external to Dataslayer.
Query load times
Some scenarios may significantly increase load times:
- Including the "Received Email" metric if your account has large amounts of data.
- Using the "Date" dimension in the Campaign/Flow Performance metrics:
Klaviyo's API does not support adding a date segmentation to Flow or Campaign performance reports. This means that, by default, it is not possible to break down these metrics by Date, Month, or other time-based dimensions in a single query.
However, since some users requested this feature, we implemented a workaround to simulate date segmentation manually. What we do is split your query into multiple API requests.
For example, if you select a full year date range and break down by "Date" dimension, we will request 365 daily reports one by one to build your result.
This can make the query take a very long time, especially because Klaviyo limits the Flow/Performance reports to 2 requests per minute.
If you find data discrepancies when working with Multi-Metric or Flow/Performance reports, please refer to this article.
How to speed up these queries
If you want to reduce query times when working with Flow or Campaign performance reports:
-
Remove the date dimensions, if possible, as it's the simplest way to avoid multiple queries.
-
Use a larger time dimension, like “Month”, to reduce the number of requests (for example, 12 instead of 365).
-
Switch to an Events metrics report, which allows time dimensions directly in the API, without workarounds.
If Klaviyo changes its API behavior in the future, we’ll make sure the connector stays up to date.
As always, please contact us via our live chat on our website chat or through our email if you still have doubts or questions. We are happy to help!