RReshape.
← All articles

Lead Status Dashboard for Mortgage Loan Officers: From Spreadsheet to One Source of Truth

By Alex Regueiro · November 14, 2026 · 5 min read

A mortgage lender can spend on ads all week and still not know which leads should get another call, which never answered, and which were never real. That was the gap on this account: every lead sat in a spreadsheet, and reading the pipeline meant reading rows.

The person in this story is a mortgage lender who gets leads from paid ads and works them by phone, with Reshape handling the ad creative and the tracking. This write-up covers the lead status dashboard we built live on a call and the ad changes that went with it. For the wider picture, see our page for mortgage loan officers.

The situation

The lender's business runs on the phone. Ads bring in leads, the leads go into a spreadsheet, and the spreadsheet is where anyone has to look to learn what happened to a lead. A spreadsheet is good at storing what came in. It is poor at answering the daily question: which of these deserve more effort?

On the call, the question was whether the lead list could become the one place to see results.

What was getting in the way

A long lead sheet hides its own answers. You cannot tell at a glance how many leads are still worth working, how many never picked up, how many were bad data, and how many turned into funded loans. Without that split, it is hard to judge whether an ad is bringing in leads who answer or only leads who fill in a form.

The ads had the same problem from the other side. Only the top three creatives were performing, and everything else was off. A team in that spot needs a fast way to see what the leads from new creative actually do.

What we built

We started with the lead list itself, because the ad decisions depend on it.

  • Dashboard: during the call, we went through the spreadsheet and sorted every lead into statuses such as move forward, never answered, invalid, and funded. The dashboard, built in Claude, was filled in live from those categories.
  • Review step: we were to send the lender the updated live link so they could check the categories themselves and start using the dashboard as the single source of truth for lead tracking.
  • Creative cadence: with only three creatives performing, the plan was to add two new ad creatives per day on an ongoing basis.
  • Geographic targeting: two loan-program videos were to be reviewed and published first. After that, ad targeting would be restricted to the agreed states. Since everything in this business is phone-based, there is no reason to run ads broadly.
  • Messaging: ad variants built around direct contact. The lender had been hearing frustration from consumers who felt flooded by outreach from the industry after submitting their information online.

What changed

No funded-loan counts or cost figures were reported on the call, so there is no result to quote here. The change is in how the pipeline reads. Every lead now carries a status, the dashboard shows them in one place, and a check-in was set to go through it together.

The ad side moved in the same direction. The plan went from running a handful of winners to a steady flow of new creative, with the audience narrowed to the states that matter.

Set up your own lead statuses

You do not need a new tool to start. Take your current lead sheet and force every row into a short list of statuses. Four is enough: keep working, never answered, invalid, and closed.

Keep never answered separate from invalid. They need different actions. One is a follow-up problem and the other is a lead source problem. Then group your ad creatives by those statuses instead of by raw lead count, and the weak creative becomes obvious.

Frequently asked questions

What statuses should a mortgage lead dashboard track?

In this build, every lead was sorted into statuses such as move forward, never answered, invalid, and funded. A short list like that keeps the dashboard readable and makes each status point to a different action, from calling again to checking the lead source.

Why separate never answered from invalid leads?

A lead who never answered may still be worth another attempt, while an invalid lead is bad data and should not be called again. Mixing them hides whether your problem is follow-up effort or the quality of the leads the ads are bringing in.

Why restrict ad targeting by state for a phone-based business?

If every lead is handled by phone, broad targeting only spends budget on people you cannot serve. In this account the plan was to publish the loan-program videos first, then limit the ads to the agreed states.

How many new ad creatives should a lender add?

There is no universal number. On this account only the top three creatives were performing, so the plan was two new creatives per day on an ongoing basis. Judge each new creative by the lead statuses it produces, not by lead volume alone.

If your leads live in a spreadsheet and nobody can say which ones are worth another call, book a 30-minute AI follow-up and reporting audit. We look at where your lead data goes quiet and show you a status view that fixes it.