homepage Welcome to WebmasterWorld Guest from 54.166.100.8
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / WebmasterWorld / Website Analytics - Tracking and Logging
Forum Library, Charter, Moderators: Receptional & mademetop

Website Analytics - Tracking and Logging Forum

    
The *best* analysis tool: SQL
franklin dematto




msg:903814
 5:59 am on Oct 30, 2001 (gmt 0)

I use a simple perl script to filter out autloaded requests (.css .js .gif etc), internal requests, and worms (there are so many these days), and then dump the whole log into a SQL database.

This provides *the best* analysis tool there is. Virtually every question I've seen here can be answered with a simple SQL query. (I use mod_usertrack to keep track of users in between sessions). Want to know which referer refered the most users who come back more than three times? Simple query. Which page caused users to visit the Contact Us page the most? Simple query. And, if you don't know SQL, you can just a GUI'd db like Access which does it for you.

Just thought I'd pass on this useful tip

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Website Analytics - Tracking and Logging
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved