Top paying topics to earn with adsense — How to find out
This post is for bloggers and/or content creators.
As you’re about to dive into writing your blog or your site content, you probably want to do some keyword research.
Now don’t let the word research throw you off-track.
It doesn’t have to be complex.
In this post, I am gonna let you know a very simple way of deciding which topics to write about that makes the most out of all your possible topics.
Let’s say you’ve got 10 topics: Topic 1, Topic 2 … Topic 10.
Let’s also say that you can write about each topic as good as any other one.
But then which one should you write about first? Let’s go with the one that makes the most adsense money per thousand impressions (RPM).
But how do you find out RPM? Once you have a site running Google will let you know what the RPM is of your site based on your real adsense stats. But how to find out a good RPM before even start writing?
Read on…
Google Keyword Planner will show you results (which are related keywords to a search term or search terms) that you use.
At which point you can click on square box beside each suggested keyword to select them. Then on top (in the blue bar) you’ll see a link that says “Add Keywords”, click on it. Your keywords will then be added to the current adwords plan (don’t worry you don’t have to go through with the plan to have a real ad running).
At this point, if you click on “Forecast” on the left hand side, you’ll see the keywords shown and Click Through Rate (CTR) and Cost Per Click (CPC) for them.
From these 2 numbers you can calculate RPM by taking CTR/100*1000*CPC.
But it’s a pain to do them manually one by one and if you’re researching you want to compare these faster (than having manually calculating them one by one).
First thing that comes to mind is copy this data as table format into Excel or Google Sheets and do calculating for all rows in there as it would be faster.
But copying this data and pasting in Excel or Google Sheets doesn’t work since they’re be copied as newline character delimited. You want to break them up by tabs and shown row by row.
That’s where my simple and effective tool comes in. (Its link is in post#2 of the linked topic).
You simply paste your copied data from Google Forecast into the tool, choose 7 columns (as when I did this Google showed 7 columns, but that might change in future). Enter which columns you want to convert to pure number/decimals to perform math on. Click Process/Run. and BOOM, you have the data in nice HTML table (which you can select from begin of table [top left] to end of table [bottom right]) and paste into Excel of Google Sheets.
Inside Excel or Google Sheets, you simply used the above bolded formula to calculate RPM and you have the RPM for all the chosen keywords available to you to see.
If you still have problem understanding what I am talking about.
You can view this video demonstration. It pretty much shows you step by step along the way.
I think this tool is very valuable to bloggers and content creators because it saves you time from writing topics with low RPM.
If you wish, you can still jump onto low RPM later (no one will stop you). But it’s probably good to aim for high RPM first to make some decent money first before you can slack and do whatever as you choose.
I hope you find this post useful and helps you target higher RPM topics and make more adsense money that way.
If you find it useful or would like to leave a comment, please feel free to do so, I love to hear from you.
