Skip to main content

Import via file transfer

Using our data management platform, Rokt can receive custom audience data at any frequency you prefer. If you’re working with Rokt as an advertiser, these lists can be used in your campaigns to either target or suppress certain customers from seeing your offers. If you’re working with Rokt as a partner these lists can be used to determine what customers see the Rokt experience on your site.

One method of delivering custom audience data to Rokt is the Rokt-hosted SFTP.

Connecting to the Rokt SFTP#

Establishing a connection from a host computer (e.g., your laptop) to a secure FTP server requires third-party client software. This tutorial suggests the popular and free client FileZilla which is available for Windows, Mac, and Linux operating systems.

  1. In your browser, navigate to https://filezilla-project.org/ and click Download FileZilla Client.
  2. Install FileZilla on your computer. If you already have FileZilla installed, ensure you are running the latest version.
  3. You should have received an email from Rokt with the subject "You've been granted access to Rokt's SFTP server."
  4. Download the attached file and unzip the encrypted file using the password provided in a second email "Email for password for file with instructions."
  5. The encrypted file you have just unzipped contains a .pem file which is your key file to access Rokt's SFTP folder.

The following steps are the same for Windows, Mac, and Linux operating systems and are based on the latest version of FileZilla.

  1. Open FileZilla and navigate to File > Site Manager

Rokt SFTP Setup

  1. On the left, click New Site and fill in the following:
  • Protocol: SFTP – SSH File Transfer Protocol

  • Host: ftp.rokt.com

  • Port: 22

  • Key file: Browse to your local key file (.pem) and select it from your local drive (see image below).

    Rokt SFTP Setup

  1. Click Connect. You should be connected and able see your accessible folders to upload files.

File path and requirements#

For the majority of integrations, custom audience files should be placed within the following file path:

File path using a default listPurpose
/upload/custom-audience/include/AdvertiserDatabaseAdd a list of customers into the default AdvertiserDatabase file associated with your account.
/upload/custom-audience/exclude/AdvertiserDatabaseRemove a list of customers from the default AdvertiserDatabase file associated with your account.

If you need to upload and maintain several different custom audience lists within a single account (for example, you might have one list for customers you’d like to use in campaign targeting, and a separate list for customers you’d like to suppress from seeing your campaigns), you can create a specific custom audience list as follows:

File path using a specific listPurpose
/upload/custom-audience/include/MyListAdd a list of customers into a non-default custom audience list named MyList.

MyList is a sub-folder you would create within the include folder as shown in the file path.
/upload/custom-audience/exclude/MyListRemove a list of customers from a non-default custom audience list named MyList.

MyList is a sub-folder you would create within the exclude folder as shown in the file path.

Note: Custom audience files are automatically deleted from this folder as soon as they are processed by Rokt.

Required file formats#

Files uploaded to the SFTP server must meet the following standards in order to be processed correctly in the Rokt data platform.

  • File format must be .csv or .txt
  • Charset UTF-8 (UTF-16 or UTF-32 with an appropriate byte-order mark)
  • The list of email addresses must be formatted:
    • In a single column
    • Without a column head
  • Email addresses can be either plain text or hashed
  • If hashing email addresses, please ensure that they:
    • Use MD5 or SHA256 hash algorithms
    • Are lowercase and trimmed (white-space removed) before hashing takes place
    • Are all hashed in the same format—do not mix plain and hashed email addresses per file (emails must be all plain, all MD5, or all SHA256)

Any file not matching the above format will be rejected by Rokt’s system.

Was this article helpful?