Export event data with SFTP
Learn how to use your SFTP client and Klaviyo’s SFTP export tool to download event data from Klaviyo.
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.
-
Toggle to turn On scheduled exports.
-
Select an export cadence to determine how often the export should process, e.g., every hour or every day.
-
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.
-
Select the output format. Exports use CSV format by default, but also support JSON format.
-
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.
-
Click Create export
-
Select a date range for the export. The default date range is the last 30 days.
-
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.
-
Select the output format. Exports use CSV format by default, but also support JSON format.
-
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
, orcomplete
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
Updated 2 days ago