Collect! Credit and Collection Software™

  Page Table of Contents Related 'How To' Tutorials

How To Use The Heatmap

The Heatmap is designed to empower you in exploring and visualizing relationships within your data. Whether analyzing the correlation between listed amounts and scores, or examining the relationship between listed amounts and liquidation percentages, the Heatmap offers a visually intuitive representation. This enables you to identify patterns, trends, and potential correlations that might not be immediately apparent in tabular form. With this Heatmap report, you can delve deeper into your data, making informed decisions and unlocking new opportunities.

The report settings that generate the Heatmap are fully configurable, offering you flexibility and control over your analysis. Upon initiating the Heatmap generation, you will be prompted with a series of configurable options tailored to your specific analytical needs. These prompts include parameters such as the choice of variables for analysis and the granularity of the data segmentation. Each prompt is accompanied by clear explanations, empowering you to make informed decisions that align with your analytical objectives.

Prerequisites

This utility is part of the Inventory Management Scenario Package. You can obtain the Inventory Management packes by logging into the Member Center and downloading the Scenario Package from here.

Depending on your preference settings, the Heatmap is designed to show you which segments of your inventory are liquidating best for you and which are not. This identification can assist you with making strategic inventory management decisions and/or adjusting your new account distribution strategies.

Top of page.

Key Aspects

Before diving into the Heatmap generation process, it's essential to understand a few key aspects:

  • The Heatmap utilizes data from ALL Modes as well as any applicable content in selected parameter range(s) from the Archive database. Listed Amounts use debtor Original Principal and Original Interest where there is no Judgement. If there is a Judgement Date on account, then the Judgement Principal and Original Judgement Interest are used instead.
  • By default, the Heatmap reads score data from the 'score' field. If your system uses a different field for scores, such as 'risk score,' you can easily customize this setting. For example, if your system utilizes 'risk score', you would modify the report parameter from '@tvarXFieldName* = "de_owned_by_ debtor"' to '@tvarXFieldName* = "de_risk_score"'. Or contact support department for assistance.
  • The colors of the Heatmap's shaded zones are predefined within the report. If these colors do not align with your preferences, you have the option to modify them. The background and text colors of the shaded zones can be adjusted using the variables '@tvarHeatColor[1][1]* = "#ffffe5"' and '@tvarHeatColor[1][2]* = "#000000"', respectively. The '[1]*' denotes the background color, while the '[2]*' represents the text color.

Top of page.

Explanation Of Report Configuration Prompts

Use of Score or Liquidation Percentages

The Heatmap uses 2-axis graphical output of either Score + Listed Amount ranges OR Liquidation % + Listed Amount ranges. The purpose of this selection is to define whether your second axis will be Score OR Liquidation. If you don't use Scoring with a credit bureau or probability scoring vendor, then choose one of the Liquidation options (all states or with state exclusions, for example if you have closed-border states you are not permitted to collect in).


Use of Score or Liquidation Percentages Prompt

Heat Zones

The next two sections involve defining your Heat Zones: these are liquidation percentage ranges represented graphically as cell background colors. These will be one color that is divided into shade gradients, lightest (low Liq % or $ Recovered) to darkest shade (High Liq % or $ Recovered).

It should be noted however, that a low liquidation percentage doesn't always equate to low agency revenue. For example, some types of debt tend to liquidate low in smaller listed amount ranges, but overall results in much higher actual dollars recovered by the agency.

Clusters of same-shaded cells in the darker color end of the spectrum in a Result spreadsheet define your statistical high recovery zones. Depending on how your portfolio liquidates, hot zones may tend to move around the Heatmap as economy and other factors impact results. Staying in the know of how your streams of business are liquidating will allow you to proactively identify trends early and action accordingly to either ward-off downtrends or amplify uptrends. Proactive actioning on early trend identification may be any, all or combinations of:

  • strategy tweaks
  • staffing adjustments
  • automation usage

As stated earlier in this Help Document, a Heatmap can show you areas of surprise. These are segments which statistically, by Listed Amount/Score OR Listed Amount/Liq % wouldn't be expected to be a significant amount of an agency's revenue BUT in actuality represent a significant amount of gross revenue. For example, a Liq % of 5.1% representing over $1M in generated gross revenue over the 12-month period.

The prompt will inquire whether to utilize the score field or liquidation percentage. It also offers the option to exclude states from the report. Here is an explanation of each option:

  1. Liq.% - Exclude States: This option utilizes the listed amount as one axis and the liquidation percentage as another axis. Once selected, it will prompt the user to exclude states.
    • State exclusion prompt: Enter state(s) to be excluded. For multiple states, use commas without spaces to separate them (e.g., CA,WA,ID). If left blank, it will include all states.

      State Exclusion Prompt
  2. Score - Exclude States: This option utilizes the listed amount as one axis and the liquidation percentage as x and y axes. It uses the same state exclusion prompt as shown in figure #2 above.
  3. Liq.% - Use All States: This option utilizes the listed amount and the liquidation percentage as x and y axes.
  4. Score - Exclude States: This option utilizes the listed amount and the score field as x and y axes.

Top of page.

Heatmap General Configuration Settings


Heatmap General Configuration Prompt

  • Heat Zones Increment By: defines how many percentage points spread you want to use to define each Heat Zone. If your entire portfolio is liquidating between 1.15% to 3.67%, you might want to increment by a fractional value such as 0.75. If your portfolio is liquidating between 1.15% to 110% (which can happen if accrued interest/costs are being added to balances), you might want to increment by 10. The larger the number of Heat Zones defined for your Heatmap output, the more fragmented/diffuse your results will be. As you use this tool, the old adage less is more will help your analytics be more meaningful.
  • Dim Number: Number is a setting that will control the cell text font color from regular black to pale grey where cells containing data carrying results representing too few accounts to be statistically valid even if the results are in target ranges are dimmed in appearance so as not to invite undue attention. These results are your outliers: the cells with the atypical few accounts that PIF'd or had a large payment but do not represent a volume of accounts with similar results. Small-sample results should not influence inventory management or staffing decisions. This setting defines your threshold for how many accounts is the least number you want to be statistically considered. This will be an individual preference that your data will identify for you. For small sites, this may be a value between 2 to 5 accounts. For large volume sites with hundreds of thousands to millions of debtor records, that would be a much larger number (may be in hundreds versus single to double digit value). You should try different values as they learn your data and determine what is a reasonable figure to input for this parameter. Number of accounts in each cell is part of the output.
  • X and Y Axis: To set your preference of what data appears in your X or Y Axis, a preference by clicking the radio buttons on the left needs to be made. If you selected either of the Liquidation options in the previous step, then the prompt will offer X-Axis is Liquidation % or X-Axis is Listed Amount. If you selected either of the Score options in the previous step, then the radio buttons to define what will appear as your X-Axis will reflect Score
  • Axis Type: A Simple Axis of '100' outputs an axis displaying only the topmost value in that row or column: it presumes 1-100 is contained in '100', and '200' output presumes 101-200 etc. Detailed Axis shows you the true range of values contained in each row or column of the output: the axis will display the range as 1.00 – 100.00 explicitly. You may have your own preferences for this cosmetic layout feature.

Top of page.

Heatmap Shaded Zones Minimum And Maximum Caps

The Min & Max Caps should be considered the 'tails' of a normal bell curve, meaning values contained within that range will be grouped together in the 'low' values as well as the 'high' values. This allows you to focus on the better liquidating ranges in your data.

For example, the following is a standard bell curve, which collection recoveries generally graphs out to with large enough samples when results are examined in comparable batches ( client types) and a reasonable number of listed months (so economic fluctuations etc. don't skew results). A reasonable number of months, depending on economy & type of business is 9 – 12 months max Listed Date range.


Normal Distribution Curve

The light and medium grey-shaded areas in the above normal distribution are representative of Min and Max Caps: values below or above which you'd want to have grouped into a single category because values in those regions are not of particular interest. This allows you to focus on the most profitable accounts.

Useful Note Heatmap Zones Increment By is decided from the previous prompt.


Heatmap Zones Cap Prompt

  • Heatmap Min Cap: This option is used to define your leftmost 'tail' of the bell curve, below which you do not wish to see granular breakout by color.
  • Heatmap Max Cap: This option is used to define your rightmost 'tail' of the bell curve, above which you do not wish to see granular breakout by color.

Anything that falls between Heatmap Min and Max Caps will increment by the "Heatmap Zones Increment By" value that is passed from the previous prompt.

For instance, if the increment is set to 10 and the minimum cap is 25, then the Heatmap colors will be defined as follows: 0 - 25.99, 26 - 35.99, 36 - 45.99, and so on. Any values exceeding the maximum cap of 75 will be grouped into one label.

Top of page.

Configure X-Axis Minimum And Maximum Caps

Identify the X-Axis minimum and maximum caps to consolidate values below or above which you would like to appear in a single cell.

Useful Note X-Axis could be score, listed amount, or liquidation percentage, as decided from the previous prompts. This can be seen on the prompt which field is used as X-axis.


X-Axis Minimum and Maximum Caps Prompt

  • X-Axis Min Cap: This option is used to group any field value from 0.00 up to this value into one grouped label.
  • X-Axis Max Cap: This option is used to group any field from this value and up into one grouped label.

Anything that falls between X-Axis Min Cap and X-Axis Max Cap will increment by the values which are set in the report filtering prompt.

For example, if the minimum is set to 1000 and the maximum is set to 5000 with an increment of 100, the Axis will be defined as follows: 0 - 1000.00, 1000.01 - 1100.00, 1100.01 - 1200.00, etc. Any values over 5000 will be grouped into one label.

Top of page.

Configure Y-Axis Minimum And Maximum Caps

Identify the Y-Axis minimum and maximum caps to consolidate values below or above which you would like to appear in a single cell.

Useful Note Y-Axis could be score, listed amount, or liquidation percentage, as decided from the previous prompts. This can be seen on the prompt which field is used as Y-Axis.


Y-Axis Minimum and Maximum Caps Prompt

  • Y-Axis Min Cap: This option is used to group any field value from 0.00 up to this value into one grouped label.
  • Y-Axis Max Cap: This option is used to group any field from this value and up into one grouped label.

Anything that falls between Y-Axis Min Cap and Y-Axis Max Cap will increment by the values which are set in the report filtering prompt.

For example, if the minimum is set to 1000 and the maximum is set to 5000 with an increment of 100, the Axis will be defined as follows: 0 - 1000.00, 1000.01 - 1100.00, 1100.01 - 1200.00, etc. Any values over 5000 will be grouped into one label.

Top of page.

Filter, X-Axis And Y-Axis Configuration

This prompt offers you several options, most of which are designed to filter the data to ensure only the desired subset is included in the Heatmap for analysis. The only mandatory option on this prompt is the Listed Date range, From and To. Additionally, you can control the Heatmap's X and Y axes increments or the number of rows. The prompt also displays whether the X-Axis and Y-Axis represent score, listed amount, or liquidation percentage. Here's an explanation of each option:


Filter, X-Axis and Y-Axis Configuration Prompt

  • Client Type: This filter allows you to specify client types. It's typically recommended to focus on one type of account, but if left blank or an unknown option is selected, this filter will be ignored.
  • Date Range Listed Date From and Listed Date To: This option is used to filter accounts based on their listed date. these fields are mandatory.
  • Operator From and To: You can filter data by operator using this option. If left blank, it will include all operators.
  • Client# From and To: This option filters accounts by client numbers. If left blank, it will include all clients.
  • Status From and To: You can filter data by statuses using this option. If left blank, all statuses will be included.
  • X-Axis Labels: This indicates the increment between your label values on this axis OR the number of represented columns that will be labeled output in your Heatmap. This is tied to selecting X-Axis as an increment value OR X-Axis as the number of columns, determined by the radio buttons under the leftmost bank of fields, respectively.
  • Y-Axis Labels: Similar to the X-Axis, this indicates the increment between your label values on this axis OR the number of rows that will be labeled output in your Heatmap. This is tied to selecting Y-Axis as an increment value OR Y-Axis as the number of rows, determined by the radio buttons under the rightmost bank of fields, respectively.

Top of page.

Notification And Messages

This prompt appears only when the Client Type (e.g. Medical, Retail, Banking, Automotive etc.) is not selected and/or the Listed "From" date is more than one year in the past.

The message serves as a notification to the user executing the report in case the options are not set for most optimal usage. Liquidation curves tend to be portfolio type-specific, e.g. Commercial doesn't liquidate at the same rate as Retail etc., and as such, that means outputting results where different types of accounts are being mixed together will not give best results. Data averages being output will provide a blurred picture due to Client Type blending: important trends as may be necessary to see on a Client Type basis will be masked or less apparent due to the blended request and/or overlong period where recovery conditions may have changed significantly in specific timelines.

We recommend using Type specific Heatmaps that select Listed Date ranges that do no not exceed 12 months.

However, the ultimate choice resides with you. If you choose to mix Client Types and/or use a wider Listed Date range, then the report will continue after you click OK.


Notification and Messages Prompt

  • The report includes multiple creditor industries. Recovery rates may differ significantly between different industry types. This message appears when the client type is not selected or "unknown" is passed.
  • The report period selected is over one year ago. Economic changes over multiple years may impact results. This message appears when the listed "From" date is more than one year in the past.

Top of page.

Enhanced Analysis With Weighted Recovery Percentage

By default, the Heatmap favors high liquidation results in the output cells. Without weighting, your highest Liq % cell values will be what gets shaded darkest in the Heat Zones.

What weighting will do for you, is identify where actual recovered dollars are high even if the liquidation percent is quite low. For example, Liq % for cell is 5.17% and recovered gross dollars is $1.5M. In the weighted version of the output, 2 accounts liquidating for an average of 80% will NOT be in output as one of the darkest shaded hot zones while the 1,523 accounts representing 5.17% for $1.5M will be shaded dark to indicate a hot zone.


Prompt To Enable Weighted Recovery Percentage

Suppose your selected criteria produced the following data:

  Listed Amount                          = $120.00
  Paid Amount                            = $95.00
  Min (of Weighted Recovery Percentage*) = 0.00
  Max (of Weighted Recovery Percentage*) = 50000.00
  * See Weighted Recovery Percentage calculated below.
  

Understanding Recovery Percentage

Recovery Percentage is a measure that indicates the percentage of the listed amount that has been paid. It is calculated by dividing the amount paid by the listed amount and then multiplying by 100 to express it as a percentage. For example, if $95.00 is paid out of a listed amount of $100.00, the Recovery Percentage would be:

  Recovery Percentage = (Amount Paid / Listed Amount) * 100
                      = (95.00 / 120.00) * 100
                      = 0.7917 * 100
                      = 79.17%
  

Introducing Weighted Recovery Percentage

Weighted Recovery Percentage takes into account both the Recovery Percentage and the actual amount paid. This means that higher payments are given more weight in the analysis. For example, if the amount paid is $95.00, the Weighted Recovery Percentage would be:

  * Weighted Recovery Percentage = Recovery Percentage × Amount Paid
                                                                 = 79.17 × 95.00
                                                                 = 7521.15
  

Normalizing the Weighted Recovery Percentage

When analyzing data using weighted recovery percentage within a single dataset, normalization plays a crucial role in ensuring fair comparisons across different entries.

Consider a scenario where our dataset contains weighted recovery percentages that vary in range. Some entries may have values ranging from 0 to 100, while others may range from 0 to 10,000. Directly comparing these values without normalization could lead to skewed interpretations due to the differing scales.

Normalization addresses this issue by scaling all values within the dataset to a standard range, typically between 0 and 100. This ensures that each entry is evaluated relative to the entire dataset, rather than solely based on its raw value.

Let's illustrate this with a simplified example from our dataset:

  • Account #1: Weighted Recovery Percentage: 50
  • Account #2: Weighted Recovery Percentage: 5000

In this scenario, without normalization, Account #2 may appear significantly higher than Account #1 simply due to its larger raw value. However, after normalization, both accounts are scaled to a common range within the dataset:

  Normalized Account #1:
  Scaled Value = (50 - Min) / (Max - Min) * 100

Normalized Account #2: Scaled Value = (5000 - Min) / (Max - Min) * 100

By applying normalization to our dataset, we ensure that each entry's weighted recovery percentage is evaluated relative to the full range of values within the dataset. This enables fair and meaningful comparisons, allowing us to identify patterns and trends accurately.

For example, if the calculated Weighted Recovery Percentage is 7521.15 and the Min and Max values are 0.00 and 50000.00 respectively, the scaled value would be approximately 18.05%:

  Scaled Value = ( (7521.15 - 0.00) / (50000.00 - 0.00) ) * 100
               = (7521.15 / 50000.00) * 100
               = 0.150423 * 100
               = 15.04%
  

Top of page.

Heatmap Result

The below image illustrates a sample Heatmap generated with default settings, offering insights into the dataset's recovery performance. Below is a comprehensive guide to interpreting the Heatmap data:

  • Y-Axis Labeling: The vertical axis represents the listed amount, spanning from 1000 to 1053235. This axis segments the dataset based on the magnitude of the listed amount, aiding in the identification of patterns related to different debt levels.
  • X-Axis Labeling: The horizontal axis displays the Score, ranging from 1 to 10 as in this example, the mock-data is using a probability score vendor rather than a credit bureau Fico score.
  • Z-Axis Interpretation: Each cell in the Heatmap corresponds to a specific intersection of the Listed Amount and Score. The cell's value represents the recovery percentage achieved for that particular combination. For instance, a cell located in the listed amount range of 0-1000 with a score of 0-1 displays a recovery percentage of 4.47%. Additionally, it provides information on the total collected amount, such as $711,984, and the number of paid accounts, such as 2,618. Clicking on any cell allows you to access a detailed list of accounts within that cell, grouped by state.
  • Cell Content Sample: This section offers an explanation of the values within a sample cell, ensuring you understand the data presented. In cases where the weighted average is selected, you will find an additional option representing the weighted recovery rate alongside the conventional recovery rate.
  • Heatmap Shaded Zones: These color-coded zones delineate different recovery ranges, enhancing the visualization's clarity and enabling quick identification of trends or anomalies across the dataset.
  • Z-Axis Formula: Hovering over this button reveals the formula used to calculate the recovery percentage, providing transparency and empowering you to understand the underlying methodology.
  • Download CSV: You can utilize this feature to download the Heatmap data along with detailed account-level information. This enables further analysis and exploration of the dataset outside the visualization tool.

This comprehensive guide equips you with the knowledge and tools necessary to effectively interpret and leverage the insights offered by the Heatmap visualization.


Heatmap Sample Result

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org