We have developed a system for 'scoring' a business' customers and clients; to help identify an appropriate marketing activity.
Currently this is in a spreadsheet; using a series of IF and Lookup functions.
The first step is for the user to record a number of names - broken into 5 categories (up to 5 clients for each)
Next they select up to 20 criteria (from a standard list we provide or enter their own)
On the next screen, the selected criteria are presented against the client names for scoring (separate scoring pages for each category but with the same criteria).
Once scored, the forms are submitted and results are presented.
There are set activities for each average score under each category.
Based on the input, the following output is generated for each client:
- Their score (the average of all scores)
- Their zone (1 of 3)
- Their code (based on a matrix we provide)
- Their appropriate marketing activity (based on a matrix we provide - there are 15 options)
- # of clients in each zone
- Summary of all clients presented in a matrix we provide
There is also a short instructions page and input for the user's personal information.
Please ask if you need/want any further information.
9 freelancers are bidding on average $1106 for this job
Hi We are interested in your project and read your requirements.We have completed 150+ big projects in last 5 years. Please check private message board for details.
Hi i have many years of experiences in web development and i have worked on STATS PROGRAM i think i can do this project perfectly.so i can start on this project asap. Thanks.
I have understood your requirement, ready to start, we have over 6+ years of experience in php, mysql, css, facebook apps, web design, flyer, PSD to html, below are some of my requirements.