/
Classic - Sales Manager Report

Classic - Sales Manager Report

Description

This article describes the Sales Manager Report (SMR). It includes sections on the following:


Overview

The Sales Manager Report is used by managers and organization administrators to monitor the work of all agents in the organization. The report records each agent’s activity related to lead assignments and their communication with leads. See the Permissions Master Document for details.

The Sales Manager Report is designed to provide a single page where managers and administrators can understand both the effort and success of each agent. Not every day is the same. Some days an agent may have a lot of success moving files through the pipeline and closing deals. On other days there may be minimal file movement but they are putting in the right amount of effort to create business and stay in touch with borrowers.

Effort
Is an agent making calls, sending SMS, and maintaining their engagement with borrowers? Managers and administrators can review the agent’s Communication metrics.

Success
Is an agent pulling credit, starting applications, submitting new loans, and getting deals closed? Managers and administrators can review the agent’s Lead and Status Activity sections.


Report Filters

Managers and administrators can run reports based on selected filters in specific fields.

  1. Enter the desired report parameters in the Date, Branch, Loan Purpose, Campaign, and Marketing Channel fields.

  2. Click Run Report to view the report.

     

Field

Description

Field

Description

Customer Type

The Customer Type may be a Borrower (default) or Partners.

Date

Lists the date range options by which the manager/admin can filter grid results based on the duration in which the applications were created

Branch

Lists all of the branch permissions of the logged-in user by which the user can filter grid results based on the primary branch of the application

Loan Purpose

Lists all of the loan purposes mapped within the organization by which the user can filter grid results based on the loan purpose associated with the application

Campaign

Lists all of the campaigns that have matching branch permissions with the logged-in user by which the user can filter grid results based on the campaign the application belongs to

Marketing Channel

Lists all of the types of campaign marketing channels


Report Sections

(1) User Information, (2) Leads/Credit/Locks, (3) Status, (4) Communication

 

 

The Sales Manager Report is divided into four sections. Each report section is divided into columns (data points) for review. The sections are:

  1. User Information

  2. Leads, Credit, and Locks

  3. Status

  4. Communication

Below is a description of each section and the field calculation logic of each column.

User Information Section

The columns in the User Information section are fixed. The agents displayed have matching branch permissions as the logged-in manager/admin. By default, whenever the report is run, the entire list of agents is always displayed. Only the counts in the grid results change according to the filter conditions.

Column Name

Filter Type

Description

Column Name

Filter Type

Description

Branch

Multi+search

  • The primary branch of the agent

  • As specified within User Registration

Manager

Multi+search

  • Who the agent reports to

  • As specified in User Registration

Loan Officer

Multi+search

  • The agent’s last name and first name

  • As specified in User Registration

 

Leads, Credit, and Locks Section

Clicking on any of the counts in the Leads or Credit columns will display the Leads Details popup. See the Columns in Leads and Columns in Credits articles for details.

Column Name

Filter Type

Description

Column Name

Filter Type

Description

Leads / New

Number

  • Count of the first time a lead is created and initially assigned to an agent

  • New application in the system

  • Created via lead distribution, manual creation, or taken from Unassigned

Leads / Internal Transfers

Number

  • Count of all existing leads associated with an Internal Transfer lead campaign that are assigned to an agent

  • Typically, assignment to an agent is done by a CSR or internal transfer agent

Leads / Assigned

Number

  • Count of all existing leads that are assigned to the agent manually

  • Existing leads previously assigned to another agent

  • Excludes all Internal Transfer lead campaigns

Leads / Open Takes

Number

Count of all Open Leads the agent takes

Leads / Total Received

Number

Total of all New, Assigned, Assigned - Internal Transfer, and Open Takes for the agent

Credit / Credit Pulls

Number

  • Total credit pulls the agent completed for the defined time period

  • Not related to a credit pull workflow status but based on direct information from the LOS or Credit Bureau integration

Credit / Transfer

Number

Allows the user to link specific organization statuses to the Transferred category and the count would increment if the lead is moved into the status that is selected.

Locks / Lock

Number

Based on Library Field (Rate Locked Date) and automatically increments if this becomes populated.

Locks / Lock / Transfer

Number

Allows the user to link specific organization statuses to the Transferred category. Any lead moved into this status during the selected time frame would appear in the Marketing Report.

Status Section

The Status section is hidden by default and can be added using the column settings. The statuses displayed within the Status section depend on the statuses configured and ordered for the organization. See the Columns in Status article for details.

Column Name

Filter Type

Description

Column Name

Filter Type

Description

Status Names
(vary by client)

Number

  • Includes all the workflow statuses for the company in order

  • Calculations at the status level track status the movement of leads

  • Count shows how many unique leads have moved into each status for the defined time period

  • This is not a waterfall. Each status is calculated independently of other statuses. A lead can be in the count of multiple statuses if it moved into each status during the defined time period. This only counts the first time a lead moves into a status and not when a lead moves between activities within a status.

 

Communication Section

The Communication section includes several communication options available to the agent. See these articles for details:

Column Name

Filter Type

Description

Column Name

Filter Type

Description

Text Messages / Sent

Number

  • How many text messages the agent manually sent

  • Does not include automated text messages from inTouch

Text Messages / Received

Number

How many text messages the agent received from borrowers regardless of if the original text to the borrower was sent manually by the agent or was automatically sent via inTouch

Inbound Marketing Calls / Call Count

Number

  • Count of all calls associated inbound marketing campaigns

  • Does not exclude if a borrower calls in multiple times

Inbound Marketing Calls / Talk Time

Number

  • Total Talk Time of all calls associated inbound marketing campaigns

  • Does not exclude if a borrower calls in multiple times

Inbound Marketing Calls/
Unique Call Count

Number

  • Count of all unique calls associated to inbound marketing campaigns

  • Each phone number only counted once; i.e., duplicates are removed

Inbound Marketing Calls/
Unique Talk Time

Number

  • Total Talk Time of all unique calls associated to inbound marketing campaigns

  • Each phone number and talk time only counted once; i.e., duplicates are removed

Outbound / Call Count

Number

Count of all outbound calls made either via Insellerate Click-to-Call or agent third-party desk phone if data integration exists

Outbound / Talk Time

Number

Total Talk Time of all outbound calls made either via Insellerate Click-to-Call or agent third-party desk phone if data integration exists

Direct / Call Count

Number

  • Count of all Direct calls the agent received either via Insellerate direct inbound call routing or agent third-party desk phone if data integration exists

  • Excludes inbound marketing calls

Direct / Talk Time

Number

  • Total Talk Time of all Direct calls the agent received either via Insellerate direct inbound call routing or agent third-party desk phone if data integration exists

  • Excludes inbound marketing calls

Total / Call Count

Number

Sum of all Call Counts: Inbound Marketing, Outbound, and Direct

Total / Talk Time

Number

Sum of all Talk Time: Inbound Marketing, Outbound, and Direct


Exporting Reports

Reports can be exported as an Excel file by clicking the Excel Export button. The report view can also be saved, loaded, or cleared. See the Saved Report Views article for more details.

  1. Run the desired report.

  2. Click Excel Export to export the report as an Excel file.



Leads Details

All reporting numbers are hyperlinks that allow the user to drill down and access the Leads Details popup window.

To add a new column to the Leads Details popup window, click the three dots in any column header and click Columns from the dropdown options. Place a checkmark in the box next to the column name to be added.

 

 

Related content