40 Excel tricks for PPC pros
In the PPC world, Excel is a given. They go hand in hand. Like peanut butter and jelly. Not only will you become better at analyzing account performance, but you’ll also save a lot of precious time by becoming savvy with Excel and all of it’s featur...
Search basics: URL structure vs Information Architecture
I’ve recently noticed some confusion around the industry on the differences between URL structures and Information Architecture (IA). I thought it was worth clarifying a few points and giving you all some language that is useful when talking about t...
The 5 tips you need to generate SaaS leads
SaaS clients have a stereotype of moving really fast and they want results right away. Most SaaS companies love data and willingly dig into their account to find what works and are actively working on how more people could utilize their software. Be...
How to use RegEx formulas in Google Sheets
Handling big sets of data to analyse is quite normal if you work in SEO. On a regular basis, either in Google Sheets or Excel, I use formulas such as vlookup, index, iferror, and the list goes on, to sort quickly through endless data. Not only are th...
Using Google Analytics with Sheets
If you didn’t already know, Google Sheets has a fantastic Google Analytics add-on that can be used to create custom reports in Google Sheets. For more information on the reporting capabilities of this tool, read this blog post from 2016, which will a...
How kids learn to search
I recently came across a couple of fascinating papers (here and here) all about how kids search. I found it fascinating in its own right, and also found it thought-provoking in the new ways of searching it showed that had simply never occu...
How to audit links for SEO
I completed a backlink audit recently, and this is the post I wish I’d had when starting the tedious task of identifying the nasty links. Not all dodgy links are obvious, heck some are even near-impossible to find, especially when you have a spreadsh...
What is UX?
Put simply, UX is important in every part of our daily lives, probably more than most of us even notice. Why does this matter for SEO? In one phrase: machine learning. Machine learning algorithms are taking over SEO. Google sti...
Voice search marketing tactics for SEO
I was recently preparing a presentation and came across a presentation I gave to a small meetup in London in 2013. While there were only 100 or so people in the live audience that day, the presentation has now probably been seen by a hundr...