Email Tracking System

Specification for tracking system.


The purpose of this system is to track the status of bulk emails, whether they have been opened, whether various links have been clicked and so on.


We have a large opt-in mailing list that we email once a month. We currently use an outside provider to monitor the emails, but would like to bring this in-house. We use Groupmail from infacta as our engine for sending the emails so that is all taken care of.

We create an email for various clients, and in that email have links to various parts of their website. We would like to track that click through, and the way naturally would be via redirect.

For example if the client was the BBC and they wanted a link to one of their pages, say [url removed, login to view] if we just stuck that link onto the email we couldn’t track it. However, if we had a database on one of our webservers that redirected it, we could create a link thus :

<A href="[url removed, login to view];amp;i=44274&u=" !*contact_id*!>BBC NEWS LINK Click Here</A>

Where ourdomain is the domain of our tracking server

C is our client id

I is the hyperlink id

And u is a merged (by groupmail) id of the contact to whom we are sending the email.

When the reader clicks through, our server can read the iis log, and store that data in an sql database (mysql?)

Furthermore, to track whether the reader has opened the email, a link to an invisible graphic would be placed on the page with this kind of a link:

<img src="[url removed, login to view];u="!*contact_id*! border="0" width="1" height="2">

Where again

C= our clients id

And u=the reader id

When the email was opened, (and the popup not blocked) the event would be recorded in our database.

All simple stuff so far.

Logins and reports.

First off we’re going to need an admin system. This will be where our administrator can create client Ids, and also create campaigns (open links and page links).

What we want is :

Admin Side

1 Create Client:

This will create a client page with name and an ID, and a user name and password.

2: administer client

Allows edit of 1.

3: create campaign

Creates an id for the campaign, and takes a description (eg ABCSpecifier July 2006)

Must list the clients that will be using this campaign

4: add links to the campaign

Need to be able to create an ‘Open page’ link, which will show the html code to be cut and pasted into the email,

Likewise need to be able to create a ‘link’ page where we put in the real link we want to be redirected to, and the system will produce a redirect link that will be cut and pasted into the email.

3,4 & 5 to be editable, and by admin only

That’s pretty much it for the admin side.

Client side.

1: login

Once logged in, they will be able to view the list of campaigns that have been created on their behalf.

2: campaign

If they click on a campaign, a stats page will come up.

This will show the list of links that were on that campaign associated with their account, along with the number of clicks through. ( a graph would be nice showing clicks over time, but not essential)

It will also show the number of people who opened the email on that campaign.

If they click on the link, they can see all those people that clicked through on that link – with brief detail – eg email address (by linking the contact_id with that of the contact_id stored in the database). A further button (show detail) will list the same contacts, but by full detail, including postal address and telephone etc, all linked again by contact_id.

All associated contacts in both formats (ie brief and detailed) should be able to be exported in a csv list, with all open/link thru detail (dates/time etc)

Email recipient side

A very simple form that enables the email recipient to log in to a screen and amend his address details, and to add further details, such as interests in various products (customisable via a database).

Will have a user name and password which is store in the database.

Would also like it time stamped so that we can track when or if they ever log in.

Also allows them to add further interested people to the mailout list.

Evner: ASP, Perl, Web Design

Se mere: which graph to use for data, what is linked in, what is a graph, what graph to use for data, what graph, user specification, use graph, use a graph, uk email database, uk email address database, uk business email list, uk business email database, track description, the parts house, system server, system one, system monitor 1.1, people co, parts database example, opt it, opt in mailing list, opt in code, monitor default, list graph, link graph

Om arbejdsgiveren:
( 0 bedømmelser ) Henley on thmaes, United Kingdom

Projekt ID: #97341

24 freelancere byder i gennemsnit $1074 på dette job


we have gone through ur requirements... Ready to start...

$500 USD in 7 dage
(288 bedømmelser)

Hi, we are ready to start,thanx

$1200 USD in 30 dage
(36 bedømmelser)

Ready to start immediately on your project, as we are the experts in such things. Waiting for your selection. Thanks!

$1500 USD in 30 dage
(65 bedømmelser)

Can be done easily..

$1300 USD in 40 dage
(12 bedømmelser)

Pls see pmb.

$1200 USD in 20 dage
(2 bedømmelser)

Hello. Please check the PMB.

$400 USD in 7 dage
(10 bedømmelser)

Hello sir, We can code this project as we are working on FrontHand for Email Server. We will provide you complete sol for this project. AS we are working on this type of project, we will not face any problem.... Flere

$1000 USD in 30 dage
(1 bedømmelse)

plz give a glance at PMB, Regards,UrFi

$1500 USD in 20 dage
(6 bedømmelser)

Hey, Im representing a reputed Web development organization. We have done umpteen number of websites and you can see some of them on our website. Pls check your PM for the website address. Awaiting your reply. Best Flere

$1500 USD in 45 dage
(1 bedømmelse)

Please review PMB

$1200 USD in 20 dage
(1 bedømmelse)

Dear Sir/Madam Thank you for allowing us to bid your project. We are a Professional Web Development Company having experience in Web Design and Development. We also do software development an Flere

$1500 USD in 35 dage
(1 bedømmelse)

Please note this bid is only an expression of our interest in your project. We may come back to you for more information, through personal message. We will place a more realistic bid and time of completion within 2-3 d Flere

$300 USD in 7 dage
(0 bedømmelser)

plz check pmb

$1500 USD in 30 dage
(0 bedømmelser)

We are very much interested to work for you. I don't wish for to take your much time, so please go through the Sites below. Our recent works. http://www.gibay. Flere

$1500 USD in 20 dage
(0 bedømmelser)

This is a place holder, Please check PMB. Thanks.

$1500 USD in 30 dage
(0 bedømmelser)

See PM please. Thanks for ur time and Hope to hear from you.

$1490 USD in 0 dage
(0 bedømmelser)

i summited the project in 45 days. i worked on this project using with C#

$300 USD in 45 dage
(0 bedømmelser)

Jarun :Owned and Operated by karun as of February 2005. Designers and Programmers highly skilled

$1285 USD in 27 dage
(0 bedømmelser)

I am an expereinced developer i can acoomplish the task required by you easily please give me chance to prove my skills i will wait for your affirmative reply.

$400 USD in 21 dage
(0 bedømmelser)

Hi. I'm based in the US. I can have it ready in a couple of days, contact me for details.

$400 USD in 2 dage
(0 bedømmelser)