Future Family Accelerates Approvals With A Modernized Funnel And Analytics Platform

Client

Future Family

Location

San Francisco, CA

Industry

Financial services and IVF

Services & Tech

Solution implemented on customer's existing cloud stack [PostgreSQL, GCP Cloud Functions, BigQuery, Pub/Sub, Terraform, CircleCI]

Project Overview

Future Family, a fertility focused financial services company, partnered with Avahi to modernize its digital experience and strengthen data driven decision making. The company needed to revamp its marketing website to improve the loan application funnel and build a robust analytics and file processing stack to understand why applications were being approved or declined. Avahi delivered a new production ready marketing site, a cloud native data platform, and an admin analytics dashboard that gave Future Family end-to-end visibility into loan processing. Within two weeks of launch, Future Family saw record daily approvals and sustained week over week funnel improvement.

About the
Customer

Future Family combines fertility expertise with innovative financing, helping families access IVF (in-vitro fertilization) and fertility care through tailored loan products and a digital first experience. Operating at the intersection of financial services and healthcare, the company relies on an efficient online funnel and precise credit decisioning to scale responsibly while maintaining a positive member experience.

The
Problem

Future Family had two critical, connected challenges. First, its marketing website needed modernization to better support 2025 fourth quarter growth objectives and improve the performance of the loan approval funnel. The existing experience was not fully optimized for conversions, and site performance, content structure, and analytics instrumentation limited the ability to test and scale new campaigns.

Second, the team lacked comprehensive visibility into how uploaded CSV files and loan applications flowed through internal systems. Operations and risk teams needed better tracking of file ingestion, error handling, and row level status for each record. Without this, diagnosing issues, understanding decline reasons, and refining underwriting models required manual effort and ad hoc analysis.

Beyond operational visibility, Future Family needed advanced analytics on decline patterns. They wanted to understand how FICO scores – a widely used three-digit credit score -, debt to income (DTI) ratios, and income distributions interacted with various decline reasons so that credit policies could be tuned with confidence. Without solving these issues, Future Family risked slower growth, missed approvals, and an inability to systematically improve underwriting rules and marketing strategies.

Why Future Family Chose Avahi

Future Family selected Avahi for its depth in cloud native engineering, data platforms, and digital experience delivery, as well as its track record working with high growth, regulated businesses. As Premier Tier AWS partner, Avahi brings strong architecture discipline, automation first operating models, and familiarity with the requirements of financial services and healthcare adjacent workloads.

The Future Family team needed a partner that could move quickly against Q4 OKRs while managing real production risk. Avahi demonstrated the ability to stand up a new marketing site, define and implement a complete analytics stack, and troubleshoot complex CI/CD and infrastructure challenges collaboratively with the client’s CTО and engineering team.

Solution

  • Avahi structured the engagement into two tightly connected workstreams: modernizing the marketing website and implementing a comprehensive data analytics and file processing platform.
  • For the marketing website, Avahi delivered a complete revamp and deployed it to production on November 4, 2025. The team implemented a CI/CD pipeline using CircleCI so that code changes could be tested and pushed to production with minimal manual intervention. Terraform was used to define and manage the underlying infrastructure as code, which improved repeatability and reduced configuration drift across environments. Avahi optimized site performance by deferring noncritical scripts, refining the hero section and key content areas, and integrating Google Tag Manager to enable more granular tracking of funnel behavior without heavy engineering involvement. The site was also prepared for Spanish language support, allowing Future Family to reach more customers without a full redevelopment.
  • On the data and file processing side, Avahi designed and implemented a cloud native platform that gave Future Family end to end visibility from file upload through analytics. A PostgreSQL database was provisioned using Terraform in the client’s GCP environment, establishing a robust and managed data store for application and processing metadata. CSV processing pipelines were built using GCP Cloud Functions, which ingested loan application files, processed rows, and wrote detailed status and error information back to the database.
  • To ensure reliability and transparency, Avahi implemented row level status tracking, automated error file generation, and explicit handling for skipped or malformed records. Pub/Sub messaging was used to provide real-time updates on processing status and to decouple components, improving resilience under varying load. BigQuery was integrated as the analytics engine, enabling complex queries on large datasets, particularly around decline reasons, FICO score bands, DTI ranges, and income buckets.
  • To ensure reliability and transparency, Avahi implemented row level status tracking, automated error file generation, and explicit handling for skipped or malformed records. Pub/Sub messaging was used to provide real-time updates on processing status and to decouple components, improving resilience under varying load. BigQuery was integrated as the analytics engine, enabling complex queries on large datasets, particularly around decline reasons, FICO score bands, DTI ranges, and income buckets.
  • The project included overcoming several non trivial technical challenges. Avahi adapted the CI/ CD design during a CircleCI outage by adjusting how contexts and values were passed through the build process and temporarily falling back to manual Terraform deployments via Artifactory built images when Bitbucket experienced disruptions. For database testing, the team shifted from Test containers to a cloud based PostgreSQL instance to better reflect the behavior of GCP Cloud Functions. Avahi also worked closely with Future Family’s CTO to resolve access and authentication issues, ensuring the team could operate efficiently in the client’s environment.

Key Deliverables

– New production ready marketing website deployed on November 4, 2025

– CI/CD pipeline for the marketing site using CircleCI and Terraform

– Performance and content optimizations for the marketing funnel, including deferred scripts and enhanced hero section

– Google Tag Manager integration for improved funnel tracking and experimentation

– Infrastructure readiness for Spanish language support on the marketing site

– PostgreSQL database provisioned and managed via Terraform in the client’s cloud environment

– CSV file processing pipeline using GCP Cloud Functions with detailed row level status tracking

– Error file generation and skipped record management with complete auditability

– Pub/Sub based status notifications for real time file processing updates

– BigQuery based analytics layer for decline and performance analysis

– Admin analytics dashboard with search, refresh, pagination, and visualization of multiple report types

Project
Impact

Within two weeks of launching the new marketing website and supporting infrastructure, Future Family saw measurable improvements in its loan approval funnel. The company recorded its highest ever daily approvals, followed by another strong day, indicating that the optimizations were not a one-off spike but part of a sustained upward trend. The marketing team and leadership explicitly linked the early traction to the new page optimizations and the improved visibility into funnel behavior.

Operationally, the new data platform and dashboard delivered complete transparency into file ingestion and processing, reduced manual investigation time, and enabled a more scientific approach to underwriting adjustments. Decline patterns can now be monitored across FICO, DTI, and income segments using prebuilt reports, which helps Future Family adjust lending criteria with confidence while managing risk.

Metrics

  • 37 approvals in a single day, a new record for Future Family
  • 36 approvals the following day, demonstrating sustained improvement rather than a one time spike
  • Steady week over week improvement in approval funnel performance following launch
  • 100 percent tracking of file processing from upload to completion
  • All skipped records captured in detailed error files for rapid root cause analysis
  • More than eight distinct report types available for multi dimensional decline analysis
  • Real time dashboard with interactive visualizations and operational search capabilities

We highly recommend Avahi as a reliable and innovative technology partner. Their expertise in cutting-edge technologies was instrumental in building our Proof of Concept (PoC) and developing our Minimum Viable Product (MVP). Avahi consistently delivered high-quality solutions on time while maintaining a collaborative, responsive approach. They went beyond expectations by identifying opportunities for enhancement, ensuring scalability and compliance for our law enforcement-focused products. Avahi is the clear choice if you need a tech partner with industry knowledge, professionalism, and a commitment to innovation.

Brandon Puhlman

Founder, Bravo Foxtrot

Ready to Transform Your Business with AI?

Book Your Free Ignition AI Workshop

Let’s explore your high-impact AI opportunities together in a complimentary half-day session

View Our Case Studies

See how we’ve delivered measurable results for businesses like yours