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 |