MAIN FUNCTION

In this case, we will use Google FREE solution to handle the leads. From google site, to Google App Script and Google Sheet. All the analysis and function are automatically and REAL TIME. Only input such as client respond after contacting them required person in charge to manually update them

Below attached a video to demonstrate the project. 

Also, the key features are listed

 WHAT CAN WE CUSTOMISE THE SYSTEM?

Of course, there are more additional feature can added into the system. The key point is, all business is unique, and may need long term support for the system based on their need.

1. Cell protection, which set validation when want to update data to prevent accidently update.

2.Security, which prevent unauthorized access to the system.

3. Backup using database, such as SQL or Firebase, to prevent some one accidently edit the data.

4. Synchronize the data to other system, for users need to communicate data between department, only relevant data are show to them. Google App Script are slow in communicate data, we may use database to handle it.

5. Interest analysis, after person in charge update lead information, we can analysis and make visualize conclusion on the lead information, to make next marketing decision.

6. Commission calculation and performance management, as person in charge update their sales and performance, automation in calculation commission can be made by formula.

7. Reminder, relevant reminder can be set.

8. AI analysis of interest, as the lead getting many, and person in charge may update using different method, AI may included inside analysis process.

 LIMITATION OF THE PROJECT

Google solution are not work well to handle huge amount of lead, as there are access limit and Google may assume us spamming if we using Email marketing as huge amount of email are sent out in short time.