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

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.
bman2011Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LajuanTaylorCommented:
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?
0
bman2011Author 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
0
LajuanTaylorCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ColdFusion Language

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.