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 |