Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMEXPSTATS
This table stores the statistics related to marketing experiments.
Column Name Column Type Description EXPERIMENT_ID INTEGER NOT NULL The identifier of the experiment within the activity. TESTELEMENT_ID INTEGER NOT NULL The identifier of the experiment path in the marketing activity. STOREENT_ID INTEGER NOT NULL DEFAULT 0 The identifier of the store. VIEWS INTEGER DEFAULT 0 The number of times (impressions) the result test element was shown to customers. VIEWORDERS INTEGER DEFAULT 0 The number of orders associated with the test element being viewed. VIEWREVENUE DECIMAL (20,5) DEFAULT 0 The revenue of the orders associated with the test element being viewed. CLICKS INTEGER DEFAULT 0 The number of times the result test element was clicked by the customers. CLICKORDERS INTEGER DEFAULT 0 The number of orders associated with the test element being clicked. CLICKREVENUE DECIMAL (20,5) 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. FIELD1 INTEGER Customizable field. FIELD2 BIGINT Customizable field. FIELD3 DECIMAL (20,5) Customizable field. FIELD4 VARCHAR(254) Customizable field. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030328220 EXPERIMENT_ID+TESTELEMENT_ID+STOREENT_ID Primary Key _vcc_freeselect_bottom_