You are here: ListManager Programmer's Guide > ListManager Tables > Clicktracking > clicktracking_
 

Summary of "clicktracking_" fields for ListManager

 

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)

 

   

Lyris, Inc.

6401 Hollis Street., # 125

Emeryville, CA 94608



Customer Support:

1-888-LYRIS-CS (1-888-597-4727)

or

1-571-730-5259



Hours:

Monday through Friday

6:00 a.m.--6:00 p.m. PST

Self-Serve Portal:

http://www.lyris.com/customer-service/contact-support/