Klaviyo Data Connector User Guide

Klaviyo Data Connector User Guide

Info
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:

  1. A Klaviyo account with Admin, Owner, or Manager user role
  2. A private API key from Klaviyo
To create your API key, follow the instructions at How to Connect to Klaviyo.

Adding Klaviyo as a Data Source

  1. Navigate to your PMA Hub and select Sources from the menu.
  2. Click + New Data Source and choose Klaviyo from the gallery.
  3. Enter your private API key from Klaviyo and click Connect.

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:
    1. Step 1:
      1. Name your data source (e.g., "Klaviyo - Organization Name")
      2. Choose your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked to use the PMA demo template
      4. Click Next
    2. Step 2:
      1. User Account: Select your Klaviyo account (for real data) or "Sample Account" (for sample data)
      2. Click Next
    3. Step 3:
      1. Click Connect (top right) to complete the data source configuration
    4. Step 4:
      1. 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 comprehensive list of available Klaviyo fields in Power My Analytics, visit the Schema Explorer.

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.

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.
  1. 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.
  2. However, the Klaviyo dashboard reports the date of these events using the send date of the campaign or flow.
  3. These differences can be minimized by using longer date ranges in your Klaviyo report.

Troubleshooting

If you encounter issues:

  1. Verify your API key is correct and has the necessary scopes.
  2. Ensure your Klaviyo account role is Admin, Owner, or Manager.
  3. If problems persist, contact Power My Analytics support.
See our article Basic Troubleshooting for more information on issues that may affect the Klaviyo connector.

    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • When Will PMA Add a Klaviyo Connector?

        Great news: Power My Analytics now offers a Klaviyo data connector! To get started using your Klaviyo data in PMA, please see the Klaviyo Data Connector User Guide.
      • Mailchimp Data Connector User Guide

        Are you looking to streamline your email marketing analytics and reporting? Power My Analytics' Mailchimp integration allows you to easily connect your Mailchimp account, automate data collection, and create powerful reports. This guide will walk you ...
      • How to Connect to Klaviyo

        Connecting your Klaviyo account to Power My Analytics allows you to centralize your email marketing data for more efficient reporting and analysis. This guide will walk you through the process of creating a Klaviyo API key and connecting your account ...
      • Stripe Data Connector User Guide

        Stripe is a powerful payment processing platform that enables businesses to accept online payments, manage subscriptions, and handle invoicing. This guide will walk you through the process of connecting Stripe to Power My Analytics, creating reports, ...
      • Criteo Data Connector User Guide

        This guide will walk you through the process of connecting your Criteo account to Power My Analytics and creating reports using the data. Criteo is a powerful advertising platform specializing in retargeting, customer acquisition, and personalized ...