Collect! Credit and Collection Software™

  Page Table of Contents Related 'How To' Tutorials

How To Use Account Toss With Custom Distribution

The Account Toss with Custom Distribution is an external process which allows you to do more complex desk distributions by being able to define more criteria. This may be utilized for new business as well as desk re-organizations. The process relies on a tagged list of accounts and subjects the same to the Distribution Rules as defined in a csv data table template. This process may be used instead of the legacy batch process to assign accounts to operators: in addition to distributing on the basis of more parameters, this process will also do basic Round Robin if there are multiple desks that qualify to receive accounts in any set of parameters defined. This process may be used standalone for it's own functionality OR in conjunction with the Heatmap and Workflow processes that shipped with the scenario package. If your utilize Team Distribution and requires no other special criteria, you may have no need of this process and would continue as normal with your new business desk allocation.

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.

Warning Note WARNING: Do not attempt to modify the layout of the DistributionRules.csv layout yourselves. This will cause the report which reads this data table to fail. It only considers the parameters as shown and is not editable on-the-fly for columns considered in distribution; just the content you can input into the columns provided will be considered.

This is a process consisting of two parts:

  1. A CSV file called DistributionRules.csv
  2. A report called Account Toss with Custom Distribution

Top of page.

Distribution Rules Overview

DistributionRules.csv is a csv data table whose purpose is to feed the desk allocation criteria to step 2 of the process, which is a report. This new process allows a much higher degree of specificity to direct accounts to desks. This streamlined method of allocating accounts will allow you to do less additional steps to curate your account assignments to individualized desks.

The template you receive contains the following header:


DistributionRules.csv File Headers

The columns are pre-formatted for correct usage to be either text or numeric, with or without 2-decimal places.

Your distribution rules will be different and you will need to populate your data table according to how you want your accounts in a tagged list to be distributed.

The following is a populated sample for new business demonstration purposes:


DistributionRules.csv Sample File Data

Mandatory Fields: ScoreFrom/ScoreTo OR OwingFrom/OwingTo are required fields. Both can be used, but at least one of these must be present. They can be the same for all operators, but at least one of these ranges must be filled per row.

The Custom Distribution will operate in order of criteria contained in the table from this point forward: First, by Score Range. If none, then by Owing Range. The remainder of the criteria are taken into account on a per Client#, and then by State/Province: in that order.

If multiple IDs have the exact same criteria, for example because it's known the section can be large and multiple collectors are needed to staff it, this process will Round Robin available accounts matching the criteria until such time as there are no more accounts to distribute. Like any other allocation system, it doesn't recall next time which collector got the last account last time: it needs to be accepted that this is how any allocation process works: it will start again at the top of the list of eligible collectors for accounts matching criteria to make distribution decisions.

Column A - CollectorOrTeamID: This column identifies the collector ID for whom the allocation criteria in this row pertains to. If you do not plan on using any of the other criteria, you are best served using the native Distribution Team ID from your Operator List.

Columns B & C – ScoreFrom and ScoreTo: If your agency scores and distributes accounts to collector and/or pool desks on the basis of low/medium/high score ranges, then set up FromTo ranges in these columns. For correct usage, the entire possible range must be covered by the widest anticipated score spread. Example: if you use Fico Scores, they range from 1-999. However, if your data source that you obtain scores from reports back to you values that can be 0 (no hit), then your From range should start at 0. If your agency does Probability Scoring that has min-max values from 1 to 4 (or 1 to 10), then the entire range needs to be represented by the desks receiving business. If this column is blank, it will be ignored and the allocation will rely on the Owing range.

Columns D & E – OwingFrom and OwingTo: If your agency wishes to designated specific assigned ranges to pool and/or collector desks, use this column to define the ranges From/To each desk. The entire min-max range of possible amounts needs to be covered by the desks in the list. The very lowest assigned amount would be 0.01. No agency will ever receive a single account that maxes our field size, and as such, we'd recommend setting your max to be 9999999.99 on the last desk receiving highest balances. If you work mortgage deficiencies, it is possible for you to receive accounts in the millions of dollars owed. The max field size in Collect! is 12x 9's plus 3 more characters for decimal and cents. If this column is blank, then it will be ignored and the allocation will rely on the Score range.

Column F – State/Province: This column can be used if your agency allocates to collectors on the basis of licensed state or province or other regional preferences. States/Provinces must be entered comma separated with no spaces. If this column is blank, then it will be ignored.

Column G – State/Province Exclude?: Enter Yes if you have designated desks that should NOT receive regional distribution where collectors are NOT licensed. If this column is blank, then it will be ignored.

Column H – Client #: If your agency utilizes client teams, or has individual collectors that service a specific client, you can designate which desks receive business for designated client numbers. Client #s must be entered in a comma separated list with no spaces. If this column is blank, then all client #s are considered eligible.

Allowing agents to be portfolio specialized allows you to focus your efforts and obtain more meaningful statistics as different kinds of business an agency receives can require:

  • different skillsets/knowledgebase and/or automations
  • length or complexity of conversation necessary to get the account paying
  • length of time to begin liquidating
  • have different rates of liquidation when examined in an apples-to-apples comparison performance report, such as our incremental analysis report called Spin Down.

Column I – Client # Exclude?: Enter Yes if you have designated desks that should NOT receive specific client #s. If this column is blank, then it will be ignored.

Column J – ContactPlan: This column may be used to indicate different runplans on a per desk basis, if applicable. If blank, this column will be ignored.

Useful Note If your agency has need of multiple distribution tables for different purposes, example, commercial versus consumer or non-medical versus medical etc. OR wishes to use this process to do bulk desk reassignments such as if collapsing old desks for staff shuffles, a creative use of this process would be to house more than named template in your styles folder, examples:

  • NewBusConsumer.csv
  • NewBusCommercial.csv
  • NewBusMedical.csv
  • NewBusNonMed.csv
  • DeskReOrg.csv

Then, you would need only to remember two things:

  1. Modify the necessary template as needed
  2. Remember to copy/paste the intended template, overwriting DistributionRules.csv each time a different allocation is being performed. This would prevent the need to be repetitively revising the template from one potential use to the next, depending on your individual preferences.

Top of page.

Distribution Rules Preparation

Before executing the report, it's essential to configure the DistributionRules.csv file. Follow these steps to ensure proper setup:

  • File Placement: Save the DistributionRules.csv file as a CSV format in a location accessible via Collect! Ensure the file is placed within the Collect\bin\style folder for optimal accessibility.
  • Configuration Steps: Open the DistributionRules.csv file using a suitable text editor or spreadsheet application. Configure the distribution rules within the CSV file according following guidelines:
    • CollectorOrTeamID: In this field enter the operator ID or the Team ID to whom the account should be transferred to.

      If a Team ID is entered then accounts will be distributed among the team members evenly. This field is mandatory.
    • ScoreFrom and ScoreTo: These fields determine the score range that the account should fall within in order to be moved to the operator. The score field uses the debtor score field, if your system uses a different field for scoring then update the report by adjusting @tvarScoreField* = "de_owned_by_debtor" to @tvarScoreField* = "de_risk_score" or any field that matches yours.

      If either ScoreFrom and ScoreTo is empty or equal to zero the score filter will be ignored for this operator.
    • OwingFrom and OwingTo: These fields determine the owing range that the account should fall within in order to be moved to this operator.

      If either OwingFrom and OwingTo is empty or equal to zero the score filter will be ignored for this operator.
    • State/Province: This field if left empty it will be ignored. It takes a comma separated list of states/province with no spaces to which the account should fall within in order to move the account to the current operator.

      Data Example: CA,WA,ID.
    • State/Province Exclude?: Enter Yes if you have designated desks that should NOT receive regional distribution where collectors are NOT licensed. If this column is blank, then it will be ignored.
    • Client#: This field if left empty it will be ignored. It takes a comma separated list of client numbers to which the account should fall within in order to move the account to the current operator.

      Data Example: 1000,1005,4000.
    • Client # Exclude?: Enter Yes if you have designated desks that should NOT receive specific client #s. If this column is blank, then it will be ignored.
    • ContactPlan: Populate this field with the contact plan code that needs to be run as soon as the account is moved to the new operator. Leave empty to not run a contact plan. The report will prompt you to run contact plan or not.


    If multiple operators possess identical settings, the report endeavors to distribute the accounts evenly among them, considering the number of accounts assigned to each operator.

Top of page.

Account Toss With Custom Distribution Report

A report called Account Toss with Custom Distribution is the engine which launches your allocation using the criteria contained in the DistributionRules.csv file.

The report has shipping default entries for the following variables. These are modifiable to a degree. Please read the descriptions following the screenshot very carefully:

  • @tvarfilePath* = "D:\CollectClient\bin\styles\"

    The default path in the report can be left for Collect! Cloud Sites. Premise sites will need to update the path to the styles folder on your network.
  • @tvarCoTypes* = "1,3,5,6"

    This pertains to which contact events you want to have updated to a new desk desk ID if found In Progress on accounts being distributed: Phone, Promise, Review, and Other, respecitively.
  • @tvarScoreField* = "de_owned_by_debtor"

    This refers to the shipping default Score field on the main Debtor screen. If for any reason you store Score in another field, the SQL name needs to be input in the above variable.
  • @tvarOwingField* = "de_owing"

    If you wished to use another field besides Owing from the main Debtor screen, such as Principal, you'd replace the field above with the SQL name. In this example, the replacement would be "de_principal".


Report Default Variables

It relies on there being a Tagged List of Debtors already in place. If no tagged list exists, the you will receive a pop-up advising that there is no tagged list of accounts, to ensure to tag a list, then rerun the report. This report Starts On Anywhere.

When executed, the report will present the you with a pop-up allowing for preference choices to be made:


Report Main Prompt

Each option of Preview Proposed Distribution and Update – Apply Distribution constitutes one execution of this report. It doesn't automatically proceed from Preview to Update; you would have to rerun the report if you wish to Preview before committing to Update.

The Update In Progress Contacts and Don't Update Contacts are ignored if you are running the report in Preview Proposed Distribution mode.

If you select Preview Proposed Distribution, you will receive an output that looks like the following:


Preview Proposed Distribution

This provides a Summary portion in the upper part of the output and a Detail on a per account basis in the batch of tagged accounts below.

The ability to Preview Proposed Distribution can prevent accidental updates. If you are new to this process and want to be certain of your results before committing to database updates, then Preview first is recommended. If you are familiar with the process and/or have used the same DistributionRules.csv content before, you may wish to proceed directly to Update – Apply Distribution which will make changes to accounts and execute Runplans, if any.

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