Listrak's Data Export tool allows you to easily export delimited subscriber and email activity data to your FTP or Listrak's FTP.

Exported reports are processed early in the morning and will include data from the previous calendar day.

Subscriber data includes: email address, email key, subscription action (subscribed/unsubscribed), subscribed or unsubscribed data, and profile fields. Email activity includes: send, open, click, bounce, and unsubscribe data. You can also export data such as a contacts universal email key and external campaign IDs if these are configured for your messages.

Listrak's supported protocols include: FTP, SFTP, and FTPS. Learn more about each protocol here.

Begin automating your data export by following the steps below:

⚠️ You must have admin permissions to access this integration in the integration manager

New Export

⚠️ Before you set up an export ensure you have at least one FTP destination (Navigate to: Integrations > Integration Management > New Integration > FTP)

  1. Navigate to Integrations > Integrations Management.

  2. Click New Integration.

  3. Select Data Export.

  4. Click Setup Integration on the main screen.

  5. Enter an Integration Name in the General section.

  6. Click Save.

Source Selection

In this section you will specify the name and format of your export.

  1. Enter a File Name and a Date Format

    💡 Select the YYYYMMDDHHMMSS option for the date format

  2. Select a File Format from the drop-down menu (.txt or .csv).

  3. Select a Column Delimiter (comma, pipe, tab, or tilde).

    💡 The Comma will automatically be chosen if using the .csv file format

  4. Select a Text Qualifier (single quote, double quote, or none).

  5. Optional: Compress your file in a .zip file.

  6. Enter your Public Key for PGP encryption. (required for FTP and FTPS

  7. ⚠️ When entering the PGP Public Key, be sure to paste the full key, including the beginning/ending text and versioning.

Data Configuration

This section specifies what type of data will be included in the export. There are three categories of data: data on current subscribers, data on current unsubscribers, and email activity.

  1. Select a Data Set (subscribe or unsubscribe data, email activity).

  2. Select a List from which to retrieve the data.

  3. Add any profile fields or email events that should be included as part of the export. Profile fields will be available for the subscriber or unsubscriber data type and will populate the report with the values in a contact's profile fields. Email events are available for the email activity data type and include activities such as bounces and clicks.

    💡 If desired you can rename the headers in column two to match the naming convention in your systems if the prepopulated values do not match.

  4. Click Update once you have added all your configurations.

Configure Recurring Export

⚠️ Make sure you have configured the steps above and clicked Update prior to following these steps.

  1. Select a Data Destination. In this drop-down any previously configured FTP should be listed.

  2. This export is delivered on a daily cadence.

  3. Do one final confirmation of your settings and click Activate Integration.

  4. Confirm the activation in the popup.

💡 The first export will be available 24 hours after initial set-up is configured and will include the data from the previous calendar day

Save the Export

After you've configured the export and set a cadence, click Update. This integration is accessible anytime through the Listrak Marketplace. 

Deactivate the Export

If you no longer want to receive this export, you may pause or deactivate the export. You must deactivate an export before deleting it.

  1. Navigate to the integration in Integrations > Integrations Management.

  2. Click on the name to edit the integration.

  3. Navigate to the setup tab.

  4. Click Deactivate Integration.

Delete the Integration

After the export has been deactivated, you may delete the integration. 

Interested in learning more about Data Export? Check out our video for more information:

Did this answer your question?