John Mueller interview at SearchLove
I was fortunate enough to be able to interview Google’s John Mueller at SearchLove and quiz him about domain authority metrics, sub-domains vs. sub-folders and how bad is ranking tracking really. I have previously written and spoken about how to int...
How to rank for head terms
Over the last few years, my mental model for what does and doesn’t rank has changed significantly, and this is especially true for head terms – competitive, high volume, “big money” keywords like “car insurance”, “laptops”, “flights”, and so on. Thi...
Find anomalies in your campaign spending with this Google Ads script
Have you ever had a campaign spend a touch more than expected and taken a too long to spot it? No one likes to catch their campaigns underspending, let alone overspending, but even pay-per-click (PPC) superheroes aren’t entirely infallible. If a chan...
How to get featured snippets
Most companies with a presence on Google will have an interest in appearing at the top of search results. Naturally then as SEOs, we are often asked how featured snippets can be acquired. If you’re currently working on winning some featured snippets,...
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...