My Pipeline
- Romina Chu (Unlicensed)
- Rebecca Kornblum
- Riley Cohen
- Tristy Lee (Unlicensed)
Overview
The My Pipeline reporting feature allows you to display preset reports, including all applications assigned to the user specified in the Team/Agent dropdown near the top of the page. Users can see company-level reports and have the ability to create custom My Pipeline Reports.
Left Panel of My Pipeline
The left side of the My Pipeline page is a customizable view panel. Users enter data into the fields and click Run Report to view customizable data reports. Without a filter set saved and selected, the Run Report button is disabled.
The system default view can be collapsed and expanded but cannot be deleted, edited, or removed. Unless a user has a filter view marked as Primary, every time the user navigates to a My Pipeline report, the default view is displayed.
Customizable View Panel Fields
Field | Description |
|
|
|---|---|---|---|
Preset Report | See the Preset Reports article for details. |
|
|
Team/Agent | The team or agent selected for the report. |
|
|
Include Inactive Applications | This toggle displays results that include/exclude applications that are assigned to inactive users. This applies when All is selected in the the Team/Agent dropdown. |
|
|
+ Filter Sets | Open up this section to use My Pipeline with the legacy functionality. |
|
|
Field View | See the Field View article for details. |
|
|
Filter Set | See the Filter Sets article for details. |
|
|
App created date | All time - 01/01/1970 to the current day. |
|
|
Branch | The logged-in user’s branches. |
|
|
Workflow Type | All branch permissions of the logged-in user. |
|
|
Statuses | All statuses in the logged-in user’s workflow. |
|
|
Campaigns | All campaigns that have the same branch permissions as the logged-in user. |
|
|
Right Panel of My Pipeline
Report results appear on the right panel of the My Pipeline page. The main grid section is blank and contains the message: Run the report to view the pipeline. When a report is run, up to 2000 results (2000 apps) are displayed in the grid according to the filter set selected. The leads clicked within the report open in a new tab in inFlow.
Report Columns
The sorting order for all columns in the system default view is descending. Columns can be moved to change the order of the display. No columns can be added but can be temporarily removed from the system default view via column options.
Column Name | Column Definitions |
Application ID | Application ID associated with the lead upon creation of an application |
Lead Name | First and last name of the application (borrower) |
Create Date | Date on which the application was created in the system |
Post Date | Date on which the application was posted into the system |
Primary Officer | Primary agent assigned to the application |
Phone number | Mobile phone number of the application (borrower) |
Email address of the application (borrower) | |
Proposed Initial Loan Amount | Proposed initial loan amount of the application as mentioned in inFlow |
Initial Loan Amount | First of the application as mentioned in inFlow |
Loan Balance First | First of the application as mentioned in inFlow |
Appraised Value | Number of the appraised value for the property |
Proposed Loan Purpose | Proposed loan purpose of the application as mentioned in inFlow |
Current Loan Purpose | Current loan purpose of the application as mentioned in inFlow |
Property State | The state where the property is |
Campaign Name | Name of the campaign the application belongs to |
Current Status Date | Date of the status (inFlow) the lead is currently in |
Current Status | Status (inFlow) the lead is currently in |
Status ID | Status ID of the status the lead is currently in |
Current Activity Date | Date on which the application is moved to the current activity |
Activity Name | Name of the activity within the status that the lead is currently in |
Next Activity | Name of the next activity within the status that the lead is currently in |
Last Phone Call | Date and time of the last phone call made to/from any of the application’s phone numbers |
Number of Calls | Number of calls made to and from the application’s mobile phone number |
Has Alert | Indicates if the lead has an alert associated with it |
Open Lead Flag | Indicates if the application is an open lead |
Branch Name | Name of the branch the application belongs to (primary branch of the primary agent) |
Export Excel
The Export Excel button is used to export data from the My Pipeline grid into an Excel file downloaded to the user’s system. It is displayed only if the organization and user have Excel Export permission turned On in Superadmin. The Excel Export button does not appear until the report has been run and grid results are displayed. The exported report is added to the My Reports or My Reports V2 queue where it will be available to download.
With Kendo + ExportAllPages permission turned On for the organization, the Export Excel button will export all pages of the grid results.
With Kendo + ExportAllPages permission turned On for the organization, the Export Excel button will only export the first 100 results of the grid results.