SubscriberSendResult
Provides information about message send outcomes at the individual subscriber level. This view helps identify whether a message was delivered, bounced, deferred, or otherwise processed for each subscriber, enabling detailed send-level analysis and troubleshooting.
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 SubscriberSendResult WHERE Id = 123 SELECT * FROM SubscriberSendResult WHERE Id IN (123, 456) SELECT * FROM SubscriberSendResult WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| Send_ID | Int | Specifies the unique identifier (Id) for the send that is associated with the subscriber's result record. This Id is read only and is managed by the system. |
| ID [KEY] | Int | Specifies the Id for the subscriber send-result record. This Id uniquely identifies the result object within the account and is read only. |
| Email_ID | Int | Specifies the Id of the email message that is associated with the subscriber's send result. This Id allows reporting systems to join send-result data with email-definition data. |
| Email_Name | String | Specifies the name of the email message that is associated with the subscriber's send result. This value provides user-friendly identification for reporting and auditing. |
| Subject | String | Specifies the subject line that is associated with the message that was sent to the subscriber. This value reflects the rendered subject at the time of send. |
| FromName | String | Specifies the 'From Name' value that is associated with the email message. This value reflects the branding that is applied at the time of send. |
| FromAddress | String | Specifies the 'From Address' value that is associated with the email message. This address represents the sending mailbox that is visible to the subscriber. |
| SentDate | Datetime | Specifies the date and time when the email message was sent to the subscriber. This timestamp is generated by the sending engine. |
| OpenDate | Datetime | Specifies the date and time when the subscriber opened the message. This value contributes to open-rate reporting and engagement analysis. |
| ClickDate | Datetime | Specifies the date and time when the subscriber clicked a link within the message. This value contributes to click-through tracking and engagement reporting. |
| Subscriber_Partnerkey | String | Specifies the partner-provided key that is associated with the subscriber for integration and correlation with external systems. This key is accessible only via the API. |
| Subscriber_EmailAddress | String | Specifies the email address of the subscriber who received the message. This address serves as the primary identifier for email delivery. |
| Subscriber_PartnerType | String | Specifies the partner-defined subscriber classification that is used for third-party correlation and integration workflows. |
| UnsubscribeDate | Datetime | Specifies the date and time when the subscriber unsubscribed as a result of the send. This value supports compliance reporting and audience-health analysis. |
| LastOpenDate | Int | Specifies the date the subscriber last opened the message, expressed as an integer timestamp. This value reflects the most recent engagement event. |
| LastClickDate | Int | Specifies the date the subscriber last clicked a link within the message, expressed as an integer timestamp. This value reflects the most recent click-through event. |
| BounceDate | Datetime | Specifies the date and time when the subscriber's email address generated a bounce for this send. This value supports deliverability reporting. |
| EventDate | Int | Specifies the date of the event that is associated with the send result, expressed as an integer timestamp for system processing. |
| TotalClicks | Int | Specifies the total number of clicks that are generated by the subscriber for the message. This value includes repeated clicks on the same link. |
| UniqueClicks | Int | Specifies the number of unique clicks that are performed by the subscriber for the message. This value counts each link only once per subscriber. |
| EmailAddress | Int | Specifies the 'From' address that is associated with the email message. This value is provided as an Id for reporting consistency. |
| Subscriber_ID | Int | Specifies the Id of the subscriber that is associated with the send result. This Id uniquely identifies the subscriber within the account and is read only. |
| SubscriberTypeID | Int | Specifies the Id that represents the subscriber type. This Id classifies subscriber records for system-level processing. |
| Subscriber_SubscriberKey | String | Specifies the subscriber key that uniquely identifies the subscriber across lists, business units, and data sources. |
| Send_PartnerKey | String | Specifies the partner-provided key that is associated with the send. This key is used for external correlation and is accessible only via the API. |
| PartnerKey | String | Specifies the partner-provided key that is associated with the send-result object. This key supports external system mapping and is accessible only via the API. |
| Client_ID | Int | Specifies the Id of the client account that owns the send-result record. This Id determines the account context for processing and reporting. |
| OtherBounces | Int | Specifies the number of bounces that are classified as Other-type bounces for the message. This value reflects bounce categories that do not fall into soft or hard classifications. |
| SoftBounces | Int | Specifies the number of soft bounces that are associated with the send. Soft bounces occur when temporary delivery issues prevent successful delivery. |
| HardBounces | Int | Specifies the number of hard bounces that are associated with the send. Hard bounces occur when permanent delivery issues prevent email acceptance. |