Klaviyo Data Connector User Guide

Klaviyo Data Connector User Guide

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 for 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 campaign metrics
  • SMS campaign metrics
  • Flow metrics

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

Limitations and Important Considerations

Keep the following in mind when using the Klaviyo connector:

  • 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.

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.

Unavailable Data

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

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.


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

      • Related Articles

      • Mailchimp Data Connector User Guide

        The following article is a guide to automating reports with your Mailchimp connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Mailchimp reports. To begin creating ...

      • 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

        The following article is a guide to automating reports with your Stripe connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Stripe reports. To begin 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 ...

      • BigCommerce Data Connector User Guide

        Are you looking to streamline your BigCommerce data analysis and reporting? Power My Analytics' BigCommerce connector automates the collection and integration of your e-commerce data, saving you time and providing deeper insights into your online ...