lyrMemberFirsts

 

A table used to aid the report summary task in identifying when a given mailing has resulted in a member first.

 

CAUTION This is an automated table; do not insert or delete any records. Doing so will cause database errors.

 

Field Name

Description

Version Added

MemberID

Reference to members_ table

Added in 9.0

openClickID

Click id of the first click for this member

Added in 9.0

openMailID

Mail ID of the mail which recorded the first click for this member

Added in 9.0

throughClickID

Click ID of the first click through for this member

Added in 9.0

throughMailID

mail ID of the mail which recorded the first through click for this member

Added in 9.0

transClickID

Click ID of the first transaction for this member

Added in 9.0

transMailID

Mail ID of the mail which recorded the first transaction for this member

Added in 9.0