The click event extract file shows all instances of a clicked link in an email occurring within the specified date range. The events in this report relate to all sends for subscribers on a list or related to a particular send.
Output Types
- CSV
- TAB
- XML
Columns
| Name | Description | Possible Values | Data Type | Character Length |
|---|---|---|---|---|
| ClientID | The system account identifier associated with 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 to 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 fileSubscriberIDcolumn. | Number | Maximum length - big integer | |
| ListID | Identifier for the list the job sent to | Number | Maximum length - big integer | |
| EventDate | Date click event occurred | Datetime | ||
| EventType | Identifier for the event type | Click | String | 6 |
| SendURLID | Unique identifier for individual URL in send | Number | Maximum length - big integer | |
| URLID | Value used by applicable database to identify target URL of the link | Number | Maximum length - big integer | |
| URL | Target URL of the link | String | 4000 | |
| Alias | Value in Alias attribute of the link | String | 500 | |
| 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 | |
| Browser | Browser where click event occurred. This field is included only if you selected Include User Agent Information. | Text | none | |
| EmailClient | Email client the subscriber received the email in. This field is included only if you selected Include User Agent Information. | Text | none | |
| OperatingSystem | Subscriber’s operating system. This field is included only if you selected Include User Agent Information. | Text | none | |
| Device | Device where click event occurred. This field is included only if you selected Include User Agent Information. | Text | none |