Google Answering Questions in Autocomplete

Posted by on July 5, 2013 at 4:47 pm

Well this is something I haven’t seen before, Google answering questions in the autocomplete.      I find it quite strange how Google is showing these types of answers from only typing in 3 characters. While the conversion calculator is very useful on Google, I wouldn’t have thought that it would be one of the […]

Google Auto Suggest Listing Websites You Have Never Visited

Posted by on April 5, 2013 at 5:18 pm

#WTF   I don’t think I need to say anything other than that and show the screenshot below – where the auto suggest on Google is listing websites that I have never visited before;     I’ve seen this before where Google shows websites that you have previously visited, but never for websites that you […]

My Top 10 Most Popular Posts from 2012

Posted by on January 10, 2013 at 2:16 pm

We are now well on our way into 2013, but looking back at 2012, what were the most popular blog posts on the website during this time?    Top 10 viewed pages in 2012 The list below shows the pages which were top viewed throughout the whole of 2012;   The Ultimate Guide to the […]

17 Of My 2013 SEO Predictions

Posted by on January 9, 2013 at 1:36 pm

At the beginng of 2012 I made some quite accurate SEO predictions so I thought I’d have another go this year and see how accurate they are again at the end of the year. Here are a few predictions that I think/hope will happen at some point in 2013.    1. Restricted API Access On […]

How To Return Multiple Nodes Using XPathOnUrl

Posted by on December 18, 2012 at 9:30 am

XPathOnURL is an amazing function within the amazing SEO Tools plugin for Excel that can scrape specific pieces of content that you need when entering in a URL and the XPath of the content that you want to retrieve. This post isn’t going to be a quite to XPathOnURL, nor is it going to be a […]

How Accurate Were My 2012 SEO Predictions?

Posted by on December 17, 2012 at 11:00 am

Back at the start of 2012 I predicted 13 things that would happen in the world of SEO over the next 12 months, looking back on these let’s see how many of these came true. 1. Social Signals Gain Importance Back in 2011 when Eric Schmidt announced that “The social signal, the people you ‘hang with’ […]

How To Get The Domain Name From a URL in Excel

Posted by on December 17, 2012 at 10:00 am

Often when analysing backlinks it is important to de-duplicate rows and rows of data into some kind of useful list of domains that you can work with. Often this can be quite a tiresome tasks but with a few Excel formulas it is possible to get the domain name from a long URL.  If you […]

How to Scrape the HREF Attribute Using XPathOnURL SEO Tools

Posted by on October 5, 2012 at 10:00 am

The joys of XPath and SEO Tools for Excel. Here we are going to talk through how to scrape the HREF attribute using the =XPathOnURL function as this is often needed when you want to scrape the actual links from a website which match a certain criteria.  If you just want the quick answer, here […]

How to Analyse Traffic from Link Building Work

Posted by on August 20, 2012 at 10:00 am

A large part of SEO is all about link building, you don’t need me to tell you that. What is important though is not just the changes in rankings which are happening due to the link building but also the amount of referral traffic which is coming through from this work.  If your links aren’t […]

How to VLOOKUP Using Partial Match

Posted by on August 17, 2012 at 7:41 pm

If you have ever used the VLOOKUP function within Excel before and tried the “Approximate Match” type then you will have realised that this is about as useful as a chocolate tea cup. Below shows how you can easily and quickly perform a VLOOKUP using a partial match on the look up value.  For those […]