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 EventsWebsiteEngagement
CartShoppingCartEngagement
Cart Events
CartItemShoppingCartProductEngagement
Cart Events ItemsShoppingCartEngagement
CatalogProductBrowseEngagement
Catalog EventsProductBrowseEngagement
ConsentPrivacyConsentLog
UsersIndividual, EmailContactPoint, PartyIdentification
OrderProductOrderEngagement
Order EventsProductOrderEngagement
OrderItemsSalesOrderProductEngagement
Order Line Items
Field API NameCustomer 360 Data Model ObjectsObject Field
profileId__cIndividualId
profileId__cContactPointEmailContact Point Email Id
profileId__cContactPointEmailParty
emailAddress__cContactPointEmailEmailAddress
profileId__cPartyIdentificationParty Identification Id
sfmcContactKey__cPartyIdentificationIdentificationNumber
sfmcPartyIdentificationName__cPartyIdentificationIdentificationName
sfmcPartyIdentificationType__cPartyIdentificationIdentificationType
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 NameCustomer 360 Data Model ObjectsObject Field
id__cProductBrowseEngagementId
eventTime__cProductBrowseEngagementCreated Date
eventTime__cProductBrowseEngagementEngagement Date Time
profileId__cProductBrowseEngagementIndividual
emailAddress__c
sfmcContactKey__c
customerId__c
action__cProductBrowseEngagementEngagement Channel Action
itemAction__c
flagPageView__c
sourceChannel__cProductBrowseEngagementEngagement Channel Type
sourceLocale__cProductBrowseEngagementDevice Locale
sourcePageType__c
sourceUrl__cProductBrowseEngagementProduct View URL
sourceUrlReferrer__cProductBrowseEngagementReferrer URL
sourceDevice__c
sourceOperatingSystem__c
sourceOperatingSystemVersion__c
sourceApplication__c
sourceApplicationVersion__c
catalogItemType__cProductBrowseEngagementProduct
catalogItemId__c
EventDate__c
DataSource__c
DataSourceObject__c
InternalOrganization__c

Order events record when a user completes a transaction.

Field API NameCustomer 360 Data Model ObjectsObject Field
id__cProductOrderEngagementId
eventTime__cProductOrderEngagementCreated Date
eventTime__cProductOrderEngagementEngagement Date Time
profileId__cProductOrderEngagementIndividual
emailAddress__c
sfmcContactKey__c
customerId__c
action__cProductOrderEngagementEngagement Channel Action
itemAction__c
flagPageView__c
sourceChannel__cProductOrderEngagementEngagement Channel Type
sourceLocale__cProductOrderEngagementDevice Locale
sourcePageType__c
sourceUrl__c
sourceUrlReferrer__cProductOrderEngagementReferrer URL
sourceDevice__c
sourceOperatingSystem__c
sourceOperatingSystemVersion__c
sourceApplication__c
sourceApplicationVersion__c
orderId__cProductOrderEngagementSales Order Id
orderTotalValue__cProductOrderEngagementNet Order Amount
orderCurrency__cProductOrderEngagementCurrency
EventDate__c
DataSource__c
DataSourceObject__c
InternalOrganization__c