OpenEvent
Records open events for email sends in Salesforce Marketing Cloud. Each record includes the timestamp, subscriber key, and send context for an opened message. This view provides key engagement metrics for campaign performance analysis.
View-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM OpenEvent WHERE Id = 123 SELECT * FROM OpenEvent WHERE Id IN (123, 456) SELECT * FROM OpenEvent WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ID [KEY] | Int | Specifies the read-only identifier (Id) that uniquely identifies the open-event record. |
| ObjectID [KEY] | String | Specifies the system-controlled, read-only text string that serves as the unique object Id for the open-event record. |
| PartnerKey | String | Specifies the partner-supplied unique Id that external systems use to reference the event through the API. |
| CreatedDate | Datetime | Indicates the date and time when the open-event record was created. |
| ModifiedDate | Datetime | Indicates the date and time when information about the open-event record was last modified. |
| ClientID [KEY] | Int | Specifies the Id of the client that is associated with the open-event record. |
| SendID | Int | Specifies the Id of the specific send that is associated with the open event. |
| SubscriberKey | String | Specifies the value that identifies the subscriber who generated the open event. |
| EventDate | Datetime | Indicates the date and time when the open tracking event occurred. |
| EventType | String | Specifies the category of tracking event recorded for the open action. |
| TriggeredSendDefinitionObjectID | String | Specifies the system-generated object Id that links the open event to its associated triggered send definition. |
| BatchID | Int | Specifies the batch Id that groups the open event with related triggered-send activity. |