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
- Navigate to the Administration - Marketing screen, then the List Formats view, and open the Analytics Data Load - Responses sample list format.
- Create new columns and map the column headers to the integration objects, using the following table as a guide.
|
|
|
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}{}' |
- 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'})
- Set the header and footer to match the object name "Response."
- Set the Purpose attributes. For example:
- Purpose: Analytics Data Load
- Delimited
- Max# Records: 1000
|