Editing a target cell spreadsheet

You edit a target cell spreadsheet so that it contains target and control cells for the offers you intend to make.

About this task

For example, the target cell spreadsheet 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.

Important: Never edit the attributes of cells in the target cell spreadsheetat 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 target cell spreadsheet is being edited.

Procedure

  1. Open a campaign and click the Target cells tab.
  2. Click Edit 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.
    ToDo this
    Add one row to the bottom of the spreadsheet Click Add a cell.
    Add several rows to the bottom of the spreadsheet
    1. Click Add many cells.
    2. Select N empty rows, enter the number of rows to add, and click Create target cells.
    Duplicate one or more rows
    1. Select at least one row.
    2. Click Add many cells, select N duplicate rows, enter the number of rows to add, and 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 target cell spreadsheet
    1. Click Search.
    2. Use the Search to enter one or more characters. 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.
    3. Click Find next to highlight the row that contains the first match.
    4. Click Find next to continue searching.
    Paste data from an external source
    1. Copy content from another application.
    2. Click a cell in the target cell spreadsheet to make it editable.
    3. Use the right-click menu to Paste.
    Import target cell data from a .csv file
    1. Obtain a comma-separated values file in the required format. See Import and export format for TCS data.
    2. Open a target cell spreadsheet for viewing (not editing).
    3. Click Import target cells.
    4. In the Import TCS dialog, click Browse to locate the .CSV file that you want to import, select the file, and click Open.
    5. Click Import.

    The contents of the .CSV file is appended below any existing cells in the target cell spreadsheet.
    Move rows up or down, or delete rows Select a row, then use the options in the toolbar: Move up, Move down, or Delete.
  4. Click Save or Save and exit.

What to do next

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 target cell spreadsheet, the flowchart designer selects Link to target cell in the process configuration dialog box.