All Posts
First Principles - How does a website work?
How does a website work? What happens between you typing an address in your browser and the website appearing on your screen?
Video: How to group your keywords into pages
How do you assign keywords to pages? How do you decide which pages you should have and which keywords they should target? Do you need 3 pages for this topic or just one? Let's work through it.
Extract day by day data from Google search analytics graph - A bookmarklet
A bookmarklet to let you easily download the day by day analytics data in the search console traffic graph.
Extract the crawl graph data from seach console - A bookmarklet
A bookmarklet to let you easily download the crawl data in search console.
A guide for B2B SEO
Let's talk about how to do B2B SEO really well. B2B and SEO have a bit of an uncomfortable relationship. The channel doesn't fit instinctively as well as for a listing site or an ecommerce site, but it can be super valuable. How?
SEO Data - All in one place
A basic step by step tutorial on how to install a python library. Nothing fancy here.
Hire me
A basic step by step tutorial on how to install a python library. Nothing fancy here.
Hire me for training
A basic step by step tutorial on how to install a python library. Nothing fancy here.
How to get un-sampled Google Analytics data with python (& without)
A guide on how to get un-sampled data out of Google analytics with python (and without). We'll also go through the basics of how sampling works.
How to install a python library?
A basic step by step tutorial on how to install a python library. Nothing fancy here.
What is a jupyter notebook and how do I use it?
A guide on how to use the basics of Jupyter notebook. What is it, how can you use it and why do I mention it all the time?
How to make your awful technical SEO audit better
Most technical SEO audits, just aren't that good. They're notorious for being long badly prioritised lists (mine certainly were). Let's talk about how to do it better.
How to get Excel in regex?
A step by step guide to getting regex in Excel. What else could you possibly want.
How to get better at account management
You're a managing a client account. What do you need to know? Learn from my mistakes so you don't have to.
Passing headers to a content script chrome extension
Passing headers to a content script in a Chrome extension has been my biggest frustration building a Chrome extension. Let's run through all my mistakes.
How to rank track Google's hotel search - DIY SERP Research
A bookmarklet which lets you scraping ranks from Google's hotel meta search engine.
Why has your organic traffic dropped? - A step by step checklist
You're organic traffic has dropped. Goodbye good times and hello to immediate stress. What is going on. Why did this happen?
Differences between Fetch and Render, Googlebot and the Mobile friendly test
Are there any differences between how fetch & render, the mobile testing tool and Googlebot render things?
How (& why) to use Python for basic data analysis instead of Excel
Jupyter Notebooks (and python) are a fantastic place to analyse data. If you spend a lot of your time analysing data in Excel or Google sheets, you should absolutely consider learning how to use them. This post is a tutorial on getting started.
How to set up Python for Marketers
We're going to learn how to set-up python, step by step for Windows or Mac.
How to audit content and structured data for the mobile first index
Even in 2020 you'll occasionally run into a website with separate mobile and desktop sites. Here we talk through a process to audit them quickly using a jupyter notebook.
Traffic Light SEO
Traffic Light SEO, is a chrome extension, designed to show you a page's indexation and meta data passively as you are browsing around the internet.