Field Name

Description

Version Added

FreshnessDateTime

The date and time this data computed. (smalldatetime, NULL)

Added in 8.8

ListID

The ID of the list from lists_.ListID_. (int, NOT NULL)

Added in 8.8

ListName

The name of the list from lists_.name_. (varchar (60) NOT NULL)

Added in 8.8

MessageID

The outmailid_.MessageID_ of the mailing. (int (4), NOT NULL)

Added in 8.8

MessageTitle

Title of this mailing. (varchar (70) NOT NULL)

Added in 8.8

SentDate

The date and time this mailing was created (from outmail_.created_ (datetime, NULL)

Added in 8.8

SenderName

The name of the sender as it appears in the header From: (from outmail_.from_). (varchar (50) NULL)

Added in 8.8

Status

The status of this mailing. If there is at least 1 lyrCompletedRecip in PAUSED the status is Paused; if no lyrActiveRecip Completed; any other status is Active. (varchar (50) NOT NULL)

Added in 8.8

AttemptedCount

The number of recipients attempted: LyrActiveRecips successful, retry + lyrCompletedRecips transient failed, permanent failed, pending. (int (4), NOT NULL)

Added in 8.8

AttemptedPercent

The percentage of recipients attempted.

Added in 8.8

DeliveredCount

The number in lyrCompletedRecips successful. (int (4), NOT NULL)

Added in 8.8

DeliveredPercent

The number of successful deliveries as a percentage of number attempted.

Added in 8.8

TransientFailuresCount

The number in lyrCompletedRecips transient failed. (int (4), NOT NULL)

Added in 8.8

TransientFailuresPercent

The number of transient deliveries as a percentage of number attempted.

Added in 8.8

PermanentFailuresCount

The number in lyrCompletedRecips permanent failed. (int (4), NOT NULL)

Added in 8.8

PermanentFailuresPercent

The number of permanent deliveries as a percentage of number attempted.

Added in 8.8

UnsubscribesCount

Count of member_.UnsubMessageID = mailing id. (int (4), NOT NULL)

Added in 8.8

UnsubscribesPercent

The number of unsubscribes as a percentage of the number of successful deliveries.

Added in 8.8

ForwardsCount

Forwards as calculated by reports::forward_mailing_detail. (int (4), NOT NULL)

Added in 8.8

ReferralsCount

Referrers as calculated by reports::page_referafriend_statistics. (int (4), NOT NULL)

Added in 8.8

UniqueOpensCount

Count of unique opens, calculated as distinct MemberID_ from clicktracking_ where UrlID_ is null and StreamWebPageName_ is null. (numeric (5), NOT NULL)

Added in 8.8

UniqueOpensPercent

The number of unique opens as a percentage of the number of successful deliveries. (numeric (5), NOT NULL)

Added in 8.8

TotalClicksCount

Count of total clicks, calculated as count from clicktracking_ where UrlID_ is null and StreamWebPageName_ is null. (int (4), NOT NULL)

Added in 8.8

UniqueClicksCount

Count of unique clicks, calculated as count of distinct MemberID_ from clicktracking_ where UrlID_ is not null and StreamWebPageName_ is null. (int (4), NOT NULL)

Added in 8.8

UniqueClicksPercent

The number of recipients who have clicked at least one link in the mailing as a percentage of the number of successful deliveries. (numeric (5), NOT NULL)

Added in 8.8

TransactionsCount

The number of purchases recorded for this mailing, calculated as count from clicktracking_, clickstreamdata_ where Quantity_ > 0. (int (4), NOT NULL)

Added in 8.8

TransactionsAmount

The amount purchased as a result of this mailing, calculated as the sum of (Quantity_*UnitPrice_) from clicktracking_, clickstreamdata_ where Quantity_ > 0. (numeric (9), NOT NULL)

Added in 8.8

ConversionPercent

The number of recipients who made a purchase as a percentage of the number of successful deliveries. (numeric (5), NOT NULL)

Added in 8.8

SurveysUniqueResponsesCount

The number of survey responses received from this mailing, as a count of lyrSurveyResponse. (int (4), NOT NULL)

Added in 8.8

SurveysUniqueResponsesPercent

The number of survey respondants as a percentage of the number of successful deliveries. (numeric (5), NOT NULL)

Added in 8.8