About the target cell spreadsheet

If your Campaign environment is integrated with Marketing Operations, you must use Marketing Operations to work with target cell spreadsheets. If your Campaign environment is configured to access legacy campaigns, use the instructions in this guide to work with target cell spreadsheets for legacy campaigns. For more information, see About integration with IBM Marketing Operations.

The target cell spreadsheet (TCS) is a spreadsheet-type feature for each campaign that displays all cells used in flowcharts within that campaign, and their details, including assigned offers. In addition to providing an accessible view of all cells as used in the campaign's flowcharts, it is a tool for cell-based offer assignment.

The target cell spreadsheet can be edited at any time, and writes values to the Campaign system tables when it is saved.

It can be used in two modes:

Top-down - you create all target and control cells in the target cell spreadsheet, then later link them to cells created in flowcharts using their cell codes. For cells created within the TCS, all fields except those that are "Used in Flowchart" can be edited in the TCS.

Bottom-up - each target cell that you create in a flowchart process is displayed in the TCS after you save the flowchart. For cells created from flowcharts, only the custom attributes can be edited in the TCS.

You can switch between the two modes at any time, although in general this will not be done often, because the top-down and bottom-up definition tasks are likely to be performed by different people.

You should put in place business rules that minimize the possibility of a target cell spreadsheet being edited when any of the flowcharts in the associated campaign are being edited or run. Incorrect data might be saved and conflicts can arise if edits are made to the flowchart and the TCS by different users at the same time, for example, if one user is editing contact processes from within a flowchart, while another user is changing offer assignments for the same cells from the TCS.

However, in some cases you will need to switch between modes. For example, if you are working in a flowchart and find that a target cell has not been defined in the TCS in top-down mode, you can save the flowchart, then switch to top-down mode (go to the TCS and create the cell there), then switch back to bottom-up mode (go back to the flowchart and link to the new cell in the TCS. The contact process then configures successfully).

Cells created in the TCS in top-down mode never are visually disabled (grayed out) if they are unused in bottom-up mode.

Cell status information in the target cell spreadsheet

Working with the target cell spreadsheet