In this report, the user can view several key data points related to mortgage loans that have progressed through the various stages of the mortgage life cycle.  For example, a manager could see that for the past 3 months, the average cycle time between App Received to Funding has increased unexpectantly. This unfortunate result can help trigger next action steps for the manager to see where inefficiencies have surfaced within the operations department leading to the increased time.

While Intuvo provides credit unions with solutions related to email and contact marketing, the purpose of this report is to create actionable and identifiable business intelligence metrics that help the user make key decisions within the mortgage space of the credit union.  Managing mortgage pipelines, identifying potential cross-sell opportunities, and reaching out to members regarding the mortgage products they have are all benefactors that the user can utilize to help make better informed decisions on the products they offer to consumers.

This report is a dashboard containing 13 different visuals.  The specifics of each dashboard can be seen below.

This report contains a drop-down filter that allows the user to narrow down to a specific loan program(s).  The filter applies to the entire dashboard except for the ‘By Program’ visual.

The Total Loans KPI visual is a metric that looks at the total loan count of all mortgage loans.  This visual is affected by the report filter and will adjust according to the selections the user makes.

The Total Loan Amount KPI visual is a metric that looks at the total loan amount of all mortgage loans.  This visual is affected by the report filter and will adjust according to the selections the user makes.

The Average Interest Rate KPI visual is a metric that takes the average interest rate of all members that have a mortgage loan.  This visual is affected by the report filter and will adjust according to the selections the user makes.

The Average Days Between App Received Date and Full Application Date KPI visual is a metric that takes the average number of calendar days between the App Received Date and Full Application Date for all loans.  This visual is affected by the report filter and will adjust according to the selections the user makes.

The Average Days Between Full Application Date and Fund Date KPI visual is a metric that takes the average number of calendar days between the Full Application Date and Fund Date for all loans.  This visual is affected by the report filter and will adjust according to the selections the user makes.

The Average Days Between App Received Date and Fund Date KPI visual is a metric that takes the average number of calendar days between the App Received Date and Fund Date for all loans.  This visual is affected by the report filter and will adjust according to the selections the user makes.

The Average Pull Through Ratio Between App Received Date and Full Application Date KPI visual is a metric that takes the average pull-through rate between the App Received Date and Full Application Date for all loans.  This visual is affected by the report filter and will adjust according to the selections the user makes.

The By Program visual is a pie chart that displays the percentage slice of each loan program that makes up the total of all mortgage loans that are assigned to a borrower. This visual is not affected by the report filter and will not adjust according to the selections the user makes.

The By Campaign Distribution visual is a pie chart that displays the percentage slice of mortgage loans that are assigned to a borrower and are on a specific Campaign. This visual is affected by the report filter and will adjust according to the selections the user makes.

The On a Campaign visual is a pie chart that displays the percentage slice of mortgage loans that are assigned to a borrower and are on a Campaign vs. Not on a Campaign. This visual is affected by the report filter and will adjust according to the selections the user makes.

The By Status visual is a pie chart that displays the percentage slice of mortgage loans that are assigned to a borrower and that have a specific mortgage status determining where it is within the pipeline. This visual is affected by the report filter and will adjust according to the selections the user makes.

The App Received Date to Full Application Date Pull Through Ratio Over Time visual is a line graph visual that displays the average pull-through ratio over the past 12 months.  This visual is affected by the report filter and will adjust according to the selections the user makes.

The Average Days Between App Received Date and Fund Date Over Time visual is a stacked bar chart visual that displays the average cycle time between the App Received Date and Fund Date over the past 12 months.  This visual is affected by the report filter and will adjust according to the selections the user makes.