Klaviyo & Google Sheets: how to integrate your data

This detailed tutorial aims to guide you through the process of connecting your Klaviyo account with Google Sheets. By the conclusion of these steps, you will have the knowledge to seamlessly integrate marketing data from Klaviyo into Google Sheets. This integration allows for better visualization, analysis, and the creation of custom reports to enhance your marketing strategies effectively.

How to Connect Your Klaviyo Account to Google Sheets

Add a Source on Catchr

To initiate the process, navigate to the Catchr homepage. On the left-hand menu, click on "Source", followed by selecting "Add a Source" located at the top right corner. Choose Klaviyo as your platform and complete the necessary steps for authentication to link Catchr with Klaviyo.

Create a New Query

Launch Google Sheets and locate "Catchr" in the menu bar. Clicking on it will reveal a dropdown, where you should select "New Query". This action is crucial for transferring your Klaviyo data.

Select Your Data Source

In the new query tab, select Klaviyo as your source of data. If your Klaviyo account isn't listed, add it by clicking on the "+" icon.

Select Your Account(s)

Proceed to the "Select account(s)" section to pick the Klaviyo account(s) whose data you wish to import.

Choose Metrics and Dimensions

Next, navigate to the "Metrics" and "Dimensions" tabs to select the appropriate data points for your query. For Klaviyo, the following options are significant:

Metrics:

• Emails Opened: The total number of email open events.
• Emails Received: The total number of emails successfully received by recipients.
• Emails Clicked: The total number of times emails were clicked by recipients.

Dimensions:

• Campaign Name: The specific name of your campaign.
• Device Type: Identifies whether the recipient used a desktop, mobile device, or tablet.
• Country: The recipient's country.

Ensure the metrics and dimensions chosen align with your data analysis and reporting goals.

Set Date Range

After metrics and dimensions selection, specify the date range for your data import in the "Date Range" tab. Catchr provides standard ranges like "Last month" or allows for custom date selection.

Apply Filters

You can refine your data further by applying filters. Simply populate the following fields to set up a filter:

• Field: Campaign Name
• Operator: Equals
• Value: Specific campaign name you're interested in

For instance, to exclusively analyze data for a particular campaign, specify its name accordingly.

Schedule & Customize Data Refreshness

In the "Options" tab, you have the flexibility to schedule automatic data refreshes. Additional settings such as "Append rows" and "Combine rows" are available to optimize how new or existing data is handled in your query.

Upon completing these steps, your Klaviyo data will seamlessly flow into Google Sheets, empowering you with real-time insights and robust data visualization capabilities.

Examples of Google Sheets You Can Create Using Klaviyo Data

With Klaviyo's comprehensive metrics and dimensions, the possibilities for creating insightful Google Sheets are vast. Here are a few examples:

• Email Campaign Performance Dashboard: Track the performance of your email campaigns over time. Visualize open rates, click-through rates, and the number of emails sent versus received for each campaign.
• Subscriber Growth Analysis: Use metrics like "Subscribed to List" and "Unsubscribed from List" along with dimensions such as date and campaign name to analyze your subscriber growth trends.
• Engagement Analysis by Device Type: Understanding how different devices impact user engagement can tailor your content strategy. Using the "Device Type" dimension along with open and click metrics, determine which devices lead to the most engagement.

By integrating Klaviyo with Google Sheets through Catchr, marketing teams unlock the full potential of their data, fostering data-driven decision-making and strategy optimization.

‍