In the previous article, I showed you how to track each individual session that is started on your site. now we explore different reports that can be run on those stats.
there are three main reports that can be run
- SELECT top 100 * FROM accesslog ORDER BY dateaccessed DESC
This will give you a listing of the last 100 visitors to your site.
- SELECT top 100 referer, count(referer) FROM accesslog GROUP BY referer ORDER BY count(referer) DESC
This will tell you what sites are sending traffic your way
- SELECT top 100 browser, count(browser) FROM accesslog GROUP BY browser ORDER BY count(browser) DESC
this will tell you what [browsers](javascript:alert('this is a test');) and OSes people are using the view your site. Once you start to view these reports daily, you will know things like whether you should make your site support Netscape 4.7, or if your main audience is using Internet explorer.
good luck all.