About Target Cell Spreadsheets

The Target Cell Spreadsheet is an editable grid that specifies the type of information users must enter to define the target and control cells for a particular campaign when Unica Marketing Operations-Unica Campaign integration is enabled. Each column on the TCS defines a particular item of information. Each column corresponds to an attribute.

A TCS contains default attributes that are automatically passed to Unica Campaign. In addition to these default attributes, you can create and add an unlimited number of additional custom attributes to the TCS.

Cell attributes and grid attributes

A TCS can contain both attributes that get passed to Unica Campaign (cell attributes) and attributes that display only in Unica Marketing Operations (grid attributes).

Use cell attributes for information you need to pass to Unica Campaign. For example, attribute values you want to include in an output list, contact history, or report need to be created as cell attributes.

Use grid attributes for descriptions, calculations, and data that is not needed in Unica Campaign.

Table Cell Spreadsheets and forms

You create a TCS on a form. (The form can contain other attributes in addition to the TCS.) When you place a TCS grid component on a form, it contains the default cell attributes. You can not delete the default attributes.

Transfer of cell attribute data

The information in the default attributes is passed automatically to Unica Campaign when a user links a flowchart cell to the TCS row. Custom cell attributes are available automatically in Unica Campaign as Unica Campaign Generated Fields in contact processes. For details on Unica Campaign Generated Fields, see the Unica Campaign User Guide.

Table Cell Spreadsheets and templates

A campaign project template can contain only one TCS.