Siebel Marketing Installation and Administration Guide > Designing Marketing Campaign Load Formats > Creating and Testing Campaign Load Formats >

Example of Creating a Response Load Format

The response list format creates responses from the program flow. It can be stored in the My Data Load Format or Shared Data Load Format folders. This topic gives an example how to create a response load format based on the Analytics Data Load - Responses sample list format. You can use this feature differently, depending on your business model.

To create a response load format

1. Navigate to the Administration - Marketing screen, then the List Formats view, and open the Analytics Data Load - Responses sample list format.
2. Create new columns and map the column headers to the integration objects, using the following table as a guide.

   Table Heading	Column Heading	Column Formula
   Response	Id	'NOID'
   Response	Response Type	'@{responseType}{}'
   Response	Treatment Id	'@{treatmentID}{}'
   Response	Description	'@{description}{}'
   Response	PR_CON_ID	"- Contact Profile"."Contact Id"
   Response	PRSP_CON_ID	"- Contact Profile"."Prospect Id"
   Response	ACCNT_ID	"- Contact Profile"."Account Id"
   Response	SRC_ID	'@{campaignID}{}'
   Response	Response Value	'@{responseValue}{}'
   Response	Response Cost	'@{responseCost}{}'
   Response	Response Cost Currency Code	'@{responseCostCurrencyCode}{}'
   Response	Score	'@{score}{}'

3. Add a filter to restrict the query count based on constraining stage wave Ids. For example:

   Re-qualified against original segment criteria

   AND ' '@{constrainingStageFlag}{N}'= 'N' OR "Campaign History (Transaction Database)"."Campaign Load Wave Id" IN (@{constrainingWaveID}{'0'})

4. Set the header and footer to match the object name "Response."
5. Set the Purpose attributes. For example:
   • Purpose: Analytics Data Load
   • Delimited
   • Max# Records: 1000