Profile Rank Report Tool Icon

Profile Rank Report Tool

Version:
Current
Last modified: December 27, 2019

The Profile Rank Report tool takes two Profile inputs (a Geography and a Product profile) and generates a rank report.

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

When using 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.

Tool Configuration

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

  1. Input Geography Profile Tab
    • Choose Name: Select the Profile Name field from the drop down list of available fields.
    • Choose Profile: Select the Profile field from the drop down list of available fields.
  2. Input Product Profile Tab
    • Choose Name: Select the Profile Name field from the drop down list of available fields.
    • Choose Profile: Select the Profile field from the drop down list of available fields.
  3. Output
    • TabChoose 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 will determine 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.
Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.