Overview
This 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.
Article Contents
Left Panel of My Pipeline
The customizable view panel of My Pipeline appears on the left side of the My Pipeline page by default. 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.
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.
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. |
Customer 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 My Pipeline. 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 (inFlow).
Report Columns
The default 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.
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.
Click the Export icon to add the report to the My Reports or My Reports V2 queue where it will be available to download.
Running a Report
The Run Report button is used to create a report based on the user’s customized settings.
If no data is found when the user clicks the Run Report button, a popup notification is displayed.
When a filter is changed, a warning message is displayed.
If results exceed 2000 when you click the Run Report button, a warning message is displayed.
Server Side Filtering
If more than 2000 results meet the customized settings for a report, only the first 2000 will be listed in the search results. The number of additional results that meet the report criteria can be seen in the top right of the screen. The results are filtered by the App Created Date column and list the leads by the most recently created.
In this example, there are a total of 4602 results but only the first 2000 are listed.
To further refine the first 2000 search results, you can select a column and add more filters.
When you click Filter, the additional filters (grid filters) are applied to the 2000 search results. In this example, 33 of the 2000 results meet the report and grid filter criteria.
Notice that the Run Report button disappears when the additional filters (grid filters) are applied. In its place, there are two new buttons:
Run Report w/Grid Filters button
Clear Grid Filters button
When you click the Run Report w/Grid Filters button, the additional filters (grid filters) are applied to the database, capturing the remaining search results (2001 through 4602). The count at the bottom right of the screen shows you the total number of search results in the database that meet the search criteria. No more than 2000 search results may be viewed.
In this example, 306 items in the database meet the criteria in the original report plus the added filters.
Notice that the Run Report w/Grid Filters and Clear Grid Filters buttons disappear when the report is run. The Run Report button returns.
Notes
The ability to download all search results, including those beyond the 2000 that appear in the report, is currently being developed.
You cannot filter down the data a second time. If you try to further refine the search results a second time, a new search will be run using the original report settings plus the new grid filters. The previously entered grid filters will not be included in the search.