You are here: ListManager Programmer's Guide > ListManager Tables > Logging > lyrRecipientTracking

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

   

Lyris, Inc.

6401 Hollis Street., # 125

Emeryville, CA 94608



Customer Support:

1-888-LYRIS-CS (1-888-597-4727)

or

1-571-730-5259



Hours:

Monday through Friday

6:00 a.m.--6:00 p.m. PST

Self-Serve Portal:

http://www.lyris.com/customer-service/contact-support/