?
Solved

tracking email links to landing page on site

Posted on 2010-01-07
4
Medium Priority
?
183 Views
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.
0
Comment
Question by:Shawn
  • 2
  • 2
4 Comments
 
LVL 9

Expert Comment

by:Andrew Maurer
ID: 26209956
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.

http://www.omniture.com/en/
http://www.webtrends.com/

"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
0
 
LVL 1

Author Comment

by:Shawn
ID: 26218262
thanks for the links though way over budget.

maybe if I give an example it will help. If I create a link with variables:
www.mycompany.com/newsletterid=1/linkid=1/clientid=1

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.
0
 
LVL 9

Accepted Solution

by:
Andrew Maurer earned 2000 total points
ID: 26273109
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.

http://www.google.com/support/googleanalytics/bin/topic.py?topic=10995
0
 
LVL 1

Author Comment

by:Shawn
ID: 26296119
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
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
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…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month17 days, 2 hours left to enroll

862 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