Recently, during a civicrm upgrade to 3.x, a client asked for each civiMail click-through to not only be tracked for mailing reports, but to show up as an activity record for the user that clicks through. The main problem with doing this out of the box is that when civimail sends an email, it doesn't send any record (other than the email address) of who is receiving that email. That is to say that no links in the email -- while they are rewritten to be directed through the civicrm server in order to count the click-throughs -- contain any information to tell the civicrm server which user is clicking-through on the link. To fix this I added a new Activity type and made some minor changes to a few files. First, add an activity type called 'Click-through': - Go to Administer Civicrm => Option Values => Activity Types - Add a new activity type: - Name: Click-through - Description: This type represents a click-through by a user for a link embedded in a civicrmail message - Click save Now for the minor code changes... First in CRM/Mailing/BAO/TrackableURL.php: In 'getTrackerURL($url, $mailing_id, $queue_id)' where the link is rewritten add:

at the top. Then near the bottom where the url is rewritten to direct it back through the civicrm server, add: to the end of the rewritten url. We'll use this information in extern/url.php in order to get the contact_id of the user who clicks-through on this link

Now, in extern/url.php: Add

To the top of the file and then added this block of code: What this does is check for the umail variable on the query string (remember we added this variable in getTrackerURL(). Once found it pulls the email address and uses civicrm_contact_search() to get the contact that the email address belongs to. Then it pulls out the $cid. We then add the $cid to the CRM_Mailing_Event_BAO_TrackableURLOpen call near the end of the file, like so:

Lastly, we'll need to alter the CRM/Mailing/Event/BAO/TrackableURLOpen.php file: Add the $cid variable to the public static declaration of the track() method. Make sure to give it a default value of "" so that calls to this method that don't include $cid won't break:

Now add the code to this method that will create a click-through activity record for the contact who has an id matching $cid: Of course, you'll need to define CLICK_THROUGH_ID and STATUS_ID to be their appropriate values. My click-through activity type_id was 33 and I used 2 as the status_id.

I've attached patch files for these files as .txt files below.

Attachment	Size
TrackableURL.txt	813 bytes
url.txt	1.26 KB
TrackableURLOpen.txt	1.48 KB