This is how we track readership: * First, we have a 1x1 transparent gif file in our images folder. * Second, when I send out a newsletter, I give it a tracking code... * Third, the actual tool I send the newsletters with converts a little code ||EMAIL|| to the user's email address. Buried in the HTML of the newsletter, I've got a little bit of code that says:
<img src="http://www.epilepsyfoundation.org/images/enewsletter.cfm?issue=advocacy _may_2002&emailaddress=||EMAIL||"> The actual CF code on the backend looks like this: ---------------------------- <!--- this is a small tool to determine readership of the enewsletter. written by Jon Roig ([EMAIL PROTECTED]) ---> <cfparam name="emailAddress" default="none"> <cfparam name="issue" default="unknown"> <Cfquery name="logUser" datasource="content" dbtype="OLEDB"> INSERT INTO dbo.eNewsletterReaders (emailaddress, issue, ipAddress) VALUES ('#emailAddress#', '#issue#', '#CGI.REMOTE_ADDR#') </CFQUERY> <CFCONTENT type="image/gif" FILE="c:\newsite\images\1pwhite.gif" DELETEFILE="No" > ---------------------------- Of course, the caveat here is that this is nowhere near 100% accurate. Some email clients don't load the gifs but display the HTML -- AOL 5 comes to mind. It does give us a rough idea of whats up, nonetheless. -- jon -----Original Message----- From: Jim Gurfein [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 7:57 PM To: CF-Talk Subject: Tracking Emails Hey, list... Does anyone have an easy way to create a database record when an email is opened? We can embed a gif and have it recorded in the logfiles, but I'd like to somehow cause a post to a page ( and record it in the database) when the email is opened. Thanks for the help. Jim ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
