Campaign | partitions | partition[n] | Deliver | contactAndResponseHistTracking

Unica Campaign uses its own ETL process to extract, transform, and load offer response data from the Unica Deliver tracking tables into the Unica Campaign contact and response history tables.

The ETL process coordinates information across the necessary tables, including UA_UsrResponseType (Unica Campaign response types) and UA_RespTypeMapping (mapping of response types between Unica Campaign and Unica Deliver).

Setting the value to Yes ensures that information about Unica Deliver offer contact and response history is coordinated between Unica Campaign and Unica Deliver. For example, email response data will be included in Unica Campaign reports.

No

Yes | No

Indicate whether the ETL process should run only once a day.

If the value is Yes: You must specify a startTime; the ETL job then runs until all records are processed; and the sleepIntervalInMinutes is ignored.

If the value is No: The ETL job starts as soon as the Campaign web server starts. The ETL job stops after all of the records are processed, then waits for the time specified by sleepIntervalInMinutes.

No

Yes | No

The ETL process uses this parameter to fetch records that have been downloaded by the RCT into the local Unica Deliver system tables. Because large values can impact performance, the list of available values is restricted to the valid values shown below. If you anticipate large volumes of records, adjust the batchSize together with the sleepIntervalInMinutes to process records at regular intervals.

100

100 | 200 | 500 | 1000

Specify the interval in minutes between ETL jobs. This option determines the wait time after a job finishes. The ETL process waits for this duration before starting the next job. Multiple jobs can run synchronously and there may be multiple ETL jobs per partition.

If runOnceADay is Yes, you cannot set a sleep interval.

60

Positive integers

Specify a time to start the ETL job. You must use the English locale format to specify the start time.

12:00:00 AM

Any valid time in the format hh:mm:ss AM/PM

An optional executable or script file that is run after each ETL job is done. For example, you might want to be notified of the success or failure of each ETL job, for monitoring purposes. The notification script runs every time the ETL job for a given partition finishes running.

The parameters passed in to this script are fixed and cannot be changed. The following parameters can be used by the script:

No default value defined.

Any valid path that the Unica Campaign server can access with Read and Execute permissions. For example: D:\myscripts\scriptname.exe

• Yes (Default): When the Flowchart runs, if the Deliver process box has records then OLT is erased and recalculated. If records from segment is empty, then the process box does not run.
• No: When the Flowchart runs and OLT is erased and recalculated regardless of whether the Deliver process box has records, the process box will run.