Net Benefits

Posts Tagged ‘adsense spreadsheet’

Calculate potential Adsense income.

March 13th, 2010

I wouldn’t normally ‘rip-off’ a post I’d seen on someone else’s site. But I’m a real numbers guy and this post on The Keyword Academy made me get my calculator out before I’d even finished reading it!

So what’s it about?

Basically it’s a simple calculation which could help you work out your potential income from an adsense site.

Now, there are NO hard and fast rules to this stuff, there is NO calculation which is totally accurate, but it is nice to have some sort of rough guide BEFORE you build a new adsense site.

I’ve also added some ideas on where to find high paying Adwords ads and I’ve created a simple spreadsheet to drop the numbers into.

So this is how to work out your potential Adsense earnings before building your site.

Nip over to Spyfu and grab the list of top 100 keywords by ‘Highest Cost Per Click’ then go over to the google keywords tool.

We want to find the amount of global searches for each of the words on our list. We don’t (necessarily) want to get suggestions for new words. So, make sure that you click on the ‘Previous Interface’

And then Edit where the results are tailored for – we want All countries and territories.

Next click on ‘Filter my results’ and check the ‘Don’t show ideas for new keywords. I only want to see data about the keywords I entered’ and un-check the ‘Use synonyms’ box.

Close the options up and paste your word list into the box (one word or phrase per line) and click the get ideas button.

Now export the results in .CSV (for Excel) format and open them up.

Copy and paste each column into this simple, free spreadsheet I created.

Download Free Spreadsheet

The sheet takes the figures and works out for each keyword what the top advertiser is prepared to spend, and of that money, how much the first site on google’s search page for that keyword could make. It also works out potentially how many clicks the first site could get on the ad as well.

As I said, this isn’t hard and fast and there are a lot of other factors to consider. But hopefully it should give you an indication if it is worth the effort to build a site for a given keyword.

Thanks to Court for the original post. If you haven’t visited to The Keyword Academy I suggest you go there and have a look.

Products that may be related to the post:

Similar Blogs

Posted in Adsense, Free Tools |

Tags: Adsense, adsense spreadsheet, potential adsense profit, potential clicks, profit, Site Building Tools |

9 Comments »