homepage Welcome to WebmasterWorld Guest from 54.167.75.155
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Google / Google AdSense
Forum Library, Charter, Moderators: incrediBILL & jatar k & martinibuster

Google AdSense Forum

This 46 message thread spans 2 pages: 46 ( [1] 2 > >     
Share your trend for Adsense earnings
GoldenHammer




msg:1327730
 3:18 am on Nov 3, 2005 (gmt 0)

Would you like to share a chart of your monthly earnings history in a relative scale (0-100%) that sets the highest earnings to 100%. We may see some interesting patterns and a wider prospective in respect to the changes of AS.

See this sample [photos-of-the-year.com].

 

Ankhenaton




msg:1327731
 4:54 am on Nov 3, 2005 (gmt 0)

Lol that looks like my rollercoaster

[tinypic.com...]

With a Friedmann smooth

dzcap




msg:1327732
 5:39 am on Nov 3, 2005 (gmt 0)

how do you make the graph?

GoldenHammer




msg:1327733
 6:26 am on Nov 3, 2005 (gmt 0)

Export your monthly earnings from the adsense report in a CSV file, open the file by EXCEL, multiple a ratio to all value that makes the highest earning become 100.

Then use the graph function to make a chart based on the earnings data.

jcmiras




msg:1327734
 7:25 am on Nov 3, 2005 (gmt 0)

Are you guys using a non-linear regression? lol

david_uk




msg:1327735
 7:30 am on Nov 3, 2005 (gmt 0)

[tinypic.com...]

The dip towards June was a smart pricing hit. That is the point I started blocking MFA's. Data from Jan 04 to Oct 05

GoldenHammer




msg:1327736
 7:44 am on Nov 3, 2005 (gmt 0)

For the past 24 months, there is a sudden drop in June.

[photos-of-the-year.com...]

david_uk




msg:1327737
 7:51 am on Nov 3, 2005 (gmt 0)

I forgot to add that the increase starting in June / July 04 was due to a combination of using the heat map for optimum position of ads, and when I started dumping unproductive banners.

GoodLuck




msg:1327738
 9:44 am on Nov 3, 2005 (gmt 0)

Past 5 months
My trend graph [img481.imageshack.us]

I love last month(Oct).

dzcap




msg:1327739
 11:01 am on Nov 3, 2005 (gmt 0)

multiple the values? care to give an example?

dzcap




msg:1327740
 11:08 am on Nov 3, 2005 (gmt 0)

here you go for october

[tinypic.com...]

rubenski




msg:1327741
 11:14 am on Nov 3, 2005 (gmt 0)

This is becoming pretty difficult to compare if everyone is plotting a different date range...

21_blue




msg:1327742
 11:28 am on Nov 3, 2005 (gmt 0)

[tinypic.com...]

Date range is mid December 2004 to date. Trend is 21 day average, dots are individual days.

wyweb




msg:1327743
 12:42 pm on Nov 3, 2005 (gmt 0)

[tinypic.com ]

range is Feb 2004 to last month

GoldenHammer




msg:1327744
 1:12 pm on Nov 3, 2005 (gmt 0)

[multiple the values? care to give an example? ]

Let say you have the highest earning $25 in Sep 2005, then the factor is 4 (=100/25), just multiple all earning value by 4 will scale it up.

jadebox




msg:1327745
 1:16 pm on Nov 3, 2005 (gmt 0)


This is becoming pretty difficult to compare if everyone is plotting a different date range...

Yes. Without scale, the graphs don't really tell us much. The squiggles could represent major changes or just random fluctuations.

-- Roger

davidof




msg:1327746
 1:26 pm on Nov 3, 2005 (gmt 0)

[tinypic.com...]

from Nov 2003 to date

NoLimits




msg:1327747
 1:58 pm on Nov 3, 2005 (gmt 0)

[tinypic.com...]

Sept 04 to Current

I wish I could put another line in there to represent number of clicks.... wouldn't look so pretty.

NoLimits




msg:1327748
 3:21 pm on Nov 3, 2005 (gmt 0)

Should we get some structure to this comparison. Set a certain date range and then compare?

Would it be against the TOS to put a line in there for clicks so long as no numbers are revealed?

Ankhenaton




msg:1327749
 4:04 pm on Nov 3, 2005 (gmt 0)

Should we get some structure to this comparison. Set a certain date range and then compare?

Would it be against the TOS to put a line in there for clicks so long as no numbers are revealed?

Dunno about TOS, but a line doesn't tell you very much.

I think CTR vs PI might be useful. If its not a line with

y=ax and a=0 APPROXIMATELY and you can exclude timeseries influences [aka you fiddling with the ads changing colours etc] you might be able to draw conclusions.

CTR vs eCPM should be fairly linear in a regression [use the right fitting curve though ;)]

ecpm vs time is interesting. If the regression is showing less wiggels at the end, the G algorithm is working, imo. If it bounces about the algo can't find an optimal fit for your set etc. There is soooo much you can do with that data ...

mhhfive




msg:1327750
 9:46 pm on Nov 3, 2005 (gmt 0)

hmm. go to the admoolah blog... maybe they'll host a way to aggregate this data.. :P

nathanso




msg:1327751
 7:04 am on Nov 5, 2005 (gmt 0)

Daily earnings from mid-April 2005 to date. Lots of ad placement optimization work went into that upward trend.

[tinypic.com...]

david_uk




msg:1327752
 8:25 am on Nov 5, 2005 (gmt 0)

Not sure what we have gained from this thread! A few interesting pictures, but no insight into general trends.

21_blue




msg:1327753
 8:57 am on Nov 5, 2005 (gmt 0)

david_uk wrote:
>Not sure what we have gained from this thread! A few interesting pictures,
>but no insight into general trends

You think the pictures are "interesting"? Last night must have been a good night out!

Re trends, some sites seem to have experienced some significant growth in the last couple of months, but other sites experienced the same last year and then earnings fell back significantly this year. But I agree it is difficult to tell what is going on just from the graphs. It's like driving in the pouring rain when your windscreen wipers have broken: you know something is there but you probably won't find out what until you've hit it.

david_uk




msg:1327754
 9:31 am on Nov 5, 2005 (gmt 0)

You think the pictures are "interesting"? Last night must have been a good night out!

I'm trying to be polite and show how intelligent I am:( Please don't blow my cover! Really, they all look like squiggles and dots!

I think general discussion of our analysis of trends we have noticed individually is more helpful - interpreting other's graphs with most of the detail missing is difficult. Probably about the only instance where a picture *doesn't* speak a thousand words.

xtreem




msg:1327755
 2:15 am on Nov 6, 2005 (gmt 0)

[tinypic.com...]

Daily earnings as a 100% ratio thing for the last few months or so, dates given on the axis. I tweak the ads every week, so itd be difficult to draw any conclusions from it. Ive also just switched a lot to chitika this past couple days, which resets any trend analysis.

Does anyone have any tips on getting stuff into excel for analysis? At the moment I use a data query, download the csv to a fixed location, and just hit refresh in another xls file to pull in the values. Trouble is, it also pulls in the 'totals' row, and I need to go about updating all the source values for each of my graphs.

I like the idea of setting up a site to collect this 'anonymised' data, and am thinking of doing it. Would google be ok with it? Would people be willing to upload their stats, without faking them? Could I publish the URL here?

I would probably provide a xls file which would anonymise and standardise the data first for upload.

xtreem




msg:1327756
 2:47 am on Nov 6, 2005 (gmt 0)

Hmm it seems thats exactly what admoolah is. I've never seen it before.. thanks for the tip. Never mind my rambling.

Ankhenaton




msg:1327757
 3:10 am on Nov 6, 2005 (gmt 0)

Does anyone have any tips on getting stuff into excel for analysis? At the moment I use a data query, download the csv to a fixed location, and just hit refresh in another xls file to pull in the values. Trouble is, it also pulls in the 'totals' row, and I need to go about updating all the source values for each of my graphs.

I use OpenOffice just import and press tab and you are done. Then I replace the annoying "," with ".", clean out the percentage into decimals in the CTR field and do a cut and paste into S-PLUS.

A free alternative to S-Plus is R although the data GUI is a bit cr@p, but it's nearly like S.

My biggest probem with Excel [besides the horrid Lego graphics] is in my opinion that it's more like a discrete package for accountants with hard numbers and really not build for highly stochastic time series data with multiple unknown covariates :\.

I mean you have the main influencing factors that is Google and Yahoo traffic then you have a weekday influence and a seasonal influence, then server speed backbone location, etc etc. Things like running means etc are probably valid in Excel but anything further is most likely too work intensive for a marketing demonstration/accountancy package. Perfectly reaonably if you want to do your accounts but useless if you have soft data.

There are also several fitting algorithms where you just need to press a button in a real statistics package, while you probably sit there for ages fighting with Excel to make ugly graphics that tell you eff all.

Rant over ;)

ebuilder




msg:1327758
 3:55 am on Nov 6, 2005 (gmt 0)

[tinypic.com...]

Jan-Oct 2005

NoLimits




msg:1327759
 4:06 am on Nov 6, 2005 (gmt 0)

what happened ebuilder?

This 46 message thread spans 2 pages: 46 ( [1] 2 > >
Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Google / Google AdSense
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved