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.

New Approach due to Covid and Successful Online Course

From May 2020 I had to make radical changes to my business. For many years I have been available to teach local people in their own home, as you can see from the early posts on this site right back to 2013.

My-Computer-Tuition is now only available Online and the main subject is now starting an online business

Towards the end of 2020 it became obvious to me that thousands of people are going to be affected by Covid, losing jobs, managing on much less income 

Free Course

Earlier this year, having launched a series of articles on the site to help visitors get started. I have put the articles in a Free Course for readers to follow, which will be available by email.

PART ONE IS NOW LIVE ( APRIL 2021) SO SIGN UP RIGHT NOW  ! 

Free Tools

The emphasis will be on using the few Free tools available to anyone on the internet. So many courses use premium tools, which have a monthly subscription and this is a potential drain for those on low incomes. I don’t want there to be any barrier to entry.

NEW April 2021: Free and Freemium Tools List , look here for some Great resources to get going ! 

I will be continuing to work online only. If I can help you with anything you find in “my-computer-tuition.co.uk” please feel free to contact me using the contact form and email. All my regular clients can follow along and of course my coaching clients can still be contact me by phone.

Coaching and Upgraded Course

As soon as possible in April , I will have online business coaching upgraded and ready to take new clients, so if you’ve tried and failed, or setup a website with some success, I’m ready to take you to the next level. There are many ways to earn money online, affiliate marketing has always been my favourite method, always happy to help you make your website take off, with Affiliate Marketing.

To apply, simply email me ( or use the online contact form ) with your progress so far – your website and where you would like to be in 12 months time. If I can help you, we can set up a phone call to discuss.

All the best for your success

Andrew