Sample action table (UA_ActionCustomer)
The Unica Campaign system tables include a sample action table for the Customer audience level, called UA_ActionCustomer. The fields in this table are intended as examples of fields that may be useful for generating response history. Administrators can customize the table as needed. Typically, each audience level in Unica Campaign has its own action table, which is used for response tracking.
Column Name |
Data Type |
Length |
Allow Nulls |
---|---|---|---|
CustomerID |
bigint |
8 |
No |
ActionDateTime |
datetime |
8 |
No |
ResponseChannel |
varchar |
16 |
Yes |
CampaignCode |
varchar |
32 |
No |
OfferCode |
varchar |
64 |
No |
CellCode |
varchar |
64 |
No |
TreatmentCode |
varchar |
64 |
No |
ProductID |
bigint |
8 |
No |
ResponseTypeCode |
varchar |
64 |
Yes |