Skip to main content

Compare Behavior Tool Icon Compare Behavior Tool


The Behavior Analysis tools have been deprecated as of version 2022.3. These tools will continue to work with US Business Insights Data Packages 2021 Q4 and earlier versions.

Use Compare Behavior to analyze 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 might need to use an Append Fields tool to append a comparison Profile record to the other records.

Configure the Tool


Set the default dataset from User Settings. Go to Options > User Settings > Edit User Settings and select the Tools tab. Next, use the Dataset Defaults section to make your selections.

  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. 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 with the Workflow Dependencies to ensure consistency throughout your workflow.

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

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

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

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

    Use Long Names: When checked, returns long field names. When left unchecked, shorter less descriptive field names are used. The table below displays available fields for output.

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