After a data stream is deployed, the Marketing Cloud Account Engagement data stream maps source objects from Account Engagement to data model objects (DMOs) in Data 360. The Email Activity object includes email engagement data.
DLO to DMO Mapping
These data mappings relate to the Email Activity object used with the Account Engagement connector. You can add to the data mappings, but don’t change the automatically generated mappings.
| DLO Field | DLO Field Data Type | DMO | DMO Field | Additional Details |
|---|---|---|---|---|
| accountEngagementBusinessUnitId | text | — | — | |
| createdAt | dateTime | Email Engagement | Engagement Date Time | The createdAt value of the visitor activity record in Account Engagement. |
| emailBounceReason | text | Email Engagement | Bounce Reason | The Account Engagement description of the bounce reason. Only populated when the eventType is BOUNCE. |
| emailBounceType | text | Email Engagement | Email Bounce Type | Possible values include: <ul><li>SOFT</li><li>HARD</li></ul>Only populated when the eventType is BOUNCE.</pi> |
| engagementChannelType | text | Email Engagement | Engagement Channel Action Type | The default, read-only value is EMAIL . |
| eventType | text | Email Engagement | Engagement Channel Action | Identifies the type of Email Activity from these possible values: <ul><li>SEND_STATUS: Corresponds to Account Engagement visitor Activity Type 6 (Sent)</li><li>OPEN: Corresponds to Account Engagement visitor Activity Type 11 (Open)</li><li> CLICK: Corresponds to Account Engagement visitor Activity Type 1 (Click)</li><li> BOUNCE: Corresponds to Account Engagement visitor Activity Type 13 (Bounced)</li><li> UNSUBSCRIBE: Corresponds to Account Engagement visitor Activity Type 12 (Unsubscribed)</li><li> COMPLAINT: Corresponds to Account Engagement visitor Activity Type 14 (Spam Complaint)</li><li> SUBSCRIBE: Corresponds to Account Engagement visitor Activity Type 16 (Resubscribed)</li></ul> Learn more in the Account Engagement API documentation. |
| externalId | text | Email Engagement | External Record Id | ID of the Account Engagement Visitor Activity record. |
| externalListEmailId | text | — | — | ID of the Account Engagement List Email record. |
| externalProspectId | text | — | — | ID of the Account Engagement Prospect record. |
| externalSourceId | text | Email Engagement | External Source Id | The default, read-only value is pi. This ID is used to determine whether the given record was ingested from Account Engagement. |
| id | text | Email Engagement | Email Engagement Id | Primary key. |
| polymorphicListEmailId | text | Email Engagement | Bulk Email Message | ID of the Salesforce List Email record. |
| prospectEmail | text | Email Engagement | Sendtime Email Address | Email address of the recipient at the time of data ingestion from Account Engagement to Data 360. |
| prospectId | text | — | A unique Visitor ID for Visitor Page View within a specific Account Engagement business unit. To preserve uniqueness across multiple business units, the format of this field is <pi-pr-account_id-prospect_id>. |
|
| prospectSalesforceId | text | Email Engagement | Contact Point & Individual | ID of the Salesforce record synced with the Account Engagement Prospect record. |
| redirectUrl | text | Email Engagement | Link URL | The URL that the prospect is redirected to when the link is clicked. Only populated when the eventType is CLICK. |
| refreshedAt | dateTime | — | — | Time when the export was processed in Account Engagement, used as the recordModified Field in Data 360. Updates to the record ingested by Data 360 if this dateTime value is newer than the current record. |
| saleforceOrgId | text | — | — | |
| sendStatus | text | Email Engagement | Email Recipient Send Status | The default, read-only value is SENT. Only populated when the eventType is SEND_STATUS. |
| updatedAt | dateTime | — | — | Time the Account Engagement visitor activity updates. Visitor activity records update when prospects are merged in Account Engagement. |