lyrReportSummaryData
A table of mailing statistics aggregated by mailing number.
| Field Name |
Data Type |
Size (Precision, Scale) |
Nulls | Default | Description | Version Added |
|---|---|---|---|---|---|---|
| DbVersion | int | (0) | Contains information used to determine if older versions of completion status's will show up on the reports | Added in 9.3 | ||
|
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 |
|
|
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 | ||||