tracking user's website usage

[am7555]

Hi Guys,
I developed a website a while back and my client wants to track user usage of the website. Basically he wants to know: who logged-in, what pages he visited and when he left. Is there an example of such idea somewhere or do I have to start from scratch.

In the event that I had to start from scratch I created a table on my Access db with the following fields:

usageID | intUserID | dteloggedin | urlvisited | loggedout

It doesn't have to be too complex.

The website is in Classic ASP/vbscript.

Thanks for any ideas leading to a fruitfull headscratch and eureka moment.

Cheers to all.

Javier

 

[Hondy]

Google Analytics is free and really good, you just put a bit of code on the site it it will tell you everything you need to know. Although, this will not give you historical data from before you add the script. If you want to look at historical data then you need a program that analyses the log files of the web server. LiveStats used to be good for this but they have gone the way of Google Analytics with web based reporting. I'm sure someone here can point you to an alternative if you want to look at older data.

Going forward though, get google analytics on the site

 

[am7555]

I already have Google analytics in place. However I need to make something that will actually track usage according to UserID. As I mentioned before doesn't need to be complex. I was thinking more about some way of recording the time the user logs, where he goes from there and when he leaves or at least the last page he visited, in case he/she doesn't logout.

Any ideas are welcome. Thanks.

 

[johnwm]

Presumably you track logged-on users in a database. Why not use a session variable to track the user, add a table for page views linked to the logged-on user and put an insert query in each ASP page, listing userid (lookup from sessionid cookie), page name and server time.

If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller