We help IT Professionals succeed at work.

Tracking page hits via URL ids per account login with ColdFusion 10

bman2011
bman2011 asked
on
I need the ability to track which types of utilities and reports are used the most and least on my site. It's a specific section of my site, not the whole site and these are usually through the main subfolder under www.domain.com/reports/.

The different type of reports are all visible through the URL, here is an example of what an account under 123 ID would pull up based on a specific report

https://www.domain.com/reports/abcreport.cfm?mainaction=formpage&accountid=2523300&customer=ABC%20INC%2E%20CONSOLIDATED&matrixnumber=1621&reporttype=DEP

Essentially I want to be able to access how many times each account accessed their report, how many times a particular report was accessed and which types exactly. Would it be easier to use google analytics to track usage on each type of report or would it be better if I did it off of ColdFusion? What I'm looking for is advice on the best approach to handle this to get the type of data I want in the least time possible in terms of implementation and most accurate.
Comment
Watch Question

The answer depends on a few things...
Is the application accessed from an intranet or the Internet?
Are you using Windows Authentication or a database backend for Access Control?
Are you interested in obtaining web analytics information or just report access information?
If the application is accessed from the Internet, is it at a hosting provider?

Author

Commented:
Application is accessed from internet.
Database backend for access control.
Mainly report access information.
Hosted in-house on dedicated server Windows 2008 IIS 7
The first option that requires no coding would be for you to perform an analysis of the IIS logs. SmarterStats (Free Edition) can be installed on your workstation to test the proof of concept. You can mine data and much more...
http://www.smartertools.com/smarterstats/website-data-mining.aspx

The second option would be to leverage your existing access control framework. The basic information to capture would be userid, date, timestamp, report name, parameters passed to report, and format (excel, pdf,html). To save some time, you could CF Report Builder to create the front-end viewer for the data you are collecting.

The third option is Google Analytics, but it's only going to be as accurate as the pages that include the tracking code. Also, you will have to configure a main gMail account for your company and sub accounts for staff that need to view the analytic reports... You could something like the following for the gmail accounts: company_employeename@gmail.com

I've used all three approaches and it really depends on what will work best for your organization.