Clearing contact history and response history

Clearing contact and response history permanently deletes history records from the system tables. This data is not recoverable.

Before you begin

The following procedure permanently deletes contact and response history. If later recovery might be required, back up the system table database prior to clearing any history.
Note: History is also permanently deleted when you delete a campaign. In this case, you are prompted to continue. If you continue, the entire campaign and all of its contents, including all contact and response history, is deleted.

About this task

You might want to delete contact or response history records in the following situations:

  • If a production run was executed by mistake.
  • If you decide to cancel a campaign after a production run.

You can choose to delete all associated contact and response history records, or delete only the response history records. Usually, it is best not to delete contact history for which responses have been recorded. However, you have the option of doing so.

Referential integrity across Unica Campaign system tables is always preserved. All contact history tables are written to simultaneously, and any clean up of contact history is done simultaneously across all contact history tables. For example, treatment table entries cannot be deleted if there are entries in the base or detailed contact history tables referencing them.

To permanently delete contact and/or response history for a contact process, follow the steps below.


  1. In a flowchart in Edit mode, double-click the contact process whose history you want to permanently delete.
  2. In the process configuration dialog, click the Log tab. You see the window for configuring logging of contact transactions.
  3. Click Clear history.

    If no contact history entries exist, a message indicates that there are no entries to clear.

  4. If contact history exists, specify which entries to delete:
    • All entries
    • All entries within a selected date range
    • Specific flowchart runs identified by the run date and time
  5. Click OK.

    If no response history records exist for the entries that you selected, you see a confirmation message.

  6. If response history records exist for any of the entries that you selected, use the Clear History Options dialog to select an option:
    • Clear all associated contact and response history records: Both contact history and response history are cleared for the entries you specified.
    • Clear associated response history records only: Only response history is cleared for the entries you specified. Contact history records are retained.
    • Cancel: No contact history or response history records are cleared.