LoanOfficer.ai Training: How to Scan Your Database for Opportunities

A hands-on training that walks through scanning your database to surface refi, equity, and reactivation opportunities you can act on today.

Quick summary

Property Pulse and Rate Watch help you scan your mortgage database for opportunities by comparing borrower loan details against your alert thresholds. When past clients have enough mortgage data—loan amount, product type, interest rate, and term—the system can automatically sync a Rate Watch and surface potential refinance savings opportunities.

Key takeaways

Run your first scan

Start from Smart Lists, apply Property Pulse filters, and save the list. Every time the data refreshes, the list stays current.

Making the workflow stick

Schedule a weekly time block to work fresh matches. Ten minutes on a well-built list beats an hour on cold outreach.

Introduction

Your database is one of the most valuable assets in your mortgage business. Past clients, closed loans, and older leads can all become new opportunities when market conditions change or when a borrower’s property and loan profile creates a reason to reach out.

In LoanOfficer.ai, Property Pulse and Rate Watch work together to help you scan your mortgage database for opportunities. The system can monitor borrowers for refinance savings opportunities based on the mortgage information you have on file and the alert thresholds you set.

This lesson explains how those opportunities are identified, what data is required, and how to use bulk uploads and Property Pulse to make sure more of your database is being watched.

Why this matters

Most loan officers have past clients sitting in a CRM who are not being actively monitored. Some may be eligible for a refinance. Others may have enough equity to start a conversation. Others simply need a timely reason to re-engage.

The challenge is that manually reviewing every borrower is not realistic. You need a way to scan your mortgage database for opportunities automatically, so you can focus your time on the borrowers who are most likely to benefit from outreach.

Rate Watch helps by looking at borrower mortgage details and comparing them to the thresholds you define. Property Pulse can help fill in additional loan and property data so the system has what it needs to monitor more records.

When this is set up correctly, your database becomes more than a list of contacts. It becomes an active source of refinance and reactivation opportunities.

How it works

Refinance opportunities are identified based on your Rate Watch settings. Inside the Rate Watch tool, you can review current rate assumptions and edit the thresholds that determine when you want to be alerted.

The threshold is the key setting. It tells the system how much potential savings must exist before an opportunity alert should be created.

For example, if you set your VA loan threshold to a half percent, you are telling the system: if a VA borrower could potentially save 0.50% based on the rate comparison, alert me.

Those thresholds are set by product. That matters because different loan types may require different levels of savings before outreach makes sense. A half-percent improvement may be meaningful for one product type, while another scenario may need a different threshold.

For Rate Watch to work on a borrower, the system needs enough mortgage data to understand what to monitor. The key pieces of information are:

With those fields in place, the system knows which loan product to watch, what the borrower’s current terms are, and how to compare against current rate assumptions.

Step-by-step

1. Open the Rate Watch tool.

Start by going to the Rate Watch area in LoanOfficer.ai. This is where your opportunity thresholds are configured and where the system determines when a borrower may have a potential savings opportunity.

2. Review current rate settings.

Use the edit rates area to review the last national average and any adjustments being applied by the system. These settings help determine the current rates used for comparison.

3. Confirm your alert thresholds.

Review the threshold for each loan product. This threshold controls when you want to be notified about potential savings for a borrower.

For example, you may want to be alerted when a VA borrower could save at least half a percent. The opportunity alert is based on the threshold assigned to that product.

4. Prepare past-client data for upload.

If you are bulk uploading past closed clients, make sure your CSV includes the mortgage data required for monitoring. At minimum, the system needs loan amount, product type, interest rate, and term.

5. Map your CSV columns during upload.

During the bulk upload process, LoanOfficer.ai gives you the opportunity to match the columns in your CSV file. Match the mortgage fields carefully so the system can recognize the loan details.

6. Verify Rate Watch creation.

When a borrower record has the required mortgage information, Rate Watch can be synced automatically. You can confirm active watches on the borrower’s Rate Watch tab.

7. Run Property Pulse when data is missing.

If a borrower has a property record but incomplete mortgage data, running Property Pulse may bring in additional details such as loan amount, product type, and estimated interest rate. That additional data can help sync Rate Watch monitoring for the property.

Best practices

Treat your database as a living pipeline. A borrower who was not ready six months ago may be ready today because rates changed, equity increased, or their financial goals shifted.

When you scan your mortgage database for opportunities, focus on data quality first. The better your mortgage data, the more useful your alerts become.

Use these best practices:

Thresholds should reflect the type of opportunity you want to act on. If the threshold is too sensitive, you may create noise. If it is too high, you may miss borrowers who would appreciate a conversation.

Think of Rate Watch as an alerting system, not a complete loan analysis. It helps identify who may be worth contacting. You still need to review the borrower’s full situation before making a recommendation.

Common mistakes

One common mistake is uploading past clients without the mortgage fields needed for monitoring. A name, phone number, and email address may be enough for contact management, but it is not enough for Rate Watch to understand the borrower’s current loan.

Another mistake is assuming every imported borrower is automatically being watched. The system can create a Rate Watch when the required data is present, but incomplete records may need Property Pulse or manual data cleanup.

Loan officers also sometimes overlook threshold settings. If your thresholds do not match your outreach strategy, the alerts may not reflect the opportunities you actually want to pursue.

Avoid these issues by reviewing your data before upload, mapping columns carefully, and checking borrower records after import.

Example workflow

Suppose you have a CSV of past closed clients from the last several years. You want to identify which borrowers may have refinance opportunities based on current rate conditions.

Before importing, you review the file and confirm that it includes the key mortgage fields: loan amount, product type, interest rate, and term. You then upload the CSV into LoanOfficer.ai and map each column to the matching borrower field.

Once the records are imported, borrowers with complete mortgage data can have Rate Watch synced automatically. You can open a borrower record and view the Rate Watch tab to confirm whether an active watch exists.

Next, you review your Rate Watch thresholds. For VA loans, you may decide that a half-percent savings is enough to trigger an alert. For other products, you may use different thresholds depending on your outreach strategy.

For borrowers with incomplete mortgage information, you run Property Pulse on the property. Property Pulse may bring in additional information such as loan amount, product type, and estimated interest rate. With that data available, Rate Watch can be synced for more borrowers.

Now your database is actively being monitored. Instead of calling through a static list, you can focus your outreach on borrowers who have a reason to talk.

Summary

LoanOfficer.ai helps you scan your mortgage database for opportunities by combining Rate Watch thresholds with borrower mortgage data. The system identifies potential refinance savings based on the product-specific thresholds you configure.

To get the best results, make sure your borrower records include loan amount, product type, interest rate, and term. When uploading past clients, map these fields carefully. When data is missing, Property Pulse can help bring in additional loan and property details.

With the right data and thresholds in place, your CRM becomes a proactive opportunity engine for refinance, equity, and borrower reactivation conversations.

Step by step

Open Rate Watch

Go to the Rate Watch tool to review the settings that control refinance opportunity alerts.

Review rate assumptions

Check the last national average and any system adjustments used to estimate current rates.

Set product thresholds

Confirm the savings threshold for each product type. These thresholds determine when the system alerts you to a potential borrower opportunity.

Prepare your client CSV

Before bulk uploading past clients, make sure your file includes loan amount, product type, interest rate, and term.

Map upload columns

During the CSV import, match your file columns to the correct fields so LoanOfficer.ai can read the mortgage data.

Verify active watches

Open a borrower record and check the Rate Watch tab to confirm whether a Rate Watch is active.

Run Property Pulse

Use Property Pulse on borrower properties to bring in additional mortgage details that may help sync Rate Watch monitoring.

Pro tips

Common mistakes

FAQ

How does LoanOfficer.ai identify refinance opportunities?

Refinance opportunities are based on your Rate Watch settings. The system compares borrower mortgage details against your product-specific savings thresholds.

What is a Rate Watch threshold?

A threshold is the amount of potential savings required before the system alerts you. For example, you can set a threshold to be notified when a VA borrower may save half a percent.

Can I bulk upload past closed clients and have them monitored?

Yes, as long as the uploaded records include the mortgage data needed for Rate Watch. The key fields are loan amount, product type, interest rate, and term.

What mortgage data is required for Rate Watch to sync?

The borrower record needs loan amount, product type, interest rate, and term. These fields allow the system to understand what product to watch and what current loan terms to compare against.

Where can I see whether a borrower has an active Rate Watch?

You can view active Rate Watches on the borrower’s Rate Watch tab.

Does Property Pulse help create Rate Watch opportunities?

Yes. Running Property Pulse on a borrower’s property can bring in additional details such as loan amount, product type, and estimated interest rate, which may help sync Rate Watch.

Do thresholds apply to every loan product the same way?

Thresholds are set by product, so you can define different alert criteria for different loan types.

What happens if my uploaded CSV is missing loan terms?

If required mortgage fields are missing, Rate Watch may not automatically sync for those borrowers. You may need to enrich the record with additional data, such as by running Property Pulse when applicable.

Transcript

[00:00] So, the way that the refi opportunities are identified is based on what we have set in our Rate Watch settings. If we click on the Rate Watch tool and then edit rates, we are going to see the last national average, along with any adjustments to the system to arrive at where your current rates are. [00:28] The opportunities are identified based on the threshold. Basically, this controls when we want to be notified about savings for a borrower. For example, if I can save a VA borrower a half a percent, then I want the system to alert me. [00:56] The opportunity alerts are going to be based on this threshold for each product. With the bulk upload of past closed clients, the system will watch them as long as it has the mortgage data. [01:24] When we do a bulk upload, we bring in a CSV file, and the system gives us the opportunity to match all those columns. As long as we have the primary pieces of information, the system can use that data. [01:52] The lead needs to have the loan amount, the product type, the interest rate, and the term. If those fields are present, it will automatically sync a Rate Watch for that borrower. [02:20] It needs those key pieces of information so we know which product to watch for, what the current terms are, and what the current loan amount is. If we have that data, a Rate Watch will automatically be synced. [02:48] You will see any active Rate Watches on the Rate Watch tab for a borrower. In addition, if you run a Property Pulse on any borrower’s property, it will also create or bring in those additional pieces of data. [03:16] When we run a Property Pulse, it is going to get the loan amount, product type, and estimated interest rate. That means you can get those Rate Watches synced as well if Property Pulse is active on any properties.