HCL TECHNOLOGIES ABOUT US PRODUCTS & SOLUTIONS RESOURCES CONTACT US

Home
HCL Contact Optimization User Guide
Contact Optimization provides documentation and help for users, administrators, and developers.
Getting started with Contact Optimization
Contact Optimization can optimize your marketing campaign and improve response from customers, but only if you know what you want to optimize. You need a plan, the data to support the plan, and an implementation method.
Create template tables
The template table is a table that you create in your database to append customized fields to the PCT and to the OCT. You can use these fields in your optimizations.
Creating a template table

Creating a template table

Procedure

Create a database table that contains all possible customized fields that you might want to use in your Contact Optimization sessions.
Create database views for each combination of fields that you want to use in a Contact Optimization session.
Note: The database table and the database views must exist in the same database where the system tables are located.
Add the new table and database views to the Campaign | partitions | partitionn | Optimize | userTemplateTables | tablenames configuration parameter with a comma delimited list.
For example, Database1.UACO_UserTable,Database1.view1.

Note: The names of the table and database views must be fully qualified. For example, database_schema.table_name or database_schema.view_name.