To profile a field

Campaign automatically profiles a field when you select it in a field that has a corresponding Profile button. You can profile any field in any mapped data source.

1.	In the configuration window of a process where the Profile button appears, select the field that you want to profile. You can also profile derived fields.

The Profile Selected Field window appears.

Campaign profiles the data in the selected field. The categories and frequency counts dynamically update as profiling progresses.

You should wait until profiling is finished before using profiling results, to ensure that all categories have been processed and counts are complete.

When profiling is complete, the Profile Selected Field window displays:

The list of values in the selected field, displayed in the Category column, and the corresponding Count of IDs with that value.

The default maximum number of categories (distinct bins of values) that can be displayed is 25. Campaign automatically displays values in the maximum number of categories, grouping them to create approximately equal-sized segments. You can change the maximum number of categories.

The Statistics pane on the right displays the total count of IDs and other details about the data for that field, including:

The number of NULL values found

The total number of categories, or values, for that field

Statistical values for the data including the mean, standard deviation, minimum, and maximum values.

Mean, Stdev., Min., and Max. are not available for ASCII text fields. When you profile text fields, these values will appear as all zeros.