Responsys

​

Overview

​

Responsys concepts

1. Profile lists table a. Profile Lists store recipient audience database records. Members of your audience might be leads, prospects, customers, contacts, consumers, or visitors, depending on your terminology. Marketers use Profile Lists and related objects (such as Profile Extension Tables and Filters) primarily for campaign targeting and personalization.
2. Profile Extension table a. Profile Extension Tables (PETs) allow you to store additional information for each unique recipient in your Profile List. Therefore a record in a PET must map to exactly one record in its parent Profile List table. Similar to data in Profile Lists, audience data in PETs can be used for segmentation and targeting in Filters as well as Programs.

​

Supported Identifiers

​

Prerequisites

1. Username a. This is the username of your Responsys account
2. Password a. This is the password your Responsys account
3. URL dropdown a. You can find your account’s endpoint by simply going to your Oracle Responsys login screen and looking at your url. i. For example : https://interact2.responsys.net ii. NOTE: You can find your account’s endpoint by simply going to your Oracle Responsys login screen and looking at your url.
   
4. Profile List name a. This is the name of the profile list where the data sent from Zeotap would be updated.
5. Profile Extension table name a. This is the name of the profile extension table where the data sent from Zeotap would be updated.
6. Folder name a. This is the name of the folder within Responsys where the data sent from Zeotap would be populated.

​

Create a destination

1

Log into the Zeotap CDP App and go to the DESTINATIONS application.

2

Click + Create Destination.

3

Under the All Destinations section, search for Responsys.

4

Click Responsys. A screen appears displaying details about the particular destination towards the left. On the right-hand side of the screen find a list of fields that are required for the integration to be established. Provide the required details as mentioned in the following steps:

• Enter a name for the Destination.
• In the Username field, provide the username of your Responsys account.
• In the Password field, provide the password of your Responsys account
• In the URL dropdown, select the URL of your Responsys instance.
• In the Profile List name field, enter the name of the profile list in Responsys where the data sent from Zeotap needs to be updated.
• In the Profile Extension table name field, enter the name of the profile extension table in Responsys where the data sent from Zeotap needs to be updated.
• In the Folder field, provide the folder path in your Responsys instance where the data sent from Zeotap CDP can be stored.
• Review all the values entered above and then click Next to proceed.

5

In the Actions and Mapping screen that appears, you can choose one of the following actions as per your requirement:

• Action name - Send data to Profile List
  • Under audience settings, the following fields needs to be filled :
    • Match Column 1
      • First match column for determining whether an insert or update should occur in Responsys.
    • Match Column 2
      • Second match column for determining whether an insert or update should occur in Responsys. (optional)
    • Insert On No Match
      • Indicates what should be done for records where a match is not found in Responsys (true = insert / false = no insert)
    • Update On Match
      • Controls how the existing record should be updated in Responsys (Values - Replace All, No Update)
      
      
• Action name - Send data to Profile Extension table
  • Under audience settings, the following fields needs to be filled :
    • Match Column
      • Match column for determining whether an insert or update should occur in Responsys.
    • Insert On No Match
      • Indicates what should be done for records where a match is not found in Responsys (true = insert / false = no insert)
    • Update On Match
      • Controls how the existing record should be updated in Responsys (Values - Replace All, No Update)
        
        

6

Based on the actions you choose, map the catalogue fields to the corresponding destinations fields. Ensure that you map the mandatory fields, otherwise destination will fail.

7

Click Create Destination. The created Destination gets listed in the Audiences application, which can be linked to an audience.

​

Link an audience to destination