SubscriberSendResult
Reserved for future use.
View-Specific Information
Select
The component 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 component processes other filters client-side within the component.
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 | 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. |