Configuring Mail list or Call list processes

Follow these instructions to configure a Mail list or Call list process in a Unica Campaign flowchart. Configure a Mail list or Call list process to assign offers to contacts, generate a contact list for a direct mail or telemarketing campaign, and write the results to contact history.

Procedure

Open a flowchart for editing.
Drag a Mail list or Call list process from the palette to your flowchart.
Connect one or more configured processes as input to the Mail list or Call list.

The input processes must produce output cells, which provide input to the Mail list or Call list process. For example, a Select process produces a list of IDs, which are used by the Mail list or Call list process.

Important: All of the cells that you select as input cells must have the same audience level.
Double-click the Mail list or Call list process in the flowchart workspace to open the configuration dialog.
Use the Fulfillment tab to build the contact list and specify whether the output is sent to a list or table.
1. From the Input list, specify the cells to use as the data source for the contact list.
  
  If multiple processes are connected to the Mail list or Call list process (or if an input process generates multiple cells), click the ellipsis button then select which inputs to use. For example, if Gold, Silver, and Bronze cells are connected to a Mail list, you can select one, two, or all three of them. When more than one cell is selected, the Input list says Multiple cells.
2. To export the list to a table or file, select Enable export to, then use the appropriate options:
  - To write the output to a file, select File from the Enable export to list, then provide a file name and other details. You can write to a file to test the output of the Mail list or Call list process. After you run the process, review the file to confirm that the results are what you expect.
  - To write the output to a database table, select a table 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 name and database. User variables are supported in the table name that you specify.
  - To create a user table, select New mapped table from the Enable export to list. For instructions, see the Unica 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 new information.
    - Create new file. This option is available if you specify a new file in the Enable export to field.
3. 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 option. (To specify how to log to the Contact history tables, use the Log tab, explained later in these steps.)
4. (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. A summary file is generated only if you select the Enable export to option.
5. (Optional) To send a trigger when the process finishes running, select Send trigger(s), 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 target cell. The cells that appear depend on the inputs you selected on the Fulfillment tab:
1. Double-click the Offer field next to a Target cell, then select an offer. To assign multiple offers to a cell, select one or more target cells, then click Assign offers. You can then choose which offers to assign to which cells.
  
  Note: If the input cells are linked to a top-down cell defined in the target cell spreadsheet, and offers are already assigned in the target cell spreadsheet, the offers are displayed here. You can override these assignments. Any changes that you make here are reflected in the target cell spreadsheet after you save the flowchart.
2. If you want to use control groups to exclude some IDs from the contact list, check Use holdout control groups, then change the Control? field to Y for each cell that you want to use as a control. Those cells appear in the Control cell list and cannot be assigned offers.
3. For each non-control cell, you can specify a control cell and an offer.
The Parameters tab shows the parameter names and values for each offer that was assigned on the Treatment tab. For example, an offer might have the parameter "Channel" with values of 'Email' and 'Phone'. If there are no parameterized offers, you can skip this tab.
1. Use the For cell(s) list to select the cells that you want to affect.
  
  To save data entry time, select [All cells] to assign values that apply to most of the cells, then select individual cells to override the values. When 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.
  
  If you assigned the same offer to multiple cells on the Treatment tab, but you assign different parameter values for each cell, the [All cells] view displays the text [Multiple values] in the Assigned value column, and the For cell(s) list shows the value that is assigned to each cell.
  
  When you select an individual cell in the For cell(s) list, you see only the offers assigned to the selected cell. Values that you enter in the Assigned value field apply to that cell only.
2. 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. For example, if the parameter is Discount, the available values might be 10%, 15%, and 20%. The available values depend on how the offer was defined.
  
  The configuration setting Unica Campaign | partitions | partition[n] | server | flowchartConfig | disallowAdditionalValForOfferParam determines whether you are allowed to specify additional values or whether you are restricted to values in the list for offer attributes of type Single select drop down.
  
  Note: If you edit an offer to change a parameter value after assigning the offer, the original value continues to be used in any assigned offers. This behavior prevents unintentional changes of attribute values for offers that have already been assigned. For example, say you assign an offer that has a Cost Per Offer value of $1.00. Later, someone edits the offer on the Offer Summary page and changes the value to $1.99. The Assigned value on the Parameters tab of the Mail list or Call list remains set to its original value of $1.00. To update the value, you must explicitly remove and then re-add the offer on the Treatment tab: Select the Target cell, click Assign offers, and remove the offer. Select a different tab, then select the Treatment tab again and reassign the offer. Now when you select the Parameters tab, the edited value ($1.99) appears.
  
  Note: Do not use a Unica Campaign generated field (UCGF) in a Mail list derived field unless the generated field is constant. Unica Campaign assumes constant values for generated fields and does not re-calculate them for records in the result set. Therefore, you may see blank or incorrect results from derived fields that call a generated field that changes value. Instead of using a derived field, output the necessary generated field directly into your Mail list fulfillment table or file. Then read that table or file back into Unica Campaign as a Select and use a Snapshot process to manipulate a new fulfillment table or file using data from the old one.
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 fields list indicates which fields to write to the output list.
- If you selected a table on the Fulfillment tab, the Export fields 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 fields 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 Unica 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.
1. 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.
  Note: This option removes duplicates that occur in the same input cell. If the same ID exists in multiple input cells, your contact list might still contain duplicates. If your goal is to remove all duplicates from the list, use a Merge or Segment process upstream of the Mail list or Call list process to purge duplicate IDs or create mutually exclusive segments.
  Note: 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 Mail list or Call list process box to ensure that the correct records are written to both the fulfillment table and contact history.
2. 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.
3. Click OK to close the Advanced settings dialog.
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.
1. 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 Unica Campaign.
  
  Note: When you create 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). Instead, consider using a Track process to log the information after it 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.
2. (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.
If you selected Log into other destination on the Log tab:
1. Use Select cells to specify which input to use (if there are multiple inputs).
2. Use Log to to select a destination table or file. If you select File, 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.
3. 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.
To customize the information that gets written to contact history, click More options on the Log tab.
The Log dialog for contact history logging options opens.
1. 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 Contact history.
2. 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.
3. Use the Tracking audience level to determine which audience level is written to contact history.
  
  Note: The Mail list or Call list process removes duplicate records based on the Audience level of the input process. Changing the Tracking audience level does not affect how records are de-duped. For example, say the input process for a Mail list process uses Audience level 1. However, you want to log records to contact history at Audience level 2. In this case, you must configure an Audience process to change the audience level. Then connect the Audience process as input to the contact process. Now you can select a Tracking audience level of 2.
4. Use the Contact date (flowchart run date will be used if empty) field to specify when to contact the people in the contact list. If you do not specify a date, Unica Campaign uses the flowchart run date.
5. Use the Contact status code list to specify a status code for tracking.
6. Use the controls to add fields from the Candidate fields list to the Fields to log list.
7. Click Close to return to the Log tab of the process configuration dialog.
(Optional) To permanently delete existing contact history and associated response history entries before the next run of the contact process, click Clear history on the Log tab.

Important: Clear history permanently deletes contact and response history records from the system tables. This data is not recoverable.
(Optional) Use the General tab to assign a name and descriptive note to the process. The Process name is used as the box label on the flowchart. It is also used in various dialogs and reports to identify the process. The content of the Note field appears when you rest your cursor over the process box in a flowchart.
Click OK.
Note: The mail list process box remains unconfigured in case no table is mapped in the flowchart for the audience level of the segment. To configure it, the select process box should be executed.

Results

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.