Klaviyo source for ELT & CDC


Description	Klaviyo, an ecommerce marketing automation platform for email marketing and sms syncs your tech stack with your website store to scale your business.
Supported Replication	Initial Sync, Continuous Sync
Authentication Type	API token

Collections

Collection Name	Full/Initial Sync	Incremental/Continuous Sync	Supports Update	Supports Delete	Notes
metrics https://developers.klaviyo.com/en/reference/get-metrics	✔	✖	✔	✖	•
events https://developers.klaviyo.com/en/reference/metric-timeline	✔	✔	✖	✖
profiles https://developers.klaviyo.com/en/reference/get-global-exclusions	✔	✔	✔	✖
lists https://developers.klaviyo.com/en/reference/get-lists	✔	✔	⚠️ (API doesn’t send the updated records correctly when updating through `Edit List Name`)	✖
list_tags https://developers.klaviyo.com/en/reference/get-list-info	✔	✖	✖	✖	Dependent on `lists`
list_members https://developers.klaviyo.com/en/reference/get-members	✔	✔	✖	✖	Dependent on `lists`
email_campaigns https://developers.klaviyo.com/en/reference/get-campaigns	✔	✔	⚠️ (API doesn’t send the updated records correctly)	✖
email_campaign_messages https://developers.klaviyo.com/en/reference/get-campaigns	✔	✖	✖	✖	Dependent on `email_campaigns`
email_campaign_tags https://developers.klaviyo.com/en/reference/get_campaign_tags	✔	✖	✖	✖	Dependent on `email_campaigns`
sms_campaigns https://developers.klaviyo.com/en/reference/get-campaigns	✔	✔	⚠️ (API doesn’t send the updated records correctly)	✖
sms_campaign_messages https://developers.klaviyo.com/en/reference/get-campaigns	✔	✖	✖	✖	Dependent on `sms_campaigns`
sms_campaign_tags https://developers.klaviyo.com/en/reference/get_campaign_tags	✔	✖	✖	✖	Dependent on `sms_campaigns`
templates https://developers.klaviyo.com/en/reference/get-templates	✔	✔	✔	✖

Setting up Klaviyo for ELT & CDC

ELT & CDC uses the Metric API provided by Klaviyo to sync the data. Klaviyo API reference

Requirements

You need permissions to create Private API Keys.

Create API Token

Follow these steps to create a private API key.

Go to https://www.klaviyo.com/settings/account/api-keys

Click the Create Private API Key button

Klaviyo Create Private API Key button on API keys page

Set a name for the API Key and select the”Read-Only Key” option. Click the “Create” button.

Klaviyo API key name and Read-Only Key scope selection

On the Private API Key Confirmation page, copy the API key and paste it into the input field below.

Klaviyo Private API Key confirmation page with key to copy

Integrate.io dashboard field for pasting the Klaviyo API key

Getting Started

Pipelines

Sources

Destinations

Monitoring

Security

Transforms

Data Observability

Klaviyo source for ELT & CDC

Collections

Setting up Klaviyo for ELT & CDC

Requirements

Create API Token

​Collections

​Setting up Klaviyo for ELT & CDC

​Requirements

​Create API Token

Collections

Setting up Klaviyo for ELT & CDC

Requirements

Create API Token