The following section describes the database tables used for the ATG Campaign Optimizer for Commerce metrics functionality.
abl_item_added
This table contains information about items added to orders during a test.
Column | Data Type | Constraint |
---|---|---|
VARCHAR(40) | not null | |
The dataset used to record when an item is added to an order | ||
VARCHAR(40) | null | |
The ID for the user who added an item to an order | ||
VARCHAR(100) | null | |
The session in which the item was added to the order | ||
TIMESTAMP | null | |
The time the item was added to the order | ||
VARCHAR(40) | null | |
The ID for the order | ||
VARCHAR(40) | null | |
The ID for the item added to the order | ||
INTEGER | null | |
The quantity of the item added to the order | ||
NUMERIC(19,7) | null | |
The cost of the item added to the order | ||
VARCHAR(40) | null | |
The currency associated with the amount for the order | ||
VARCHAR(40) | not null | |
The ID of the test | ||
VARCHAR(40) | null | |
The ID of the test group |
abl_order_submit
This table contains information about orders submitted during a test.
Column | Data Type | Constraint |
---|---|---|
VARCHAR(40) | not null | |
The dataset used to record when an order is submitted | ||
VARCHAR(40) | null | |
The ID for the user who submitted the order | ||
VARCHAR(100) | null | |
The ID for the session during which the order was submitted | ||
TIMESTAMP | null | |
The time the order was submitted | ||
VARCHAR(40) | not null | |
The ID for the order | ||
NUMERIC(19,7) | null | |
The cost of the order | ||
INTEGER | null | |
The number of items in the order | ||
VARCHAR(40) | null | |
The currency used for the order | ||
VARCHAR(40) | not null | |
The ID of the test | ||
VARCHAR(40) | null | |
The ID of the test group |
abl_order_abandon
This table contains information about incomplete orders that appear to have been abandoned by registered users who participated in a test.
Column | Data Type | Constraint |
---|---|---|
VARCHAR(40) | not null | |
The dataset used to record information about abandoned persistent orders | ||
VARCHAR(40) | Null | |
The ID for the user who abandoned the order | ||
TIMESTAMP | Null | |
The time when it was determined that the order had been abandoned | ||
VARCHAR(40) | not null | |
The ID for the order | ||
NUMERIC(19,7) | Null | |
The total cost of the order, including the cost of the items in it, shipping and tax | ||
VARCHAR(40) | Null | |
The currency used for the order | ||
VARCHAR(40) | not null | |
The ID of the test | ||
VARCHAR(40) | Null | |
The ID of the test group |
abl_trnsnt_abandon
This table contains information about orders that are abandoned by transient (non-logged in) users during a test.
Column | Data Type | Constraint |
---|---|---|
VARCHAR(40) | not null | |
The dataset used to record when a transient user abandons an order | ||
VARCHAR(40) | Null | |
The ID for the transient user | ||
VARCHAR(100) | Null | |
The session in which the transient user created the order | ||
TIMESTAMP | Null | |
The time the order was abandoned | ||
VARCHAR(40) | not null | |
The ID for the order | ||
NUMERIC(19,7) | Null | |
The total cost of the items in the order | ||
VARCHAR(40) | Null | |
The currency used for the order | ||
VARCHAR(40) | not null | |
The ID of the test | ||
VARCHAR(40) | Null | |
The ID of the test group |