Classic - Sales Manager Report
Description
This article describes the Sales Manager Report (SMR). It includes sections on the following:
- 1 Description
- 1.1 Overview
- 1.2 Report Filters
- 1.3 Report Sections
- 1.3.1 User Information Section
- 1.3.2 Leads, Credit, and Locks Section
- 1.3.3 Status Section
- 1.3.4 Communication Section
- 1.4 Exporting Reports
- 1.5 Leads Details
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.
Enter the desired report parameters in the Date, Branch, Loan Purpose, Campaign, and Marketing Channel fields.
Click Run Report to view the report.
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
The Sales Manager Report is divided into four sections. Each report section is divided into columns (data points) for review. The sections are:
User Information
Leads, Credit, and Locks
Status
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 |
---|---|---|
Branch | Multi+search |
|
Manager | Multi+search |
|
Loan Officer | Multi+search |
|
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 |
---|---|---|
Leads / New | Number |
|
Leads / Internal Transfers | Number |
|
Leads / Assigned | Number |
|
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 |
|
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 |
---|---|---|
Status Names | Number |
|
Communication Section
The Communication section includes several communication options available to the agent. See these articles for details:
Column Name | Filter Type | Description |
---|---|---|
Text Messages / Sent | Number |
|
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 |
|
Inbound Marketing Calls / Talk Time | Number |
|
Inbound Marketing Calls/ | Number |
|
Inbound Marketing Calls/ | Number |
|
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 |
|
Direct / Talk Time | Number |
|
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.
Run the desired report.
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.