Connect Klaviyo to Looker Studio : How-to, templates and metrics

Klaviyo is one of the great alternatives to ActiveCampaign or Mailchimp. You can keep in touch with your customers across multiple canals, create your email and SMS campaign, and use automation and IA to send and write your message... All of this is great, and you will need to create a custom dashboard to follow and share your performance!

That's where Looker Studio intervenes. You can create a custom report, select your KPIs and design, and share it easily with anyone. It becomes effortless to analyze and present performance. 

With Catchr's connector for Looker Studio, you can connect Klaviyo to Looker quickly and start creating reports or using templates.

Connect your Klaviyo account to Catchr.

Create an API Key in Klaviyo. 

To authorize a third-party app like Catchr to connect to your Klaviyo account, you need an API Key. You can generate this key in your Klaviyo account from the homepage :

• Click your organization name in the bottom left.
• Click Settings.

• Click API Keys and Create Private API Key.

• Name your key and select the read-only scope.
• Click Create

Copy this API Key. We will use it on Catchr to connect your Klaviyo account.

Add a new Source on Catchr.

Go to your Catchr account and :

• Navigate to Sources -> Add source.
• Select the Klaviyo integration.
• Paste the API key and click Next.

Wait for your account to appear on the page.

How to connect your Klaviyo account to Looker Studio

Create an Account on Looker Studio

If this is your first rodeo with Looker Studio, then saddle up by setting up your account. Veterans who are familiar with Looker Studio can simply ride along by using their existing Google credentials.

Connect Klaviyo to Looker Studio

• Navigate to the Looker Studio homepage and hit the "Create" button.

• From the dropdown options, choose "Report."

• Once in the data sources gallery, keep an eye out for the Catchr Klaviyo data connector.

Step-by-step guide on the authorization step:

If this is your inaugural authorization of the connector:

• Looker Studio will ask for your permission to work with the community connector.

• Select your desired Google Account for the connection.

• Read and understand the necessary permissions before scrolling and granting access.

• Now, it's time for the Catchr Klaviyo connector to link up with your Klaviyo data. Hit the 'Authorize' prompt below 'Klaviyo requires authorization.'

• Follow the simple steps in the pop-up, and once done, your status will be confirmed.

• Wait for a brief loading period and then choose the Klaviyo account to grant Catchr access.

Congratulations! You're now all set to explore the boundless world of marketing data within Looker Studio with your Klaviyo account.

Example of metrics you can use with the Looker Studio Integration for Klaviyo

Diving into the metrics enabled by integrating Klaviyo with Looker Studio unlocks a galaxy of data visualization possibilities. From tracking email open rates to analyzing subscriber behavior, these insights offer a granular view of your marketing efforts. The cross-channel analysis is particularly potent, allowing you to see how various marketing facets work synergistically towards growth.

Imagine charting the journey of email campaigns with the Campaign ID, Campaign Name, and recipients' engagement metrics such as Emails Opened and Emails Clicked. Dive deeper to assess the effectiveness of targeted campaigns by looking at Campaign Message Type and usage across different platforms through metrics like API - Viewed Product and Shopify - Placed Order.

For more advanced users, the temporal analytics, given by Year, Quarter, and Month, allow for trend analysis and time-sensitive marketing strategies. By tracking these alongside engagement metrics like Subscribe to List and Unsubscribed from List, you can derive crucial insights into subscriber lifecycles and churn rates.

Lastly, the holistic view of customer interactions through personal information metrics empowers you to create personalized and more converting campaigns. This granular detail might include Person name, Person Email, and Person Organization.

For a complete list of metrics and to make the most out of your Klaviyo integration with Looker Studio, visit the Catchr metrics directory.

‍