Target cell spreadsheets
A Target Cell Spreadsheet (TCS®) is an editable grid component that has a set of predefined attributes. You use Target Cell Spreadsheets when IBM® Marketing Operations-Campaign integration is enabled.
The TCS® specifies the data that users must enter in a campaign project to define the target and control cells for the campaign. Each column on the TCS® corresponds to an attribute. Values for the predefined, or default, attributes are automatically passed to Campaign. In addition to these default attributes, you can add an unlimited number of custom attributes to a TCS®.
Cell attributes and grid attributes
A TCS® can contain attributes that get passed to IBM® Campaign (cell attributes) and attributes that display only in IBM® Marketing Operations (grid attributes).
Use cell attributes for information you want to pass to Campaign. For example, attribute values you want to include in an output list, contact history, or report must be created as cell attributes.
Use grid attributes for descriptions, calculations, and data that is not needed in Campaign.
Target Cell Spreadsheets and forms
You add a TCS® to a form by creating a new editable grid and identifying it as a TCS®. (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 cannot delete the default attributes.
Transfer of cell attribute data
When a user links a flowchart cell to the TCS® row, the data values supplied for the default attributes are passed to Campaign automatically. Custom cell attributes are available automatically in Campaign as IBM® Campaign Generated fields in contact processes. For details on Generated fields, see the IBM® Campaign User's Guide.
Target Cell Spreadsheets and templates
Each campaign project template can contain only one TCS®.