Editing a target cell spreadsheet
You edit a TCS® so that it contains target and control cells for the offers you intend to make.
For example, the TCS® for a direct mail campaign might include four rows: One for a 10% offer, one for 10% holdouts, one for a 20% offer, and one for 20% holdouts.
*
Never edit the attributes of cells in the target cell spreadsheet (TCS®) at the same time that any flowcharts in the associated campaign are being edited or run. Put business practices in place to ensure that users do not edit or run a flowchart at the same time as the TCS® is being edited.
1.
Open a campaign and click the Target Cells tab.
2.
Click the Edit icon Page with pencil icon.
The spreadsheet opens in Edit mode. Existing cells that are used in flowcharts are highlighted in color.
3.
Click the cell fields that you want to edit, and make your changes. Descriptions of the most common edits follow.
To
Do this
Add one row to the bottom of the spreadsheet.
Click the Add a Cell icon Page with small plus sign icon.
Add several rows to the bottom of the spreadsheet.
a.
Click the Add Many Cells icon Page with italic capital N and small plus sign with menu arrow icon.
b.
Select N empty rows and enter the number of rows to add.
c.
Click Create Target Cells.
Duplicate one or more rows.
a.
Select at least one row.
b.
Click the Add Many Cells icon Page with italic capital N and small plus sign with menu arrow icon and select N duplicate rows.
c.
Enter the number of rows to add.
d.
Click Create Target Cells.
The new rows are added below the selected row, with the cell code and cell name already populated. All other column values except Used in Flowchart are copied from the selected row.
Search the TCS®
a.
Enter a search string in the Find window.
You can enter a partial string to find matches in any column of the spreadsheet. For example, "924" finds a row that contains cell code "A0000000924" and also finds a row with "Offer9242013" assigned.
b.
Click Find String.
The row that contains the first match is highlighted.
c.
Click Find Next to continue searching.
Paste data from an external source
a.
Copy content from another application.
b.
Click a cell in the TCS® to make it editable.
c.
Use the right-click menu to Paste.
Import target cell data from a .csv file
a.
Obtain a comma-separated values file in the required format. See Import and export format for TCS data.
b.
Click the Import Target Cells icon Piece of paper with disk and arrow that points away from the paper icon.
c.
In the Import TCS dialog, click Browse to locate the .CSV file that you want to import, select the file, and click Open.
d.
Click Import.
The contents of the .CSV file is appended below any existing cells in the TCS®.
Move rows up or down, or delete rows
Use the toolbar icons Three icons of a table with a highlighted row, one with arrow that points up, one with arrow that points down, and one with a red "X".
4.
Click Save or Save and Return.
The flowchart designer can now create processes to select IDs that meet the 10% and 20% offer and hold-out criteria. To link the data manipulation process output to a cell in the TCS®, the flowchart designer selects Link to Target Cell in the process configuration dialog box.
Copyright IBM Corporation 2015. All Rights Reserved.