Natural Search Blog


New Tool to Annualize Google Keyword Data

Do you use Google’s AdWord Keyword Tool for your keyword research? If not, you might be missing out. Like all keyword research tools, it may not be the end all be all, and it isn’t without its own little quirks, but it is still rich keyword data whether you use it on its own or in relation with the other keyword tools you are using.

Google has modified the tool over time, and one of the great additions was the ability to see the monthly demand via a small little bar chart. This can be very useful for factoring in seasonality or growing demand for certain phrases. Wrapping your head around the actual numerical data is a bit more challenging. The Local number is just for the most recent month while the Global number is a monthly average. This is further complicated in that the Global number includes the world essentially while the Local number may factor in your campaign settings and locality (based on your AdWords campaign configuration).

To help tighten up data and provide a little more insight into the Local numbers, I just released an Excel spreadsheet that can take your Google Keyword Tool’s export and annualize the Local demand numbers. In some cases, this may dramatically change the order of importance of keywords to target.

Best of all, this tool is free to use so give it a play. The link below will take you to the download page for the tool as well as more detail about how it works and an example.

Google Keyword Tool Annualizer

Taking On An Existing PPC Campaign – Things To Be Aware Of

Working in a search marketing firm throws up lots of interesting challenges. One of them is taking over an existing Pay Per Click campaign from another agency as the client is very unhappy with her paid search efforts. Her main grouse is that she is not getting enough business out of her PPC campaigns and her ROI (Return on Investment) is pretty poor.

There are a variety of factors that are contributing to the client’s poor performance in paid search. If you are taking over the client’s existing campaign, there are positives and negatives which you have to be aware of. This post will discuss these at length in no particular order.

(more…)


Fatal error: Uncaught Error: Call to undefined function UTW_ShowCurrentTagSet() in /home2/sspencer/public_html/naturalsearchblog.com/wp-content/themes/naturalsearch/footer.php:5 Stack trace: #0 /home2/sspencer/public_html/naturalsearchblog.com/wp-includes/template.php(688): require_once() #1 /home2/sspencer/public_html/naturalsearchblog.com/wp-includes/template.php(647): load_template('/home2/sspencer...', true) #2 /home2/sspencer/public_html/naturalsearchblog.com/wp-includes/general-template.php(76): locate_template(Array, true) #3 /home2/sspencer/public_html/naturalsearchblog.com/wp-content/themes/naturalsearch/index.php(49): get_footer() #4 /home2/sspencer/public_html/naturalsearchblog.com/wp-includes/template-loader.php(74): include('/home2/sspencer...') #5 /home2/sspencer/public_html/naturalsearchblog.com/wp-blog-header.php(19): require_once('/home2/sspencer...') #6 /home2/sspencer/public_html/naturalsearchblog.com/index.php(17): require('/home2/sspencer...') #7 {main} thrown in /home2/sspencer/public_html/naturalsearchblog.com/wp-content/themes/naturalsearch/footer.php on line 5