tracking email links to landing page on site

Posted on 2010-01-07
Last Modified: 2013-12-24
I am about to send a newsletter via email to all of our clients (about 1000) via our site. In the newsletter There are various links and I would like to track:
who clicked on the link, which link they clicked on, which newsletter it was

I'm thinking of setting up a table to record this information in our db(sql server).

what would be the best way to record this? an insert into on the index.cfm ? would this slow down the page from loading, risk timing it out?

I've never really done this before so any advice would be more than welcome.
Question by:Shawn
    LVL 9

    Expert Comment

    by:Andrew Maurer
    The best solution would be a Web Analytics package like WebTrends or Omniture. Those packages aren't cheap but they do most of the work for you. You would just have to tag what you want to track and they give you documentation for that.

    "Would it slow the page from loading"
       Of course, you're adding sql queries and logic for web tracking usage.

    "Risk of timing out"
       Depends on how much traffic the server gets or your website gets.

    If you were to create your own trending tool, I would say you should create an architecture that uses javascript to make a tagging call when the page is finished loading. That way you do not slow the normal page loading times at all and can tag every scenario.

    my 2.5 cents (the half cent are the links) =p
    LVL 1

    Author Comment

    thanks for the links though way over budget.

    maybe if I give an example it will help. If I create a link with variables:

    when someone clicks on this i want this to be recorded. what would be the best way to record this?

    In my admin area I could then see who clicked on which link, etc.

    I would prefer it to be with coldfusion unless I could hook up a third party element that could at least read tables in sql server to convert clientid to real names....without spending a forture or weeks developing something from scratch.
    LVL 9

    Accepted Solution

    Read up on Googles Analytics, They do have some extras other than basic page tagging. They'll also have the reports for you which you probably dont want to spend the time creating.
    LVL 1

    Author Comment

    I've decided to break it down into
    users not logged in
    Google Analytics is by far the best. thanks zadoc:

    users logging in.
    cf works nicely

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    A web service ( is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
    In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now