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 Phrase | Searches/month | Competition | CostPerClick | CPC (number) |
|---|---|---|---|---|
| how to get my website to the top of google | 90 | Medium | $23.07 | 23.07 |
| how to get my website on google first page | 20 | Medium | $22.07 | 22.07 |
| how to get on google search first page | 10 | Medium | $21.25 | 21.25 |
| how to show your website on top of google search | 10 | Medium | $20.25 | 20.25 |
| how to get your website higher on google | 90 | Medium | $18.41 | 18.41 |
| how to get my site higher on google | 10 | Low | $17.79 | 17.79 |
| how to get website on first page of google | 140 | Medium | $17.35 | 17.35 |
| how to get your website to rank higher on google | 10 | Low | $17.24 | 17.24 |
| how to get google ranking for my website | 10 | Medium | $17.15 | 17.15 |
| how to get my website higher on google | 30 | Medium | $14.78 | 14.78 |
| how do i get my website to rank higher on google | 10 | Medium | $14.19 | 14.19 |
| how to get your website on the first page of google | 50 | Medium | $13.8 | 13.8 |
| how to get on 1st page of google | 10 | Medium | $13.42 | 13.42 |
| how to get your site at the top of google search | 10 | Medium | $12.69 | 12.69 |
| how is my site ranking on google | 10 | Medium | $8.00 | 8 |
| how to find my website google ranking | 10 | Low | $6.41 | 6.41 |
| how to rank on the first page of google | 10 | Medium | $5.45 | 5.45 |
| how to find google ranking of a website | 10 | Medium | $3.05 | 3.05 |
| how to rank my website top in google | 10 | Medium | $2.73 | 2.73 |
| how to get your website to the top | 30 | Medium | $2.31 | 2.31 |
| how to rank my site first on google | 10 | Low | $2.14 | 2.14 |
| how to rank your website for keywords | 10 | Medium | $2.07 | 2.07 |
| how to rank a new website on google | 10 | Medium | $1.68 | 1.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.