A couple of ideas for Excel junkies that also store their website in a MYSQL database.

Aside: You can export MYSQL data as XML by simply clicking the XML button on export (using PHPMYADMIN).

Idea 1
John Mansfield posted PHP code for Tracking the Googlebot awhile back. Why not write this data to a my MYSQL database instead of getting hundreds of emails. Next, export XML from the MYSQL database, then import that data to Excel and really get a good picture of what the googlebot (or any bot) is doing over time?

Idea 2
Similar to Idea 1, instead this time record a user’s IP, Referrer, and URL they land on (help), then write to MYSQL. Next, export XML from the MYSQL database, then import the data to Excel and I should be able to get a clear picture of where any visitor goes on this site, in what order, how long at each page, etc. and all in nice charts if desired.

Idea 3
Instead of Exporting the data from the first 2 ideas, create a REST interface that exposes the MYSQL databases for anyone to consume, Excel app or not.

I haven’t tried any of them yet.