You are here: Tools > All Tools > Compare Behavior

Compare Behavior Tool

The Compare Behavior tool analyses 2 Profile sets, comparing one against the other. Think of it as building a sentence: "Analyze'this/these'Using 'this/these'."

This tool requires a single data stream with 2 Profile fields. You may need to use an Append Fields tool to append a comparison Profile record (Using) to the other (Analyze) records.

Configuration Properties

  1. Choose a Dataset: Select the Dataset to use. Each dataset has its own Profiles and Profile Sets that are specific to the selected clustering system. These datasets require a current subscription and license. Please contact your Alteryx account representative for more information regarding compatible datasets.

  2. For best results, keep your datasets consistent with each Behavior tool. Choosing "Most Recent Vintage" rather than a specific dataset ensures the most current dataset is used and won't require updating your workflow. You can easily specify the dataset in multiple tools at once through Workflow Dependencies to ensure consistency throughout your workflow.

    You can specify the default dataset from User Settings. Go to Options > User Settings > Edit User Settings and click the Dataset Defaults tab.

  3. Analyze: Select the data field that represents the Profile to use for analysis.

  4. Using: Select the data field that represents the Profile to use to compare the Analyze Profile against.

  5. Demographic: Classification level the Profile was built with. Choices include Auto-Detect, Household, Person, or Adult.

  6. Select Output Fields: Use the checkboxes to select the desired output fields. The buttons All and Clear can help with multiple selections.

Field Name Short Name

Market Potential (Users)


Market Potential Index (Users)


Market Potential (Volumetric)


Market Potential Index (Volumetric)


Spearman Correlation (Users)


Pearson Correlation (Users)


Spearman Correlation  (Penetration)


Pearson Correlation (Penetration)




Household Count

Household Count

Person Count

Person Count

Adult Count

Adult Count

Click Apply to have the configurations accepted.

Related Topics Link IconRelated Topics