This table records the relevant data of a recommendation event. It captures which campaign was run, which campaign activity was run, the e-Marketing Spot, which customer segments were involved, and what was recommended to the customer.
Column Name | Column Type | Description |
---|---|---|
USRTRAFFIC_ID | BIGINT NOT NULL | The user traffic identifier as described in the USRTRAFFIC_ID column of the USRTRAFFIC table. |
STOREENT_ID | INTEGER NOT NULL | The store entity identifier as described in the STOREENT_ID column of the STOREENT table. |
MPE_ID | INTEGER NOT NULL | The e-Marketing Spot identifier as described in the EMSPOT_ID column of the EMSPOT table. |
MPETYPE_ID | INTEGER | Reserved for IBM internal use. |
MPENAME | VARCHAR(64) | The name of the e-Marketing Spot as described in the NAME column of the EMSPOT table. |
INITIATIVE_ID | INTEGER NOT NULL | The campaign activity identifier as described in the INITIATIVE_ID column of the INITIATIVE table. |
MPETYPENAME | VARCHAR(64) | The identifier of the e-Marketing Spot type, the possible values are: P (product recommendation) C (category recommendation) A (awareness advertisement) S (product association) |
CAMPAIGN_ID | INTEGER | The campaign identifier as described in the CAMPAIGN_ID column of the CAMPAIGN table. |
SHOPSEGMENTS | VARCHAR(254) | A comma-delimited list of customer segment names in which the customer fell into when a recommendation was run. |
RESULTS | VARCHAR(254) | 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. |
INITIATIVENAME | VARCHAR(64) | The name of the campaign activity as described in the NAME column of the INITIATIVE table. |
CAMPAIGNNAME | VARCHAR(64) | The name of a campaign as described in the NAME column of the CAMPAIGN table. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031216970 | USRTRAFFIC_ID+MPE_ID+INITIATIVE_ID | Primary Key |