ESP - Responsys¶

Prerequisites¶

See Email before integrating CDP with Responsys.

Input data¶

CDP pulls the following information from your application:

• Full master contact list with the latest main subscription status
• Send/open/click/bounce/subscription/unsubscription events
  • Daily: yes
  • Historical load: Responsys only sends the last 14 days of events. Therefore, the email event history is built mostly based on the daily loads. Machine learning models relying on email engagement can only be turned on after two or three months of email pull. This ensures that there is enough data.

Output data¶

You can leverage CDP to push audience and content data to Responsys supplemental tables.

To push data from CDP to the Responsys ESP:

1. Sign in to the CDP user interface.

2. Click Actions > Campaigns+ > New Campaign.

3. Specify all the required information. For more information, see Campaigns+.

4. In Destination, select either of the following ways:

   • Use Acquia API Connector with a standard or custom destination table containing the list of fields that you want to send to Responsys. The Responsys application creates supplemental tables. You must ensure that you maintain all of your Acquia supplemental tables in the designated Acquia folder.

     

   • Send your flat CSV file to the Responsys SFTP server. Ensure that you schedule your import automation to process the CSV file to your PET or supplemental table.

     

CDP can push to different supplemental tables. Note that CDP does not have any limitation on creating or pushing data to any masters supplemental tables. For example, if you want to create a Store Locator campaign, the audience data is pushed to the Acquia_Master_Audience supplemental table. However, for an abandoned cart campaign, the data is sent to the Acquia_AbandonedCart supplemental table. Similarly, for a browse campaign, the data is sent to the Acquia_AbandonedBrowse supplemental table.

To identify a specific audience sent from CDP, you can leverage the Campaign_ID field. Campaign_ID is the unique identifier that CDP generates while creating the campaign. You can leverage the value in this field to distinguish between campaigns when you export multiple campaigns to the same table.

Ensure that all supplemental tables where you want to push CDP data are preconfigured. For preconfiguration, contact Acquia Support.

Setup¶

• Provide CDP with a Responsys admin account.
• Provide access to the Responsys File Server and the corresponding SSH private key. Do not use a password-protected private key.
• Provide CDP with an API user and the endpoint URL.
• Ensure that no existing Connector Job is scheduled to extract the key Responsys Events Sent / Clicked / Opened / Opted-In / Launch State.