The data export integration within Listrak offers individual nightly (~1 AM EST) flat file exports to your external SFTP endpoints so that you may collect ongoing contact activity updates. These exports are list centric and can provide sub and unsub activity as well as email and sms engagement activity. This can be helpful in keeping parity or collecting and storing updates for benchmarking or other purposes. Each export type, the configuration, and the data contained within are all explained below in detail.duction
Channel Data Configuration Examples
Click the channel to learn more about the specific configurations
These details outline how you may configure your flat file export, how it is delimited, format, qualifiers, etc.
Pretty Good Privacy (PGP) is an encryption program that provides cryptographic privacy and authentication for data communication. It uses a combination of hashing, data compression, symmetric-key cryptography, and public-key cryptography to secure data
How PGP Encryption is Used in Data Export
When exporting data via FTP to either a Listrak or external FTP host, PGP encryption ensures that the data remains secure both in transit and at rest, as PGP encryption is applied to the file. Here’s how it works in this context:
The public key and versioning should be in openssh format.
Listrak’s Recurring Data Export does support the delivery of files to a specific folder using an external FTP integration. However, External FTP hosts are managed by entities outside of Listrak. As such, the host’s networking configuration, user authentication & security, and FTP server applications may impact export performance. It is recommended to activate the data export in a strategic testing phase to verify that the file can be exported by Listrak successfully.
When configuring an External FTP integration, the user can “test connection” to ensure successful connectivity from the Listrak platform. This test is a network connectivity test - not an actual file transfer via (s)ftp. Due to this, the test connection feature may produce an error, though the Data Export service may still be able to connect successfully during file transfer. To confirm connection and data export performance, coordinate with the host to test file transfer by activating a data export.
Marketing teams often need to sync subscription events and statuses for contacts with systems outside of Listrak. Recurring Data Export integrations can be used to export these opt-in and opt-out events, propagating up-to-date subscription statuses in platforms outside of Listrak.
Listrak offers an activity stream export for both the SMS and Email channels - detailing opt ins and opt outs for each channel respectively. There are four exports types in total: Email Subscribe Data, Email Unsubscribe Data, SMS Opted In, SMS Opted Out Internal Do Not Call
Each of the linked exports will include all the related subscribe or unsubscribe events for the specific channel and list, for the relative yesterday 24 hour period. Once extracted from the specified FTP location in each data export’s configuration settings, marketing teams can push these files to external systems updating the opt-in status for the matching SMS or Email record.
The Message Activity data exports provide Listrak customers the ability to inform external platforms' contact performance tracking by digesting message activity. Each row in a message activity export represents one unique activity performed by a contact. The report is channel, list, and contact specific.
For example, conversion spend can be tracked by consuming message activity event_type:conversion and message activity conversion event_data. New conversion event data values can be aggregated, providing a conversion spend output for the contact.
Similar to contact analytics, each row in a message presents a unique activity selected in the recurring data export configuration. A total event count per message (based on message ID) be determined and then added to by future recurring data exports.
Click the channel to learn more about the specific configurations
.png){kind=icon}
