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.

Table 1. Sample UA_ActionCustomer table

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