Cell Variable Crosstab report: Profiling two characteristics of a cell simultaneously

Use the Cell Variable Crosstab report to profile data from two fields simultaneously for the specified cell. For example, you can select Age and Amount for the Gold.out cell to see the relative amount of purchases by age for clients with gold credit cards.

About this task

Each field that you select represents one axis of the grid. For example, you could select Age for the X axis and Amount for the Y axis. The report divides the field values into a number of bins along each axis. The size of the box at each intersection represents the relative number of customer IDs that have both attributes. For example, using Age and Amount, you can visually identify which age groups spent the most money.

Procedure

  1. Open a flowchart in Edit mode.
  2. Configure and run the process to generate the cell that you want to profile.
  3. Click Reports in the toolbar.
  4. Select Cell Variable Crosstab from the Report to view list.
  5. Select a cell from the Cell list.
  6. Select fields (variables) to profile from the Field 1 and Field 2 lists.
  7. (Optional) To modify the display, click Options , then change the following options:
    • Number of bins: Unica Campaign groups field values along each axis to create equal-sized segments, or bins. For example, if you specify four bins for Age, values might be grouped into bins of 20-29 and 30-39, 40-49, and 50-59. If the number that you specify is less than the number of different field values, some fields are joined in one bin. The default number of bins is 10.
    • Profile by meta type: This option is enabled by default. This option ensures that field values that represent dates, money, telephone numbers, and other numeric data are correctly sorted and binned, rather than sorting on ASCII text. For example, when you profile by meta type, dates are sorted as dates, not as numeric values.
    • View table: View the report in a table format.
    • View 2-D plot: View the report as a 2-D plot graph (the default). Right click the report to access more display options.
    • View 3-D plot: View the report as a 3-D plot graph. Right click the report to access more display options.
    • Cell 1 display: Specify how the cell information is displayed on the X-axis. For certain numeric fields, you can select fields to operate on from the Value field list.
    • Value field (For both Cell 1 display and Cell 2 display): Add a variable to the existing variable that is being profiled. This second variable will appear as a box within the box that represents the first variable.