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  |