Search code examples
emailtrackingmandrill

How to track individual links in email newsletter through Mandrill (or an alternative)?


I'm sending regular newsletters through Mailpoet running on a WP site, integrated with Mandrill's API.

In said newsletters I've got multiple links to posts on my blog plus excerpts of the posts. I'm currently tracking all links through Mandrill and a sum of all link clicks shows up at my Mandrill Url Tracking screen. Problem is, for the newsletters I'm sending out, it's essential to see which specific links are getting the most attention (clicks), so I've got an idea what content is relevant to readers.

I've searched all over google and stackoverflow but I haven't found an answer. If there's a way to track specific link activity using Mandrill or any other transactional mail service, or any other conceivable method of tracking individual links in an email being clicked, that'd be fine - this functionality is critical for my project at this point.

I'm a bit over my head here, so any help would be greatly appreciated.

Thanks for your time!


Solution

  • Mandrill search and info APIs return the following information:

      "clicks_detail": [
            {
                "ts": 1365190001,
                "url": "http://www.example.com",
                "ip": "55.55.55.55",
                "location": "Georgia, US",
                "ua": "Linux/Ubuntu/Chrome/Chrome 28.0.1500.53"
            }
    

    You can use a Mandrill java library to parse this data, and put it into excel/sql and group by url and count(*) will give which URLs are most clicked.

    url field in the above response, is an url in the email . it shows when/where that URL was clicked.

    Hope this helps,