Acquia CDP


Responsys helps brands to manage their digital relationships across multiple channels such as email, mobile, and web.


Before integrating Customer Data Platform (CDP) with Responsys, see File Layouts for SMS

Input data

CDP pulls the following upstream information from your Responsys SFTP server:

  • Full master contact list with the latest main subscription status

  • Send, open, click, bounce, subscription, and 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

CDP pushes the SMS daily event file to the Responsys application. This is the downstream data.

To push data from CDP to the Responsys:

  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.

Sample of Acquia standard SMS destination table:


The following are the requirements of the setup:

  • Provide CDP with a Responsys admin account.

  • Provide CDP with Responsys SFTP credentials. This ensures that CDP can leverage automated workflows to consume the SMS daily event file.

Extracting data

You can extract daily or historical event data through the Responsys Job Type:

  1. Set up a Job type SMS automation.

    • In Job Type set up 1:

      • The Responsys SFTP server pushes the file. CDP fetches the file and consumes it.

      • You must select the System table to extract to CDP.

    • In Job Type set up 2:

      • Select separated Pipe delimiter.

    • In Job Type set up 3:

      • Schedule the process on a daily basis.