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

  1. Before you set up an export ensure you have at least one FTP destination (Navigate to: Manage > Integrations > New Integration > FTP)

  2. Navigate from the home menu to Manage.

  3. Go to Integrations.

  4. Click New Integration.

  5. Select Data Export.

  6. Click Setup Integration.

  7. Enter an Integration Name

  8. Click Save.

SOURCE SELECTION

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).
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)

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

DATA CONFIGURATION

1. Select a Data Set (subscribe or unsubscribe data, email activity).
2. Select a List from which to retrieve the data.
3. Add and select the applicable profile fields or email events to export.

💡 Rename your fields using the header column to names that match the conventions in your system.

CONFIGURE RECURRING EXPORT

Please be sure to have set up the source, data configuration, and save before continuing to the next steps.

1. Select a Data Destination.
2. This export is delivered on a daily cadence.

If you've configured all of the above settings for the export and are ready to begin receiving the export on a daily cadence, click Activate Integration.

💡 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

  2. Edit the integration.

  3. Navigate to the recurring export.

  4. Click Deactivate Integration.

DELETE THE EXPORT

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?