File Layouts for Holdout Group
The following table describes the layouts of the Holdout Group export files.
|
Field Name |
Type and Max Length |
Null? |
Description/Comments |
|---|---|---|---|
|
EVENT_TYPE_ID |
NUMBER |
N |
Numerical value that denotes the event type for the given event transaction. See Contact Event Type IDs for more information. |
|
ACCOUNT_ID |
NUMBER |
N |
Account number (for example, 1234) |
|
LIST_ID |
NUMBER |
N |
Numerical identifier for the List object used by the campaign |
|
RIID |
NUMBER |
N |
Unique ID assigned for this specific List record |
|
CUSTOMER_ID |
VARCHAR2(255) |
Y |
A unique identifier of the recipient/record that matches a customer ID or unique identifier in your system of record |
|
CUSTOM_PROPERTIES |
|
Y |
|
|
EVENT_CAPTURED_DT |
TIMESTAMP |
N |
Date and time the system was informed about the event, in UTC |
|
EVENT_STORED_DT |
TIMESTAMP |
N |
Date the event transaction was stored into the Event DB, in UTC |
|
PROGRAM_ID |
NUMBER |
N |
Numerical identifier of the given Program |
|
HOLDOUT_ID |
VARCHAR2(255) |
N |
Unique identifier of the Holdout Group stage in the program |
|
COMPARE_TO_CAMPAIGN_ID |
NUMBER(38,0) |
Y |
Campaign ID of comparison campaign that may or may not have lift over the holdout group. A NULL value means the holdout group is compared against all campaigns in the program. |