Export data from Klaviyo

Data objects

When understanding how to export data from Klaviyo and sync it into another system, it helps to first understand Klaviyo’s data model (i.e., what data Klaviyo collects and how it’s organized). 

Metrics, as the key data object representing a given person’s activity and engagement with your brand and messaging, are the most commonly requested data objects to export from Klaviyo. Metrics are actions represented as timestamped records that include JSON-formatted payloads that can contain an unlimited quantity of key-value pairs, including arrays and further-nested JSON. Klaviyo automatically records Metrics for email, push, and SMS-related activity such as "Received Email", "Opened Email", "Clicked Email", and more. Some other common objects that may be exported include Profiles, Lists, and Unsubscribes.

Exporting data

You can find a complete list of our available APIs for exporting Klaviyo data on our API docs. Here are some of our more frequently used export APIs:

• Get Metrics
  Returns a list of all the metrics in your account.

• Get Events
  Returns a batched timeline of all events in your account.

• Get Events and filter by metric_id
  Returns a batched timeline for one specific metric.

• Query Metric Aggregates
  Exports aggregate counts of event data from Klaviyo, optionally filtering and segmenting on available event properties.

• Get Profile
  Retrieves all the profile properties for a profile, using the profile_id. Can also request specific fields using sparse field-sets.

• Get Profile’s Events for All Metrics
  Returns a batched timeline of all events for a person when you pass in the profile_id as a filter.

• Get Profile’s Events for a Specific Metric
  Returns a batched timeline of all events for one specific Metric for a given person when you pass the profile_id and metric_id as filters.

• Get Lists
  Returns a listing of all of the lists in an account.

• Get List Info
  Returns information about a list.

• Get List Members
  Gets all profiles in a given list.

• Get Segment Members
  Gets all profiles in a given segment.

• Get Campaigns
  Returns a list of all the campaigns you've created.

• Get Campaign Info
  Returns summary information for the campaign specified.

• Get Campaign Recipient Estimation
  Returns summary information about email recipients for the campaign specified.

• Get All Templates
  Returns a list of all the email templates you've created.

Example: how to export data

Klaviyo exposes data for export through REST APIs associated with these data objects. You can use these to extract information, optionally using parameters to refine the information returned. As an example, a simple curl request to retrieve a list of each unique metric observed in the account via the Klaviyo Metrics API would look like this:

curl --location 'https://a.klaviyo.com/api/metrics/' \
--header 'revision: {latest revision header}' \
--header 'Accept: application/json' \
--header 'Authorization: Klaviyo-API-Key your-private-api-key'

The GET call returns a JSON object with all the fields of the specified dataset as a reply. In this illustrative example, the account has three unique metrics. The resulting JSON would look like:

{
    "data": [
        {
            "type": "metric",
            "id": "KxhW33",
            "attributes": {
                "name": "Clicked Email",
                "created": "2020-01-28T13:33:15+00:00",
                "updated": "2020-01-28T13:33:15+00:00",
                "integration": {
                    "object": "integration",
                    "id": "0rG4eQ",
                    "name": "Klaviyo",
                    "category": "Internal"
                }
            },
            "links": {
                "self": "https://a.klaviyo.com/api/metrics/KxhW33/"
            }
        },
        {
            "type": "metric",
            "id": "JUzjai",
            "attributes": {
                "name": "Added to Cart",
                "created": "2020-01-29T13:19:30+00:00",
                "updated": "2021-08-27T08:41:10+00:00",
                "integration": {
                    "object": "integration",
                    "id": "7FtS4J",
                    "name": "API",
                    "category": "API"
                }
            },
            "links": {
                "self": "https://a.klaviyo.com/api/metrics/JUzjai/"
            }
        },
        {
            "type": "metric",
            "id": "XNJ6uB",
            "attributes": {
                "name": "Placed Order",
                "created": "2023-04-19T03:01:44+00:00",
                "updated": "2023-04-19T03:01:44+00:00",
                "integration": {
                    "object": "integration",
                    "id": "7FtS4J",
                    "name": "Shopify",
                    "category": "eCommerce"
                }
            },
            "links": {
                "self": "https://a.klaviyo.com/api/metrics/XNJ6uB/"
            }
        }
      ]

Use case: integrating Klaviyo with a data warehouse

If you’d like to extract data from Klaviyo to a data warehouse or internal system, the general integration process is as follows:

Additional resources

• Use data in Klaviyo
• Custom integration FAQs