Are you looking to streamline your email and e-commerce marketing data analysis? This guide will walk you through setting up Klaviyo as a data source in Power My Analytics. By integrating Klaviyo with PMA, you'll be able to automate your data collection, centralize your metrics, and create powerful, customized reports.

Prerequisites

Before connecting Klaviyo to Power My Analytics, ensure you have:

• A Klaviyo account with Admin, Owner, or Manager user role

Adding Klaviyo as a Data Source

1. Go to your Power My Analytics hub at https://hub.powermyanalytics.com and click on Sources in the left sidebar.
2. Click the + Add new source button.
3. Find and select Klaviyo from the data source gallery.
4. Log in to your Klaviyo account with email and password or SSO.
5. Click Continue when prompted to authorize the PMA app.
6. Select the Klaviyo account you want to connect by clicking the Select button.
7. On the next screen, click Allow to authorize PMA to connect to Klaviyo. You’ll be returned to your PMA hub.

For more information on adding or removing your Klaviyo account as a data source, please see How to Connect to Klaviyo.

Creating a Looker Studio Report

Follow these steps to create a Looker Studio report using your Klaviyo data:

1. In the PMA hub, navigate to Reports > Looker Studio
2. Select Klaviyo under Create Looker Studio Report (this will open the official Looker Studio application in a new window)
3. Google Looker Studio Configuration:
   • Step 1:
     • Name your data source (e.g., "Klaviyo - Organization Name")
     • Choose your Power My Analytics hub from the dropdown
     • Optional: Leave "Use report template for new reports" checked to use the PMA demo template
     • Click Next
   • Step 2:
     • User Account: Select your Klaviyo account (for real data) or "Sample Account" (for sample data)
     • Click Next
   • Step 3:
     • Click Connect (top right) to complete the data source configuration
   • Step 4:
     • Click Create Report (top right)

Key Reports and Fields

The Klaviyo connector provides access to a variety of marketing data, including:

• Email and SMS Campaign Metrics: Opened Email, Bounced Email, Clicked SMS, Received SMS
• Flow Metrics: Flow ID, Status, Trigger Type
• List Metrics: List ID, List Name

For a list of available Klaviyo fields in Power My Analytics, visit the Schema Explorer.

Klaviyo Metrics Behavior

Klaviyo metrics are handled as custom metrics in Power My Analytics and aren't visible in the Schema Explorer. These metrics will appear in your reports after connecting to Klaviyo. For more information on the common metrics available after connecting, please see Common Klaviyo Metrics.

Limitations and Important Considerations

• Backfilling: Backfilling of past data is not possible, as all data is live only. Historical data collection begins on the day you connect your Klaviyo account to PMA.
• Unique Values with Flow Metrics: Flow metrics (such as open, click, and conversion rates) are unique values. Open rates and click rates are calculated based on unique recipients.

Unavailable Data

• The tables Lists, Person, Purchase, and Ads are unavailable.
• Data from integrations for Shopify, Magento, Stripe, and WooCommerce is currently unavailable.

Data Discrepancies

There may be minor data differences between the send performance metrics reported in your Klaviyo dashboard and these metrics as reported through PMA.

• When reporting email and sales events by date in PMA, the date is based on the time that a given event (such as an email open) actually took place, rather than the send date of the campaign or flow.
• However, the Klaviyo dashboard reports the date of these events using the send date of the campaign or flow.
• These differences can be minimized by using longer date ranges in your Klaviyo report.

Troubleshooting

If you encounter issues:

1. Ensure your Klaviyo account role is Admin, Owner, or Manager.
2. If problems persist, contact Power My Analytics support.
   

See our article Basic Troubleshooting for more information on issues that may affect the Klaviyo connector.