To configure a contact process (Mail List or Call List)

Within a campaign, open a flowchart for editing.

Drag a contact process (Mail List or Call List) from the palette to your flowchart.

Connect one or more configured processes as input to the contact process.

All of the cells that you select as input cells must have the same audience level.

Double-click the contact process in the flowchart workspace.

Use the Fulfillment tab to specify what input is used to build the contact list and to specify whether output is generated to a list or table.

From the Input list, specify the input cells to use as the data source for the contact list.

If the contact process is not connected to a process that provides output cells, there are no cells to select from in the Input list. The Multiple Cells option is available only if the input process generates multiple cells or if there are more processes that are feeding into the contact process.

The Enable Export To check box is selected by default. To export your list data to a table or file, leave Enable Export To checked, then use the appropriate options:

To write the output to a database table, select its name from the Enable Export To list.

If the database table that you want to use is not in the list, or if you want to write the output to an unmapped table, select Database Table. Use the Specify Database table dialog to indicate the table and database name. User variables are supported in the table name you specify here.

To write the output to a file, select File from the Enable Export To list, then use the Specify Output File dialog to provide a file name and other details. You can write to a file to test the output of the contact process. After you run the process, review the file to confirm that the results are what you expect.

To create a user table, select New Mapped Table from the Enable Export To list. For instructions, see the Campaign Administrator's Guide.

Specify how to handle updates to the output file or table:

▪ Append to Existing Data. Add the new information to the end of the table or file. This option is the best practice for database tables. If you select this option for a delimited file, labels are not exported as the first row.

▪ Replace All Records. Remove any existing data from the table or file and replace it with the new information.

▪ Create New File. This option is available if you specify a new file in the Enable Export To field.

If you only want to write to contact history, and you do not want to generate output to a table or file, clear the Enable Export To check box. (Use the Log tab, explained later in these steps, to specify how to log to the Contact History tables.)

(Optional) Summary File: Enter a path and file name in the Summary File field, or navigate to a location by clicking the ellipsis button. A summary file is a text file with the extension .sum. This file contains information about the contents of the list. Typically, you include this file with the list when you send it to the fulfillment center.

(Optional) To send a trigger when the process finishes running, select the Send Trigger(s) check box, and choose the trigger that you want to send. To send multiple triggers, use Ctrl+Click to select more than one trigger. The selected triggers are listed in the Send Trigger(s) field, and they are separated by commas.

Use the Treatment tab to assign one or more offers or offer lists to each listed target cell:

To assign an offer to a target cell, click the Offer field next to the cell, then select from the list of available offers. To assign one or more offers to multiple cells, select all rows to which you want to assign offers, and use the Assign Offers button.

If the input cells are linked to a top-down cell defined in the Target Cell Spreadsheet (TCS), and offers are already assigned in the TCS, the offers are displayed here. You can override these assignments. Any changes that you make in the contact process are reflected in the TCS after you save the flowchart.

To use control groups, which are excluded from the contact list, select Use Holdout Control Groups. Columns that are relevant for control groups appear in the grid.

For each cell that you want to use as a control, change the Control? field from N (the default) to Y. Cells that are designated as controls cannot be assigned offers.

For each non-control cell, you can specify a control cell and an offer. Optionally select a control cell from the Control Cell list. This list is populated with the names of cells for which you indicated Control? = Y.

To change the offer assigned to a non-control cell, click in the Offer field and select an available offer.

Use the Parameters tab to refine your offer for each cell. This tab shows the parameter names and values for each parameterized offer that was assigned on the Treatment tab. Follow the steps below if you want to change the parameter values. If there are no parameterized offers, you can skip this tab.

Use the For Cell(s) list to select the cell that you want to affect.

If you select an individual cell, the table displays only the offers assigned to the cell you selected. Values that you enter in the Assigned Value field apply only to that cell.

If you select [All Cells], you see one row per offer per parameter. Values that you enter in the Assigned Value field apply to every cell that gets that offer.

You can assign the same offer to multiple cells on the Treatment tab, but set different parameter values for each cell. In this case, the [All Cells] view displays the text [Multiple Values] in the Assigned Value column. Use the For Cell(s) list to see which value is assigned to each cell.

To save data entry time, use [All Cells] to assign values that apply to most of the cells, then select individual cells to override their values.

Click in the Assigned Value field (or select a row in the table and click Assign Value), then select or type a value to assign to the parameter. You can use constants, derived fields, or table fields as values.

Use the Personalization tab to specify which fields to write out to the contact list. For example, if you are building a mailing list, include contact names and addresses.

The Export Field list indicates which fields to write to the output list.

If you selected a table on the Fulfillment tab, the Export Field list includes all of the fields from that table. You must map each data field to a corresponding table column. To automatically find matching fields, click Match. Fields with exact matches for the table field names are automatically added to the list. If there are multiple matching fields, the first match is taken.

If you selected a file on the Fulfillment tab, the Export Field list is empty and you must specify which fields to output.

When you select Candidate Fields, you can click the arrow next to an item to expand it. For example, you can expand the IBM® Campaign Generated Fields list, then select Treatment Code. By including the Treatment Code in your output, you can use it to track responses. Direct Response tracking requires customers to provide the same code when they respond to the offer (for example, by using a coupon). Use Ctrl+Click or Shift+Click to select multiple fields.

To view the values in a field, select the field and click Profile.

Use the Add and Remove controls to adjust the contents of the list.

The order of the fields in the Export Fields list determines the order that the data is written out.

To sort the output and specify how to handle duplicate IDs in the list, click More on the Personalization tab.

You see the Advanced Settings dialog.

Decide whether your list will include or omit duplicate IDs. For example, if your Audience ID is Household, there might be duplicate Audience IDs for each person in that household. You may or may not want each person included in the list. To omit duplicate IDs, choose Skip Records with Duplicate IDs, and specify which record to retain if duplicate IDs are returned. For example, to keep only the family member with the highest household income, select MaxOf and Household_Income.

This option removes duplicates that occur in the same input cell. If the same ID exists in multiple input cells, your contact list can still contain duplicates. If your goal is to remove all duplicates from the list, use a Merge or Segment process upstream of the contact process to purge duplicate IDs or create mutually exclusive segments.

This option pertains only to the fulfillment table (the list) and not to contact history. The contact history tables always contain unique IDs only. For example, say that your output list includes multiple family members (duplicate IDs for Households). The contact history will contain only one record for Household, using the first CustomerID found. The flowchart designer must ensure that the result set obtains the correct records before the records reach the contact history tables. Use the Extract process to de-dupe the results before the contact process box to ensure that the correct records are written to both the fulfillment table and contact history.

To sort the output, use the Order By options. For example, to sort by surname in reverse order, select the Last_Name field and Descending.

Click OK to close the Advanced Settings window.

10.

Use the Log tab to control what is written to contact history.

You must have the appropriate permissions to enable or disable the contact history log options.

To log contact history to the system tables, check Log to Contact History Tables.

This option makes contact information available for tracking and reporting throughout Campaign.

When you configure a mailing list, do not log to contact history if you plan to send the list to a mailing house for processing (such as validating addresses or householding). Instead, consider using a Track process to log the information that is returned from the mailing house. In this way, you capture only the list of customers who were mailed an offer. Another approach is to allow the Mail List to update contact history, then use the Track process to update the contact history records that were created by the Mail List process.

(Optional) To store contact information in another location, in addition to or instead of the contact history tables, check Log into Other Destination. This option is useful if your organization requires further processing of the information in another format, or if you want to examine the output before you update contact history.

11.

If you selected Log into Other Destination on the Log tab:

Use Select cells to specify which input to use (if there are multiple inputs).

Use Log to to select a destination table or file. If you select File, use the Specify Output File dialog to define the output file name and parameters.

Indicate which field data to include by moving candidate fields to the Fields to Output list. You can automatically find matching fields by clicking Match. Fields with exact matches for the Table Field names are automatically added to the Field to Log list. If there are multiple matching fields, the first match is taken. The order of fields in the list determines the order of data in the file.

Use the following options to specify how updates to the destination file or table are handled:

Append to Existing Data: Add the new contact information to the end of the table or file. Appending data is a safe choice for database tables because it preserves existing data. If you select this option for a delimited file, labels are not exported as the first row.

Replace All Records: Remove any existing data from the table or file, and replace it with the new contact information.

An informational field indicates whether Skip records with duplicate IDs is set to Yes or No. You set this option on the Personalization tab but it also applies to the table or file that you specified for Log into Other Destination, where you are additionally logging contact history.

12.

To customize the information that gets written to contact history, click More Options on the Log tab.

The Contact History Logging Options dialog opens.

To avoid updating contact history when this process runs, select Create Treatments Only.

This option generates new treatments in the Treatments table without updating the contact history, allowing for a delayed update to the history tables. For example, use this option if you plan to remove invalid and duplicate addresses through post-processing. By waiting to update contact history with the final list of IDs to which offers are sent, the resulting contact history will be smaller and more accurate.

If you select this option, the other options in this dialog that no longer apply are disabled.

By default, this option is not selected, so contact history is updated when the process runs.

For more information about logging contact history, see About contact history.

To generate new treatments with the same package ID as in the most recent process run, select Use Last Package ID.

All offers given to an individual in the same contact process are considered to be a single "package". By default, Use Last Package ID is not selected. Not selecting this option ensures that each package is assigned a unique ID for each production run of the contact process.

If you selected Create Treatments Only to prevent customer history from being updated, you can also select Use Last Package ID to ensure that the package ID from the prior run is assigned to each set of offers. This action links the offers to the existing contact history.

Use the Tracking Audience Level list to select the audience level at which you are tracking contact history.

Use the Contact Date field to specify when to contact the people in the contact list. If you do not specify a date, Campaign uses the flowchart run date.

Use the Contact Status Code list to specify a status code for tracking.

Use the controls to add fields from the Candidate Fields list to the Fields to Log list.

Click Close to return to the Log tab of the process configuration dialog.

13.

(Optional) To clear some or all existing contact history and associated response history entries before the next run of the contact process, click Clear History on the Log tab.

Clear History permanently deletes contact and response history records from the system tables. This data is not recoverable.

14.

(Optional) Use the General tab to assign a name and descriptive notes to the process.

15.

Click OK.

The process is now configured. You can test run the process to verify that it returns the results you expect. A test run does not output data or update any tables or files, but it does run any triggers that were selected on the Fulfillment tab.