Ever wonder how some advanced Google AdSense publishers dig into their data? A WebmasterWorld thread has discussion on the topic of using Microsoft Excel to really analyze their AdSense data.
By generating reports on a daily, weekly, monthly, quarterly and yearly basis - you may pinpoint certain trends that you can replicate in the future. Publishers discuss using several statistical techniques such as moving averages when plotting their data. In addition, Excel's Pivot Tables help them automate and streamline much of the data crunching.
Of course you can also use SQL databases and build your own reports. Using the Google AdSense API, you should be able to pull down data directly from Google in an automated fashion and set up dynamic reports to run as often as you like. Plus, I am sure there are many free tools that do the number crunching for you.
Have your own ideas and reporting techniques?
Forum discussion at WebmasterWorld.