Adsense diary recommended by Joel is something I have implemented after reading all the 199 pages (almost, I skipped some of the pages because I know about it before hand) of Joel Comm’s Adsense Secrets 3, a eBook that comes with Joel’s Instant Adsense Template.
This is one of the 14 books that I managed to get, including some bonus ebook that was not announced. Adsense Secret 3 was the first book recommended in all the eBooks given.
I must say that most of the content was not new but I managed to pick up 5 to 6 tricks that I can try to improve my page ranking. That excludes the sample sites that are featured which are good for case studies. It eliminates the uncertainty that the sites that I picked to study on my own may run contrary to the improvement of my adsense performance. One of the things that I must mention is the understanding of smart pricing which I feel could potentially improve my adsense earnings. I started to analyze my adsense pages and also started an adsense diary to facilitate the evaluation of my adsense performance due to smart pricing (please refer to Joel’s Adsense Secrets 3 pg 117 to 120). Because of the smart pricing topic, I have created 2 charts which help me compare my adsense earnings over weeks and over the day of the week.
I am an Excel guy so naturally, you will see that I will put everything I need to analyse even my notes and diary into Excel. And here’s how I am planning to monitor the performance of my adsense results.
Chart 1 is for analyse your earnings by day of the week. You can compare the results across weeks.
Chart 2 is for analysing your earnings by week number. The bars within each week are the days of the week. Using the chart, you can therefore have a quick understanding on how you are performing within the week.
To connect using the above sample codes, you must create another sub procedure e.g. “Demo“
I believe the charts will help in the analysis of smart pricing and only those who know the working of smart pricing will find this chart useful. Fill up the form below to get a copy of the file to complement your adsense diary. I will provide you with updates as I continue to add or modify the charts based on the feedback I get. So please send me the feedback.”
Share this page:
Would you prefer to share this page with others by linking to it?
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
advanced-excel.com is in no way associated with Microsoft