Home
User Guide
Unica Optimize provides documentation and help for users, administrators, and developers.
Unica Optimize configuration properties
This section describes the Unica Optimize configuration properties that are found on the Configuration page.
Campaign | partitions | partition[n] | Optimize | DatabaseTuning
These configuration properties are for tuning the database.

User Guide
Unica Optimize provides documentation and help for users, administrators, and developers.
- About Unica Optimize
  Unica Optimize is a web-based extension of Unica Campaign that allows you to determine the optimal contact strategy for each customer. You can optimize over time, looking across the proposed offers and channels across multiple marketing campaigns.
- Getting started with Unica Optimize
  Unica Optimize 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.
- Unica Optimize sessions
  A Unica Optimize session is a combination of rules and scores that apply to a set of proposed contacts.
- Optimization rules
  Unica Optimize uses the rules and scores you define in your Unica Optimize session to mathematically determine the best combination of final contacts you use across your marketing campaigns.
- Setting up scores
  You use scores in Unica Optimize to rank possible offers for each customer using a patent-pending optimization algorithm. The higher the score you assign to a contact, the more desirable you are making that contact. Unica Optimize maximizes the sum of scores in the OCT.
- Generate a list of proposed contacts
  The optimization process involves generating a list of proposed contacts in Unica Campaign and sending these contacts to Unica Optimize to produce optimized contacts.
- Use optimized contacts in marketing campaigns
  After you optimize the proposed contacts, you must retrieve the optimized contacts from Unica Optimize to send marketing communications to these contacts.
- Viewing Reports
  For each production run or test run, Unica Optimize generates a number of reports. These reports help you understand what happened during the optimization process by providing analyses pre- and post-optimization.
- Administering Unica Optimize
  There are many aspects of Unica Optimize you can configure to improve performance.
- Unica Optimize configuration properties
  This section describes the Unica Optimize configuration properties that are found on the Configuration page.
  - Campaign | unicaACOListener
    These configuration properties are for Unica Optimize listener settings.
  - Campaign | partitions | partition[n] | Optimize | sessionRunMonitor
    These configuration properties are for sessionRunMonitor settings.
  - Campaign | partitions | partition[n] | Optimize | MemoryTuning
    These configuration properties are for the MemoryTuning settings.
  - Campaign | partitions | partition[n] | Optimize | AgentTemplateTables
    These configuration properties define template tables for Agent Capacity Optimization.
  - Campaign | partitions | partition[n] | Optimize | userTemplateTables
    This property defines the template tables that are used by the PCT and OCT.
  - Campaign | partitions | partition[n] | Optimize | TestRun
    This property defines the options to use for performing a test run of your Unica Optimize session.
  - Campaign | partitions | partition[n] | Optimize | AlgorithmTuning
    These configuration properties define settings that you can use to tune your optimizations.
  - Campaign | partitions | partition[n] | Optimize | DatabaseTuning
    These configuration properties are for tuning the database.
  - Campaign | partitions | partition[n] | Optimize | Debug
    This property defines debug level for processing the PCT.
  - Campaign | partitions | partition[n] | Optimize | TestRun
    This property defines the options to use for performing a test run of your Unica Optimize session.
  - Campaign | partitions | partition[n] | Optimize | logging
    This property defines logging settings for Unica Optimize.
  - Campaign | unicaACOOptAdmin
    These configuration properties define settings for the unicaACOOptAdmin tool.

Campaign | partitions | partition[n] | Optimize | DatabaseTuning

These configuration properties are for tuning the database.

UpdateSessionTableStatistics

Description

The UpdateSessionTableStatistics parameter adds a query for updating statistics of the PCT, RC, and POA tables during a Unica Optimize session run. You can tune this parameter at the session level without affecting other sessions. Keeping up-to-date index statistics can help improve the performance of the query on these tables. This parameter is also present in the global configuration settings of Unica Optimize.

Depending on your database, the method to write a query to update statistics varies.

Use following value to update statistics of DB2® tables:

CALL SYSPROC.ADMIN_CMD('RUNSTATS ON TABLE <TABLENAME>')

Note: If you use DB2® 8 or below, you must write your own custom stored procedure for implementing the functionality that is similar to SYSPROC.ADMIN_CMD. Also, you can write your own stored procedure to update statistics and start it through the UpdateSessionTableStatistics parameter at run time to update statistics.

Use the following value to update statistics of Oracle tables:

analyze table <TABLE> compute statistics

Use the following value to update statistics of SQL Server tables:

UPDATE STATISTICS <TABLE>

Important: If you run this query, the database user in UA_SYSTEM_TABLES must have privileges to run query, which is mentioned in this UpdateSessionTableStatistics parameter. For the session to run successfully, the correct value must be passed or left blank. If the value passed is incorrect, then the session run fails.

Default value

No default value defined.

AllowTempTables

Description: The AllowTempTables parameter creates temporary tables instead of database views, and populates them during the Unica Optimize session run. Enabling this parameter helps in improving run time performance of the Unica Optimize session run. For more information about this parameter, see Optimize a transaction query for performance improvements in the Unica Optimize Troubleshooting and Tuning Guide.
Default value: True
Valid values: True | False

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.