Marketing Cloud Personalization Mappings
When creating a data stream in Data Cloud using a Marketing Cloud Personalization (formerly Interaction Studio) starter bundle, the system creates standard mappings for you.
Available in: All Editions supported by Data Cloud. See Data Cloud edition availability.
Products:
- Data Cloud
- Marketing Cloud Personalization
Event and attribute mappings that aren't included in the starter data bundle data streams must be defined manually after bundle creation:
- Shopping cart and order line item events
- Custom events
- Custom user attributes
Attributes for standard and custom events are fixed. Event data ingested from Marketing Cloud Personalization into Data Cloud is limited to the standard attributes for both standard events and custom events. If you add, delete, or rename attributes in Marketing Cloud Personalization after creating and deploying a Marketing Cloud Personalization data stream, these changes won't be reflected in your data stream.
When ingesting data from Marketing Cloud Personalization, Data Cloud creates data lake objects (DLOs) for each starter bundle along with schemas and mappings to Data Model Objects (DMOs). Use these tables to identify how the data is ingested from the DLO and how it's mapped to the DMO within Data Cloud.
Data for users and four engagement events is ingested. Each is mapped to a separate data stream, and each populates a separate DLO. Events are immutable and appended. Shopping cart and order events both have an event CSV and a line items CSV, which creates two data streams for each event. A total of seven data streams are created, one for users and six for engagement events.
These data mappings relate to data associated with the Marketing Cloud Personalization connector and how that data connects to DMOs.
Data Lake Objects (DLOs) | Customer 360 Data Model Objects |
---|---|
Base Events | WebsiteEngagement |
Cart | ShoppingCartEngagement |
Cart Events | |
CartItem | ShoppingCartProductEngagement |
Cart Events Items | ShoppingCartEngagement |
Catalog | ProductBrowseEngagement |
Catalog Events | ProductBrowseEngagement |
Consent | PrivacyConsentLog |
Users | Individual, EmailContactPoint, PartyIdentification |
Order | ProductOrderEngagement |
Order Events | ProductOrderEngagement |
OrderItems | SalesOrderProductEngagement |
Order Line Items |
Field API Name | Customer 360 Data Model Objects | Object Field |
---|---|---|
profileId__c | Individual | Id |
profileId__c | ContactPointEmail | Contact Point Email Id |
profileId__c | ContactPointEmail | Party |
emailAddress__c | ContactPointEmail | EmailAddress |
profileId__c | PartyIdentification | Party Identification Id |
sfmcContactKey__c | PartyIdentification | IdentificationNumber |
sfmcPartyIdentificationName__c | PartyIdentification | IdentificationName |
sfmcPartyIdentificationType__c | PartyIdentification | IdentificationType |
anonymous__c | ||
customerId__c | ||
extUserId__c | ||
sfUserId__c | ||
DataSource__c | ||
DataSourceObject__c | ||
InternalOrganization__c |
Catalog events record when a user looks at an item.
Field API Name | Customer 360 Data Model Objects | Object Field |
---|---|---|
id__c | ProductBrowseEngagement | Id |
eventTime__c | ProductBrowseEngagement | Created Date |
eventTime__c | ProductBrowseEngagement | Engagement Date Time |
profileId__c | ProductBrowseEngagement | Individual |
emailAddress__c | ||
sfmcContactKey__c | ||
customerId__c | ||
action__c | ProductBrowseEngagement | Engagement Channel Action |
itemAction__c | ||
flagPageView__c | ||
sourceChannel__c | ProductBrowseEngagement | Engagement Channel Type |
sourceLocale__c | ProductBrowseEngagement | Device Locale |
sourcePageType__c | ||
sourceUrl__c | ProductBrowseEngagement | Product View URL |
sourceUrlReferrer__c | ProductBrowseEngagement | Referrer URL |
sourceDevice__c | ||
sourceOperatingSystem__c | ||
sourceOperatingSystemVersion__c | ||
sourceApplication__c | ||
sourceApplicationVersion__c | ||
catalogItemType__c | ProductBrowseEngagement | Product |
catalogItemId__c | ||
EventDate__c | ||
DataSource__c | ||
DataSourceObject__c | ||
InternalOrganization__c |
Order events record when a user completes a transaction.
Field API Name | Customer 360 Data Model Objects | Object Field |
---|---|---|
id__c | ProductOrderEngagement | Id |
eventTime__c | ProductOrderEngagement | Created Date |
eventTime__c | ProductOrderEngagement | Engagement Date Time |
profileId__c | ProductOrderEngagement | Individual |
emailAddress__c | ||
sfmcContactKey__c | ||
customerId__c | ||
action__c | ProductOrderEngagement | Engagement Channel Action |
itemAction__c | ||
flagPageView__c | ||
sourceChannel__c | ProductOrderEngagement | Engagement Channel Type |
sourceLocale__c | ProductOrderEngagement | Device Locale |
sourcePageType__c | ||
sourceUrl__c | ||
sourceUrlReferrer__c | ProductOrderEngagement | Referrer URL |
sourceDevice__c | ||
sourceOperatingSystem__c | ||
sourceOperatingSystemVersion__c | ||
sourceApplication__c | ||
sourceApplicationVersion__c | ||
orderId__c | ProductOrderEngagement | Sales Order Id |
orderTotalValue__c | ProductOrderEngagement | Net Order Amount |
orderCurrency__c | ProductOrderEngagement | Currency |
EventDate__c | ||
DataSource__c | ||
DataSourceObject__c | ||
InternalOrganization__c |