Connect Klaviyo to Google Data Studio with Windsor.ai
Directly connect Klaviyo to Google Data Studio, in minutes, and in an easy-to-use format.
All your marketing data in one place, just in a few clicks.
Automate and save time.
Use all your data where and when you need it.
About Klaviyo
Klaviyo is an email marketing and automation platform that helps businesses build stronger customer relationships and grow revenue. The company provides a cloud-based email marketing and automation platform that allows businesses to create targeted, personalized email campaigns that are triggered by specific customer behaviors or actions. Klaviyo can be integrated with popular e-commerce platforms such as Shopify, Magento, BigCommerce, and WooCommerce and has over 300 tech integrations. The company has been recognized as a leader in the email marketing space and is used by more than 100,000 brands.
Learn more about Klaviyo
About Google Data Studio
Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.
Learn more about Google Data Studio
Why integrate Klaviyo with Google Data Studio?
- You can create customized reports and dashboards tailored to your needs using Google Data Studio. By connecting Klaviyo to Google Data Studio, you can track the performance of your email campaigns, such as deliverability and engagement, and make data-driven decisions about your email marketing strategy as needed.
- Integrating Klaviyo with Google Data Studio allows you to combine data from both e-mail and paid media marketing campaigns which can help you understand how your paid media campaigns interact with your email campaigns and make decisions about future strategies.
- Klaviyo allows you to segment your audience and create targeted email campaigns for different customer groups. Using Google Data Studio to visualize Klaviyo’s data, you can compare the performance of different segments and understand which segments of your audience are most engaged, and make decisions about where to focus your marketing efforts.
- Connecting Klaviyo with Google Data Studio can increase your efficiency by automating the reporting process and ensuring data accuracy. You can share and collaborate on your reports with other team members, allowing you to focus on data analysis rather than spending time on data collection and report access.
About the Klaviyo Google Data Studio Connector
The Klaviyo Google Data Studio connector pulls metrics and dimensions from Klaviyo. The insights are retrieved at the campaign and contact level.
Once the user successfully logs into the connector it’s possible to choose the metrics and dimensions to create a report.
Prerequisites
To set up the connector, the user should have:
- A Klaviyo API key (Visit our privacy policy and terms of use)
- Google account for Klaviyo to Google Data Studio integration.
- A Windsor account. Start your free trial now.
How to connect Klaviyo to Google Data Studio?
You need to select Klaviyo as a Data Source and grant access to Windsor.ai. A Klaviyo API key is required to grant access.
Select the fields on the right to later use in your data source. For example, you can include metrics such as open rate, clicks, or conversions.
Go to “Select Destination” and choose Google Data Studio.
Once done, select “connect” and authorize access to your data source.
Windsor.ai: All your marketing data in one place
Power up your marketing performance with result-driven marketing solutions
- Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
- The setup is done in minutes. No coding is required.
- Currently, we support more than 3000 dimensions and metrics.
- See the value and return on every marketing touchpoint.
- Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.
Google Data Studio Templates for Klaviyo
Do you plan to connect and visualize Klaviyo data in Google Data Studio?
These free and customizable Google Data Studio Klaviyo templates will assist you in visualizing your data for easy reporting and analysis.
Google Data Studio Tutorials for Klaviyo
Would you like to take your Google Data Studio Klaviyo dashboards to the next level?
Here are some of our favorite tutorials to help you:
Available Klaviyo Metrics and Dimensions
| Name | Type | Description |
|---|---|---|
| Account ID | TEXT | Klaviyo account ID |
| Address Line 1 | TEXT | The primary address line of the object |
| Address Line 2 | TEXT | The secondary address line of the object |
| Campaign Name | TEXT | Campaign name |
| Campaign Id | TEXT | Campaign id |
| City | TEXT | The city of the object |
| Click rate | NUMERIC | Click rate of e-mails |
| Clicks | NUMERIC | Number of unique e-mail clicks |
| Conversions | NUMERIC | Total Value of placed orders |
| Average Conversion Value | NUMERIC | Average value of placed orders |
| Country | COUNTRY | The country of the object |
| Created at | TEXT | Campaign creation time |
| Created Date/Time | DATE | The time stamp of the object creation |
| Date | DATE | Date of metric type data |
| Email address | TEXT | The email address of the object |
| First Name | TEXT | The first name of the object |
| From E-mail | TEXT | From e-mail |
| From Name | TEXT | From name |
| ID | TEXT | The ID of the object |
| Last Name | TEXT | The last name of the object |
| Latitude | TEXT | The latitude of the object |
| Longitude | TEXT | The longitude of the object |
| Members | NUMERIC | Total number of members in lists for the period |
| Object Type | TEXT | The type of the object (e.g. Person) |
| Open rate | NUMERIC | Open rate of E-mails |
| Opens | NUMERIC | Number of unique e-mail opens |
| Ordered Product | NUMERIC | Total amount of Ordered product |
| Ordered Product Average Value | NUMERIC | Ordered product average value |
| Ordered Product Value | NUMERIC | Ordered product value |
| Organization Name | TEXT | The organization of the object |
| Phone Number | TEXT | The phone number of the object |
| Received e-mails | NUMERIC | Number of e-mails received |
| Region | TEXT | The region of the object |
| Sent at | TEXT | Campaign sent time |
| Status | TEXT | Campaign status |
| Subject | TEXT | Campaign subject |
| Time Zone | TEXT | The time zone of the object |
| Title | TEXT | The title of the object |
| Total Clicks | NUMERIC | Total number of e-mail clicks |
| Total Conversions | NUMERIC | Total amount of placed orders |
| Total Opens | NUMERIC | Total number of e-mail opens |
| ZIP Code | TEXT | The zip code of the object |