Adding custom attributes
You can add custom campaign, offer, and cell attributes to the Custom Campaign Attributes reporting schema.
Before you begin
Determine the following information:
- The value from the attribute's
AttributeID
column in theUA_CampAttribute
,UA_CellAttribute
, orUA_OfferAttribute
table, as appropriate - The data type of the attribute: string value, number value, or date/time value
About this task
To add custom attributes, complete the following steps.
Procedure
- Select .
- Expand .
- Select the type of column that matches the type of attribute that you want to add.
- In the form on the right, click New category name and enter the name of the custom attribute.
-
For Column Name, enter the name to use in the reporting schema for the
attribute.
Use all uppercase letters with no spaces.
- For Attribute ID, enter the ID of this attribute.
- For Value Type, specify the data
type of the attribute. Note: If you add an attribute that holds a currency value, specify NumberValue in the Value Type field. If you add an attribute whose Form Element Type was set to Select Box - String in Unica Campaign, specify StringValue in the Value Type field.
- Click Save Changes.