Figuring out where your hits are coming from and which pages are being viewed is not too difficult if you use a good log analyzer like Analog or something similar, but if you want to pull up reports on the fly at any time, you need to take a different route.
For about six months, I was importing my Apache logs into an SQL database and then running ad-hoc queries against that.
Unfortunately, that requires me to go out and manually grab those log files, tweak the format a bit, then import. I wanted something better - something that was continually updated, flexible enough to simultaneously support multiple sites, and multiple actions (page view, ad click, click-in, click-out, plus more if needed).
MySQL 
Make Your Own Cool Drop Down Ad#39;s
