An Open event extract file shows open instances of an HTML email during the date range. The open events relate to all sends for subscribers on a list or to a particular send.
Output Types
- CSV
- TAB
- XML
Columns
| Name | Description | Possible Values | Data Type | Character Length |
|---|---|---|---|---|
| ClientID | System account identifier associated with the attribute set | -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) | Numeric | Maximum length - big integer |
| SendID or JobID | Identifier associated with an email send | Number | Maximum length - big integer | |
| SubscriberKey | Customer-specified subscriber unique identifier associated with attribute set. By default, the value is the same as EmailAddress. | String | 254 | |
| EmailAddress | Subscriber email address identifier associated with attribute set | String | 254 | |
| SubscriberID | System-generated subscriber unique identifier associated with attribute set. SubscriberID relates to the Subscribers file SubscriberID column. | Number | Maximum length - big integer | |
| ListID | Identifier for the list the job sent to | Number | Maximum length - big integer | |
| EventDate | Date event occurred | Datetime | ||
| EventType | Identifier for the event type | Open | String | 6 |
| BatchID | Identifies batch associated with a triggered email sent event - defaults to 0 for a marketing list send |
Sample values: SendID,EventDate,SubscriberKey,EmailAddress,TriggeredSendExternalKey,BatchId 1234,1/2/2009,"example@example.com","example@example.com","Coupon",1 1234,1/2/2009,"example@example.com","example@example.com","Coupon",2 1238,1/10/2009,"example@example.com","example@example.com","Coupon",1 |
Number | Maximum length - big integer |
| TriggeredSendExternalKey | External key associated to a triggered send definition if the bounce resulted from a triggered send request | String | 100 |