A table of mailing statistics aggregated by mailing number.
Field Name |
Data Type |
Size (Precision, Scale) |
Nulls |
Default |
Description |
Version Added |
attempted |
int
|
4
|
Added in 9.3
|
|||
finish_date |
datetime
|
16
|
X |
Added in 9.3
|
||
id |
int |
4 |
|
|
Mailing id references outmail, deletes from outmail are not cascaded |
Added in 9.0 |
EarliestPauseID |
int |
4 |
X |
|
Id of the first paused completed recipient in last incremental update |
Added in 9.0 |
EarliestSoftFailID |
int |
4 |
X |
|
Id of the first soft fail completed recipient in last incremental update |
Added in 9.0 |
FirstRecipientID |
int |
4 |
X |
|
First completed recipient to contribute to aggregate stats |
Added in 9.0 |
FirstClickID |
int |
4 |
X |
|
First click to contribute to aggregate stats |
Added in 9.0 |
active |
int |
4 |
|
(0) |
Number of records for corresponding mailing that were in lyractiverecips last time it was checked |
Added in 9.0 |
paused |
int |
4 |
|
(0) |
Number of 309 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
mailed |
int |
4 |
|
(0) |
Number of records in lyrcompletedrecips for this mailing, less 309 records. |
Added in 9.0 |
received |
int |
4 |
|
(0) |
Number of 300 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
opens |
int |
4 |
|
(0) |
Number of opens for this mailing |
Added in 9.0 |
opens_firsts |
int |
4 |
|
(0) |
Number of members for whom clicking on this mailing was their first |
Added in 9.0 |
total_clicks |
int |
4 |
|
(0) |
|
Added in 9.0 |
clicks_firsts |
int |
4 |
|
(0) |
|
Added in 9.0 |
unique_clicks |
int |
4 |
|
(0) |
Number of unique ‘member id/mail id/ click id’ events for this mailing |
Added in 9.0 |
trans |
int |
4 |
|
(0) |
|
Added in 9.0 |
trans_firsts |
int |
4 |
|
(0) |
|
Added in 9.0 |
trans_amt |
int |
4 |
|
(0) |
|
Added in 9.0 |
soft_fails |
int |
4 |
|
(0) |
Number of 301 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
hard_fails |
int |
4 |
|
(0) |
Number of 302 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
perm_fails |
int |
4 |
|
(0) |
Number of 302 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
dns_temps |
int |
4 |
|
(0) |
Number of 303 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
bad_doms |
int |
4 |
|
(0) |
Number of 304 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
bounces |
int |
4 |
|
(0) |
Number of 305 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
invalids |
int |
4 |
|
(0) |
Number of 306 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
mes_missings |
int |
4 |
|
(0) |
Number of 307 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
expirations |
int |
4 |
|
(0) |
Number of 308 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
skips |
int |
4 |
|
(0) |
Number of 310 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
aborts |
int |
4 |
|
(0) |
Number of 311 records in lyrcompletedrecips for this mailing |
Added in 9.0 |
unsubs |
int |
4 |
|
(0) |
Number of members who have clicked a unsubscribe link, or sent an unsubscribe e-mail |
Added in 9.0 |
forwards |
int |
4 |
|
(0) |
Number of members opening this message from different domains, not counting one domain which would correspond with the original recipient. |
Added in 9.0 |
referrals |
int |
4 |
|
(0) |
Number of sender records in the referrals table corresponding to this mailing |
Added in 9.0 |
new_members |
int |
4 |
|
(0) |
Number of receiver records in the referral table corresponding to this mailing |
Added in 9.0 |
start_date |
datetime |
8 |
X |
|
The date of the first completed recip record |
Added in 9.0 |
Created |
datetime |
8 |
X |
|
The created date copied from the outmail_ table |
Added in 9.0 |
DeliverBefore |
smalldatetime |
4 |
X |
|
copied from the outmail_ table (NULL for MSSQL only) |
Added in 9.0 |
InmailBodySize |
int |
4 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
Priority |
tinyint |
1 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
SplitTestID |
int |
4 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
SplitPartID |
int |
4 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
SubsetID |
int |
4 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
ListID |
int |
4 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
InmailHdrForm |
varchar |
238 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
OutmailFrom |
varchar |
200 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
List |
varchar |
60 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
Title |
varchar |
70 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
OutmailTo |
varchar |
200 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
Subject |
varchar |
200 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
DescShort |
varchar |
200 |
X |
|
copied from the outmail_ table |
Added in 9.0 |
Type |
varchar |
50 |
|
|
copied from the outmail_ table |
Added in 9.0 |
unique_opens |
int |
4 |
X |
(0) |
|
Added in 9.0 |
unique_trans |
int |
4 |
X |
(0) |
|
Added in 9.0 |
units |
|
|
|
|
Number of units purchased by member who received this mailing |
9.2 |
streams |
|
|
|
|
Number of pages viewed by members who received this mailing |
9.2 |
unique_streams |
|
|
|
|
mber of recipients who viewed at least one page linked by this message. |
9.2 |
survey_responses |
|
|
|
|
Used for reports |
9.2 |
complaints |
|
|
|
|
count of unique users complaining for this mailing (int, NOT NULL) |
9.2 |
pre10_complaints | user complaints from before verson 10 (int, NOT NULL) |
10.0
|
||||
successes | successful deliveries (int, NOT NULL) | 10.0 | ||||
immediate_transients | undelivered recipients with at least 1 retry (int, NOT NULL) | 10.0 | ||||
final_technicals | undelivered recipients due to remove server issues (int, NOT NULL) | 10.0 | ||||
unknowns | recipients with unclassified errors (int, NOT NULL) | 10.0 | ||||
invalid_users | number of invalid email addresses for this mailing (int, NOT NULL) | 10.0 | ||||
blocked_contents | recipients rejected due to the content being sent (int, NOT NULL) | 10.0 | ||||
likely_blocked | users failed due to ISPs blocking the MailStream (int, NOT NULL) | 10.0 | ||||
internal_stops | undelivered recipients due to paused, skipped or aborted mailings (int, NOT NULL) | |||||
blocks | unused (int, NOT NULL) | 10.0 | ||||