Klaviyo

Last updated on May 06, 2024

Effective June 30, 2024, this version of the Klaviyo Source will be sunset and replaced with an upgraded version, Klaviyo v2 (currently in Early Access). After the sunset, you will not be able to create new Pipelines using this Source, and your existing Pipelines will be paused. You need to create new Pipelines using Klaviyo v2 to ensure a smooth transition. Please contact your Hevo account executive or the Support team to enable Klaviyo v2 for your team.

Klaviyo is an e-mail marketing platform with email and SMS marketing automation.

You can replicate data from your Klaviyo account to the Destination database or data warehouse using Hevo Pipelines.

Setup

Data Sync

Prerequisites

An active Klaviyo account from which data is to be ingested exists.
You are assigned the Team Administrator, Team Collaborator, or Pipeline Administrator role in Hevo to create the Pipeline.
The API key is available to allow Hevo to connect to your Klaviyo account.

Generating the API Key in Klaviyo

You require an API key to authenticate Hevo on your Klaviyo account.

Perform the following steps to create an API key:

Log in to your Klaviyo account.
In the top right, click the drop-down next to your username, and then click Account.
In the Account page, click Settings in the tab bar, and then, click API Keys.
In the Private API Keys section, click Create API Key.

An API key is created without a label.
(Optional) Update the API key name:
1. Click the Edit icon next to the Label field for the API to provide a name for it.
2. In the Update API Key Label dialog, enter a name and click Save API Key.

You can view the API key along with its name in the Private API Keys section. Use this key while configuring your Hevo Pipeline.

Configuring Klaviyo as a Source

Perform the following steps to configure Klaviyo as the Source in your Pipeline:

Click PIPELINES in the Navigation Bar.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select Klaviyo.
In the Configure your Klaviyo Source page, specify the following:
- Pipeline Name: A unique name for your Pipeline.
- Private API Key: The private API key for your Klaviyo account.
- Historical Sync Duration: The duration for which you want to ingest the existing data from the Source. Default duration: 3 Months.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.

Data Replication

For Teams Created	Default Ingestion Frequency	Minimum Ingestion Frequency	Maximum Ingestion Frequency	Custom Frequency Range (in Hrs)
Before Release 2.21	6 Hrs	1 Hr	48 Hrs	1-48
After Release 2.21	6 Hrs	30 Mins	24 Hrs	1-24

Note: The custom frequency must be set in hours as an integer value. For example, 1, 2, or 3 but not 1.5 or 1.75.

Historical Data: In the first run of the Pipeline, Hevo ingests historical data for the Event object on the basis of the historical sync duration selected at the time of creating the Pipeline and loads it to the Destination. Default duration: 1 Year. For the remaining objects, Hevo performs a Full Load and ingests all the data present in your Klaviyo account.
Incremental Data: Once the historical load is complete, all new and updated records for the Event and Campaign Recipient objects are ingested as per the ingestion frequency. The remaining objects are ingested in Full Load mode.

For all Pipelines created from Release 1.97 onwards, Hevo supports the replication of historical and incremental data for the Campaign Recipient object, along with the Event object.

Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination:

Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Note: All objects other than Event and Campaign Recipient are Full Load objects.

Object	Mode	Description
Campaign	Full Load	Contains the details of a campaign including its type, status, and schedule for sending the emails for it. Each event may be associated to a campaign, which further has a list of users associated with it.
Campaign Recipient	Incremental	Contains the details of the email recipient(s) associated with a campaign.
Event	Incremental	Contains the details of one or more Events associated with a metric, in a timeline format, in your Klaviyo account. List of Events: - Bounced Email - Clicked Email - Dropped Email - Marked Email as Spam - Opened Email - Received Email - Subscribed to List - Unsubscribed - Unsubscribed from List - Updated Email Preferences - Custom Tracking
List	Full Load	Contains the details about users that have subscribed to a campaign.
List Exclusions	Full Load	Contains the details of the users that unsubscribed from a campaign. This list of unsubscribed users is created corresponding to each list in a campaign.
Metric	Full Load	Contains the details of metrics that are captured on Klaviyo. For example, Email Open and Website Visit.
Person	Full Load	Contains the details of the people associated with an event.

Additional Information

Read the detailed Hevo documentation for the following related topics:

Source Considerations

The Change Position option is possible only for the Event object. You can modify the date/time to a past value to re-load data since then.

Limitations

None.

Revision History

Refer to the following table for the list of key updates made to this page:

Date	Release	Description of Change
Mar-05-2024	2.21	Updated the ingestion frequency table in the Data Replication section.
Feb-20-2023	NA	Updated section, Configuring Klaviyo as a Source to update the information about historical sync duration.
Sep-21-2022	NA	Updated the screenshots in the page to reflect the latest Klaviyo logo.
Sep-07-2022	1.97	Updated section, Data Replication to add information about incremental data support for Campaign Recipient object.
Aug-24-2022	NA	Updated sections, Data Replication and Data Model to reorganize content for better understanding and coherence.
Apr-18-2022	NA	Updated the historical data point in the Data Replication section to correctly reflect how historical data is ingested for every object.
Oct-25-2021	NA	Added the Pipeline frequency information in the Data Replication section.
Jul-26-2021	NA	Added a note in the Overview section about Hevo providing a fully-managed Google BigQuery Destination for Pipelines created with this Source.