Creating a Supplemental Table by Specifying Fields

A Supplemental Table stores relevant information for each record that can be drawn on for personalization of the campaign message or form document. One or more supplemental data sources can be combined with a distribution list using data extraction fields. Unlike a Profile Extension Table (PET), which stores aggregated data, a Supplemental Table holds unaggregated data. For example, John Doe performed multiple browses or made multiple purchases.

By default, Oracle Responsys allows 250 Supplemental Tables per account. Set an expiration date for Supplemental Tables that you only need temporarily.

To start creating your Supplemental Table:

  1. In the Navigation Pane, click Actions> Create View/Supplemental Table. (Not seeing this choice? Refer to the Side navigation bar changes topic.)
  2. Click Specify Fields.

Creating the table

To specify your table's fields:

  1. Enter the field names and set the corresponding types for your new table.

    Note: When entering field names, keep in mind that field names cannot contain the single letters A, E, G, K, M P, T and U (these letters are reserved by the application), must start with a letter, must not end with a trailing underscore (to avoid duplication of system fields), and should contain at least two characters. See Data Types and Field Name Requirements for more information.

  2. Click Next.

Defining the Primary Key

A primary key uniquely identifies a record in your table. If your supplemental table, for example, stores information on recipient purchases, a recipient's email address could be used as primary key to identify each purchase as belonging to that recipient. Or if, for example, your Supplemental Table stores a product catalog, the product SKU number or product ID could be used as the primary key to identify products.

To define the Primary Key:

  1. Select fields in the Available Fields list and use the right arrow to move them to the Primary Key Fields list. Use the left arrow to remove them from the list.

    Tip: When you create a supplemental table to be used for personalization, you must define a primary key constructed from columns in the table. This allows for more efficient loading and updating of the personalization data from the supplemental table into memory.

  2. Click Next.

Creating the data source

To create the data source:

  1. Select the folder where the Supplemental Table will be stored.

    Tip: Typically, you collect all the data sources for a campaign in a single folder, although this is not a requirement.

  2. Name your Supplemental Table using only the listed characters, or replace an existing Supplemental Table with your new one (only data sources in the selected folder are listed.).
  3. Choose an expiration date, or have your Supplemental Table never expire.

    Note: When creating a Supplemental Table, you can now set an expiration date. If you set an expiration date for a table, the default is 90 days unless you specify another date. By default, all tables never expire.

  4. Click Create.

You'll be redirected to the Select Key Fields page.

Selecting Key Fields

In Responsys, a data extraction key can be used either as a foreign key between a Supplemental Table and a campaign's or form's profile table (for personalization of the campaign or form), or as a match key used by a form submission's merge into a given Supplemental Table (for storing form submission data into a supplemental table).

To select key fields for data extraction:

  1. Select up to 4 data extraction fields.

    Tip: Hold Shift while selecting fields to select multiple fields for data extraction.

  2. Click Finish.

    You'll be redirected to Folders where you'll now be able to find your Supplemental Table. You'll still be able to modify your Supplemental Table from within in the Folders list.

Learn more