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
|
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
|
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 |
|
|
|
|
|
|
|