Create a sales and marketing database that tracks multiple sales/advertising data.

Budget $750 - $1500 CAD
Bids 26
Average Bid $1053

We are looking to have a database created that will help track sales by product (about 30 products) as well as compare other imported data. This database should be able to have the following information imported/entered through a user friendly interface. We are looking for someone that has worked on this type of database, and may have suggestions.

Items to be imported/entered into database:

• A user friendly Main Menu as well as other forms/menus. ITEM 1
• Customer tracking - phone calls and showroom visits/day period See Attachment ITEM 2
• inquiries and how did you hear of us/week period - this is to be entered by a staff member through a form. See Attachment ITEM 2
• Sales data from quickbooks imported with customer data? using ODBC connector? this will be imported every week. See Attachment ITEM 3
• Print Campaigns (newspaper ads, kijiji ads, craiglist ads, etc..) that we are running entered on a weekly bases. See Attachment ITEM 4
• Google site analytics imported, such as web site visits, referral sources etc.
• Google adwords information, such click through rates, cost, etc..
• Facebook information such as visits, new likes, etc…

What we're trying to accomplish:

• Seeing how our campaigns are relating to individual product sales and inquiries, and web traffic.
• See what days are the busiest at the showroom per time period example: year over year are Mondays always the busiest?
• All graphs/charts time frame selected from date pickers
• Sales per product compared with showroom visits/inquires/campaigns
• Other various charts/graphs/print-outs to be determined.

Please Review the attachment for examples of data to be tracked and entered. Please give a detailed explanation on the work you propose for the project.

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project