Overview
You want to get the Time Opened from the database and need to know what table Time Opened is on.
Information
The clicktracking_ table stores events like Time Opened. Look for records where the URLID_ field (column) is blank. The field that stores the date/time that the message was opened is the TIMECLICKED_ field. See the table below for details on the fields in the clicktracking_ table.
| Field Name | Description |
| 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) This is seen as MailingID_ in other areas of ListManager. They are the same thing with different names. |
| 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) |
Priyanka Bhotika
Comments