Column Name | Type | Max Length | Column Description | Default Value | Allow Null | Read Only |
---|
id | Int32 | | The ID of the sent mailing. Typically referred to as MailingID or MessageID elsewhere. | | | |
active | Int32 | | Number of active recipients | | | |
paused | Int32 | | Number of paused recipients | | | |
mailed | Int32 | | Number of sent recipients | | | |
received | Int32 | | Number of successfully delivered recipients | | | |
opens | Int32 | | Total number of opens | | | |
total_clicks | Int32 | | Total number of clickthroughs | | | |
unique_clicks | Int32 | | Number of unique clickthroughs | | | |
trans | Int32 | | Total number of purchases | | | |
trans_amt | Decimal | | Total purchase amount | | | |
soft_fails | Int32 | | Number of recipients which failed with a transient error | | | |
hard_fails | Int32 | | Number of recipients which failed with a permanent error | | | |
perm_fails | Int32 | | Number of recipients which failed with a permanent error | | | |
dns_temps | Int32 | | Number of recipients which failed with a temporary DNS error | | | |
bad_doms | Int32 | | Number of recipients which failed with a permanent DNS error | | | |
bounces | Int32 | | Number of recipients which failed with an out of band DSN error | | | |
invalids | Int32 | | Number of recipients which were determined to be an illegal email address | | | |
mes_missings | Int32 | | Number of recipients which were mailmerge aborted due to missing demographic information | | | |
expirations | Int32 | | Number of recipients which met their final expiration without completion of at least one attempt | | | |
skips | Int32 | | Number of recipients which were mailmerge skipped | | | |
aborts | Int32 | | Number of recipients which were mailmerge aborted | | | |
unsubs | Int32 | | Total number of tracked unsubscribes | | | |
forwards | Int32 | | Number of estimated forwards | | | |
referrals | Int32 | | | | | |
Created | DateTime | | | | X | |
DeliverBefore | DateTime | | | | X | |
InmailBodySize | Int32 | | | | X | |
SplitTestID | Int32 | | | | X | |
SplitPartID | Int32 | | | | X | |
SubsetID | Int32 | | | | X | |
InmailHdrFrom | String | 238 | | | X | |
OutmailFrom | String | 200 | | | X | |
List | String | 60 | | | X | |
Title | String | 70 | | | X | |
OutmailTo | String | 200 | | | X | |
Subject | String | 1000 | | | X | |
Type | String | 50 | | | | |
unique_opens | Int32 | | Number of unique opens | | | |
unique_trans | Int32 | | Number of unique purchases | | | |
units | Int32 | | The total units purchased in all purchases | | X | |
streams | Int32 | | Total number of clickstreams | | X | |
unique_streams | Int32 | | Number of unique clickstreams | | X | |
engagement | Decimal | | The calculated engagement for this mailing | | | |
complaints | Int32 | | Total number of complaints | | X | |
attempted | Int32 | | Number of recipients that have been attempted at least once | | | |
finish_date | DateTime | | DateTime of the most recent recipient reaching final completion | | X | |
social_shares | Int32 | | Total number of social shares | | X | |
social_impressions | Int32 | | Total number of social impressions | | X | |
completed | DateTime | | DateTime of the last recipient reaching final completion | | X | |
MobileOpens | Int32 | | Total number of opens on mobile | | X | |
WebOpens | Int32 | | Total number of opens on web | | X | |
DesktopOpens | Int32 | | Total number of opens on desktop | | X | |
UnknownOpens | Int32 | | Total number of opens on unknown platforms | | X | |
UniqueMobileOpens | Int32 | | Number of unique opens on mobile | | X | |
UniqueWebOpens | Int32 | | Number of unique opens on web | | X | |
UniqueDesktopOpens | Int32 | | Number of unique opens on desktop | | X | |
UniqueUnknownOpens | Int32 | | Number of unique opens on unknown platforms | | X | |
MessageTypeID | Int32 | | | | X | |
DripCampaignID | Int32 | | | | X | |
IsTriggered | Boolean | | | | X | |
ModerateID | String | | | | X | |