7Advanced Marketing Information for Administrators
Advanced Marketing Information for Administrators
This appendix contains advanced information for administrators. It includes the following topics:
Upgrading Campaigns from Earlier Versions
Customers upgrading campaigns from any versions prior to 7.7 must review 478260.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Technical Note 583. This Technical Note is also useful to anyone who wants more information on campaigns, waves, and the underlying table information.
Field Names for Marketing Integration Components
The followning tbale contains a list of Marketing integration objects, their components, and field names.
Table Field Names for Marketing Integration Components
Parent Integration Object | Parent Integration Component | Name | Data Type | Length |
---|---|---|---|---|
Business Intelligence Account |
Account |
Attribute 66 |
DTYPE_TEXT |
100 |
Attribute 67 |
DTYPE_TEXT |
100 |
||
Attribute 68 |
DTYPE_TEXT |
100 |
||
Attribute 69 |
DTYPE_TEXT |
100 |
||
Attribute 70 |
DTYPE_TEXT |
100 |
||
Attribute 71 |
DTYPE_TEXT |
100 |
||
Attribute 72 |
DTYPE_TEXT |
100 |
||
Attribute 73 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 74 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 75 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 76 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 77 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 78 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 79 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 80 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 81 |
DTYPE_NUMBER |
Not applicable |
||
Id |
DTYPE_ID |
30 |
||
Integration Id |
DTYPE_TEXT |
30 |
||
Location |
DTYPE_TEXT |
50 |
||
Name |
DTYPE_TEXT |
100 |
||
Business Intelligence Contact |
Contact |
Attribute 49 |
DTYPE_TEXT |
100 |
Attribute 50 |
DTYPE_TEXT |
100 |
||
Attribute 51 |
DTYPE_TEXT |
100 |
||
Attribute 52 |
DTYPE_TEXT |
100 |
||
Attribute 53 |
DTYPE_TEXT |
100 |
||
Attribute 54 |
DTYPE_TEXT |
100 |
||
Attribute 55 |
DTYPE_TEXT |
100 |
||
Attribute 56 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 57 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 58 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 59 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 60 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 61 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 62 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 63 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 64 |
DTYPE_NUMBER |
Not applicable |
||
First Name |
DTYPE_TEXT |
50 |
||
Id |
DTYPE_ID |
30 |
||
Integration Id |
DTYPE_TEXT |
30 |
||
Last Name |
DTYPE_TEXT |
50 |
||
Person UId |
DTYPE_TEXT |
100 |
||
Business Intelligence Household |
Household |
Attribute 48 |
DTYPE_TEXT |
100 |
Attribute 49 |
DTYPE_TEXT |
100 |
||
Attribute 50 |
DTYPE_TEXT |
100 |
||
Attribute 51 |
DTYPE_TEXT |
100 |
||
Attribute 52 |
DTYPE_TEXT |
100 |
||
Attribute 53 |
DTYPE_TEXT |
100 |
||
Attribute 54 |
DTYPE_TEXT |
100 |
||
Attribute 55 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 56 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 57 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 58 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 59 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 60 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 61 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 62 |
DTYPE_NUMBER |
Not applicable |
||
Attribute 63 |
DTYPE_NUMBER |
Not applicable |
||
Household Name |
DTYPE_TEXT |
50 |
||
Household Number |
DTYPE_TEXT |
100 |
||
Id |
DTYPE_ID |
30 |
||
Integration Id |
DTYPE_TEXT |
30 |
||
Marketing Contact |
Account |
Account Location |
DTYPE_TEXT |
50 |
Account Name |
DTYPE_TEXT |
100 |
||
Home Page |
DTYPE_TEXT |
100 |
||
Id |
DTYPE_TEXT |
30 |
||
Integration Id |
DTYPE_TEXT |
30 |
||
Main Fax Number |
DTYPE_TEXT |
Not applicable |
||
Main Phone Number |
DTYPE_TEXT |
Not applicable |
||
Region |
DTYPE_TEXT |
25 |
||
Marketing Contact (continued) |
Account Address |
Address Name |
DTYPE_TEXT |
100 |
City |
DTYPE_TEXT |
50 |
||
Country |
DTYPE_TEXT |
50 |
||
Id |
DTYPE_TEXT |
30 |
||
Integration Id |
DTYPE_TEXT |
30 |
||
Postal Code |
DTYPE_TEXT |
30 |
||
State |
DTYPE_TEXT |
10 |
||
Street Address |
DTYPE_TEXT |
200 |
||
Street Address 2 |
DTYPE_TEXT |
100 |
||
Account Organization |
Organization |
DTYPE_TEXT |
50 |
|
Campaign Contact |
Campaign Id |
DTYPE_ID |
Not applicable |
|
Completion Date |
DTYPE_TEXT |
Not applicable |
||
Distribution Id |
DTYPE_ID |
Not applicable |
||
Key 1 |
DTYPE_TEXT |
30 |
||
Key 2 |
DTYPE_TEXT |
30 |
||
Key 3 |
DTYPE_TEXT |
30 |
||
Key 4 |
DTYPE_TEXT |
30 |
||
Key 5 |
DTYPE_TEXT |
30 |
||
Key 6 |
DTYPE_TEXT |
30 |
||
Key 7 |
DTYPE_TEXT |
30 |
||
Load Number |
DTYPE_NUMBER |
Not applicable |
||
Load Wave Id |
DTYPE_ID |
Not applicable |
||
Scalability Batch Number |
DTYPE_NUMBER |
Not applicable |
||
Segment Id |
DTYPE_ID |
Not applicable |
||
Source Code |
DTYPE_TEXT |
75 |
||
Token Number |
DTYPE_NUMBER |
Not applicable |
||
Treatment Id |
DTYPE_ID |
Not applicable |
||
Marketing Contact (continued) |
Contact |
Cellular Phone # |
DTYPE_TEXT |
Not applicable |
Email Address |
DTYPE_TEXT |
50 |
||
Fax Phone # |
DTYPE_TEXT |
Not applicable |
||
First Name |
DTYPE_TEXT |
50 |
||
Gender |
DTYPE_TEXT |
30 |
||
Home Phone # |
DTYPE_TEXT |
Not applicable |
||
Id |
DTYPE_ID |
30 |
||
Integration Id |
DTYPE_TEXT |
30 |
||
Job Title |
DTYPE_TEXT |
75 |
||
Last Name |
DTYPE_TEXT |
50 |
||
Middle Name |
DTYPE_TEXT |
50 |
||
Person UId |
DTYPE_TEXT |
100 |
||
Preferred Communications |
DTYPE_TEXT |
30 |
||
Salutation |
DTYPE_TEXT |
15 |
||
Status |
DTYPE_TEXT |
30 |
||
Work Phone # |
DTYPE_TEXT |
Not applicable |
||
Contact Address |
Id |
DTYPE_TEXT |
30 |
|
Integration Id |
DTYPE_TEXT |
30 |
||
Personal Address Name |
DTYPE_TEXT |
100 |
||
Personal City |
DTYPE_TEXT |
50 |
||
Personal Country |
DTYPE_TEXT |
50 |
||
Personal Postal Code |
DTYPE_TEXT |
30 |
||
Personal State |
DTYPE_TEXT |
10 |
||
Personal Street Address |
DTYPE_TEXT |
200 |
||
Personal Street Address 2 |
DTYPE_TEXT |
100 |
||
Contact Organization |
Organization |
DTYPE_TEXT |
50 |
|
Marketing Contact (continued) |
Household |
Fax Number |
DTYPE_TEXT |
Not applicable |
Household Name |
DTYPE_TEXT |
50 |
||
Household Number |
DTYPE_TEXT |
100 |
||
Household Size |
DTYPE_NUMBER |
Not applicable |
||
Household Wealth |
DTYPE_TEXT |
Not applicable |
||
Id |
DTYPE_ID |
30 |
||
Income |
DTYPE_TEXT |
Not applicable |
||
Integration Id |
DTYPE_TEXT |
30 |
||
Phone Number |
DTYPE_TEXT |
Not applicable |
||
Revenue |
DTYPE_TEXT |
Not applicable |
||
Household Organization |
Organization |
DTYPE_TEXT |
50 |
|
Marketing Person |
Campaign Contact |
Account Id |
DTYPE_ID |
Not applicable |
Campaign Id |
DTYPE_ID |
Not applicable |
||
Completion Date |
DTYPE_TEXT |
Not applicable |
||
Contact Id |
DTYPE_ID |
Not applicable |
||
Distribution Id |
DTYPE_ID |
Not applicable |
||
Household Id |
DTYPE_ID |
Not applicable |
||
Key 1 |
DTYPE_TEXT |
30 |
||
Key 2 |
DTYPE_TEXT |
30 |
||
Key 3 |
DTYPE_TEXT |
30 |
||
Key 4 |
DTYPE_TEXT |
30 |
||
Key 5 |
DTYPE_TEXT |
30 |
||
Key 6 |
DTYPE_TEXT |
30 |
||
Key 7 |
DTYPE_TEXT |
30 |
||
Load Number |
DTYPE_NUMBER |
Not applicable |
||
Load Wave Id |
DTYPE_ID |
Not applicable |
||
Prospect Id |
DTYPE_ID |
Not applicable |
||
Scalability Batch Number |
DTYPE_NUMBER |
Not applicable |
||
Segment Id |
DTYPE_ID |
Not applicable |
||
Source Code |
DTYPE_TEXT |
75 |
||
Treatment Id |
DTYPE_ID |
Not applicable |
||
Token Number |
DTYPE_NUMBER |
Not applicable |
||
Marketing Prospect |
Campaign Contact |
Call Completed |
DTYPE_TEXT |
Not applicable |
Campaign Id |
DTYPE_ID |
Not applicable |
||
Completion Date |
DTYPE_TEXT |
Not applicable |
||
Distribution Id |
DTYPE_ID |
Not applicable |
||
Key 1 |
DTYPE_TEXT |
30 |
||
Key 2 |
DTYPE_TEXT |
30 |
||
Key 3 |
DTYPE_TEXT |
30 |
||
Key 4 |
DTYPE_TEXT |
30 |
||
Key 5 |
DTYPE_TEXT |
30 |
||
Key 6 |
DTYPE_TEXT |
30 |
||
Key 7 |
DTYPE_TEXT |
30 |
||
Load Number |
DTYPE_NUMBER |
Not applicable |
||
Load Wave Id |
DTYPE_ID |
Not applicable |
||
Prospect Id |
DTYPE_ID |
Not applicable |
||
Scalability Batch Number |
DTYPE_NUMBER |
Not applicable |
||
Segment Id |
DTYPE_ID |
Not applicable |
||
Treatment Id |
DTYPE_ID |
Not applicable |
||
Token Number |
DTYPE_NUMBER |
Not applicable |
||
Prospect |
Account |
DTYPE_TEXT |
Not applicable |
|
Account Id |
DTYPE_ID |
Not applicable |
||
Alias |
DTYPE_TEXT |
Not applicable |
||
Alternate Phone # |
DTYPE_TEXT |
Not applicable |
||
Annual Revenue |
DTYPE_NUMBER |
Not applicable |
||
Assistant |
DTYPE_TEXT |
Not applicable |
||
Assistant Phone # |
DTYPE_TEXT |
Not applicable |
||
Birth Date |
DTYPE_DATETIME |
Not applicable |
||
Cellular Phone # |
DTYPE_TEXT |
Not applicable |
||
City |
DTYPE_TEXT |
Not applicable |
||
Comment |
DTYPE_TEXT |
Not applicable |
||
Country |
DTYPE_TEXT |
Not applicable |
||
Marketing Prospect (continued) |
Prospect (continued) |
County |
DTYPE_TEXT |
Not applicable |
Disable DataCleansing |
DTYPE_TEXT |
Not applicable |
||
DUNS Number |
DTYPE_ID |
Not applicable |
||
Email Address |
DTYPE_TEXT |
Not applicable |
||
Employee At Site |
DTYPE_NUMBER |
Not applicable |
||
Employee Total |
DTYPE_NUMBER |
Not applicable |
||
Expiration Date |
DTYPE_TEXT |
Not applicable |
||
Fax Phone # |
DTYPE_TEXT |
Not applicable |
||
First Name |
DTYPE_TEXT |
Not applicable |
||
Gender |
DTYPE_TEXT |
30 |
||
Hide DUNS Number Flag |
DTYPE_TEXT |
Not applicable |
||
Home Page |
DTYPE_TEXT |
100 |
||
Home Phone # |
DTYPE_TEXT |
Not applicable |
||
Id |
DTYPE_ID |
30 |
||
Job Title |
DTYPE_TEXT |
Not applicable |
||
Last Name |
DTYPE_TEXT |
Not applicable |
||
Line of Business |
DTYPE_TEXT |
50 |
||
Maiden Name |
DTYPE_TEXT |
Not applicable |
||
Manager Name |
DTYPE_TEXT |
Not applicable |
||
Marital Status Code |
DTYPE_TEXT |
Not applicable |
||
Middle Name |
DTYPE_TEXT |
Not applicable |
||
Nationality |
DTYPE_TEXT |
Not applicable |
||
Postal Code |
DTYPE_TEXT |
Not applicable |
||
Preferred Communications |
DTYPE_TEXT |
30 |
||
Preferred Language Name |
DTYPE_TEXT |
Not applicable |
||
Primary Account Location |
DTYPE_TEXT |
Not applicable |
||
Primary SIC Code |
DTYPE_TEXT |
30 |
||
Marketing Prospect (continued) |
Prospect (continued) |
Primary SIC Id |
DTYPE_ID |
Not applicable |
Product Interest |
DTYPE_TEXT |
100 |
||
Prospective Contact UId |
DTYPE_TEXT |
100 |
||
Province |
DTYPE_TEXT |
Not applicable |
||
Public |
DTYPE_TEXT |
1 |
||
Race |
DTYPE_TEXT |
Not applicable |
||
Salutation |
DTYPE_TEXT |
Not applicable |
||
Social Security Number |
DTYPE_TEXT |
Not applicable |
||
Source Name |
DTYPE_TEXT |
100 |
||
State |
DTYPE_TEXT |
Not applicable |
||
Street Address |
DTYPE_TEXT |
Not applicable |
||
Street Address 2 |
DTYPE_TEXT |
Not applicable |
||
Suppress Call Flag |
DTYPE_TEXT |
Not applicable |
||
Suppress Email Flag |
DTYPE_TEXT |
Not applicable |
||
Suppress Fax Flag |
DTYPE_TEXT |
Not applicable |
||
Suppress Mail Flag |
DTYPE_TEXT |
Not applicable |
||
Time Zone |
DTYPE_TEXT |
Not applicable |
||
Work Phone # |
DTYPE_TEXT |
Not applicable |
||
Year Started |
DTYPE_NUMBER |
Not applicable |
Extending Column Data to Promote Prospects to Contacts
When promoting prospects to contacts, use this example as a guide for promoting data stored in extension columns in the S_PRSP_CONTACT table to the S_CONTACT table.
To promote data stored in extension columns in the S_PRSP_CONTACT table to the S_CONTACT table
Add a new extension column called X_ACADEMIC_TITLE to S_PRSP_CONTACT.
Add a new extension column called X_ACADEMIC_TITLE to S_CONTACT.
Add a field called Academic Title to the List Management Prospective Contact business component.
Add user properties to the List Management Prospective Contact business component with the following values:
Name: Promotion Map:Contact.Academic Title
Value: Academic Title
Add a field called Academic Title to the Contact business component.
Add a field called Academic Title to the List Management Prospective Contact List applet and Contact List applet.
Add a field called Academic Title to the Promote To Contact or Promote To Contact (SIA) integration object.