Export event data with SFTP

Before you begin

This feature is only available to Klaviyo users with an Owner, Admin, or Manager role. Learn more about Klaviyo user roles.

To export event data via SFTP you must first enable it for your account by following the steps to set up SFTP data transfer.

You will learn

In this guide we'll cover how to export event data from Klaviyo using the SFTP export tool, how to schedule a recurring export, and take a look at the output data.

Initiate SFTP export

From SFTP data transfer, navigate to the Data export tab.

📘

The amount of time an export takes to process may vary depending on the quantity of event data in your account. Exporting all event data can result in long processing times.

Scheduled export

Data can be exported via SFTP at regular intervals.

1. Toggle to turn On scheduled exports.

2. Select an export cadence to determine how often the export should process, e.g., every hour or every day.

3. Choose the Events data object. From the dropdown, place a check next to all defined events that you would like to include in this export, or include all event data in your account by checking All Events.

4. Select the output format. Exports use CSV format by default, but also support JSON format.

5. Click Save.

If you need to make changes to these settings later, click the Change settings button to modify the cadence and data objects.

Historical export

Data can also be exported on a one-off basis using the historical export.

1. Click Create export

2. Select a date range for the export. The default date range is the last 30 days.

3. Choose the Events data object. From the dropdown, place a check next to all defined events that you would like to include in this export, or include all event data in your account by checking All Events.

4. Select the output format. Exports use CSV format by default, but also support JSON format.

5. Click Save.

Review exports

All requested exports appear in the table below Historical Export. For each export, you will be able to see:

• Requested on: the date the report was requested.
• Data objects: which data objects were included, such as Events.
• Date range: the date range used, such as Last 365 days.
• Requested by: the email address of the logged-in user on your account who submitted the request.
• Status: the current status of the export. The Status column shows the processing, failed, canceled, or complete exports.

Click the carrot next to each line to open up additional Event details about the export, including which data objects were specifically included.

Exports contain the following data about your events:

• id
  The ID of the event object.

• metric_id
  The ID of the corresponding metric.

• profile_id
  The ID of the associated profile.

• event_properties
  JSON containing all of the event's properties, such as name and subject line.

• datetime
  The timestamp of when the event was recorded.

• uuid
  The unique user ID associated with the event.

🚧

Note that the CSVs generated with the SFTP export tool cannot be reuploaded to Klaviyo without modification to the data formatting. For more information about how to import data to Klaviyo and how to format your imports, check out how to import profile and event data with SFTP.

Additional resources

• Bulk Import Profiles API
• Export data from Klaviyo