Salesforce CRM: Contact Mappings

After a data stream is deployed, the Salesforce CRM starter data bundle automatically maps data from Sales Cloud or Service Cloud to data model objects (DMO)s in Data Cloud. The Sales Cloud and Service Cloud bundles deploy mappings to Contact Point type DMOs. Identity Resolution uses the DMOs, which link multiple records into a unified customer profile.

Usage and Data Bundles

These mappings are used for various purposes within these bundles. For Loyalty Management, information about the contact is associated with an Individual type loyalty program member. For Service Cloud, they’re used to power Service Intelligence visualizations of contact center performance metrics.

Bundles:

Loyalty Management
Sales Cloud
Service Cloud

DLO to DMO Mapping

These data mappings relate to the Contact object included in the Salesforce CRM connector and how that data connects to DMOs.

DLO Field	DLO Field API Name	DLO Field Data Type	DMO	DMO Field Name	Additional Details
Account Id	`AccountId__c`	text	Account Contact	Account
Assistant Name	`AssistantName__c`	text	Account Contact	Assistant Name
Asst. Phone	`AssistantPhone__c`	text	Account Contact	Assistant Phone	Foreign Key
Birthdate	`Birthdate__c`	dateTime	Individual	Birth Date
Business Phone	`Phone__c`	text	Contact Point Address	Telephone Number
Business Phone	`Phone__c`	text	Account Contact	Business Phone	Used within the Loyalty Management bundle.
Contact ID	`Id__c`	text	Account Contact	Account Contact ID	Primary Key
				Business Phone	Foreign Key
				Contact Email	Foreign Key
				Individual	Foreign Key
				Mailing Address	Foreign Key
			Contact Point Address	Contact Point Address ID	Primary Key
			Contact Point Address	Party	Foreign Key
			Contact Point Email	Contact Point Email ID	Primary Key
			Contact Point Email	Party	Foreign Key
			Contact Point Phone	Contact Point Phone ID	Primary Key
			Contact Point Phone	Party	Foreign Key
			Individual	Individual ID	Primary Key
Created Date	`CreatedDate__c`	dateTime	Account Contact	Created Date
Created Date	`CreatedDate__c`	dateTime	Individual	Created Date
Department	`Department__c`	text	Account Contact	Department Name
Email	`Email__c`	text	Contact Point Email	Email Address
Email	`Email__c`	email	Account Contact	Contact Email	Used within the Loyalty Management bundle.
Email Bounced Date	`EmailBouncedDate__c`	dateTime	Contact Point Email	Email Latest Bounce Date Time
Email Bounced Reason	`EmailBouncedReason__c`	text	Contact Point Email	Email Latest Bounce Reason Text
First Name	`FirstName__c`	text	Individual	First Name
Full Name	`Name__c`	text	Individual	Person Name
Last Activity	`LastActivityDate__c`	dateTime	Account Contact	Last Activity Date
Last Modified Date	`LastModifiedDate__c`	dateTime	Account Contact	Last Modified Date
Last Modified Date	`LastModifiedDate__c`	dateTime	Individual	Last Modified Date
Last Name	`LastName__c`	text	Individual	Last Name
Mailing Address		address	Account Contact	Mailing Address	Used within the Loyalty Management bundle.
Mailing City	`MailingCity__c`	text	Contact Point Address	City
Mailing Country	`MailingCountry__c`	text	Contact Point Address	Country
Mailing Latitude	`MailingLatitude__c`	number	Contact Point Address	Geo Latitude
Mailing Longitude	`MailingLongitude__c`	number	Contact Point Address	Geo Latitude
Mailing State/Province	`MailingState__c`	text	Contact Point Address	State Province
Mailing Street	`MailingStreet__c`	text	Contact Point Address	Address Line 1
Mailing Zip/Postal Code	`MailingPostalCode__c`	text	Contact Point Address	Postal Code
Phone		text	Contact Point Phone	Telephone Number
Photo URL	`PhotoUrl__c`	text	Individual	Photo URL
Salutation	`Salutation__c`	text	Individual	Salutation
Title	`Title__c`	text	Account Contact	Title

Data Cloud Reference Guide

Salesforce CRM: Contact Mappings

Usage and Data Bundles

DLO to DMO Mapping