The following section describes the database tables used for the ATG Campaign Optimizer reporting functionality.
abr_control
This table contains information about the last time the ReportGeneratorService
was run. There is one record in this table.
Column | Data Type | Constraint |
---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID of the control record | |
TIMESTAMP | Null | |
The last time the |
abr_report
This table contains information about reports for individual tests.
Column | Data Type | Constraint |
---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID of the test | |
TIMESTAMP | Null | |
The last time the test report was updated | ||
VARCHAR(40) | Null | |
The test’s state the last time the report was updated |
abr_report_group
This table contains information about measurements (or metrics) for individual test groups.
Column | Data Type | Constraint |
---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID of the test groups | |
VARCHAR(40) | Null | |
The ID of the test | ||
INTEGER | Null | |
The number of participants in the group | ||
INTEGER | Null | |
The number of sessions by participants in the group | ||
INTEGER | Null | |
The number of times test content was viewed by participants in the group | ||
INTEGER | Null | |
The number of pages viewed by participants in the group |