Page 1 of 1

Calculating the most popular pages from the last month

Posted: Mon Jan 07, 2008 8:28 am
by hame22
Hi

I am trying to create a list of the 10 most visited pages on my website in the last 30 days.

Does anyone have any expertise in setting up such as feature?

As I see it there are 2 potential options - 1. set up a database table to record page impressions or 2. access the website log files.

Log files seem the best option but I have no experience in doing this, does anybody have any suggestions on how I could achieve this?

Thanks in advance

Posted: Mon Jan 07, 2008 11:46 am
by s.dot
In my opinion, setting up a database table and recording page impressions would be the best rout. Just update/insert a record on page view, query to get the most popular 10.

Posted: Mon Jan 07, 2008 11:56 am
by Kieran Huggins
How often do you want the list updated? If you want any sort of immediacy you'll have to go the DB route.

If you're happy with periodic updates you could parse log files on a cron job - or better yet scrape the output of a reporting package like AWstats (again, on a cron job).

Posted: Mon Jan 07, 2008 2:11 pm
by Ollie Saunders
Use Google Analytics. Saves so many headaches. Nothing can touch it. Implement it on all your sites, now!!!

Posted: Mon Jan 07, 2008 3:39 pm
by Kieran Huggins
is there an API for GA?

Posted: Mon Jan 07, 2008 4:17 pm
by arjan.top
yes, check google api page :arrow: http://code.google.com/apis/analytics/