lyrUnsummarizedRecips
Below is a table of recipients that has been completed, but not 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 |
| 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 |