ODBC Driver for Salesforce Data Cloud

Build 24.0.9175

EmailEngagement

The Email Engagement DMO is a Data Cloud data model object (DMO) for data captured from various data sources about engagement in the Email channel.

Columns

Name Type References Description
Account Contact Varchar A reference ID to account contact.
Action Cadence Step Varchar A reference ID to action cadence step.
Case Varchar A reference ID to a recorded issue, for example laptop connectivity.
City Name Varchar The city of recipient derived from IP address at time of engagement event.
Contact Point Varchar A reference ID to accounts’ contact point, for example physical address, email address, or phone number.
Country Varchar A reference ID to country of recipient derived from IP address at time of engagement event.
Created Date Datetime The date the record was created.
Data Source Varchar A reference ID for the logical name for a system that is the source of records identified by external record ID.
Data Source Object Varchar A reference ID for the logical name of the object where this record came from, whether that is a name of a cloud storage file or another connector’s external object.
Device Country Varchar A reference ID to the country where device is located.
Device IP Address Varchar The IP address of device.
Device Latitude Double The Geo latitude of the device when engagement was recorded.
Device Locale Varchar A reference ID to user locale configured on device.
Device Longitude Double The Geo longitude of the device when engagement was recorded.
Device Postal Code Varchar The postal code associated with device.
Email Domain Name Varchar The subset of email address that represents domain after @ sign.
Email Engagement Id Varchar A unique ID used as primary key for the Email Engagement DMO.
Email From Address Varchar The email address of sender profile associated with email at time of send.
Email From Name Varchar The sender profile name associated with email at time of send.
Email Name Varchar The email message name associated at time of send.
Engagement Asset Varchar A reference ID to the engagement asset.
Engagement Channel Varchar A reference ID to the engagement channel.
Engagement Channel Action Varchar A reference ID to the engagement channel action.
Engagement Channel Type Varchar A reference ID to the type of engagement channel.
Engagement Date Time Datetime The date and time of engagement. Engagement records result from activities occurring later than the send, so Engagement Date Time must be later than Send Date Time.
Engagement Event Direction Varchar The engagement event direction where values are Inbound or Outbound.
Engagement Notes Varchar The details about what transpired during engagement.
Engagement Number Varchar A user-facing ID that isn’t automatically set using auto-number.
Engagement Publication Varchar A reference ID to background process that generates volumes of email messages, SMS messages, or other Engagement Vehicle types. Publications can be specific to Engagement Channel Actions.
Engagement Type Varchar A reference ID to the type of engagement, for example email or phone.
Engagement Vehicle Varchar A reference ID for the engagement vehicle.
External Record ID Varchar A reference ID for an external data source system.
External Source ID Varchar A reference ID for the system in which the external record ID was assigned.
Individual Varchar A reference ID to contact for account.
Internal Engagement Actor Varchar A reference ID to engagement actor that groups the different types of individuals targeted for marketing engagements, for example leads and account contacts.
Internal Organization Varchar A reference ID to the business unit or other internal organization that owns the business account.
Is Test Send Varchar A flag to indicate if an engagement record was generated as part of testing.
Last Modified Date Datetime The date when a user last modified the record.
Lead Varchar A reference ID to person or company that showed interest in products.
Link URL Varchar The link where software application or web page accessed, generated the engagement.
Market Audience Varchar A reference ID to the intended audience that engagement was designed to reach.
Market Journey Activity Varchar A reference ID to step or activity that customer configures in Salesforce Journey Builder tool for marketing associated with engagement.
Market Segment Varchar A reference ID to group of people who share one or more common characteristics, and are grouped for marketing associated with engagement.
Marketing Email List Varchar A reference ID to the marketing email list used for the engagement.
Name Varchar The name of the engagement.
Referrer Varchar The name of a generic marketing method that generated user engagement, for example a campaign or search advertisement. For example, a campaign or search advertisement.
Referrer URL Varchar The URL of application that directed user to the software application that generated engagement.
Sales Order Varchar An internal document generated by seller indicating that customer is ready to purchase products and services.
Send Classification Varchar A reference ID to how consent is checked, for example Transactional such as placing an order implies opt-in for an order confirmation email or a commercial promotional email requiring opt-in
Sent Date Time Datetime The date and time of send.
Session Varchar A reference ID to session used to group related events together.
Shopping Cart Varchar A reference ID to the shopping cart for data captured from user actions, for example adding or removing items from shopping cart.
State Province Varchar A reference ID to the state of recipient derived from IP address at time of engagement event.
State Province Code Varchar A reference ID to the state/province code of recipient derived from IP address at time of engagement event.
Subject Line Text Varchar The associated email subject line at the time of send.
Target Engagement Actor Varchar A reference ID to engagement actor that groups different types of individuals targeted for marketing associated with engagement, for example leads and account contacts.
Task Varchar A reference ID to business activity, for example making a phone call. In the user interface, tasks and event records are collectively referred to as activities.
Web Cookie Varchar A reference ID to a small piece of data sent from website and stored on user's computer by user's web browser while user is browsing.
Workflow Varchar A reference ID to a sequence of steps or processes in software application where a piece of work passes from initiation to completion.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175