Mark Rushworth - Company SEO Services, Tips and Tools Leeds

  • Home
  • About
  • Services
    • SEO Services
    • Local Search
    • PPC Services
    • Social Media
      • Reputation Management
    • Web Design
      • Ecommerce
    • Email Marketing
  • Blog
    • SEO Advice
      • SEO Techniques
      • SEO Tools
      • SEO News
      • Google
      • Link Building
    • My Life
    • Work Related
    • Web Design
    • Web Development
  • Free SEO Analysis
  • Contact

Google Knowledge Graph Brings Answers to Search

May 17, 2012, by Mark Rushworth No comments yet

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

I’m surprised the blog-o-sphere hasn’t been all over this but yesterday Google USA launched a new change to their user interface, this time called Google Knowledge Graph. What this does is provide answers from ‘trusted sources’ inline with your search queries. To achieve this, they’ve developed a new algorithm that puts the words in your search into into context. This is pretty revolutionary stuff and certainly has a knock on effect when it comes to our thinking about how this could apply to on-page text. Other implications of this is how it will affect Q&A style website content which i know is favored by many SEO professionals as a way of mopping up long tail traffic for our clients.

To date, there is no information on what sites they’re using as trusted sources for this information but you can bet that once its more widely available this is going to form the first goal of the industry as we seek to influence the influencers.

It’s also interesting that Matt Cutts already hinted that this was going to be rolled out and I personally had fears that Google was seeking to turn into an answers engine that displayed scraped content instead of providing website listings based on their need to add semantics and microformats to content (Google Shopping changes too). I’m sure this will come in time and we’ll all either love it or hate it and move back to Bing (which also showcased the same technology when it was being conceived). Also that Google+ isnt integrated apart from people searches.

As mentioned previously Google Knowledge Graph is USA only for now.

Note: I intended to attach an image but for some reason that doesn’t work today???

 

 Google Knowledge Graph Brings Answers to Search

SEO Tip – Identify New Data Between 2 Excel Sheets

May 3, 2012, by Mark Rushworth 3 comments

Paul our new Excel guru has shown me a nifty little trick that im sure you’ll find interesting.

I was discussing how each month Open Site Explorer outputted new data and it was hard to integrate this into an existing (previous months) worksheet without potentially overwriting the work already done.

He rolled his eyes and said “easy… give me a minute” and then dropped this on me:

=VLOOKUP(A1,Sheet1!A:D,1,0)

What it does is compare the (old) data in a tab called Sheet1 with the new data in Sheet2 using the first column (URL) as the measurement. Then all entries that are new will be labelled NA and can be integrated into the (old) work sheet.

Awesome stuff. Thanks Paul

 SEO Tip   Identify New Data Between 2 Excel Sheets

Panda, Penguin… Whats Googles Next Update Going to be

May 2, 2012, by Mark Rushworth 11 comments

OK, so we’ve had a succession of Google Panda updates and the latest ones called Penguin. This implies that the theme is black and white… is a site or link good or bad. This begs the question what other black and white animals can they come up with to name future Google updates? Heres my list… place your bets now folks!

  • Zebra
  • Dalmatian
  • Lemur
  • Orca
  • Killer Whale
  • Skunk (love this!)
  • Jersey (cow)

Can you think of any more?

 Panda, Penguin... Whats Googles Next Update Going to be

List of Google Social Analytics Metrics Partners

April 25, 2012, by Mark Rushworth 6 comments

Apologies for an other aide memoire but the following is a list of official websites used by Google in its social media metrics gathering.

If you sell in social media to your clients or simply want to enhance your organic search results then this is a great way of doing so. Its interesting that Disqus and Blogger/Typepad are in there which could prove to be a useful double hit if you’re using Disqus as a blog commenting system. Im not sure about the on-page SEO effectiveness of this as it seems Disqus uses some Ajax type thing but aas a social metrics gathering tool, maybe theres a benefit to it.

AllVoices
Badoo
Blogger
Delicious
Digg
Diigo
Disqus
Echo
Gigya
Google+
Google Groups
Hatena
Livefyre
Meetup
Read It Later
Reddit
Screen Rant
SodaHead
TypePad
VKontakte
yaplog!

 List of Google Social Analytics Metrics Partners

SEOMoz Gives Google Panda the Fist

April 25, 2012, by Mark Rushworth 1 comment

Our n00bie SEO Paul found this on SEOMoz and thought it was funny… I have to agree.

fist 300x159 SEOMoz Gives Google Panda the Fist

SEOMoz Google Panda Fist

Now I know the Panda update hit SEO’s and site owners hard and it certainly packed a punch.

Enough with the sillyness, its time to get back to work.

 SEOMoz Gives Google Panda the Fist

Matt Cutts Announces New Google Update that Tackles Web Spam

April 25, 2012, by Mark Rushworth 3 comments

Today the mighty Matt Cutts announced the latest in their series of updates designed to kill the impact of so called web spam. The full article can be read here.

Now I fully understand keyword stuffing and acknowledge that it’s a technique from the dark past of SEO however the second example they show just baffles me.

It’s a screenshot of some unrelated links on a page about a totally different topic.

I read it and thought I must have been taking crazy pills. Why would you ever put links on a site/page that’s not about your topic? Seriously…my brain turned to jelly.

Taking a step back, the biggest number of users this will affect are those who use blog comment spamming and more importantly, forum users. This is due to these links all being placed in signatures / threads / comments on pages that are not about the same topic. So if you use forums as part of your SEO (does anyone seriously use comment spamming?) then you might want to narrow your sphere of influence to forums and more importantly threads that support your signature.

Important stuff!

 

 Matt Cutts Announces New Google Update that Tackles Web Spam

Ad Group Ideas – New in the Google Adwords Keyword Tool

April 18, 2012, by Mark Rushworth No comments yet

Just noticed a great addition to the Google Adwords Keyword Tool, a new tab called “Ad Group Ideas (Beta)”.

ad group ideas 300x147 Ad Group Ideas   New in the Google Adwords Keyword Tool

Ad Group ideas

This tool is amazing for SEO as it gives you even more search keywords that the original Keyword Tool misses out!

It appears to auto create sample campaigns based around your seed keyword complete metrics and seasonality information.

Brilliant

 Ad Group Ideas   New in the Google Adwords Keyword Tool

Eggusaurus Rushworthus

April 16, 2012, by Mark Rushworth No comments yet

Ok, so ive been called out again and we’re now SEOing on a new competition for the keywords eggusaurus rushworthus. I’m confident that with a bit of skill and effort I will be able to trounce the other team members and reign supreme.

Again i need your help getting the word out. Please link back to this page using the eggusaurus rushworthus keyword and we’ll see how things progress.

The joke is that i bought a Threadless Tee that had some glow in the dark details. when washed these plastic strips began to stink of egg hence the eggusaurus rushworthus keyword :/

 Eggusaurus Rushworthus

Multilingual SEO Infographic for Translation

March 20, 2012, by Mark Rushworth 5 comments

My friends at Applied Language Solutions (Hi Emma) have cajouled me into placing this lovely infographic depicting the issues sites face when considering multilingual content.

Be careful i think its A3 when clicked!

Multilingual SEO a3 300x212 Multilingual SEO Infographic for Translation

Multilingual SEO Infographic

To view the original document that accompanies this infographic check the officiasl blog page at appliedlanguage.com

 Multilingual SEO Infographic for Translation

Excel Tip – Trim URL’s to just Domain

March 16, 2012, by Mark Rushworth 7 comments

If you use OSE or some other tool (majestic, link diagnosis) for back link analysis then you probably have issues with listing information concisely.

I typically work off a few columns:

  • URL
  • Title
  • Anchor
  • DA

The problem is many of the URL’s are deep links with long strings. So to trim a url column down to just show the root domain use the following in Excel:

=LEFT(A1,SEARCH(“/”,A1,8))

What this does is search cell A1 for all instances of the / character and trim back to the last one after the 8th character (because http:// is 8 characters and you want the one after this).

Enjoy!

 

 Excel Tip   Trim URLs to just Domain
123Next ›Last »

The SEO Team You Need!

I work as Director of Digital for Bite Digital, a leading SEO company in Manchester who in turn handle campaigns for some of the UK's largest high street brands. Our approach is to use a broad range of on-page analysis and Link Building techniques to holistically build high quality traffic to your website.

Call me today on 01612280127 for free, honest and open advice about your online projects or email markrush@gmail.com.

Follow us

FacebookTwitterYouTubeRSS feed

We Are Recruiting

Bite Digital, Manchester's leading boutique Digital Marketing agency is looking for new talented SEO team Leader (£25k+) to help mastermind and manage our growing portfolio of clients. If you fit the bill and want to bring and develop your existing link building and staff management skills then send your CV to mark.rushworth@biteus.net

Free SEO Audit Report

Free SEO Audit
Click here to receive a FREE detailed report on your websites on-page SEO.

Top Posts

  • The Walking Boots Bribe
  • iPod Dock Reviews
  • Buy Windows 7
  • SEO Leeds
  • Free Directory Submission
  • Web Design Leeds
  • SEO Manchester

Categories

  • Blogging
  • Gadgets
  • Google
  • Guest Posts
  • Link Building
  • My Life
  • SEO Advice
  • SEO News
  • SEO Techniques
  • SEO Tools
  • Social Media
  • Software
  • Web Design
  • Web Development
  • Work Related

Archives

  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008
  • October 2008
  • September 2008
  • August 2008
  • June 2008
  • May 2008
  • April 2008
  • March 2008
  • January 2008
  • December 2007
  • November 2007
  • October 2007
  • August 2007
  • June 2007
  • February 2007
  • January 2007
  • December 2006
  • November 2006
  • October 2006
  • September 2006
  • August 2006
  • July 2006
  • June 2006
  • Google Knowledge Graph Brings Answers to Search Mark Rushworth, May 17, 2012
  • SEO Tip – Identify New Data Between 2 Excel Sheets Mark Rushworth, May 3, 2012
  • Panda, Penguin… Whats Googles Next Update Going to be Mark Rushworth, May 2, 2012
  • List of Google Social Analytics Metrics Partners Mark Rushworth, April 25, 2012
  • SEOMoz Gives Google Panda the Fist Mark Rushworth, April 25, 2012
  • alanc230: I still think quality content is king. Drives me crazy...
  • tns: thats a good question guys i think google new update...
  • alanc230: These are some pretty great shirts. I've bookmarked the site...
  • Jordan: Rorschach update? haha
  • Consultoria: Poor animals... I'm sure the next will be Zebra Update,...

This is widgetised area:
Footer › Column 3

Copyright © 2011 Mark Rushworth SEO Leeds. All Rights Reserved. Privacy policy