lyrDAOMailStreamTracking
The lyrDAOMailStreamTracking is used to hold aggregated sending attempt data for each Mailstream, for a specific completion status within the specified interval.
The intervals are of five minutes approximately, and are accumulated in memory before being written to this table. Data for one week is kept in this table.
| Field Name | Description | Version Added |
|---|---|---|
|
MailStreamID |
The MailStream associated with this data (int, NULL) |
10.1 |
| CompletionStatusID |
The completion status, from the lyrLookupCompletionStatus table. (int, NULL) |
10.1 |
| Count |
The number of send attempts resulting with this CompletionStatusID within the interval (int, NULL) |
10.1 |
| IntervalStart |
Start time of the collection interval (smalldatetime, NOT NULL) |
10.1 |
| IntervalEnd |
End time of the collection interval (smalldatetime, NOT NULL) |
10.1 |