DMEXPSTATS

This table stores the statistics related to marketing experiments.

Column Descriptions:

NameTypeDescription
EXPERIMENT_IDINTEGER NOT NULLThe identifier of the experiment within the activity.
TESTELEMENT_IDINTEGER NOT NULLThe identifier of the experiment path in the marketing activity.
STOREENT_IDINTEGER NOT NULL DEFAULT 0The identifier of the store.
VIEWSINTEGER DEFAULT 0The number of times (impressions) the result test element was shown to customers.
VIEWORDERSINTEGER DEFAULT 0The number of orders associated with the test element being viewed.
VIEWREVENUEDECIMAL (20,5) DEFAULT 0The revenue of the orders associated with the test element being viewed.
CLICKSINTEGER DEFAULT 0The number of times the result test element was clicked by the customers.
CLICKORDERSINTEGER DEFAULT 0The number of orders associated with the test element being clicked.
CLICKREVENUEDECIMAL (20,5) DEFAULT 0The revenue of the orders associated with the test element being clicked.
CURRENCYCHAR (3)The currency of the viewed and clicked order revenue.
FIELD1INTEGERCustomizable field.
FIELD2BIGINTCustomizable field.
FIELD3DECIMAL (20,5)Customizable field.
FIELD4VARCHAR (254)Customizable field.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EXPERIMENT_ID+TESTELEMENT_ID+STOREENT_IDPrimary Key