Database Table: CPGNSTATS

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000315 MPE_ID Non-Unique Index
SQL030416034914330 INITIATIVE_ID, MPE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable