You are here: ListManager Programmer's Guide > ListManager Tables > Reporting > lyrMemberTracking

lyrMemberTracking

 

This table is updated during the incremental and full report summaries. It contains information for individual members aggregated across all mailings which have been sent to them. It is meant as a ready source of member information which would otherwise require timely aggregations.

 

Field Name

Description

Version Added

MemberID

Reference to members_ table

9.2

firstOpenClickID

Reference to clicktracking table

9.2

firstOpenMailID

Reference to outmail_ table

9.2

firstThroughClickID

Reference to clicktracking table

9.2

firstThroughMailID

Reference to outmail_ table

9.2

firstStreamClickID

Reference to clicktracking table

9.2

firstStreamMailID

Reference to outmail_ table

9.2

firstTransClickID

Reference to clicktracking table

9.2

firstTransMailID

Reference to outmail_ table

9.2

opens

Number of opens accumulated for this member

9.2

clicks

Number of clicks accumulated for this member

9.2

streams

Number of streams accumulated for this member

9.2

trans

Number of purchases accumulated for this member

9.2

forwards

Number of forwards accumulated for this member

9.2

uniqueOpens

Number of unique opens accumulated for this member

9.2

uniqueClicks

Number of unique clicks accumulated for this member

9.2

uniqueStreams

Number of unique streams accumulated for this member

9.2

uniqueTrans

Number of unique purchases accumulated for this member

9.2

mailed

Number of messages sent to this member

9.2

received

Number of successfully sent to this member

9.2