Listrak

Before You Begin

You must have admin permissions to access this integration in the integration manager. Contact your Listrak administrator or Listrak support if you need your permissions adjusted.

Create Export Destination

You will need to define an export definition before you can create export jobs.

Note Clario only supports SFTP and requires use of RSA keys for authentication. Please contact your Clario Customer Success representative if you need assistance with getting RSA keys in place.

Navigate to Manage → Integrations → New Integration → FTP

Field	Value
Name	Clario SFTP
Address	sftp.clar.io/toClario
Username	Will be provided by Customer Success
Password	Not applicable; RSA keys will be used

Email Activity Feed

Create Export Jobs

Configure a recurring export for each of the following sources:

• Subscribe Data

• Unsubscribe Data

• Email Activity (including send, open, click, bounce, and unsubscribe)

For each of the above sources we are targeting the main/master list. In the case of multiple brands, create export jobs for each brand’s main/master list.

New Export

• Navigate from the home menu to Manage.

• Select Integrations and click on New Integration.

• Select Data Export and click Setup Integration.

• Enter an integration name, where exportType is one of:

  • subscribe

  • unsubscribe

  • activity.

  Include a brand identifier if applicable clario_email_{exportType}_{brand}

• Click Save.

Source Selection

• Enter a File Name and a Date Format, where exportType is one of:

  • subscribe

  • unsubscribe

  • activity

• Include a brand identifier if applicable. Select the YYYYMMDDHHMMSS option for the date format.

Field	Value
File Name	clario_email_{exportType}_{brand}
Date Format	YYYYMMDDHHMMSS

• Select File Format .txt.

• Select Column Delimiter tab.

• Select Text Qualifier Double Quote.

• Export a compressed .zip file should be unchecked.

Data Configuration

• Select a Data Set that matches the exportType you defined in prior steps.

• Select the List from which to retrieve the data.

• See the field set table for the exportType you defined in prior steps. Ensure that the field selection and order matches exactly.

  • Subscribe Field Set

  • Unsubscribe Field Set

  • Activity Field Set

Configure Recurring Export

Please ensure that you have configured the source, data configuration and save before continuing to the next steps.

• Select Clario SFTP under Data Destination.

• Select Daily under Cadence.

• Click Activate Integration and confirm the activation when prompted.

Email Activity Feed Field Sets

Subscribe
EmailAddress
SubscribeDate
ResubscribeDate
EmailKey
ExternalContactID
UniversalEmailKey
SubscribeMethod

Unsubscribe
EmailAddress
UnsubscribeDate
ResubscribeDate
EmailKey
ExternalContactID
UniversalEmailKey
UnsubscribeMethod

Activity
EmailAddress
MessageID
MessageSubject
MessageSendDate
EventDate
EventType
EventData
ListrakAnalyticsCampaignName
GoogleAnalyticsCampaignName
GoogleAnalyticsCampaignContent
ExternalCampaignID
ExternalContactID

SMS Activity Feed

Create Export Jobs

Configure a recurring export for each of the following sources:

• Subscribe Data

• Unsubscribe Data

• Email Activity (including send, open, click, bounce, and unsubscribe)

For each of the above sources we are targeting the main/master list. In the case of multiple brands, create export jobs for each brand’s main/master list.

New Export

• Navigate from the home menu to Manage.

• Select Integrations and click on New Integration.

• Select Data Export and click Setup Integration.

• Enter an integration name, where exportType is one of:

  • subscribe

  • unsubscribe

  • activity.

  Include a brand identifier if applicable clario_sms_{exportType}_{brand}

• Click Save.

Source Selection

• Enter a File Name and a Date Format, where exportType is one of:

  • subscribe

  • unsubscribe

  • activity

• Include a brand identifier if applicable. Select the YYYYMMDDHHMMSS option for the date format.

Field	Value
File Name	clario_sms_{exportType}_{brand}
Date Format	YYYYMMDDHHMMSS