lyrRecipientTracking
This table is updated during the incremental and full report summaries.
This table stores intermediate calculations for the report lyrReportSummaryData table.
|
Field Name |
Description |
Version Added |
|---|---|---|
|
RecipientID |
Reference to lyrCompletedRecips |
9.2 |
|
MemberID |
Reference to members_ |
9.2 |
|
MailingID |
Reference to outmail_ |
9.2 |
|
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 |
|
UnitCount |
Number of units accumulated for this recipient |
9.2 |
|
ForwardCount |
Number of forwards accumulated for this recipient |
9.2 |
|
SubAmount |
Amount of purchases accumulated for this recipient |
9.2 |
|
UnitCount |
Adding columns to lyrRecipientTracking |
9.2 |
|
SubAmount |
Adding columns to lyrRecipientTracking |
9.2 |
|
ForwardCount |
Adding columns to lyrRecipientTracking |
9.2 |
|
ContentFieldParamID |
Create table lyrContentFieldParams |
9.2 |