Creating Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition user profile tables

Some features of Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM® SPSS® Modeler Advantage Enterprise Marketing Management Edition, such as global offers, offer suppression, and score override, require specific tables in your user profile databases. Run SQL scripts to create the required user tables.

Use your database client to run the appropriate SQL scripts against the appropriate database or schema and create the required user tables. If you have multiple audience levels defined, you must create a table for each audience level.

When you create your databases, you should use the same code page for all of your databases. You cannot change this code page once it is set. If you did not create your databases to use the same code page, you must use only the characters supported in the code page. For example, if you create a zone in global offers that does not use a character in the profile database code page, the global offer does not work.

For more information about the profile database, and the role that offer suppression, global offers, and score override tables play in offer serving, see the HCL Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition Administrator's Guide.

User profile tables

You must use SQL scripts to create the following optional profile tables:

  • Global offers table (UACI_DefaultOffers)
  • Offer suppression table (UACI_BlackList)
  • Score override table (UACI_ScoreOverride)

The SQL scripts are in the ddl directory under your Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition installation.

You must run the SQL scripts once for every audience level. Modify the script for each audience level, after the first, and rename the profile tables that are created after you run the scripts.

Use the scripts in the following table to create the Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition user profile tables:

Table 1. Scripts for creating user profile tables

This two-columned table provides information about the data source type in one column, and the script name in the second column.
Data source type Script name

HCL DB2®

 aci_usrtab_db2.sql

Microsoft™ SQL Server

 aci_usrtab_sqlsvr.sql

Oracle

 aci_usrtab_ora.sql

Advanced scoring (optional)

For Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition built-in learning, you can use the advanced scoring feature to override components of the Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition learning algorithm.

All the SQL scripts are in the ddl/acifeatures directory under your Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition installation.

If your scoring tables are configured for Unicode, use the appropriate script in the ddl/acifeatures/Unicode directory under your Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition installation to create the learning tables. You must run the SQL scripts against the User Profile database.

Use the scripts in the following table to create the Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition scoring tables:

Table 2. Scripts for creating advanced scoring tables

This two-columned table provides information about the data source type in one column, and the script name in the second column.
Data source type Script name

HCL DB2

 aci_scoringfeature_db2.sql

Microsoft SQL Server

 aci_scoringfeature_sqlsvr.sql

Oracle

 aci_scoringfeature_ora.sql