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.

Beceriler: ASP, Perl, Web Sitesi Tasarımı

Daha fazlasını görün: 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

İşveren Hakkında:
( 0 değerlendirme ) Henley on thmaes, United Kingdom

Proje NO: #97341

24 freelancers are bidding on average $1074 for this job


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

in 7 gün içinde500$ USD
(288 Değerlendirme)

Hi, we are ready to start,thanx

in 30 gün içinde1200$ USD
(36 Değerlendirme)

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

in 30 gün içinde1500$ USD
(65 Değerlendirme)

Can be done easily..

in 40 gün içinde1300$ USD
(12 Değerlendirme)

Pls see pmb.

in 20 gün içinde1200$ USD
(2 Değerlendirme)

Hello. Please check the PMB.

in 7 gün içinde400$ USD
(10 Değerlendirme)

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.... Daha fazlası

in 30 gün içinde1000$ USD
(1 Değerlendirme)

plz give a glance at PMB, Regards,UrFi

in 20 gün içinde1500$ USD
(6 Değerlendirme)

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 Daha fazlası

in 45 gün içinde1500$ USD
(1 Değerlendirme)

Please review PMB

in 20 gün içinde1200$ USD
(1 Değerlendirme)

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 Daha fazlası

in 35 gün içinde1500$ USD
(1 Değerlendirme)

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 Daha fazlası

in 7 gün içinde300$ USD
(0 Değerlendirme)

plz check pmb

in 30 gün içinde1500$ USD
(0 Değerlendirme)

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. Daha fazlası

in 20 gün içinde1500$ USD
(0 Değerlendirme)

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

in 30 gün içinde1500$ USD
(0 Değerlendirme)

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

in 0 gün içinde1490$ USD
(0 Değerlendirme)

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

in 45 gün içinde300$ USD
(0 Değerlendirme)

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

in 27 gün içinde1285$ USD
(0 Değerlendirme)

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.

in 21 gün içinde400$ USD
(0 Değerlendirme)

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

in 2 gün içinde400$ USD
(0 Değerlendirme)