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.
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.
How to View the Sales Manager Report
Select Sales Manager Report v2 from the inSight dropdown menu.
The Sales Manager Report page opens.
Enter the desired report parameters in the Date, Branch, Loan Purpose, Campaign, and Marketing Channel fields. See the field description details for the report parameters below.
Click Run Report to view the report.
The report matching the parameter criteria opens.
Report Parameters
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 the several sections. Each report section is divided into columns (data points) for review. The sections are:
User Information
Leads
Credit
Locks
Status
Text Messages
Marketing Inbound Calls
Direct Inbound
Outbound
Total
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 Sections
Clicking any of the counts in the Leads, Credit, or Locks columns will display the Leads Details popup. See the Columns in Leads and Columns in Credits articles for details.
Column Name | Description |
---|---|
Leads / New |
|
Leads / Internal Transfers |
|
Leads / Assigned |
|
Leads / Open Takes | Count of all Open Leads the agent takes |
Leads / Total Received | Total of all New, Assigned, Assigned - Internal Transfer, and Open Takes for the agent; may contain duplicate leads from different sources |
Leads / Total Unique Received | Total of all New, Assigned, Assigned - Internal Transfer, and Open Takes for the agent without any duplicate leads from different sources |
Credit / Credit Pulls |
|
Credit / Transfer | 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 | Based on Library Field (Rate Locked Date) and automatically increments if this becomes populated. |
Locks / Lock / Transfer | 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 | Description |
---|---|
Status Names |
|
Communications Sections
The Communications sections include several communication options available to the agent. See these articles for details:
Column Name | Description |
---|---|
Text Messages / Sent |
|
Text Messages / Invoiced Message | The combined number of sent and received text messages |
Text Messages / Received | 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 |
Marketing Inbound Calls / |
|
Marketing Inbound Calls / |
|
Marketing Inbound Calls/ |
|
Marketing Inbound Calls/ |
|
Direct Inbound / Call Count |
|
Direct Inbound / Talk Time |
|
Outbound / Call Count | 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 | Total Talk Time of all outbound calls made either via Insellerate Click-to-Call or agent third-party desk phone if data integration exists |
Total Section
The columns in the Total section display the sum of all call counts and talk time for inbound marketing, outbound, and direct calls.
Column Name | Description |
Total / Call Count | Sum of all Call Counts: Inbound Marketing, Outbound, and Direct |
Total / Talk Time | 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.
Leads Details
All reporting numbers are hyperlinks that allow the user to drill down and access the Leads Details popup window.
The Leads Details popup window in the Sales Manager Report includes the Taken From column which allows you to see which custom queue the lead was taken from.