This table contains the details of what was
displayed to a customer on a store page in an e-Marketing Spot as a
result of an experiment.
Column Descriptions:
| Name | Type | Description |
| DMEXPLOG_ID | BIGINT NOT NULL | The unique identifier of the experiment log
entry. |
| STOREENT_ID | INTEGER NOT NULL | The ID of the store. |
| 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. |
| PERSONALIZATIONID | VARCHAR (30) NOT NULL | The unique personalization identifier of a
customer. |
| CREATED | TIMESTAMP NOT NULL | The time this experiment log entry was
created. |
| CLICKED | SMALLINT NOT NULL DEFAULT 0 | Has the customer clicked on the item displayed in
the eMarketing Spot. 0 - the customer has not clicked the item; 1-
the customer has clicked the item. |
| VALUE | VARCHAR (254) NOT NULL | The ID of the item that was displayed in the
e-Marketing Spot. |
| CONTENTTYPE | VARCHAR (254) NOT NULL | The type of content that was displayed. Valid
values include: CatalogGroup, CatalogEntry, MarketingContent. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | DMEXPLOG_ID | Primary Key |
| I0001198 | STOREENT_ID+PERSONALIZATIONID+CREATED | Non-Unique Index |
| I0001199 |
STOREENT_ID+EXPERIMENT_ID+TESTELEMENT_ID+CREATED | Non-Unique Index |