Treatment history (UA_Treatment)
Rows are added to the treatment history table (UA_Treatment) each time a flowchart is run in production mode. In other words, if you have a flowchart scheduled to run periodically, each new run generates a new set of treatments, one for each offer per cell, for both contact and control cells, at flowchart run time. Campaign thus provides the most granular tracking possible, by recording as a separate instance each time a treatment is generated.Treatment history works together with base contact history to provide a highly compressed and efficient way to store complete contact history information. The base contact history table (UA_ContactHistory) records only the cell membership information for the appropriate audience, while the treatment(s) given to each cell are recorded in the treatment history table (UA_Treatment).
Each treatment instance is identified with a globally unique treatment code that can be used in response tracking to directly attribute to a specific treatment instance.
Treatment history also records control cell data if controls are used. Rows pertaining to offers given to a target cell are called target treatments. Rows pertaining to offers given to a control cell are called control treatments. Target treatments will have an associated control treatment if a control cell was assigned to the target cell in the contact process. Each control treatment is also assigned a unique treatment code, although the codes are not distributed to hold-out control members. Control treatment codes are generated to facilitate custom response tracking where custom flowchart logic is used to identify a control: control treatment codes can be looked up and associated with the event so that the response can be attributed to an exact control treatment instance.