Set up SFTP data transfer with 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.

You will learn

In this guide, you will learn how to set up your public SSH key in Klaviyo and use it to establish a connection to Klaviyo's SSH File Transfer Protocol (SFTP) server. Once connected, you'll be able to:

• Use Klaviyo's SFTP import tool to import event and profile data
  Transfer comma-separated files over SFTP to sync customer data via SFTP CSV ingestion.
• **Use Klaviyo's SFTP export tool to export event data
  Specify a range of events, time of day to run an export, and what cadence you'd like to export your latest event data at.

To use our import and export tools, you’ll first generate a public/private SSH key pair. Then, you’ll use your SFTP client to initiate an import/export.

SSH key generation

Before getting started, generate a public/private key pair on your local machine using ssh-keygen or a tool of your choice. Klaviyo uses Amazon Web Service’s Transfer Family service to provision its SFTP server and handle authentication. Transfer Family will accept the SSH key formats listed in its documentation.

Once you have generated your keys:

1. In Klaviyo, select Integrations from the side navigation.
2. On the Integrations page, click Manage Sources in the upper right, then select Import via SFTP.
3. Click Add a new SSH Key.
4. Paste your public key into the SSH Key box.
   
5. Click Add key.

Establish an SFTP connection

You can use FileZilla, Cyberduck or an SFTP client of your choice to connect to Klaviyo’s SFTP server at sftp.klaviyo.com following key creation. To establish a connection:

• Your public key must be added in the previous step for Klaviyo to properly authenticate.
• You must connect with a machine that has the private key at the location your client specifies.
• You must specify your username assigned by Klaviyo. Passwords can be left blank, as key validation is used instead of a password. To find your username, navigate to the SFTP setup tab (within SFTP Data Transfer), where you’ll find it under Username.

Your connection should be set up as follows:

• Server
  sftp.klaviyo.com
• Username
  Your_SFTP_Username (abc123_def456 in the example above)
• Port
  22
• Password
  empty
• SSH Private Key
  The private key associated with the public key generated in previous steps

In Cyberduck, your connection would look like this:

Next steps

Now that you're connected to Klaviyo's server, check out our SFTP import tool and SFTP export tool guides to learn how to import and export data into and out of Klaviyo.

Additional resources

• Bulk Import Profiles API
• Export data from Klaviyo