Table of contents
- 1. Description
- 2. Output Types
- 3. Columns
- 3.1. ClientID
- 3.1.1. Possible Values
- 3.1.2. Data Type
- 3.1.3. Length
- 3.2. SendID
- 3.3. SubscriberKey
- 3.4. Email Address
- 3.5. SubscriberID
- 3.6. ListID
- 3.7. EventDate
- 3.8. EventType
- 3.9. BatchID
- 3.9.1. Sample Data
- 3.9.2. Data Type
- 3.9.3. Length
- 3.10. TriggeredSendExternalKeu
- 3.11. Reason
- 3.1. ClientID
- 4. Schema Relationship
Description
This list contains information on send jobs and messages that were not sent.
Output Types
- CSV
- TAB
Columns
ClientID
Specifies the ExactTarget account identifier associated with attribute set.
Possible Values
-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
Data Type
Number
Length
Maximum Length (Big Integer)
SendID
The ExactTarget identifier associated to an email send.
Data Type
Number
Length
Maximum Length (Big Integer)
SubscriberKey
Specifies the customer-specified subscriber unique identifier associated with attribute set. By default, the value is the same as EmailAddress.
Data Type
String
Length
100
Email Address
Specifies the subscriber email address identifier associated with attribute set.
Data Type
String
Length
100
SubscriberID
Specifies the ExactTarget-generated subscriber unique identifier associated with attribute set.
SubscriberID relates to the Subscriber's SubscriberID column.
Data Type
Number
Length
Maximum Number / Big Integer
ListID
The ExactTarget identifier for the list that the job was sent to.
Data Type
Number
Length
Maximum Number / Big Integer
EventDate
The date the click event occurred.
Data Type
DateTIme
Length
EventType
Identifies the event type. For this extract, this field contains NotSent.
Data Type
String
Length
6
BatchID
Identifies the batch associated with a triggered email sent event if the email message was a batch triggered email.
Sample Data
SendID,EventDate,SubscriberKey,EmailAddress,TriggeredSendExternalKey,BatchId
1234,1/2/2009,"dmccrory@example.com","dmccrory@example.com","Coupon",1
1234,1/2/2009,"dmccrory@example.com","dmccrory@example.com","Coupon",2
1238,1/10/2009,"dmccrory@example.com","dmccrory@example.com","Coupon",1
Data Type
smallint
Length
TriggeredSendExternalKeu
The external key associated to a triggered send defnition if the bounce resulted from a triggered send request.
Data Type
String
Length
100
Reason
Data Type
Length
Schema Relationship
- Tag page
- What links here
Images 1
