When creating a data stream in Data 360 using a Marketing Cloud Personalization (formerly Interaction Studio) starter bundle, the system creates standard mappings for you.
Available in: All Editions supported by Data 360. See Data 360 edition availability.
Products:
- Data 360
- Marketing Cloud Personalization
Event and attribute mappings that aren't included in the 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.
DLO to DMO Mapping
These data mappings relate to data associated with the Marketing Cloud Personalization connector and how that data connects to DMOs.
Data Lake Objects to Customer 360 Data Model Mapping
| 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 |