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&amp;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">
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 :
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.
Once logged in, they will be able to view the list of campaigns that have been created on their behalf.
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.
24 freelancers are bidding on average $1074 for this job
we have gone through ur requirements... Ready to start...
Ready to start immediately on your project, as we are the experts in such things. Waiting for your selection. Thanks!
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 Fazla
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 Fazla
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 Fazla
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 Fazla
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 Fazla
This is a place holder, Please check PMB. Thanks.
See PM please. Thanks for ur time and Hope to hear from you.
i summited the project in 45 days. i worked on this project using asp.net with C#
Jarun :Owned and Operated by karun as of February 2005. Designers and Programmers highly skilled
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.
Hi. I'm based in the US. I can have it ready in a couple of days, contact me for details.