If you've been in SEO a while, chances are you've needed to ask a client for a complete list of their website's pages, preferably in a nice, simple spreadsheet. I don't know about you, but I love spreadsheets - I love them so much, I own several books on Excel (don't judge me), but being sent their XML sitemap can really put a spanner in the works, especially if it's a big … [Read more...] about How To Turn An XML Sitemap Into A CSV Spreadsheet
SEO
How To Make Site 5 WordPress Themes More SEO Friendly
As you may notice if you're a regular reader, I really struggle to stick with the same Wordpress theme for any period of time. There's always something shinier out there, or there turns out to be something wrong with the one I'm using from an SEO perspective that makes me want to change things up. At the moment, I'm using one from Site 5 and as pretty as their themes are, there … [Read more...] about How To Make Site 5 WordPress Themes More SEO Friendly
Your Backlinks Suck – Now What?
One of the most difficult parts of making an SEO campaign a success is building backlinks to the site in question. Well, that’s only half true – getting the links isn’t really a problem, it’s getting the links that matter and doing so in a way that won’t get your site penalised when Google finally cottons on to some of the naughtier link building methods.The problem with … [Read more...] about Your Backlinks Suck – Now What?
The Passion Factor – Does Authenticity of Content Influence SERPS?
As part of my daily blog reading, I came across this interesting post from SEOMoz’s Rand Fishkin the other day. He’s got a feeling that what he describes as “passion” is influencing search results in Google and frankly, I find it hard to disagree.The sites he discussed were mostly blogs that were ranking pretty well for mildly competitive terms, but what’s interesting is … [Read more...] about The Passion Factor – Does Authenticity of Content Influence SERPS?
Discovering A Forum Profile Linkwheel
If you spend a couple of years working in SEO, particularly agency-side, chances are you’ll see a lot of different ways to do things. White hat, black hat, varying shades of grey, good site architecture, navigation so bad that every link in the menu 302 redirects, you’ll see pretty much all of it, but the forum profile linkwheel I found the other day was a new one on me.It … [Read more...] about Discovering A Forum Profile Linkwheel