Summary of "clicktracking_" fields for ListManager

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)