ReportSummaryDataDataset.ReportSummaryDataDataTable

Column NameTypeMax LengthColumn DescriptionDefault ValueAllow NullRead Only
idInt32The ID of the sent mailing. Typically referred to as MailingID or MessageID elsewhere.
activeInt32Number of active recipients
pausedInt32Number of paused recipients
mailedInt32Number of sent recipients
receivedInt32Number of successfully delivered recipients
opensInt32Total number of opens
total_clicksInt32Total number of clickthroughs
unique_clicksInt32Number of unique clickthroughs
transInt32Total number of purchases
trans_amtDecimalTotal purchase amount
soft_failsInt32Number of recipients which failed with a transient error
hard_failsInt32Number of recipients which failed with a permanent error
perm_failsInt32Number of recipients which failed with a permanent error
dns_tempsInt32Number of recipients which failed with a temporary DNS error
bad_domsInt32Number of recipients which failed with a permanent DNS error
bouncesInt32Number of recipients which failed with an out of band DSN error
invalidsInt32Number of recipients which were determined to be an illegal email address
mes_missingsInt32Number of recipients which were mailmerge aborted due to missing demographic information
expirationsInt32Number of recipients which met their final expiration without completion of at least one attempt
skipsInt32Number of recipients which were mailmerge skipped
abortsInt32Number of recipients which were mailmerge aborted
unsubsInt32Total number of tracked unsubscribes
forwardsInt32Number of estimated forwards
referralsInt32
CreatedDateTimeX
DeliverBeforeDateTimeX
InmailBodySizeInt32X
SplitTestIDInt32X
SplitPartIDInt32X
SubsetIDInt32X
InmailHdrFromString238X
OutmailFromString200X
ListString60X
TitleString70X
OutmailToString200X
SubjectString1000X
TypeString50
unique_opensInt32Number of unique opens
unique_transInt32Number of unique purchases
unitsInt32The total units purchased in all purchasesX
streamsInt32Total number of clickstreamsX
unique_streamsInt32Number of unique clickstreamsX
engagementDecimalThe calculated engagement for this mailing
complaintsInt32Total number of complaintsX
attemptedInt32Number of recipients that have been attempted at least once
finish_dateDateTimeDateTime of the most recent recipient reaching final completionX
social_sharesInt32Total number of social sharesX
social_impressionsInt32Total number of social impressionsX
completedDateTimeDateTime of the last recipient reaching final completionX
MobileOpensInt32Total number of opens on mobileX
WebOpensInt32Total number of opens on webX
DesktopOpensInt32Total number of opens on desktopX
UnknownOpensInt32Total number of opens on unknown platformsX
UniqueMobileOpensInt32Number of unique opens on mobileX
UniqueWebOpensInt32Number of unique opens on webX
UniqueDesktopOpensInt32Number of unique opens on desktopX
UniqueUnknownOpensInt32Number of unique opens on unknown platformsX
MessageTypeIDInt32X
DripCampaignIDInt32X
IsTriggeredBooleanX
ModerateIDInt32X