Earlier today I gave a presentation at SES London 2012 with Ron Jones from Symetri on the topic of advanced keyword modelling for keyword research. While Ron gave the theoretical overview of the concepts a good researcher might use to understand and categorise how users search, I gave a practical demonstration using SEO Tools for Excel and the Adwords API Extension. I also gave a preview of a new tool we’re testing to help keyword researchers predict keywords for the fresh index. More on that later, because it’s buggy as hell…
Tools of the Trade: Excel Tips from Richard at SES London 2012
While preparing myself for an SEO conference presentation, I like to practice to make sure I can fit in what I have to say, or in this case; show. Speaking on the SES London 2012 “SEO Tools of the Trade” panel, I gave up a few interesting Excel tips using SEO Tools for Excel and the Adwords API extension. Here are the guides: - SEO Tools for Excel - Check your Sitemap for Errors with Excel - Fun With The SEOmoz API – Get Links Data Straight into Excel - Adwords…
Check Your XML Sitemap For Errors with this Excel Tip
Today, I want to share a tip for quickly weeding out errors in sitemap XML files. This post will teach your a few new Excel tricks and (hopefully) save you some time in your own technical SEO audit projects. Why a nice clean sitemap? Google have invested a lot of time and effort into improving the sitemaps functionality in Webmaster Tools and the advice I’ve always heard from Google people is advice like; keep your sitemaps as error free as you can, use the correct canonical URL. I’ve always felt…
Why You Should Supercharge Your Video Strategy & How to Do It
Introductory video: Video vs. Copy & Infographics Since users only read an average of 28% of words on web pages, we can conclude that copy just isn’t a great conveyer of information online for human users (although I’ve had to use it along with videos in this post – I hope you read it all!). Copy’s weakness is one of the reasons for the infographic boom, yet video can go further than infographics at conveying information quickly. Consequently, I’m surprised videos aren’t used more widely in SEO. They are probably…
Find us on