Klaviyo
The Klaviyo connector gets your Klaviyo data into Google Sheets and Google Data Studio. Use it to track your key metrics in a spreadsheet or a Google Data Studio report.
What you can report on
- Email campaign performance: opens, clicks, and bounces
- Flow analytics and automated message performance
- Revenue attributed to email and SMS campaigns
- List growth, unsubscribes, and subscriber churn
- Segment performance and A/B test results
Prerequisites
- A Klaviyo account with the Admin, Owner or Manager role
- A private API key with read-only scope. See How to get your credentials.
Klaviyo documents what each role can do in their help article.
How to get your credentials
- In Klaviyo, open your Profile menu. Then select Settings.
- Under Account, select API keys.
- Select Create Private API Key and enter a name. Under Select Access Level, choose Read-Only Key. Then select Create.
- Copy or download the key from the confirmation screen.
How to create a connection
- In the Hub, open Connections & accounts.
- Select Create connection.
- Select Klaviyo in the connector list.
- Select Next.
- In Name the connection, enter a name.
- In API key, paste your Klaviyo private API key. If you don't have one, see How to get your credentials.
- Select Test connection.
- Enable the accounts you want to report on.
- Select Done.
How to get Klaviyo data into Google Sheets or Google Data Studio
To get Klaviyo data into Google Sheets:
- In the Two Minute Reports sidebar, open Data Queries.
- Select Add.
- Select the accounts you want to report on. You can select more than one.
- Select your metrics and dimensions.
- Select the date range.
- Set sorting and filters if you need them.
- Select Run query. Two Minute Reports adds the data to your sheet.
Reporting on several Klaviyo accounts. Select more than one account when you create a query. You can also open Clients, add a client, assign its Klaviyo accounts and select Save & Close. The assignment is then ready for later queries.
To get Klaviyo data into Google Data Studio:
- In the Hub, open Google Data Studio › Klaviyo.
- Select Create report.
- Select or create a query config:
- To use a query config you have: select it in Choose your query config. Then select Save.
- To create a query config: if you already have one, first select Create new query config in the list. Enter a name in Name your query config, and select the accounts in Select your accounts. Select Save.
- Select Create from scratch. If templates show under Quick start from a template, you can select one instead.
- Looker Studio (formerly Google Data Studio) opens in a new tab, with the Two Minute Reports connector. If you are in more than one team, select your team in Select your Team.
- In Select Query Config, select your query config.
- Select Connect in the top-right corner.
- In your new report, add Klaviyo metrics and dimensions to the canvas.
Next steps
- Scheduling auto-refresh in Google Sheets
- Run queries
- Manage your spreadsheets
- Google Sheets troubleshooting
Understanding and resolving data discrepancies
You might encounter discrepancies between data in Two Minute Reports and what you see in the Klaviyo dashboard. Below are the common causes and how to resolve each one.
Flow emails displayed as campaigns
In Two Minute Reports, all email types (campaigns and flows) are listed under campaigns. To separate them, use a filter on the Campaign is part of a flow dimension.
Filter for campaigns only:
| Setting | Value |
|---|---|
| Field | Campaign is part of a flow |
| Condition | MATCHES REGEX |
| Value | false |
Filter for flows only:
| Setting | Value |
|---|---|
| Field | Campaign is part of a flow |
| Condition | MATCHES REGEX |
| Value | true |
Discrepancies in metrics
Klaviyo attributes email and sales events differently in its dashboard and in its API.
- In the dashboard, events are assigned to the date the user received the email.
- In the API, events are assigned to the date they actually occurred.
Two Minute Reports uses the API, so results may differ from the Klaviyo dashboard. Using longer date ranges in your queries reduces the impact of this difference.
Discrepancies in open and click rate data
Two Minute Reports calculates open and click rates by dividing unique opens or clicks by total emails delivered. When a query uses an incomplete time frame, multiple API requests may run and count unique values more than once.
For best accuracy, use these date ranges:
- A complete week (Monday to Sunday)
- A full calendar month
- The current month (for month-to-date performance)
Open rate or click rate exceeding 100%
When breaking down rates by date, values can exceed 100% because opens don't always happen on the same day emails are received. Metrics are attributed to the day the event occurred, not the send date.
Example: 40 emails sent Monday, 20 on Tuesday. 5 opened Monday, 30 opened Tuesday.
- Monday open rate = (5 ÷ 40) × 100% = 12.5%
- Tuesday open rate = (30 ÷ 20) × 100% = 150%
To avoid this, pull rates by campaign or over a longer time frame (a full month) rather than a daily breakdown.
Total integration value instead of Klaviyo attributed value
By default, Two Minute Reports may show total integration value. To show only Klaviyo-attributed value, turn on the attribution option:
- In a Google Sheets query: Filter insights, only attributed to Klaviyo Campaigns and Flows
- In a Google Data Studio query config: Only include insights attributed to Klaviyo campaigns and flows
Alternatively, apply this filter:
| Setting | Value |
|---|---|
| Field | Campaign name |
| Operator | DOES NOT MATCH REGEX |
| Value | null |