Database for project management

Cerrado Publicado May 22, 2008 Pagado a la entrega
Cerrado Pagado a la entrega

We are an ecommerce retail company that sells various products on different websites. We advertise with many online websites, and we are looking to keep a better management of this. The purpose of this database program will be to organize our advertising contracts and help assist in harvesting lists of new prospects for our company to advertise with. Currently, we use Excel spreadsheets to list all of our contacts. It does not keep track of overall progress per site (grown of advertising expenditure), overall advertising expense per site, and renewal reminders. The information relevant to each contract is spread out on the spreadsheet beyond one visible viewing screen. In short, there are several disappointments in our current system, and it is long overdue for a repair.

## Deliverables

There will be 5 people using this program , and we need functionality to add users. They will all be similar hardware configs, with Windows Vista or XP.

There are a three main components to our advertising process:

1) Harvesting Targets

During this process, we use a variety of methods to harvest a list of sites that we are interested in advertising on. We may search google, use advanced google modifiers, etc. The methods we use do NOT matter for the database. All we NEED the database to accomplish for this part of the process is have a place for us to input a URL, and some basic contact information we find on the website (email address, whois email, contact form, etc).

Each harvested target also needs to be identified according to the website, or websites, we are trying to advertise. Some sites we may choose to advertise on for several of our businesses. This is especially common for our automotive sites.

When placing a site into our harvested list, the system needs to be able to identify if this site has already been placed in the harvested list before, or if we are currently advertising with this site with any of our companies. Because multiple people work together to harvest targets, this is very important. Cross checking the contact emails and the domain names should work well, but any other ideas to accomplish this are welcome.

2) Contacting Harvested Sites

We would like the second component of this database program to be a log in area where our users can send contacts out to our harvested list, and record the details of any correspondences that result thereafter. Roughly 20% of our sent emails are responded to, so most harvested targets are dead on contact. We have experienced some good results in sending email follow ups 30 days after sending our first email, so having a highlight at that time for non responsive sites would be very efficient. For the sites that do respond, the details of the correspondences should be recorded for later reference in the database.

3) Management of advertising agreements

All of our current advertisers need to be managed in this database. Right now, the contract details and start of contract date are kept in a column on the Master Link Sheet. The database should be able to line graph our month to month progress. It would be good to be able to graph multiple pieces of information, such as number of advertisers, or total advertising cost.

If MS Access is unable to accomplish these graphs, we may be able to just have it chart some numbers for us. Please advise.

Ingeniería Microsoft Microsoft Access MySQL PHP Gestión de proyectos Arquitectura de software Verificación de software Windows Desktop

Nº del proyecto: #3943038

Sobre el proyecto

14 propuestas Proyecto remoto Activo Jun 13, 2008

14 freelancers están ofertando un promedio de $3079 por este trabajo

LeadSoft

See private message.

$4250 USD en 14 días
(48 comentarios)
8.2
shikhamehta

See private message.

$2975 USD en 14 días
(248 comentarios)
7.2
asselsolutions

See private message.

$2890 USD en 14 días
(65 comentarios)
7.1
asawyer13

See private message.

$4080 USD en 14 días
(59 comentarios)
5.8
micrologixsl

See private message.

$4675 USD en 14 días
(21 comentarios)
5.5
tusharjohri

See private message.

$1498.55 USD en 14 días
(82 comentarios)
5.6
FMKSOFT

See private message.

$850 USD en 14 días
(10 comentarios)
5.2
jamiedrapervw

See private message.

$4462.5 USD en 14 días
(17 comentarios)
4.4
arilonza

See private message.

$2125 USD en 14 días
(4 comentarios)
3.4
klaus71

See private message.

$2975 USD en 14 días
(5 comentarios)
3.3
russellfox

See private message.

$1275 USD en 14 días
(2 comentarios)
1.9
krishkunair

See private message.

$4250 USD en 14 días
(0 comentarios)
0.0
envizionsoftllc

See private message.

$2550 USD en 14 días
(0 comentarios)
0.0
jairosolutions2

See private message.

$4250 USD en 14 días
(2 comentarios)
0.0