This table contains the statistics related to campaigns. The statistics include the number of impressions and the number of clickthroughs.
Column Name | Column Type | Column Description |
---|---|---|
CLICKS | INTEGER NULL |
The number of times the e-Marketing Spot recommendation was clicked by customers. |
INITIATIVENAME | VARCHAR (64) NULL |
The name of the initiative as described in the NAME column of the INITIATIVE table. |
INITIATIVE_ID | INTEGER NOT NULL |
The initiative identifier as described in the INITIATIVE_ID column of the INITIATIVE table. |
MPENAME | VARCHAR (64) NULL |
The name of the e-Marketing Spot as described in the NAME column of the MPE table. |
MPETYPENAME | VARCHAR (64) NULL |
The e-Marketing Spot type name as described in the NAME column of the MPETYPE table. |
MPETYPE_ID | INTEGER NULL |
The e-Marketing Spot type identifier as described in the MPETYPE_ID column of the MPETYPE table. |
MPE_ID | INTEGER NOT NULL |
The e-Marketing Spot identifier as described in the MPE_ID column of the MPE table. |
STOREENT_ID | INTEGER NOT NULL |
The store entity identifier as described in the STOREENT_ID column of the STOREENT table. |
VIEWS | INTEGER NULL |
The number of times (impressions) an e-Marketing Spot recommendation was shown to customers. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000315 | MPE_ID | Non-Unique Index |
SQL030416034914330 | INITIATIVE_ID, MPE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|