|
Field Name
|
Description
|
Version Added
|
|
FinalAttempt
|
smalldatetime(16); NULL
|
Added in 9.3
|
|
RecipientID
|
Copied from RecipientID in lyrcompletedrecip (NULL for MSSQL only)
|
Added in 9.0
|
|
CompletionStatus ID
|
Copied from CompletionStatusID in lyrcompletedrecips
|
Added in 9.0
|
|
MailingID
|
Copied from MailingID in lyrcompletedrecips
|
Added in 9.0
|
|
FirstAttempt
|
Copied from FirstAttempt in lyrcompletedrecips
|
Added in 9.0
|
|
RecordCount
|
-1 or 1 depending on the trigger that inserted corresponding record
|
Added in 9.0
|
|
OpenCount
|
Number
of opens accumulated for this recipient
|
9.2
|
|
ClickCount
|
Number
of clicks accumulated for this recipient
|
9.2
|
|
StreamCount
|
Number of streams accumulated for this recipient
|
9.2
|
|
TransCount
|
Number of purchases accumulated for this recipient
|
9.2
|
|
UniqueOpen
|
1 if this recipient recently opened the message
|
9.2
|
|
UniqueClick
|
1 if this recipient recently clicked the message
|
9.2
|
|
UniqueStream
|
1 if this recipient recently viewed a page linked by the message
|
9.2
|
|
UniqueTrans
|
1 if this recipient recently purchased from a page linked by the
message
|
9.2
|
|
Units
|
Number of units accumulated for this recipient
|
9.2
|
|
Forwards
|
Number of forwards accumulated for this recipient
|
9.2
|
|
Amount
|
Amount of purchases accumulated for this recipient
|
9.2
|
|
Unsubs
|
Number of unsubs
accumulated for this recipient
|
9.2
|
|
MemberID
|
Reference to members_
table
|
9.2
|
|
ReferralCount
|
Number of referrals
accumulated for this member
|
9.2
|
|
ReferredCount
|
Count of individuals
referred accumulated for this member
|
9.2
|
|
SurveyResponseCount
|
Number of survey
responses accumulated for this member
|
9.2
|
|
ForwardCount
|
Number of forwards
accumulated for this member
|
9.2
|
|
UnsubCount
|
Number of unsubs
accumulated for this member
|
9.2
|
|
UnitCount
|
Number of units
accumulated for this member
|
9.2
|
|
SubAmount
|
Amount of purchases
accumulated for this member
|
9.2
|