Prosper Healthcare Lending is a patient financing marketplace company headquartered in Salt Lake City, Utah at the heart of the “Silicon Slopes”. We sit at the intersection of the healthcare, technology, and financial services markets and we are using technology to bring innovative financial services solutions to a massive healthcare problem. Our patient financing platform allows healthcare providers nationwide to help Make Healthcare Affordable™ for patients every day by referring patients with good credit to affordable installment loans offered through Prosper.
Prosper Healthcare Lending is a subsidiary of Prosper Marketplace, America’s first peer-to-peer lending marketplace, with more than 2 million members and over $6,000,000,000 in funded loans.
Main Objective: As a Patient lending platform, we connect healthcare providers (e.g. large hospital systems) and their patients to lenders. Healthcare providers complete forms on our website to refer their patients to us and complete loan requests. When these leads comes in, account data and loan request data gets entered into Salesforce automatically. To provide access to loan request status details, we implemented a Salesforce1 Customer Community. To provide access to real-time & relevant aggregated loan request status information, we needed to somehow roll-up multiple loan requests for each provider and provide healthcare providers and our account managers with a summary of activity on the account page. The account page was viewable in the Customer Portal by users of the healthcare provider.
Approach: Initially, we were using salesforce reports to get this information. The challenge with this approach was that the reports were too time consuming to generate. Multiple steps had to be carried out by the users to update information before the reports could reflect accurate date. We considered writing custom apex code to do batch updates of this information, but it was never in real-time. Having a real-time process was needed, so that Accounts Managers and their Customers didn't have to wait to analyze this information.
To provide real-time loan request status and summary information to the account management team and our customers, we created rollups in Rollup Helper for each of our loan metrics. Rollup Helper was the only solution which allowed them to do this in real-time.
Challenge: Salesforce did not provide the tools to do this out of the box and custom apex coding was not a cost affordable, fast, or real-time option.
- A Loan request child record tied to a parent HealthCare provider account was entered from our website.
- One of our rollups was the count of open loan requests. When the count of open loan requests was > 0, we sent workflow email notifications out to the lenders for them to help with the pre-approval process.
- One of our other rollups was to check any loan requests had been pre-approved. This cause another workflow email notification to go out to the Healthcare provider.
- We implemented several other meaningful workflow-based email notifications tied to the Healthcare provider account lifecycle (e.g. First Loan Funded).
Without Rollup Helper, none of these workflows would have been achievable as the data was not available in real-time.
Results: Rollup Helper has dramatically improved customer engagement & has positively impacted our sales process as we can now acquire & communicate more information in real-time than ever before. Account manager users and customer portal (Salesforce1 Community) users can easily login and see in real-time what is going on with funding and what pending loan requests exist. What used to take each account manager 30 minutes - 45 minutes to generate, now takes seconds. We can now roll-up information in real-time for 500 providers. Additionally, even more time has been saved as we have implemented rollups used for our monthly account statements.