does anyone know of a pre-made excel spreadsheet that lets you simply import data files from adsense (ie weekly reports) and sort the data accordingly so it is displayed via graphs, CTRs, clicks, and revenues?? I'm looking for one...anyone know of something like this?? thanks!
you can simply import the .csv files from adsense into excel and it will display the stats in excel, leaving you to do whatever you like with them. you can highlight as many columns as you like and create charts from them. i did a quick search and found this link: http://feedmoney.com/archives/2005/04/14/how-to-create-pretty-adsense-earnings-graphs-charts
I created a spreadsheet that does a lot, but I'm rewriting it right now to have graphs and better trending. I wish Google's TOS let me publish my numbers for people to see my trending, but alas I can't.
I may have to create one myself, but I'm looking for something that will let me import my weekly reports from AdSense and then add the data to the spreadsheet accordingly and save it. When importing, simply apply all the new data to the graphs and have it all automagically work. This would be a lot easier if Google Analytics worked with Adsense, but it doesn't right now so we can't use Analytics. I'm trying to resort to using excel, but I want something automated and easy to use.