The following section describes the database table used for the ATG Campaign Optimizer marker functionality.

abt_markers

This table contains information about user participants in tests.

Column

Data Type

Constraint

marker_id

VARCHAR(40)

not null

(primary key)

The ID of the marker

profile_id

VARCHAR(40)

not null

The ID of the user containing the marker

marker_key

VARCHAR(100)

not null

The marker key (atg.abtests)

marker_value

VARCHAR(100)

null

The value of the marker (the test ID)

marker_data

VARCHAR(100)

null

The data stored in the marker (the group ID)

creation_date

TIMESTAMP

null

The date this marker was added to the profile

Version

INTEGER

not null

The repository version used to prevent conflicting changes

marker_type

INTEGER

null

For future use