Skip to main content

Profile Rank Report Tool Icon Profile Rank Report Tool

Important

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 Profile Rank Report to take 2 Profile inputs (a Geography and a Product profile) and generate a rank report.

Important

This tool is a macro that requires a separate data install and license. To use this tool, contact your Account Executive.

When you use this macro in a workflow, be sure to enable Show all Macro Messages on the Runtime tab in the Workflow Configuration window so the final report is available in the Results window.

Configure the Tool

Important

Set the default dataset from User Settings. Go to Options > User Settings > Edit User Settings and open the Dataset Defaults tab.

  1. Input Geography Profile Tab

    • Choose Name: Select the Profile Name field from the dropdown list of available fields.

    • Choose Profile: Select the Profile field from the dropdown list of available fields.

  2. Input Product Profile Tab

    • Choose Name: Select the Profile Name field from the dropdown list of available fields.

    • Choose Profile: Select the Profile field from the dropdown list of available fields.

  3. Output Tab

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

    • Rank By: Determine how to position the report. Choices include...

      • Product: Which product is the most popular in the geography?

      • Geography: Which geographies represent the highest popularity for the product?

    • Select the output fields you would like on the report. Choices include...

      • 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)

      • Penetration

      • Female Adult Count

      • Household Count

      • Male Adult Count

      • Person Count

      • Adult Count

    • Select a field to order by: This is the ranking variable and determines the sort order of the report. Ensure the field specified here is checked above.

    • Specify the report output: Browse to the location you would like to save the final report.

In this section: