File Layouts for MVT
The following table describes the layouts of the MVT export files.
|
Field Name |
Type and Max Length |
Null? |
Description/Comments |
|---|---|---|---|
|
PROGRAM_ID |
NUMBER |
NO |
Numerical identifier for the given Program |
|
CAMPAIGN_ID |
NUMBER |
NO |
Numerical identifier of the specific campaign |
|
STAGE_ID |
STRING (25) |
NO |
The numeric identifier of a Program stage |
|
CAMPAIGN_VERSION |
NUMBER |
YES |
The identifier of the test version |
|
CAMPAIGN_VERSION |
VARCHAR2(255) |
NO |
The name of the test version |
|
TEST_START_DT |
DATETIME |
YES |
The date and time the MVT started |
|
TEST_END_DT |
DATETIME |
YES |
The date and time the MVT ended |
|
WINNER_SELECTION_TYPE |
CHAR (1) |
YES |
Automatic or manual |
|
TEST_SUCCESS_METRIC |
CHAR (1) |
YES |
This field stores the metric that determines the winning version of a test. Valid values are: O-Open rate C-Click-through rate N-Conversion rate U-Unsubscribe rate |
|
IS_WINNER |
CHAR (1) |
YES |
Identifies the winning version |
|
CAMPAIGN_VERSION_CONTENT |
STRING (1000) |
YES |
The content of the version |