Siebel Marketing User Guide > Managing Lists > Process of Importing and Managing External Lists >

Campaign and Response Data

List Import can be used to import campaign and Response Data about contacts and prospects. For example, your company may run a campaign against a target list of contacts, but it collects the responses in an external application or through an outside service company. You can import the response results from these sources and attribute the responses to the original campaign.

The List Import view provides the following additional actions that you can select in the Additional Actions field to include response and campaign data in the file:

• Assign to Campaigns. Adds the contacts and prospects in the import file to the campaign included in the file. This action does not create any response data.
• Assign to Responses. Creates response records for the contacts or prospects in the list. The action does not add, delete, or modify the set of contacts and prospects already associated with the campaign.
• Assign to Campaigns/Responses. This action takes contacts and prospects records from the import file, adds them to the campaign, and creates responses for them.

Campaign and response data is not created unless you select one of these additional actions, even if you mapped response or campaign fields. If you do not select an additional action, the import utility ignores response and campaign columns and only creates a list of contacts and prospects.

The List Import view includes the following response fields for mapping import data:

• Offer Code
• Offer Language
• Offer Name (required)
• Response Date
• Response Description (required)
• Response Method
• Response Score,
• Response Status
• Response Type (required)

The List Import view includes the following campaign fields for mapping import data:

• Campaign Name (required)
• Campaign Source Code

When mapping, response and campaign fields, be sure to map all the fields required to create a response in the application. The import provides some default values you do not include all the required fields.

• If you do not specify Offer Name, the response defaults to the primary offer for the campaign.
• If you do not specify Response Type, the type defaults to Unclassified Response.
• If you do not specify Response Description, the type defaults to Imported Response.

If you enable the response business service that performs automatic lookups for Campaign Source Code and Offer Code, you can map the Campaign Source Code and Offer Code fields as an alternative to Campaign Name and Offer Name. In this case, the import utility performs the lookup and defaults to the related Campaign Name and Offer Name. For more information, see About Using Response Management.

NOTE:  The Campaign Source Code field in the List Import mappings indicates the source code value assigned individually to each Campaign Contact and Prospect. It does not refer to the Source Code field in the Campaign record (the field displayed on the Campaign form).