Siebel Marketing User Guide > List Management > Importing and Managing External Lists >

Mapping Fields

After you import a list, you must map the fields in the imported list to the fields in the Prospect Business Component. When you do this mapping, the values in the list fields are transferred accurately into the correct fields in the prospect records.

When there is a dedicated column in the prospect table, you should map fields in the imported list to existing fields in the prospects record. Try to avoid mapping fields to additional attribute columns in the database extension table. When a value is stored in the main Prospect table, there is more flexibility to configure the location where the promoted field value should be mapped on the Contact record in the promotion map in the repository. Additional Attribute values can only be promoted to Contact Category data.

To map fields when importing a list

1. Navigate to the List Management screen
2. In the List Management link bar, click Additional Attributes.
3. Query for each attribute you want to use and verify that they exist.
4. In the List Management link bar, click Lists.
5. Drill down on the list name and click the List Additional Attributes view tab.
6. To associate attributes with the list, in the attributes list, click New.
7. In the Pick Additional Attribute dialog box, perform the following steps:
   1. To create new attributes, click New, and in the attributes list, type a name and description.
   2. To associate predefined attributes to the list, select an attribute, and click OK.
8. Associate the attributes with the list using the List Additional Attributes tab.
9. Navigate to the List Import view tab. At the top of each column in the external list, select the appropriate field or attribute to which the column should be mapped.
10. Click Save as New to save the List Import Format.
11. At the top of each column in the external list, select the appropriate prospects record attribute to which the column should be mapped.
12. Create additional attributes for columns in your list which have no corresponding prospect field.