To view click data for emails sent from your account, query the _Click data view in Automation Studio. Click data is retained for six months.
Dates and times are stored in Central Standard Time. Daylight Savings Time isn’t observed. To view time-related data in your time zone, set time zone user preferences.
Note When profile attributes are created in Enterprise 2.0 accounts, new columns are
added to the _EnterpriseAttribute table. Data view queries in Enterprise 2.0
accounts can return results from profile attribute columns in addition to the
columns listed here.
| Name | Description | DataType | Data Extension Data Type | Nullable |
|---|---|---|---|---|
| AccountID | Your account ID number. | int | Number | |
| OYBAccountID | The account ID number for any related On-Your-Behalf (OYB) accounts. This field applies to enterprise accounts only. | int | Number | X |
| JobID | The job ID number for the email send | bigint | Number | |
| ListID | The list ID number for the list used in the send | int | Number | |
| BatchID | The batch ID number for any batches used in the send | bigint | Number | |
| SubscriberID | The subscriber ID for the affected subscriber. This number represents the unique ID for each subscriber record. | int | Number | |
| SubscriberKey | The subscriber key for the affected subscriber | nvarchar(254) | Text | |
| EventDate | The date the click took place | datetime | Date | |
| Domain | The domain at which the click occurred | varchar(128) | Text | |
| URL | The URL for the link clicked. No AMPscript or variables are populated in this column, for example, www.example.com?%%attribute%% | varchar(900) | Text | X |
| LinkName | The link name assigned in the email send | varchar(1024) | Text | X |
| LinkContent | The link content assigned in the email send. AMPscript and variables are populated in this column, such as www.example.com?12345 | varchar(max) | Text | X |
| IsUnique |
Whether the event is unique or repeated Note Clicks are
processed in asynchronous batches. The earliest click event
written to the database will have IsUnique set to
true.
|
bit | Boolean | |
| TriggererSendDefinitionObjectID | The object ID for the triggered send definition | uniqueidentifier | Text | X |
| TriggeredSendCustomerKey | The customer key for the triggered send | varchar(36) | Text | X |