Recurring Data Exports are a great resource for utilizing data collected in Listrak in other systems or reporting tools. Listrak's Recurring Data Export allows you to configure a daily export of data for your email program or SMS program. This provides an extension of the email-only export to new channels and additional data.
Learn more about the process of setting up an export for:
🔑 Important Notes
Exported reports are processed early in the morning and will include data from the previous calendar day.
You must have admin permissions in order to access the integration manager and configure an export.
The recurring export supports FTP and SFTP protocols. Learn more about each protocol here.
Before you set up an export ensure you have at least one FTP destination (Navigate to: Integrations > Integration Management > New Integration > FTP)
You can only create an export for the channels enabled in your account.
Creating an Email Recurring Export
Once the FTP destination for your file has been created, follow the steps below to configure an email recurring export.
Navigate to Integrations > Integrations Management.
Click New Integration.
Click Import on the card for Recurring Data Export.
Click Setup Integration on the main screen.
Select the Email option.
Enter an Integration Name in the General section.
File Configuration
Give your file a name.
In the append dropdown, select the date format option
Select your file format from either .txt or .csv
Next, select your Column Delimiter from Comma, Pipe, Tab, or Tilde.
💡 CSV files will automatically select Comma.
Then, select a Text Delimiter from None, Single Quote, or Double Quote.
Select a Data Destination from your previously configured FTP integration.
If desired, select the zip checkbox to export your data in this format.
💡 This may already be pre-selected based on the configuration of the FTP you selected.
Enter your Public Key for PGP encryption. When entering the PGP Public Key, be sure to paste the full key, including the beginning/ending text and versioning.
💡 This is required for FTP integrations, but recommended for SFTP as well.
The daily cadence will already be selected.
Data Configuration
Select from the following Data Sets:
Subscribe Data: Export list-specific data about contact's subscribe date, method, resubscribe date, and any profile fields on the list.
Unsubscribe Data: Export list-specific data about a contact's unsubscribe date, method, resubscribe date, and more.
Email Activity: Export list-specific data on email activities including sends, opens, clicks, and unsubscribes. You can also layer in system fields including Listrak and Google Analytics values.
Email Aggregation: Export list-specific data about the number of messages sent, lifetime engagement metrics, and first and last email engagement dates.
Select the specific email list where data should be gathered.
Select any profile fields that should be included in the export based on the types of data available for each data set.
⚠️ At least one field must be added to the export. Click Add Field to add additional fields to the export.
Click Save to update the properties or Activate to start the recurring export.
Creating an SMS Recurring Export
Once the FTP destination for your file has been created, follow the steps below to configure a SMS recurring export.
Navigate to Integrations > Integrations Management.
Click New Integration.
Click Import on the card for Recurring Data Export.
Click Setup Integration on the main screen.
Select the SMS option.
Enter an Integration Name in the General section.
File Configuration
Give your file a name.
In the append dropdown, you can select none or date to append the date of the export to each file name to easily identify different files.
Select your file format from either .txt or .csv
Next, select your Column Delimiter from Comma, Pipe, Tab, or Tilde.
💡 CSV files will automatically select Comma.
Then, select a Text Delimiter from None, Single Quote, or Double Quote.
Select a Data Destination from your previously configured FTP integration.
If desired, select the zip checkbox to export your data in this format.
💡 This may already be pre-selected based on the configuration of the FTP you selected.
Enter your Public Key for PGP encryption.When entering the PGP Public Key, be sure to paste the full key, including the beginning/ending text and versioning.
💡 This is required for FTP integrations, but recommended for SFTP as well
The daily cadence will already be selected.
Data Configuration
Select from the following Data Sets:
Opt-In: For a list on a specific sender code you can export the SMS system fields, custom fields, SMS engagement data, and sender code and list properties.
Opt-out: For a specific sender code you can export opt-out date, SMS system and custom fields, and SMS engagement data.
Activity: For a list on a specific sender code you can export data on sends, clicks, and conversions. You can also include SMS system field data and campaign- specific data such as Campaign Name and Campaign Content.
Select the specific SMS Sender Code.
If using the opt-in or activity data set, select the specific SMS list where data should be gathered.
💡 Lists will be separated into the marketing and transactional list types.
Select any profile fields that should be included in the export based on the types of data available for each data set. When the activity type is selected you will also see SMS events prechecked, but can be adjusted based on the goal of your export.
⚠️ At least one field must be added to the export. Click Add Field to add additional fields to the export.
Click Save to update the properties or Activate to start the recurring export.
Creating an App Push Recurring Export
Once the FTP destination for your file has been created, follow the steps below to configure a SMS recurring export.
Navigate to Integrations > Integrations Management.
Click New Integration.
Click Import on the card for Recurring Data Export.
Click Setup Integration on the main screen.
Select the App Push option.
Enter an Integration Name in the General section.
File Configuration
Give your file a name.
In the append dropdown, you can select none or date to append the date of the export to each file name to easily identify different files.
Select your file format from either .txt or .csv
Next, select your Column Delimiter from Comma, Pipe, Tab, or Tilde.
💡 CSV files will automatically select Comma.
Then, select a Text Delimiter from None, Single Quote, or Double Quote.
Select a Data Destination from your previously configured FTP integration.
If desired, select the zip checkbox to export your data in this format.
💡 This may already be pre-selected based on the configuration of the FTP you selected.
Enter your Public Key for PGP encryption.When entering the PGP Public Key, be sure to paste the full key, including the beginning/ending text and versioning.
💡 This is required for FTP integrations, but recommended for SFTP as well
The daily cadence will already be selected.
Data Configuration
Select from the following Data Sets:
Subscriber: For a selected merchant, export details on a contact who has opted-in to App Push (e.g. Mobile App Version and Subscribe Date).
Unsubscriber: For a selected merchant, export details on a contact who has opted-in to App Push (e.g. Mobile App Version and Unsubscribe Date).
Activity: For a selected merchant, export details on sends, clicks, and specific message properties (e.g. Message Name, AndriodLink, or iOSLink).
Select the specific merchant.
Select any profile fields that should be included in the export based on the types of data available for each data set. When the activity type is selected you will also see events prechecked, but can be adjusted based on the goal of your export.
⚠️ At least one field must be added to the export. Click Add Field to add additional fields to the export.
Click Save to update the properties or Activate to start the recurring export.
Editing and Deleting an Export
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.
Navigate to the integration in Integrations > Integrations Management.
Click on the name to edit the integration.
Navigate to the setup tab.
Click Deactivate Integration.
Delete the Integration
After the export has been deactivated, you may delete the integration.