This table stores information about click tracking, click stream, and open events.
Primary key: ClickID_
Field Name | Description | Version Added |
ClickID_ | An auto-numbering field to provide a unique ID. (int, NOT NULL) |
|
GroupID_ | The group that this click is associated with. (int, NOT NULL) |
|
IPAddress_ | The IP address of the user clicking on a link. Stored as an int. (int, NOT NULL) |
|
MemberID_ | The ID of the member who was sent the email which resulted in this click (int, NOT NULL) |
|
MessageID_ | The ID from the outmail_ table that represents the mailing that caused this event. (int, NOT NULL) |
|
StreamWebPageName_ | The user-provided name of the web page that caused this event. (varchar(255), NULL) |
|
TimeClicked_ | The time that the click event occurred. (smalldatetime, NOT NULL) |
|
UrlID_ | The ID from the URLs table that stores this URL. (int, NULL) |
|