Lead / Client database web based

IN PROGRESS
Bids
44
Avg Bid (USD)
$976
Project Budget (USD)
$100 - $1000

Project Description:
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 Freelancer.com, 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 required:
AJAX, Graphic Design, HTML, PHP, Website Design
Additional Files: dopper.zip
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 1000
in 35 days
$ 1474
in 30 days
$ 1546
in 30 days
$ 1030
in 8 days
$ 1427
in 30 days
$ 1030
in 25 days
$ 1631
in 30 days
$ 1000
in 30 days
$ 824
in 15 days
$ 789
in 30 days