Monetisation by Google Adsense

Sometimes the blog subject may be a difficult one to find affiliate products for. Any blog interesting enough to attract visitors in numbers, can be monetised with Ads 

With an interesting site, you can approach Google Adsense, to place ads on your webpages. This is  where the CPC ( cost per click) metric becomes important. If  you can find  topics with high  cpc  values, your advertising revenue via Adsense, will be much higher. 

How to find the best keyword terms to maximise Ad revenue


First I tried out several free keyword tools to get the data I wanted, which was: 

 1. Number  of searches per month in Google

2. Cost per Click

3. Competition 

Wordstream seemed the best option and I entered my search term “How  to get my Website ranking in Google” Wordstream responded with 25 keywords.  They send it by email ( which is a crafty way to get your email !! ) and it is in csv format, so using Google sheets or Excel…

First – remove those with low number of searches/month

Next – remove those with high  competition

Now I want to reorder the data table, based on its CPC.  When I  tried  this, it didn’t work,  behind the scenes the $  amount is  held as character data – so to reorder it I needed it to be Numerical data, so I had to remove the dollar sign 

More excel problems – just clicking on the column and changing the data types didn’t work on my 2007 version of excel, automatically ,  so I reverted to the formula method – make a new column based on the dollar  column , enter this formula in the new column and replace B2 with the dollar column ID.

= RIGHT(B2,LEN(B2)-1)

You should now  have a column with just numbers.  Reorder the table now based on the numbers column. 

Keyword PhraseSearches/monthCompetitionCostPerClickCPC (number)
how to get my website to the top of google90Medium$23.0723.07
how to get my website on google first page20Medium$22.0722.07
how to get on google search first page10Medium$21.2521.25
how to show your website on top of google search10Medium$20.2520.25
how to get your website higher on google90Medium$18.4118.41
how to get my site higher on google10Low$17.7917.79
how to get website on first page of google140Medium$17.3517.35
how to get your website to rank higher on google10Low$17.2417.24
how to get google ranking for my website10Medium$17.1517.15
how to get my website higher on google30Medium$14.7814.78
how do i get my website to rank higher on google10Medium$14.1914.19
how to get your website on the first page of google50Medium$13.813.8
how to get on 1st page of google10Medium$13.4213.42
how to get your site at the top of google search10Medium$12.6912.69
how is my site ranking on google10Medium$8.008
how to find my website google ranking10Low$6.416.41
how to rank on the first page of google10Medium$5.455.45
how to find google ranking of a website10Medium$3.053.05
how to rank my website top in google10Medium$2.732.73
how to get your website to the top30Medium$2.312.31
how to rank my site first on google10Low$2.142.14
how to rank your website for keywords10Medium$2.072.07
how to rank a new website on google10Medium$1.681.68

Some of the terms with similar low search volume had only 1 or 2 dollar cpc value, so make sure you cover the subjects with the higher cpcs , which will start the ad revenue flowing

Don’t forget to fully get up to speed with the latest SEO for Googles algorithm. Details of changes are published on Googles developer pages. 

Add your  own banners to the sidebar, as internal links ( reference your own more detailed pages on a topic )  and external links ( to authority sites ), both of these are needed for SEO purposes.

Leave a Comment