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