The following section describes the database tables used for the ATG Campaign Optimizer for Commerce reporting functionality:
abr_dcs_rpt_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 group | |
INTEGER | Null | |
The total quantity of items added to orders | ||
INTEGER | Null | |
The number of submitted orders | ||
INTEGER | Null | |
The total quantity of items in submitted orders | ||
NUMERIC(197) | Null | |
The monetary amount submitted | ||
VARCHAR(40) | Null | |
The currency associated with contents of the | ||
INTEGER | Null | |
The number of sessions during which orders were submitted |
abr_dcsabd_rpt_gr
This table contains information about abandoned order metrics for individual test groups.
Column | Data Type | Constraint |
---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID of the test group | |
INTEGER | Null | |
The total number of orders that have been abandoned by registered users | ||
NUMERIC(19, 7) | Null | |
The total monetary value of orders abandoned by registered users | ||
INTEGER | Null | |
The number of orders abandoned by transient users | ||
NUMERIC(197) | Null | |
The total monetary value of orders abandoned by transient users |