Skip to Content
Back to projects

Financial services analytics

Fixing the Deposit Application Funnel

A 365-day analysis of San Francisco Fire Credit Union's deposit application funnel: where 85% of prospective members were being lost, why, and the page-by-page fixes that followed.

The short version

  • SF Fire Credit Union was losing 85% of the people who started a deposit application. I analysed 365 days of funnel data in BigQuery to find where they left, and why.
  • Time was the culprit: completions averaged 17.4 minutes against an industry danger line of five, and a quarter of prospects took more than 20 minutes.
  • I walked the application page by page and logged the friction: one long form with no progress indicator, no way to save and resume, and an ID step that left applications stuck in pending.
  • Every recommendation shipped as a mockup with the data that justified it: capture email first, simplify eligibility, prefill forms. Application processing time fell 19%, and abandonment went from a dead end to a follow-up list.

Pull-through when I started

15%

Average completion time

17.4 min

Application processing time

-19%

A San Francisco cable car climbing California Street

The problem, drawn

15%COMPLETED85%STARTED AN APPLICATION, NEVER FINISHED15%COMPLETED THE APPLICATION
365 days of deposit-application funnel data: 85% of started applications were never finished. A quarter of prospects took more than 20 minutes, against a 17.4-minute average for those who reached the final page.

The setting

As Data Scientist at San Francisco Fire Credit Union (August 2024 to August 2025), I owned the analysis of how new members join. Deposit accounts are the majority of new membership applications, so if the credit union wanted to grow, this funnel was where growth lived.

What the data showed

I analysed 365 days of deposit-application funnel data in BigQuery. The pull-through rate was 15%: of everyone who started a deposit application, 85% never finished it.

Time was the clearest culprit. The average completion took 17.4 minutes for people who reached the final page, and a quarter of prospects took more than 20 minutes. Industry research says that is far past the danger line: The Financial Brand reports abandonment rising to 60% or more once account opening takes over five minutes, and McKinsey found every additional 10 seconds of application time correlates with a 5% increase in abandonment.

Walking the funnel

The funnel data showed where people left, but not why. So I walked the existing application page by page, the way an applicant would, and logged the friction.

The personal information and ID screens were one long form with no progress indicator, which is punishing on a phone. There was no way to save and continue later, so anyone interrupted mid-application lost everything. The ID upload step had a low click rate and produced applications stuck in pending for lack of a document. Eligibility questions and product selection were tangled together on one screen, asking people to make two kinds of decision at once.

The recommendations

The analysis pointed to two levers: make the process faster and easier, and stop treating an abandoned application as gone forever.

The recommendations were specific to the friction we found. Collect email first, which makes save-and-resume possible and lets us follow up with people who drop out. Simplify the eligibility questions (published research suggests removing three selections lifts pull-through by around 11%) and split them from product selection so each screen asks one kind of question. Prefill forms from answers already given. Make the ID upload an explicit, obvious step. Give the funding screen plain descriptions and a clear submit.

Each recommendation shipped as a mockup of the redesigned screen alongside the data that justified it, so the design conversation started from evidence rather than opinion.

The outcome

The funnel work contributed to cutting application processing time by 19%. Just as importantly, capturing email early turned abandonment from a dead end into a follow-up list, and the page-by-page evidence gave the digital team a prioritised backlog rather than a vague sense that the application was too long.