Creating unique email hash and tracking system when emailing

• Project ID:

  734545

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

Statement of work:
We are emailing to our list and need to make the hyperlinks in the emails campaign unique while tracking who downloads and clicks on the links. You will need to create a unique hash (not MD4, MD5 etc…) for the emails. We need to be able to track how many people downloaded the pictures in the email, who clicked on the campaign hyperlink and who opted out of future campaigns (Opt out should be done automatically with one click of the email). See below:
hxxp://ksp.domain.c0m/0C4q1UpBWbyX1vJDj38Q2ATN6EVxm2wDrW9PSNOZ2GECv7X6DRssI7NTqp0yufsJZ01HUH2Tl_VQoyJpMaMZhUeCFXSHly6D7TvS5dFMA2xw2syF14Urf8uwmvlyI9LmQPrn3el6m446k72b5ZL21qgsIFbb2XYZPpY961vGQ5HTo9hpdLwfGcR5V7OeCNyawsAi5OVKtdc1rHoDmgakQBnacXOiBr4FkX-WnyTgDQW-288PfpZX_eygX87yiVNloyskge0V5Drjw7ZYJfTZXd3Lsz4FXpaCzJS6RMt5b8s7Xb0Rsd0KDxRUbAadmhM1"><img src="hxxp://nnqf.domain.c0m/0C4q1UpBWbyX1vJDj38Q2ATN6EVxm2wDrW9PSNOZ2GECv7X6DRssI7NTqp0yufsJZ01HUH2Tl_VQoyJpMaMZhUeCFXSHly6D7TvS5dFMA2y3CXtYLpLgfEQg0zrcum6ELH32LBi60E1SRQziIt9Iy81RRB9UlwOdj4jAIFUIIkvHG2ck0qrEoBr69DiIbKVweP8ObZACqMLu4lNLrhGAlFnTDPpXVHQjcp3Kl49cAUr-w9wbjwONHGjWHL7aWbgB9aCuic_ixRsf93WsonorSF5NkSPPfSW825UttQwmlUnNP93kmzbB47Te6Tsh5Cp2

The hyperlink above should redirects you to the website of the affiliate.

Opt out link is: hxxp://nnqf.domain.c0m/mpygzbizodjt/vybw/
Upon clicking the opt-out, You get:
Removal Request Status:
Requested Removal Address: xxxxx AT domain.c0m
Removal Request: processing
Please allow 3 days for processing.
Thank you for your patience.

The data for each campaign (Email,name,address) is in a CSV file format.
You will need to enter the hash equivalent in the csv (Email,hash,name,address) so that we can insert it using our email system.
There should be an easy way to translate the hash into email to determine who clicked a hyperlink. The hash of each email should be captured and saved to a txt or csv file.
We mail on a CentOS system and we have a large amount of domains so it needs to capture the data from all domains.
The Opt out link should also capture the email/hash to a file
Other ideas and strategies are welcome but the general idea is to make each email unique while capturing who is clicking on the hyperlinks and how many people have downloaded the pictures.
It would be great if the data/statistics can be viewed and managed from a website but it is not required. I can putty into the system to grab the files.
I am currently using send-safe enterprise to email campaigns.

Additional Project Description:

07/23/2010 at 0:02 EDT:
*** CORRECTION ***
YOU WILL NOT BE REQUIRED TO CREATE YOUR OWN UNIQUE HASH.
YOU CAN USE MD5 OR ANY OTHER ONE AS LONG AS EACH EMAIL HAS A UNIQUE HYPERLINK AND WE CAN TRACK THE EMAIL ADDRESS WHO CLICKED ON THE HYPERLINK.

Skills required:

Linux, MySQL, Python, Shell Script