Link tables overview

Important: Effective June 2024, Responsys will not support Classic Campaign functionality. After the effective date, Campaign Designer will be the only Responsys tool for creating and sending targeted and personalized campaigns. Learn more about the Campaign Designer.

The Link Table option allows you to track recipient clicks for a specified campaign.

  • To directly create a Link Table, click Actions on the side navigation bar, and select Create Link Table. (Not seeing this choice? Refer to the Side navigation bar changes topic.)

To create a Link Table via Campaign Dashboard:

  1. Click The Folders icon on the side navigation bar.
  2. Click your specified campaign name in the Contents section.
  3. Select Campaign Dashboard.
  4. Click the Link Table link.

Link Table Fields

Typically, link tables include the following fields.

  • Symbolic names of links (must be text fields).
  • Actual URL for each link.
  • Optional parameters to be passed to an external tracking process (if your account is set up with this feature).
  • Optional link category (if link categories have been defined for your account).

Notes

  • First two fields are required.
  • Subsequent fields are optional.
  • Symbolic name and the URL must be unique.

    Important: Duplicate names/URLs cause the misdirection of hyperlinks. With duplicates, only top link is used.

Creating Link Tables

You can create link tables using one of the following methods:

  • Automatically generate when creating a campaign.
  • Extract data from existing documents.
  • Generate from scratch and populate fields manually.
  • Upload a delimited text file.
  • Create link table data from existing supplemental data sources.

Creating Link Tables from Existing Documents

With this method you can build a link table from one or more existing HTML and/or plain-text documents. The link table is populated with the URLs. The corresponding text descriptions making up the hypertext links found in the documents becomes the name.

Extracting from Documents Example

Responsys (<a href="http://www.responsys.com" target="_blank">Responsys</a>)

  • Name – textlink_Responsys.

    Note: When image is used as the hyperlink (such as responsyslogo.gif): Name – imagelink_Responsyslogo.

  • URL – www.responsys.com.

Creating Link Tables from Scratch

Example 1 – One Campaign Builder

As the campaign builder, you are responsible for both managing the content as well as the data.

You can use the Oracle Responsys data source wizard to modify the link table as you require. Or you can download the link table to a delimited-text file, and use Microsoft Excel® for more advanced text manipulation.

Example 2 – Multiple Campaign Builders

You and one or more users are responsible for managing the content and the data as follows.

  1. Web Development Team – Builds landing page and provides link information.
  2. Campaign Creator – Responsible for campaign content. With links already known (via web developers) prior to creating the campaign document, the link table is pre-built and imported into Oracle Responsys.
  3. Campaign Developer – With the link table created, this developer may choose to take advantage of Oracle Responsys Built-in Functions (such as clickthrough(), urlencode(), etc.) to embed links into the document without having to retype actual links.

Characters Permitted in Link Tables

Only the following characters are allowed for link names added to a link table:

  • A-Z a-z 0-9

Learn more