User tables with multiple audience levels

A user table can be associated with multiple audience levels, with one of the audience levels designated as the primary audience level, and the remaining audience levels as alternate audience levels.

Note: To enable flowchart designers to switch from one audience level to another or to scope one audience level by another, you must define at least one user table with all required audience levels. Unica Campaign can then use this table to "translate" between one audience level and another as needed.

For example, a user table that contains data about customer accounts could have the following columns:

  • Acct_ID
  • Indiv_ID
  • HHold_ID

In this table, the Acct_ID might be unique for each record. Because an individual could have multiple accounts, and a household could contain multiple individuals, multiple records could have the same values for the Indiv_ID and HHold_ID fields.

Assuming you have three audience levels, Account, Customer, and Household, when you map this user table, you could specify all three of these audience levels and associate them with the corresponding fields listed above in the user table. This enables flowchart designers to switch target audiences, or scope one audience level by another (for example, accounts per customer, customers per household, or accounts per household) when using this table.