If your a fan of a sports team you may have seen Google displaying the last result and next fixture at the top of the SERP. They haven’t got is correct on all searches with some team names not triggering the feature e.g. “bolton wanderers”.

For my team, Blackpool they are showing the fixtures for Blackpool FC our namesake who play in the Malawi Superleague.

Blackpool FC Fixtures Blackpool

If you try the search sometimes Google is displaying the correct date which indicates it’s mixed across data centres.

Lets hope nobody goes to see Blackpool play the Barracks on the 31st!

When conducting key phrase research little tips, tricks and tools can save time. Being a wizz at Excel helps, being able to create scraping tools is also great but sometimes you just need to copy and paste from sites to generate key phrase lists.

Google docs

I’ve come across a neat method of using the ImportXML function on Google Docs to extract lists from a web page into spreadsheet (from there you can paste into the Google Keyword Tool to get volumes). Credit goes to this post for the how to us http://ouseful.wordpress.com/2008/10/14/data-scraping-wikipedia-with-google-spreadsheets/.

First you need a page with data on, could be a list of products, table of locations, for example list of dog breads, list of football teams, or a list of settlements in the uk ordered by population.

In Google docs you then use the ImportHtml function specifying the URL, that you want to grab a table and which table e.g. the 1st, 2nd etc.

=ImportHtml(URL, “list” | “table”, index).

For example

=ImportHtml(“http://en.wikipedia.org/wik…..m_settlements_by_population”,”table”,1)

A full explanation can be found on the help files http://docs.google.com/support/bin/answer.py?hl=en&answer=75507 which also show other uses and variations.

You hit enter and hey presto you have a nice table with all the figures separated out.

google docs import html

If you look into the “ouseful” blog, linked above, you can then publish from google docs into RSS, then to Yahoo pipes into RSS then use the RSS on your site as content.

You can also import from RSS and product feeds.

With Chrome coming out on the Mac I’ve moved away from FireFox at home and work, it’s just too slow and does have the odd crash. There is still no extension support on the Mac version but these all work with no problems on Windows XP SP3.

chrome billboard
Photo Credit – iVinay

Chrome Flags by josorek – https://chrome.google.com/extensions/detail/jhejngphiacapbgllhagbpdkkdieeaej

PageRank by kalehrishi – https://chrome.google.com/extensions/detail/pneoplpmnpjoioldpodoljacigkahohc

Firebug Lite by andrei.pervychine – https://chrome.google.com/extensions/detail/bnbbfjbeaefgipfjpdabmpadaacmafkj – Or use the one built into chrome Ctrl + Shift + I

IE Tab Classic by josorek – https://chrome.google.com/extensions/detail/miedgcmlgpmdagojnnbemlkgidepfjfi

No Follow Checker by Dan – http://www.chromeextensions.org/webmaster-seo/nofollow-checker/

Anyone else with any good extensions for chrome?

I’ve seen in the past scraper sites cause problems for sites in Google and this blog is currently been scraped and outranked sometimes by brokencontrollers.com. A quick spam report to google and the offending site soon goes away. But it seems that the page to report spam to google has been removed recently and you can only report spam while signed into a Google account…

The page used to be located at http://www.google.com/contact/spamreport.html known as the “unauthenticated” you could report spam anonymously, so no ties to your Google account which links to your site.

google-report-spam-result-form

That page now 301 re-directs to https://www.google.com/webmasters/tools/spamreport?hl=en which does load up the form but only when logged in to a Google Account with Webmaster Tools.

The landing URL from the natural ranking for “report spam” takes you just the dashboard of webmaster tools which is pretty useless, guessing they haven’t added the correct re-direct.

google spam report serp

This seems a strange move by Google as this may decrease the number of spam reports.

1. Not everyone has a Google account.
2. Even if you have a Google account your might not have Webmaster Tools.
3. You might not want to report on an webmaster tools account that contains your site if you use any black hat methods. E.G. reporting your competitor may draw attention to your site.

Google’s best method of detecting spam and paid links are reports from webmasters, SEO’s and users. This move to to remove the unauthenticated / anonymously report method may have made their jobs a little harder?

Back in the office for the new year and I noticed a new name advertising on the term “SEO” – BT.

bt-seo-advert

There’s been a few posts recently about how you get what you pay for with SEO services, so it doesn’t look great for BT’s new SEO service know as SearchSmart which starts at a chirpy £74.99 a month. There’s a £100 set up fee and also a minimum 3 month contract.

For £74.99 I’m guessing that the key phrases selected are long tail and local.

It sounds pretty much an automated service (bar the audit doc) with tight control on any phone conversations with a consultant. If you need extra consultancy time it’s £100 an hour, a little expensive for the UK.

It’s hard to judge the service, so far they have only got one testimonial Brand X PR who haven’t implemented the work and guessing haven’t had any link building as they have no links according to YSE. But a quick check on the BT site and they don’t rank for their own content.

bt-seo-ranking

So they have a duplicate domain “http://www.latitudeorganic.com” which is strangely owned by “Scott Sargeant” who works for the Latitude Group.

In conclusion is BT SearchSmart Any Good? Well it’s seems it’s just SEO by Latitude.. If your going to resell at least do a good job of separating ties from the company who are going to do

EDIT – Article from SEOCO about this too http://www.seoco.co.uk/blog/bt-now-offering-seo-ppc-services/

Posted in SEO.