Marketing Cloud Personalization Bundle 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 360
  • 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 360 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 360 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 360.

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.

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  

Users DLO Mapping

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 DLO Mapping

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 DLO Mapping

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