The following section describes the database tables used for the ATG Campaign Optimizer metrics functionality.
abl_page_visit
This table contains information about page visit data collected during a test.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
The dataset used to record page visit information | ||
VARCHAR(40) | null | |
The ID of the user making the page visit | ||
VARCHAR(100) | null | |
The session in which the page visit occurred | ||
TIMESTAMP | null | |
The time of the page visit | ||
VARCHAR(254) | null | |
The URL that was visited | ||
VARCHAR(40) | not null | |
The ID of the test | ||
VARCHAR(40) | null | |
The ID of the test group | ||
abl_started
This table contains information about test starts.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
The dataset used to record test start information | ||
Timestamp | Null | |
The date and time the test started | ||
VARCHAR(40) | not null | |
The ID of the test | ||
abl_ended
This table contains information about test ends.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
The dataset used to record test end information | ||
TIMESTAMP | null | |
The date and time the test ended | ||
VARCHAR(40) | not null | |
The ID of the test | ||
abl_user_group
This table contains information about user’s membership in test groups.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
The dataset used to record when a user is assigned to or unassigned from a test group | ||
VARCHAR(40) | not null | |
The ID of the user joining or being removed from a test group | ||
VARCHAR(100) | null | |
The session in which the user joined or was removed from the test group | ||
TIMESTAMP | null | |
The time at which the user joined or was removed from the test group | ||
VARCHAR(40) | not null | |
The ID of the test | ||
VARCHAR(40) | null | |
The ID of the group | ||
abl_content_viewed
This table contains data on content viewed during a test.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
The dataset used to record content viewed events | ||
VARCHAR(40) | null | |
The ID of the user viewing the content | ||
VARCHAR(100) | null | |
The session in which the content was viewed | ||
TIMESTAMP | null | |
The time at which the content was viewed | ||
VARCHAR(40) | not null | |
The ID of the test | ||
VARCHAR(40) | null | |
The ID of the group being tested | ||
abl_session
This table contains information about sessions for test participants.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
The dataset used to record session information | ||
VARCHAR(40) | Null | |
The ID of the user of the session | ||
VARCHAR(100) | not null | |
The ID of the session | ||
TIMESTAMP | Null | |
The time the session ended | ||
VARCHAR(40) | not null | |
The ID of the test | ||
VARCHAR(40) | Null | |
The ID of the test group | ||
