WebSphere Commerce database table: EXPSTATS

WebSphere Commerce database table: EXPSTATS

This table stores the statistics related to marketing experiments. The statistics include the number of impressions, the number of click-throughs, the number of orders generated by the display of the test element, and the total revenue associated with the orders.

Column Descriptions
Column Name Column Type Description

EXPERIMENT_ID INTEGER NOT NULL The marketing experiment identifier as described in the EXPERIMENT_ID column of the EXPERIMENT table.

TESTELEMENT_ID INTEGER NOT NULL The identifier of the test element that was shown to the customer.

STOREENT_ID INTEGER NOT NULL The store entity identifier as described in the STOREENT_ID column of the STOREENT table.

NAME VARCHAR(64) Name of the marketing experiment.

EXPTYPE_ID INTEGER The marketing experiment type identifer as described in the EXPTYPE_ID column of the EXPTYPE table.

CONTROLELEMENT CHAR(1) NOT NULL A flag that determines whether the test element is the control element or not. 0 - a test element 1 - a control element

DISPLAYS INTEGER DEFAULT 0 The number of times (impressions) the result test element was shown to customers.

CLICKS INTEGER DEFAULT 0 The number of times the result test element was clicked by the customers.

DISPLAYORDERS INTEGER DEFAULT 0 The number of orders associated with the test element being viewed.

DISPLAYREVENUE DECIMAL (20,5) DEFAULT 0 The revenue of the orders associated with the test element being viewed.

CLICKORDERS INTEGER DEFAULT 0 The number of orders associated with the test element being clicked.

CLICKREVENUE DECIMAL (20,5) NOT NULL DEFAULT 0 The revenue of the orders associated with the test element being clicked.

CURRENCY CHAR(3) The currency of the viewed and clicked order revenue.

FREQUENCY VARCHAR(10) The display frequency of the test element.

FIELD1 INTEGER Customizable

FIELD2 BIGINT Customizable

FIELD3 DECIMAL (20,5) Customizable

FIELD4 VARCHAR(254) Customizable

TESTELEMENTNAME VARCHAR(254) NOT NULL The name of the test element that was shown to the customer.

OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type

SQL060903235157410 EXPERIMENT_ID+TESTELEMENT_ID+STOREENT_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type

F_1506 EXPTYPE_ID EXPTYPE EXPTYPE_ID Cascade

Column Name	Column Type	Description
EXPERIMENT_ID	INTEGER NOT NULL	The marketing experiment identifier as described in the EXPERIMENT_ID column of the EXPERIMENT table.
TESTELEMENT_ID	INTEGER NOT NULL	The identifier of the test element that was shown to the customer.
STOREENT_ID	INTEGER NOT NULL	The store entity identifier as described in the STOREENT_ID column of the STOREENT table.
NAME	VARCHAR(64)	Name of the marketing experiment.
EXPTYPE_ID	INTEGER	The marketing experiment type identifer as described in the EXPTYPE_ID column of the EXPTYPE table.
CONTROLELEMENT	CHAR(1) NOT NULL	A flag that determines whether the test element is the control element or not. 0 - a test element 1 - a control element
DISPLAYS	INTEGER DEFAULT 0	The number of times (impressions) the result test element was shown to customers.
CLICKS	INTEGER DEFAULT 0	The number of times the result test element was clicked by the customers.
DISPLAYORDERS	INTEGER DEFAULT 0	The number of orders associated with the test element being viewed.
DISPLAYREVENUE	DECIMAL (20,5) DEFAULT 0	The revenue of the orders associated with the test element being viewed.
CLICKORDERS	INTEGER DEFAULT 0	The number of orders associated with the test element being clicked.
CLICKREVENUE	DECIMAL (20,5) NOT NULL DEFAULT 0	The revenue of the orders associated with the test element being clicked.
CURRENCY	CHAR(3)	The currency of the viewed and clicked order revenue.
FREQUENCY	VARCHAR(10)	The display frequency of the test element.
FIELD1	INTEGER	Customizable
FIELD2	BIGINT	Customizable
FIELD3	DECIMAL (20,5)	Customizable
FIELD4	VARCHAR(254)	Customizable
TESTELEMENTNAME	VARCHAR(254) NOT NULL	The name of the test element that was shown to the customer.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.