Home
User Guide
Unica Campaign is a web-based solution that enables you to design, run, and analyze direct marketing campaigns.
Stored objects
If there are campaign components that you use frequently, you can save them as stored objects. Reusing stored objects across flowcharts and campaigns saves time and ensures consistency.
Derived fields
Derived fields are variables that do not exist in a data source and are created from one or more existing fields, even across different data sources.
Creating a derived field from an existing one
You can create a new derived field by basing it on an existing derived field, then changing the expression.

User Guide
Unica Campaign is a web-based solution that enables you to design, run, and analyze direct marketing campaigns.
- Unica Campaign overview
  Unica Campaign is a web-based solution that enables you to design, run, and analyze direct marketing campaigns.
- Creating and managing campaigns
  One of the first things you do in Unica Campaign is to create a marketing campaign to identify your objective. Each campaign is defined by its business objective, initiative, and effective date range. A campaign always consists of at least one flowchart, where you select recipients and assign offers. You can create, view, edit, delete, and perform similar operations on marketing campaigns.
- Designing flowcharts
  Unica Campaign flowcharts define the campaign logic. Each campaign consists of at least one flowchart. A flowchart performs a sequence of actions on data that is stored in your customer databases or flat files.
- Flowchart management
  Unica Campaign flowcharts define the campaign logic. Each flowchart in a campaign performs a sequence of actions on data that is stored in your customer databases or flat files.
- Send Time Optimization
  Send time optimization calculates the best time to contact the target customer via various channels based on past interactions.
- Offer management
  Offers are specific marketing communications that you send to particular groups of people, using one or more channels. Each offer is based on an offer template that a Unica Campaign administrator defines.
- Target cell management
  A cell is a group of people that you want to target, such as high value customers. A target cell is a cell that has an offer assigned to it.
- Contact history
  Unica Campaign maintains contact history to record information about offers that are sent to contacts. History is also recorded about control cells, to identify customers who are purposely not sent the offer.
- Unica Campaign response tracking
  Use the Response process in a flowchart to track the actions that occur after a campaign. When you run the Response process, data is recorded in the response history tables and is available for the Unica Campaign performance reports.
- Stored objects
  If there are campaign components that you use frequently, you can save them as stored objects. Reusing stored objects across flowcharts and campaigns saves time and ensures consistency.
  - Derived fields
    Derived fields are variables that do not exist in a data source and are created from one or more existing fields, even across different data sources.
    - Naming restrictions for derived fields
    - Creating derived fields
      You can create fields from one or more existing fields, even across different data sources.
    - Creating a derived field from an existing one
      You can create a new derived field by basing it on an existing derived field, then changing the expression.
    - Creating a derived field based on a macro
      You can create a derived field by basing it on a macro.
    - Making derived fields persistent
      When you make a derived field persistent, you instruct Unica Campaign to store its calculated values and make them available to subsequent processes. This saves time and resources because Unica Campaign does not have to recalculate these values downstream in the flowchart.
    - Storing derived fields
      Store a derived field if you want to be able to use it in another process in the same or a different flowchart.
    - Using and managing stored derived fields
      A derived field that was stored can be used in another flowchart. A derived field consists of an expression, such as AccountType='gold'. Derived fields are variables that do not exist in a data source and are created from one or more existing fields, even across different data sources.
  - User variables
    Unica Campaign supports user variables, which can be used during process configuration when creating queries and expressions.
  - Custom macros
    A custom macro is a query that you create using an macro expression, raw SQL, or raw SQL that includes a value. Custom macros support the use of variables.
  - Templates
    A template is a group of selected and saved processes from flowcharts.
  - Stored table catalogs
    A table catalog is a collection of mapped user tables.
- Session flowcharts
  Sessions provide a way to create persistent, global "data artifacts" for use in all campaigns. Each session contains one or more flowcharts. Running a session flowchart makes the outcome of the session (the data artifacts) available globally to all campaigns.
- Unica Campaign reports overview
  Unica Campaign provides reports to aid in campaign and offer management.
- Special characters in Unica Campaign object names
  Some special characters are not supported in any Unica Campaign object names. In addition, some objects have specific naming restrictions.
- Packaging flowchart files for troubleshooting
  If you need help from HCL to troubleshoot a flowchart, you can automatically collect relevant data to send to the Technical Support.

Creating a derived field from an existing one

You can create a new derived field by basing it on an existing derived field, then changing the expression.

About this task

Only fields from tables that are selected in the process configuration dialog can be used in a derived field expression. If a desired table does not appear, make sure it is selected as a source table.

Procedure

From the configuration window of a process that supports derived fields, click Derived fields.

The Create Derived Field dialog opens.
From the Field name list, select an existing derived field.

The expression for the selected field appears in the Expression area.
Change the name of the existing derived field to the name that you want to use for the new derived field.
Important: You cannot use the words "Yes" or "No" as names for derived fields. Doing so results in database disconnects when these derived fields are called.
Edit the derived field expression.
Click OK.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.