Blog

Update: we've updated this spreadsheet to the new Google Docs format - no more 50 limit on importxml lookups (and hopefully, more reliable results).

If you like this, also check out our spreadsheet to scrape the top 100 results and other Google Docs spreadsheets for SEO.

Fed up with adding "&pws=0" to your address bar to bypass Google's search personalisations? Sick of your friend's mugshots showing up in Google search results? Then be fed up no more with this handy bookmarklet!

What Google Personal Search does

Based on your search history, Google Plus connections, activity and more, Google re-orders your search results, to place sites you have an association with higher in the rankings. Here's a quick example:

These days there are a number of providers of search analytics data - that is, historic and ongoing data about keyword rankings and site performance across both paid and organic search. The data is extremely useful when evaluating both your own sites, and looking at competitors.Most of these tools provide an amount of free data, with a subscription plan to "unlock" more complete data.

Google has an advanced search option called "verbatim" that allows you to bypass many of its prediction/expansion features. So, if you want Google to search exactly for the words you enter (i.e. you're a pro searcher!) you can enable the option and get, frankly, better results.

Particularly for lengthier searches, Google's default results can be some distance from what you actually wanted to find. And the verbatim button is about as buried as a Google option could ever be! Here's a quick example: