Reference > Database > WebSphere Commerce database tables > E
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 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 SQL100520030334420 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 _vcc_freeselect_bottom_