A table of recipients that have been completed, but have not been incorporated into the report summary data. Filled by triggers on the lyrCompletedRecips table.
CAUTION This is an automated table; do not insert or delete any records. Doing so will cause database errors.
|
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 |
|
ComplaintCount |
Number of complaints 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 |