lyrSplitTests

Below table records information about each Split Test. The settings here are used to drive the mails sent out as part of the split test, including the "Send to Rest" mail.

Field Name Description

Version Added

SplitTestID

Unique Split Test ID. (int, identity, NOT NULL)

Added in 9.0

Status

Status of the split test: processed

Added in 9.0

Created

Date the Split Test was created (datetime, NULL)

Added in 9.0

SentRestOn

Date the Split Test’s “Send Rest” mailing was sent (datetime, NULL)

Added in 9.0

Method

The Sampling method: N or P (for Number or Percentage), processed (VarChar(1), NOT NULL)

Added in 9.0

SampleSize

The Number to Sample (% or #, based on method) (int, NULL)

Added in 9.0

TrackOpens

Whether to track opens of the test and send-rest emails. T/F (char, NOT NULL)

Added in 9.0

DetectHTML

Whether to detect HTML in the test and send-rest emails. T/F (char, NOT NULL)

Added in 9.0

RecencyWhich

Recency Method, if any (m,f,e for more than, fewer than, or equal to) (char, NULL)

Added in 9.0

RecencyDays

Recency Day count to be used in comparison, based on RecencyWhich (int, NULL)

Added in 9.0

RecencyNumberOfMailings

Recency Mailings count to be used in comparisons for Recency restriction enforcement (int, NULL)

Added in 9.0

SendRestContentID

ID of the winning content (int, NULL)

Added in 9.0

PurgeMess

List of Message IDs to purge from mailing, if any (text, NULL)

Added in 9.0

SuppressionList

List of emails to suppress from the list, if any (text, NULL)

Added in 9.0

SuppressionListCount

Count of the emails in the Suppression List (int, NULL)

Added in 9.0

TrackAllUrls_