clicktracking_
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) |