In Progress

Lead / Client database web based

We're a small company that has trouble tracking clients and leads (leads are potential clients). We do construction and renovation, painting, home repair. We do telemarketing to find clients who are interested to have some work done, then an estimator (salesman) goes there and gives them a quote. If it gets sold, they become our client. Sometimes clients order more than once, maybe after a year or two or more, they will order again. We need to keep track of everything - who ordered what, who made an appointment, who got quoted, who didnt... who needs to be followed up, and by who (who will follow it up?) etc.

I thought about the features I want, and here it is:

Appointment/Lead Tracking Software, Web-based. It should be very easy to use, and have nice interface (like [url removed, login to view], or facebook and gmail ... use AJAX or something similar. easily viewable and useable on your cellphone browser)

I made a sample which is very ugly and doesnt work, see attached. its just to help you see what we need. The final product should be WAY better than this

It should be able to:

1. Keep track of all appointments made

2. Appointments should have the following details: lead's name, phone, email and address, date app was made, date of actual appt, agent info, estimator name, lead type (A,B,C,AAA, etc), and comments.

3. Every time a comment is made, a date/time stamp and username is appended so there is a history of all comments added or any time the lead is updated.

4. It should be classified if: sold, ff up by marie with date, results and comments, then ff up by Manila same with comments and notes, most likely 5 ff ups in a year if not sold on 1st attempts.

5. Ability to export everything into excel

6. Ability to search by date made or date of last follow up call made, and export an excel list based on date of last follow up call.

7. Ability to assign to a salesman/estimator

8. Ability to search for anything - example, if I search for "Jones", search results should return all records containing JONES - either first name, last name, comments, street address, etc.

9. ability to: Add/Edit/Delete Lead classifications (Such as Sold, Followup-Marie, Followup-Manila, Bad, Chose Another Vendor, etc)

10. ability to view master stats page upon login, which will show how many leads there are, how many are in each classification (Sold, Followup, etc)

11. ability to: Add/Edit/Delete Users

12. ability to: Add/Edit/Delete Salesmen/Estimators list

13. ability to: Add/Edit/Delete Lead type (such as AAA, A, B, C, etc)

14. ability to: Add/Edit/Delete other things to the lead, in case we think of something else other than the "type" and "classification" and "sale amount". Maybe in the future we can add "material cost" to the lead, or some other thing.

Sample Lead History:

1) Created March 1, 2013 by jsmith

2) Notes added on April 29, 2013: "Mrs. Jones never answers her phone, i left her 7 messages" by marie

3) Classification changed from Followup-Marie to Followup-Manila on April 30, 2013 by marie

4) Notes added on May 3, 2013: "Mrs Jones wants another estimator to come over on May 12, 2013" by Manila03

5) Lead type changed to "A" on May 3, 2013 by Manila03

6) Sale price updated to "$17,000" and classification changed from Followup-Manila to "SOLD" on May 13, 2013

Skills: AJAX, Graphic Design, HTML, PHP, Website Design

See more: work notes freelancer, work home leads list, needs design web, made freelancer, software use web design, every freelancer needs, web page repair, web page design notes, web design software database, web design master, web design freelancer database, web design case price, web based design, web app freelancer, vendor freelancer, type freelancer username, tracking home freelancer, telemarketing web app, stats answers, stamp website design, stamp design website, software keep track clients, software freelancer cost, see client web design, sale design freelancer

About the Employer:
( 15 reviews ) Makati, Philippines

Project ID: #4832450

Awarded to:


Hi jaxdeguzman, I have developed something similar to this before (see my review, project "lead management"). Let me help you :) Thanks, Quan.

$684 USD in 15 days
(10 Reviews)

42 freelancers are bidding on average $976 for this job


Experts are here, kindly check PM, thanks!!!

$1000 USD in 35 days
(200 Reviews)

Hello, We are Experienced Professionals with similar skills required and having 7 years of web based and mobile based Development expertise. Please see PMB. Thanks

$1474 USD in 30 days
(119 Reviews)

Hi, I can help you on this and develop what you need. Best quality assured. Thanks

$1546 USD in 30 days
(859 Reviews)

**********************.. YOUR SEARCH ENDS HERE .. ********************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and getting started. I've been working in simple and More

$1030 USD in 8 days
(127 Reviews)

Check your PMB for details!!!

$1427 USD in 30 days
(81 Reviews)

We have all the required designers and developers according to your project and we can allocate dedicated resources to your project. You will be very happy and satisfied with our services.

$1030 USD in 25 days
(98 Reviews)

Greetings, We would like to avail required solution.

$1631 USD in 30 days
(331 Reviews)

Please check PMB for reference

$1000 USD in 30 days
(224 Reviews)

Expert developer here. we like to build this lead/client management system. ready to start right now.

$824 USD in 15 days
(129 Reviews)

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$789 USD in 30 days
(63 Reviews)

We believe good design is like good manners, you just simply have it and you do not need to prove it. You might not find us on Award lists and we do not aim to get any award. Our award = superb result = happy client. W More

$1030 USD in 10 days
(356 Reviews)

We are ready to endow with the solution as per your requirements.Please check your PMB to see our previous work. Thank You.

$1030 USD in 30 days
(120 Reviews)

Hi, Thank you for considering our proposal and please contact us for further discussions. Please check your PMB for more details and portfolio. Thanks!

$900 USD in 28 days
(47 Reviews)

we will develop this lead management system in php and mysql

$947 USD in 30 days
(93 Reviews)

Dear Sir or Madam: Thank you for giving us opportunity to submit our proposal for your project. Our company have good team of people which includes: Project Manager, Web Developer, Web Designer, Q/A and Testing sta More

$1150 USD in 30 days
(112 Reviews)

Hi, I am confident i am able to help you with this project. Just give me the chance!

$1084 USD in 30 days
(34 Reviews)

Hi, We have a dedicated team with 7 years of experience on PHP/MySQL, Ajax, Jquery, HTML, CSS, Javascript, Java/J2EE. Also having much experience on framework and CMS like 1) CakePHP 2) CodeIgniter 3) Zendframew More

$1030 USD in 20 days
(47 Reviews)

Hi, Consider its done! I would love to get this opportunity of working with you. I can guarantee complete satisfaction if you select me to execute this project. Please check your private message board. Thanks

$1030 USD in 10 days
(47 Reviews)

Hello, we are very serious about this project. please have a look at your p-m.b. Thanks

$1000 USD in 25 days
(89 Reviews)

Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Please check inbox for our previous work.

$1287 USD in 22 days
(60 Reviews)