| 8:33 pm on Apr 13, 2005 (gmt 0)|
You'll find that, like leurve, AdSense sends you on a rollercoster ride with mad ups and downs...
Hold on tightly, and don't draw conclusions from too little data. B^>
| 8:34 pm on Apr 13, 2005 (gmt 0)|
|I hear it makes you a better lover too. |
It does! I can personally attest to that. :-)
| 8:36 pm on Apr 13, 2005 (gmt 0)|
One fact I omitted from my message is that I have been using Adsense for a year, and despite a dip in September 2004, things have been pretty constant. It's only in this last two weeks that things have started to look up again.
Is it true that summer is coming? (I'm a Brit, we only have rain...)
| 9:00 pm on Apr 13, 2005 (gmt 0)|
| 9:02 pm on Apr 13, 2005 (gmt 0)|
You should read some more ;)
| 9:22 pm on Apr 13, 2005 (gmt 0)|
Brilliant. I'm glad other people have noticed this too. I was hoping to salvage people from the wreckage and depression of when smart pricing destroys their hard work.
[edited by: ClosedGL at 9:23 pm (utc) on April 13, 2005]
| 9:22 pm on Apr 13, 2005 (gmt 0)|
I'm a Brit too, but was in a basement in Soho (London) all afternoon, so what would I know about rain? B^>
Glad you have some stability; but you must see a lot of day-to-day noise too?
| 9:29 pm on Apr 13, 2005 (gmt 0)|
There is definetly noise and sometimes it is distracting, because you find yourself trying to imagine what you did right on that particular day, instead of letting the discipline filter show you what you did in a given period (like a couple of weeks). If anybody hasn't already, I highly recommend taking your figures into a spreadsheet program like Microsoft Excel and having a glance at some charts. they can't show you where you're going, but they can help you make a little sense of what sometimes looks like random numbers.
| 9:32 pm on Apr 13, 2005 (gmt 0)|
is there a way to share how you made the pretty graphs in your spreadsheet.
I'm a bit afraid of them myself, but I do so love a pretty graph that shows in pictures the up/down trends.
| 9:59 pm on Apr 13, 2005 (gmt 0)|
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)|
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)|
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.
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
wanna install a pc even in the loo soon ....
| 2:49 pm on Apr 14, 2005 (gmt 0)|
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)|
|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!
| 6:10 pm on Apr 14, 2005 (gmt 0)|
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)|
Thanks ClosedGL for the tips about charts. It does look good this way :-)
| 8:34 pm on Apr 14, 2005 (gmt 0)|
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)|
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)|
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...
| 11:44 pm on Apr 14, 2005 (gmt 0)|
I saw a script advertised somewhere recently which made pretty graphs of your AdSense earnings.
I guess it would save a bit of Excel time each day - it was only about $25 or so.
I ASSUME you'd have to give it your username and password though - which always makes me a bit nervous - though it looked reputable enough.
Can't remember where I saw it - but I'm sure a search would turn it up.
| 2:00 am on Apr 15, 2005 (gmt 0)|
Come on mrowton, let go! Start breathing. Use the "Add Trendline" to reassure yourself, and remember, figures only show you the past, not the future. You can turn it around in the next 5 minutes, the result of which you may see as close as a few days away.
| 3:22 am on Apr 15, 2005 (gmt 0)|
Instead of the straight trendline, use a moving average. You can get a 7-day moving average, 30-day moving average--whatever you prefer. Just choose that option instead of the straight trendline. Much more useful.
| 6:19 am on Apr 15, 2005 (gmt 0)|
I set up a second site just to target high paying sports related words, result so far.....
Tripled my income already in teh first month and we are only 2 weeks in.
| 9:13 am on Apr 15, 2005 (gmt 0)|
A little bit of a differnt twist can be if you can't control it to a heathly extend.
When I made 6gran a month on top of my regular daytime job I started dreaming and with that losing touch to my relationship's reality. Only way too late I realized that my wife could not be happy with a guy sitting in the study every other night working towards early retirement in the Carribean while she started pointing her attention and dreams elsewhere.
Very ugly and painful experience when your dreams lose you or you get lost in the dream.
With all due respect there is always a flip side I am sure many have experienced already, a word of caution really to look behind you and don't make prisoners along the way.
| 1:21 pm on Apr 15, 2005 (gmt 0)|
thanks for that post! it finally made me do my stats in a proper way :)
now the question is, how do I get my curves to lay on top of each other, to see the relevancy more easily?
| 6:13 pm on Apr 15, 2005 (gmt 0)|
I won't post the link, but if you search G for "digital point adsense chart" Shawn has a really cool web-based adsense charting app. Very customizable and can track:
- Impressions (Cumulative)
- Clicks (Cumulative)
- Clickthrough Percentage
- Earnings (Cumulative)
- Earnings Per Click
And it's free. I'm in no way affiliated with DigitalPoint other than being a member of the forums.
| 7:30 pm on Apr 15, 2005 (gmt 0)|
This site & specifically this forum has improved my life MUCH MORE THEN 10%
THANK YOU BRETT & THANK YOU JENSTAR
| 8:30 am on Apr 16, 2005 (gmt 0)|
::::I hear it makes you a better lover too.
Please identify your source. I'm 28 and still a virgin!!!!!
| 8:46 am on Apr 16, 2005 (gmt 0)|
I'm quite curious how you're doing well when "smart pricing" is changing things for so many.
I love reading about the graphs- I've been using them since I really got into AdSense in Oct 2004- had been doing AS for some time but leapt by 3x in one month, then 3x again the next month.
My graphs were about 30 degree up for a long time.
After taking a 50% traffic hit in March, the smart pricing appears to have done me even worse- for two reasons-
1. coincidentally, many of my highest earning pages (out of a pool of 1000 or so) dropped off the search charts, and my highest traffic ones now are a group I had already tracked with AS and found out they didn't pay much. hmm.
2. overall CTR has dropped to 1/3 or 1/2 of the previous rate- perhaps because of #1
So now my graphs look quite precipitous.
Anyhow, I looked at keyphrases and AS stuff from many angles for a long time- I found that many of my statistical forays yielded little- but did get an idea of which categories paid best, at least back then.
I never tracked who exactly was showing up on my pages, so I can't compare that to now. But I suspect that those who are bidding lower are showing up on AS pages.
Anyhow, any useful tips to get my graph slope back up?
| This 41 message thread spans 2 pages: 41 (  2 ) > > |