Setting up a follow-up routine to qualify leads for loan applications

Setting up a follow-up routine to qualify leads for loan applications

Feature: Workflow Rule | Edition: Enterprise
 
Scenario
 
Michael Andrew is a loan officer who evaluates and authorizes loans to small and medium-sized enterprises, and self-employed individuals. A week back, his company announced about a "Smart Scheme" that gives financial assistance of up to $50,000 at low interest rates. Post this announcement, they have been flooded with enquiries about the scheme like eligibility, minimum interest rate, coverage, etc. Besides soliciting loans, Michael is also responsible for following-up with each prospect to qualify and convert them to create an opportunity.
 
Requirement
Below is the follow-up process that he plans. However, with so many applications and enquires, he finds it difficult to track the statuses manually. To work efficiently, he needs to automate the follow-up processes.



 
Solution
 
Michael decides to make use of Workflow rules to set up the follow-up routine and streamline the process. 
 
In a Workflow Rule, he can set up multiple conditions, each of which includes the criteria and the actions for each follow up. However, before setting up the Workflow, there are some pre-requisites:

I. Create a Custom Module
 
   Go to Setup > Customization > Modules and Fields > New Module to create a module named Borrowers.
 
II. Add Picklist Fields

    Borrower's Status: 
  1. Interested in Scheme
  2. Details of Scheme Sent
  3. First Reminder Sent
  4. Second Reminder Sent
  5. Called
  6. Lost Borrower 
Response Status: 
  1. Responded 
  2. Has not Responded 
To create fields, follow the steps in the link below https://help.zoho.com/portal/kb/articles/use-custom-fields#Custom_Fields
 
Note: Select Interested in Scheme from the Select Default Value drop-down of the Borrower's Status field.
This enables you to have the status of each lead automatically updated to "Interested in Scheme". 
 
III. Design Email Templates
 
     Create three email templates:
  1. Details of Scheme
  2. First Reminder
  3. Final Reminder 
To do this follow the steps given in the link below:
 
Workflow Rule

1. Go to Setup > Automation > Workflow Rules > Create Rule and create a rule for the Borrowers module
 
    Enter the following details:

Rule Name

Email Prospects Based on Loan Origination Status

Description (optional) 

Send email to prospects

When to execute

On a Record Action > Create



Condition 1

Which records the rule should apply to?

Records matching certain conditions. 

Criteria 

 

* Borrower Type is Existing Borrower, New Borrower.

AND

* Borrower Status is Interested in Scheme.

Instant Action

-

Action - I

Email Notification

Name

Details of Scheme

Action - II

Field Update 

Name

Details of Scheme Sent

Module

Borrowers

Update

Borrower's Status = Details of Scheme Sent



 Condition 2

Which records the rule should apply to?

Records matching certain conditions.

Criteria 

* Borrower's Status is Details of Scheme Sent.

AND

* Response Status is Has Not Responded.

Scheduled Action 

Set action to execute 2 Days After Rule Trigger Date

Action - I 

Email Notification

Name

First Reminder

Action - II

Field Update

Name

Reminder 1 Sent

Module

Borrowers

Update

Borrower's Status = First Reminder Sent


Condition 3

Which records the rule should apply to?

Records matching certain conditions.

Criteria 

* Borrower's Status is Reminder 1 Sent.

AND

* Response Status is Has Not Responded.

Scheduled Action 

Set action to execute 4 Days After Rule Trigger Date

Action - I

Email Notification

Name

Final Reminder

Action - II 

Field Update

Name

Reminder 2 Sent

Module

Borrowers

Update

Borrower's Status = Second Reminder Sent


Condition 4

Which records the rule should apply to?

Records matching certain conditions.

Criteria

Borrower's Status is Reminder 2 Sent.

                            AND

Response Status is Has Not Responded. 

Scheduled Action

Set action to execute 6 Days After Rule Trigger Date)

 

Action - I 

Task

Subject

Call borrower to remind them about schemes

Due Date 

Workflow Rule Trigger Date plus 6 day(s


Condition 5

Which records the rule should apply to?

Records matching certain conditions.

Criteria

Borrower's Status is Called.

AND

Response Status is Has Not Responded. 

Instant Action

-

Action - I

Field Update

Name

Lost

Module

Borrowers

Update

Borrower's Status = Lost
















    • Related Articles

    • How do I export my leads from CRM to an XLS file?

      You can export the leads in your account to an XLS file using reports. To export leads: Go to the Reports module and click Create Report. Select the Leads module and choose a report type, e.g. Tabular. Select the fields you want to add to your ...

    • Creating Leads

      In Zoho CRM, you can create leads by: Entering data in the lead details form: You can manually fill in the Lead details gathered from various external sources, e.g. trade shows, exhibitions, colleagues, business cards, etc. Importing leads from ...

    • Initiate an approval request when the loan applicant has a low credit score

      Edition: Enterprise | Industry: Banking and Loan | Feature: Approval Process  Scenario Noah Parker is a loan officer at a Boston-based finance firm that specializes in providing financial assistance to SMBs, individuals, and retailers. He receives ...

    • Working with Leads

      Leads are the details gathered about an individual or representatives of an organization. They play a very important role in an organization's Sales & Marketing department and are useful in identifying potential customers. Collecting leads and ...

    • Setting up SalesIQ Integration

      Zoho SalesIQ integration with Zoho CRM, also called as Visitor Tracking, allows you to engage with people visiting your website through chat and push their information into CRM. You can also embed a chat widget on your webpage and converse with the ...