Enabling System Data Expressions for Required Columns

Several of the Campaign Contact columns required for the campaign load format must be populated with values that are determined by the list generation process at run time. To accomplish this, you set up the Campaign Contact columns to use system data expressions. The following procedure describes this task.

To enable system data expressions for required columns

1. Click the properties button on the Campaign Contact column.

2. In the dialog box, first click the Custom Headings check box.

   This makes sure the table and column name are not changed when you modify the formula in the next step.

3. Clear the current formula from the Column Formula box.

4. Place your cursor in the Column Formula box, then click the Available System Data link.

5. Select the appropriate system data expression from the values in the following table.

   Column	Corresponding System Data Expression
   Campaign Id	Campaign Id
   Load Number	Load Number
   Scalability Batch Number	Email Batch Number
   Segment Id	Segment Id
   Token Number	Token Number
   Treatment Id	Treatment Id

   The expression is added to the formula. For example, the Campaign ID column would show the following formula:

   @{campaignID}{0}
   

   Note: If you get an error message in the Formula dialog box, then ignore the error.

6. Click OK.