Welcome to WebmasterWorld Guest from 54.205.251.179

Forum Moderators: incrediBILL & martinibuster

Message Too Old, No Replies

WebmasterWorld Improves Your Standard of Living! FACT!

Reading threads and implementing ideas raises earnings 10%

   
8:29 pm on Apr 13, 2005 (gmt 0)

10+ Year Member



I'm a relative newbie around here, having only joined a week/couple of weeks ago and I've been doing some downloading of my Adsense CSVs. Being unafriad of spreadsheets and charts, I imported them and built some pretty pictures.

The result? Looking at the graph shows I'm 10% up so far this month. The attribution? Reading WebmasterWorld.

I hear it makes you a better lover too.

9:59 pm on Apr 13, 2005 (gmt 0)

10+ Year Member



I must agree. Adsense member since 10/2003 and by summer 2004 I set a goal to double adsense revenue (based on things I have read here - and a few other sources). Did that - then set a goal to triple from that point. Accomplished last month.

Funny thing is: Now other advertisers (not adsense guys) are placing ads on the site - more than ever in the past. Too bad I only run this business for the winter half of the year!

(Sorry - had to edit - obviously a first post - but long time lurker)

12:16 am on Apr 14, 2005 (gmt 0)

WebmasterWorld Senior Member annej is a WebmasterWorld Top Contributor of All Time 10+ Year Member



This adsense forum is a great help but be sure to take advantage of the other forums too.

I started out in the WW Google forum over three years ago. Using totally white hat SEO I have been able to bring all my pages way up in the serps. Usually in the first 10 on 2 word phrases. Of course that help a lot with adsense, amazon and just plain building a huge base of regular visitors.

10:17 am on Apr 14, 2005 (gmt 0)

10+ Year Member



raises earnings 10%

reading forum since about 4 months.
50% raise my adsense income.

Gained weight and have become lazy. i dont go out as much anymore. saves fuel cost. saves what i used to pay at McDonalds by buy a big one in each drive.

makes u a better lover

real world girlfriend left me....
Made a new one who is a WebmasterWorld and AdSense freak. only virtual .

my happyness ideas have changed.

>5 cents clicks make me feel sad
5 to 10 cents clicks make me feel ok
10 to 20 cent clicks makes me smile
20 to 50 cent clicks makes me refresh page, calculate epc again
50 cents to 1 dollar clicks makes me have a quick dance by revolving my chair thrice.

my fears have changed.

large ctr makes me think, i check my mail for a kick from adsense.

PSA makes me feel i am doing something good for charity

more...

wanna install a pc even in the loo soon ....

2:49 pm on Apr 14, 2005 (gmt 0)

10+ Year Member



To create your own pretty charts, simply follow these quick instructions:

1) Download your CSV file from Google (its above every report you can make) I recommend taking the "All Time" report because if gives a larger sample size.
2) Open Microsoft Excel or a similar spreadsheet application. These instructions are really for Excel, but most spreadsheet packages are similar.
3) Open the CSV file in Excel, you'll have a table of figures.
4) Delete only the column heading marked "Date" (for some reason this messes charts up) (don't delete the entire column or you can't tell what you've done over time!)
5) Delete the rows at the bottom of your sheet that indicate Totals. (otherwise you have a spike at the end of your graph which makes everything else hard to interpret)
6) Highlight column A (should be date) and highlight column B (most likely to be Page impressions) and go to Insert > Chart. Go through the wizard (its really simple) looking at the lovely charts you can make. Settle on the first bog standard line graph. Next, Next, Next, until you hit the part that asks where you want to create it (in the current worksheet- no, or in a new worksheet- yes!) Click Finish and bang! Instant charts.
7) Now repeat for A+C, A+D, A+E and A+F.
8) Save to disk, then print. Analyse, marvel and plot for world domination.
9) Profit! (okay, I had to do that).

3:30 pm on Apr 14, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



To create your own pretty charts, simply follow these quick instructions:

Thank you! I wish there was some "karma" or other way to thank you for this easy, step by step breakdown. I really appreciate you sharing this.

I am now the owner of pretty excel graphs :)

Man, if I printed this out on transparencies and laid them over each other, there are some interesting trends there!

Thanks again.

6:10 pm on Apr 14, 2005 (gmt 0)

10+ Year Member



Nice. never even thought to use excel or a spreadsheet... here i was planning to code up something that will calculate everything and draw up graphs. Didn't even think of using excel.

This will save me a lot of time. Thanks.

7:32 pm on Apr 14, 2005 (gmt 0)

10+ Year Member



Thanks ClosedGL for the tips about charts. It does look good this way :-)
8:34 pm on Apr 14, 2005 (gmt 0)

10+ Year Member



The options for messing about with stats are endless so if anybody else has some methods they use for analysis I'll love to hear them.

If, like me you figures levelled out for a period and have only just started growing again, or you can't actually see the direction you're efforts are taking you, another handy tip is:

Whilst viewing your chart sheet (whichever one doesn't matter), in Microsoft Excel, go to Chart > Show Trendline and then choose one of the various styles. It places a single line on the chart at an angle.

Let's hope yours is 45 degress pointing upwards, or more!

8:35 pm on Apr 14, 2005 (gmt 0)

WebmasterWorld Senior Member ogletree is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Everything that sent me in the direction I went came from here. There was no big secret but it helps you think. Some of my best ideas have come from samll comments here. Don't just look for secrets look for clues and think about it.
11:19 pm on Apr 14, 2005 (gmt 0)

10+ Year Member



I try not to check my earnings often, because it makes me nervous (plus at the end of the month it usually settles down)

Now that I see my all time earnings as a line that goes strait up and strait down over and over and over is even more disturbing than checking my earnings mid-day.

I'll never generate the earnings chart again...

This 41 message thread spans 5 pages: 41