SubscriberSendResult
Reserved for future use.
View-Specific Information
Select
The driver 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 driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.
For example, the following (but not only) queries are processed server side:
SELECT * FROM SubscriberSendResult 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 | Read-only identifier for an object. |
| ID [KEY] | Int | Read-only identifier for an object. |
| Email_ID | Int | Read-only identifier for an object. |
| Email_Name | String | Name of the object or property. |
| Subject | String | Contains subject area information for a message. |
| FromName | String | Specifies the default email message From Name. |
| FromAddress | String | Indicates From address associated with a object. |
| SentDate | Datetime | Indicates date on which a send took place. |
| OpenDate | Datetime | Specifies data on which a subscriber opened a send. |
| ClickDate | Datetime | Specifies the data subscriber clicked a link included in a send. |
| Subscriber_Partnerkey | String | Unique identifier provided by partner for an object, accessible only via API. |
| Subscriber_EmailAddress | String | The email address of the subscriber. |
| Subscriber_PartnerType | String | The partner type of the subscriber. |
| UnsubscribeDate | Datetime | Indicates the date on which an unsubscribe event took place due to a send. |
| LastOpenDate | Int | Specifies the date subscribe was last opened. |
| LastClickDate | Int | Specifies the date subscribe was last clicked. |
| BounceDate | Datetime | Contains the date on which an individual send bounced for a subscriber. |
| EventDate | Int | Indicated the date of the event. |
| TotalClicks | Int | Indicates total number of clicks on link in message. |
| UniqueClicks | Int | Indicates number of unique clicks on message. |
| EmailAddress | Int | Indicates From address associated with a object. |
| Subscriber_ID | Int | Read-only identifier for an object. |
| SubscriberTypeID | Int | Read-only identifier for an object. |
| Subscriber_SubscriberKey | String | The subscriber key of the subscriber. |
| Send_PartnerKey | String | Unique identifier provided by partner for an object, accessible only via API. |
| PartnerKey | String | Unique identifier provided by partner for an object, accessible only via API. |
| Client_ID | Int | The Id of the client. |
| OtherBounces | Int | Specifies number of Other-type bounces in a send. |
| SoftBounces | Int | Indicates number of soft bounces associated with a specific send. |
| HardBounces | Int | Indicates number of hard bounces associated with a send. |