Welcome to WebmasterWorld Guest from 100.26.182.28

Forum Moderators: martinibuster

Message Too Old, No Replies

excel charts for adsense

     
7:11 pm on Feb 27, 2006 (gmt 0)

New User

10+ Year Member

joined:Feb 1, 2006
posts:33
votes: 0


has anyone written any and willing to share? if not, I'm thinking of doing this and sharing it with the comunity.
7:18 pm on Feb 27, 2006 (gmt 0)

Full Member

10+ Year Member

joined:Feb 10, 2004
posts:263
votes: 0


yes, but nothing sophisticated enough to be worth sharing :(
8:32 pm on Feb 27, 2006 (gmt 0)

Preferred Member

10+ Year Member

joined:Jan 15, 2004
posts:612
votes: 0


Did it, but not good enough to share. Just a few indicators for you to consider:

- gather all daily data that Google provides (including page =and= adviews, revenue, and clicks), and use only the 'official' Google data

- compile weekly cumulative data from the raw data, which is usually telling much more than the daily data

- compile monthly cumulative data (instead of four weeks). This is good for month-by-month comparisions.

- when drawing charts, always add moving averages: 7 days and 30 days. You'll be amazed at the trends you'll be able to see once you remove daily variance! In fact, this has become the most important value to me by now: If, for example, the 7 day EPC moving average declines for a few days, I know I am in for a bit of weeding...

- also add calculations for ads/page by dividing ad views by page views. It should be always in the same range unless you change the site or the source of your traffic changes significantly.

- use scatter graphs a lot! It is very revealing to see, for example, ads per page vs. revenue. This graph will tell you how variables are linked to each other.

But be warned: all statistical data and graphs should not make you believe that everyone else is seeing the same behaviour. It just helps you discovering certain indicators more clearly (and/or earlier) telling you that "something is wrong".

I hope this makes sense to you and helps you with your Excel sheet. I would certainly be interested to see it once you're done.

Good luck!

10:28 pm on Feb 27, 2006 (gmt 0)

New User

10+ Year Member

joined:Feb 1, 2006
posts:33
votes: 0


good pointers mzanzig. looks like I've got my work cut out for me :)

stay tuned!

7:16 am on Feb 28, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Jan 20, 2006
posts:46
votes: 0


ive done one that allows the simply pasting of the exported CSV file, then it updates all the graphs for 12 months, 180 days, 90 days, 14 days & 7 days.

its fine for what i need, but may not contain some expected graphs or date ranges (ie: last 5 years etc).

members are welcome to it, but i presume i cant post a download link here, so im not sure how to give it to those that may want it

cheers
mike

9:55 am on Feb 28, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Jan 20, 2006
posts:46
votes: 0


ive had quite a few PM's regarding this excel file, can a mod confirm if it's OK to post a file download?

cheers
mike

12:31 pm on Feb 28, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Apr 30, 2004
posts:164
votes: 0


ive had quite a few PM's regarding this excel file, can a mod confirm if it's OK to post a file download?

I guess yes ;-) on a file-sharing service.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members