Leeds SEO

Big thumbs up to SEOmoz for this one, I sent a suggestion only a couple of weeks ago to have the ‘target’ (i.e. page) that the link goes to added to linkscape csv exports and note today it’s already been added.

There are some great benefits to this subtle change, especially in relation to analysis :

Quickly find your competitors most optimised links

An optimised link would generally contain great anchor text and point to the most valuable sub-page. They are often paid for. Simply do a pivottable adding Target, then Anchor text to the row labels, then Anchro text to values and you’ll have a nice summary of pages with anchor texts and counts – if you click on a number then you’ll see the links to that page with the given anchor text in a new worksheet. What you do with this date is of your call

Work out very quickly what products your competitor appears to be targeting

This can be done with a very simple pivot table, look at how many of their sub-pages have inbound links ; if they are doing SEO it indicates which products are important to them

Find your or your competitors most successful linkbaits

This one is a simple pivottable & sort – look for deep pages with a lot of inbound links. When I do this on Seomoz.org, I notice that the beginners guide to search engine optimisation, and the search ranking factors are amongst the most popular pieces of content. Unfortunately , due to the ways linkscape filters out links you’ll lose a lot of the natural links , but you should still have enough to see the actual pieces which earned the natural links to find them with a new search (either using linkscape or Yahoo!).

Honing in on your competitors lower grade activity

What on earth do I mean by this? well I’m referring to comment spam, article distribution & the like – again, due to low quality frequently being filtered out of linkscape (and indeed many tools) it’s often necessary to find the URL’s  and then move to yahoo to get the raw data (i.e. links).

You can hone in on this by exporting the linkscape data to csv, doing a pivottable, using nofollow as a filter (where nofollow has a ‘1′ in it), and target as both a row label and value – you should be able to identify sub-pages picking up a fair few nofollow links this way, which can trigger further investigation.

If you do identify a lot of these ‘noise’ links, then you can exclude this noise from your analysis when trying to work out the links that are really doing the damage.

An alternative way I’ve used to hone in such links is to do a similar thing using anchor text instead of target, isolating all nofollowed links with rich anchor texts – these are almost always spam. If you’re that way inclined you could even use these links to report your competitors, but given they aren’t paid for, Google is unlikely to care too much …..

If you’ve read this post wondering how on earth to do Pivottables, I recommend you read and listen to the distilled series on how to be an excel ninja .

While I think the ever increasing visibility being provided on links by Linkscape/Majestic is excellent, I think it’s worth pointing out that it’s becoming easier everyday for your competitors to imitate or scrutinise your link building techniques, meaning we have to work ever harder to create inimitable campaigns.

Occasionally I wonder whether we are own worst enemies in the SEO Industry, so I’m unsettled by one of the latest trends I’ve observed over the last couple of years (and increasingly in the last few months) – an irrational fear of anything that could possibly be linkbait.

It goes like this – somebody says something potentially controversial , we (as SEO’s) decide as a collective that… Read More...

Hey folks,

Just a quick one to tell you about a change for me. It’s with both sadness and great excitement I can now tell you about my pending move from Leeds to pastures new.

I’ve decided to leave my current position here to take a new Job @ Gravytrain working with LeedsSEO favourite Hannah_bo_banna , in Hampton Hill, SW London. I’m obviously really excited about… Read More...

As  a user of Smartphones from the very earliest days, I’m currently feeling pretty low. My trusty HTC Touch HD has broken (Touchscreen completely stopped working after a small blob appeared in top corner), and I’ve had to send it back. For the next 28 days I have the Joy of using a Nokia 6120 , which seems almost as 2008 as RSS (well actually it feels more 1998, but… Read More...

Ok, I’ve just coded a neat little macro that I thought might be useful to others.

Something that always annoyed me is the result I get when I export keyword data from GA comparing two time periods. The reason why I run this report this report is pretty simple , I want to see what is different on a keyword level from, say , last month to the month… Read More...

Wherever I’ve worked I’ve always been the excel guru who everybody would come to when they had an excel problem. I’m quite at ease with VBA code, pivot tables and multiline formulas, but oddly enough I’ve never really been that good at graphs, and typically I’d beeline towards my comfort zone of pie, column and line charts. I decided that I’d correct this weakness earlier this month, and thought it… Read More...

No doubt most of you will have read the techcrunch article by now, proposing that it’s time to regulate search marketing , and quite possibly dismissed it like I did. The article does make some good points around google dominance, but makes unworkable conclusions.

As a generalisation, I don’t agree with regulation (or most forms of government interference for that matter), and I much prefer voluntary industry standards… Read More...