Database Table: CPGNLOG

This table records the relevant data of a recommendation event. It captures which campaign was run, which initiative was run, the e-Marketing Spot, which customer profiles were involved, and what was recommended to the customer.

Column Name Column Type Column Description
CAMPAIGNNAME VARCHAR (64)
NULL
The name of a campaign as described in the NAME column of the CAMPAIGN table.
CAMPAIGN_ID INTEGER
NULL
The campaign identifier as described in the CAMPAIGN_ID column of the CAMPAIGN table.
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 EMSPOT table.
MPETYPENAME VARCHAR (64)
NULL
The name of the e-Marketing Spot type as described in the NAME column of the MPETYPE table.
MPETYPE_ID INTEGER
NULL
Reserved for IBM internal use.
MPE_ID INTEGER
NOT NULL
The e-Marketing Spot identifier as described in the EMSPOT_ID column of the EMSPOT table.
RESULTS VARCHAR (254)
NULL
A comma-delimited list of category entry identifiers (for suggestive selling) or ad copy identifiers (for awareness advertisements). This column stores what was recommended to the customer.
SHOPSEGMENTS VARCHAR (254)
NULL
A comma-delimited list of customer profile names in which the customer fell into when a recommendation was run.
STOREENT_ID INTEGER
NOT NULL
The store entity identifier as described in the STOREENT_ID column of the STOREENT table.
USRTRAFFIC_ID BIGINT
NOT NULL
The user traffic identifier as described in the USRTRAFFIC_ID column of the USRTRAFFIC table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034914040 USRTRAFFIC_ID, MPE_ID, INITIATIVE_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