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.
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.

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.

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.

About this task

Derived fields are variables that do not exist in a data source; they are created from one or more existing fields, even across different data sources. A derived field is available only within the process where it was created. It is not available in any other process (except an immediately following process if Make persistent is enabled).

If you want to store a derived field definition so that you can use it in other processes and flowcharts, follow the procedure below.

Procedure

From the configuration window of a process that supports derived fields, click Derived fields and create the derived field that you want to store.
For example, define an expression such as (Balance / Credit_limit) * 100.
In the Create derived field dialog, open the Stored derived fields list and select Save current expression to stored list.
Use the Save derived field expression dialog to specify whether to save the expression in a folder. You can assign a security policy and optionally change the expression and assign it a different name. The expression that you save will be stored in a list that you can access when you configure other processes and flowcharts.
Click Save.

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.