Charting Adsense

Will help to keep track of everything

[Clark]

I made an excel spreadsheet of the Google reports using the date range of "All time". It's very interesting just looking at a regular chart with the data they mention. What I saw was a very minor improvement in terms of impressions. Since being given ability to choose color and to switch to leaderboard, the CTR jumped to more than double. As did earnings. Tweaking your site in terms of where and how to display the code really can help tremendously.

I added an extra column called Earnings per click. It has been slowly, steadily going down from the beginning. I suspect this is the thing for us to watch to determine how well the profit-sharing cut goes in the future... It is possible that more pages were shown with less profitable terms, but I'm not really sure. Would be nice to know if others also seeing a downward trend.

[cornwall]

>>CTR jumped to more than double

>>Earnings per click. It has been slowly, steadily going down from the beginning

It is likely that the two are in fact related. More ads on the page, (probably) means more lower price ads on the page. So although more users click, they are clicking on lower price adverts

I would suggest you also plot CPM, with mathematically is a funcion of both EPC and CTR. It is IMO, a better gauge of your progress.

[Clark]

Good point.

So by CPM you mean revenue per thousand impressions? Or something else?

[TipKing]

I cannot remember the date that they brought out the ability to change the color of the boxes etc. Could anyone advise

Thanks

[Visi]

TipKing...around 7/6/03.

[Visi]

Clark...want to have a little more fun...hit that chart wizard and plot out the trends. Then will see the trends. Have this for CPM, EPC and $/visitor, click percentage etc. Interesting results and trends over the last 2 months. When you trend in this fashion can see increases and decreases and more importantly the effects throughout the month.