Data Analysis

Market Analysis & Keyword Insights Part 2: Analysing SERP Data

After running through the keyword research in part 1 here, we’re now digging into the SERPs. We’ll be extracting the data, and then looking into a few of the different analyses we can do with it. Extract SERP data Format the data Top performing competitors Top-ranking pages & page types Look into the structure of …

Market Analysis & Keyword Insights Part 2: Analysing SERP Data Read More »

SERP Scraping & Keyword Clustering in Google Sheets

Ever wanted to scrape just a handful of Google SERPs inside a Google Sheet? Or wanted to group a bunch of keywords, to better de-duplicate them and isolate unique topics? Well, have I got a Google Sheet for you! My SERP Scraper & Keyword Grouping Google Sheet will do all of that for you. Check …

SERP Scraping & Keyword Clustering in Google Sheets Read More »

Market Analysis & Keyword Insights Part 1: Keyword Research

It’s time to dive into my full process of doing SEO market research & analysis. This is something I do for some of my bigger clients when they’re either kicking off their SEO and want to understand the market, or they want to understand current positioning. A market research & analysis piece is essentially keyword …

Market Analysis & Keyword Insights Part 1: Keyword Research Read More »

Programmatic SEO: Tracking & Performance Monitoring

So you’ve got a shiny new programmatic build, and want to know how it’s performing. Monitoring indexation, traffic, conversions, rankings, there’s so much to look at so what should you focus on? Let’s take a look into a few things you should be monitoring, and how to go about it. Key metrics that can gauge …

Programmatic SEO: Tracking & Performance Monitoring Read More »

Using Data to Determine What Filters Should be Targeted

Bedrooms, and bathrooms, and price ranges, oh my! There are so many filters that could be used in the pretty URL, but what should be used? What should earn the “pretty” status, and what should be relegated to query parameter status? Some may say everything goes in pretty. Some may just pick a few, and …

Using Data to Determine What Filters Should be Targeted Read More »

Building Your Own CTR Model from Search Console Data

Rather than performing analysis using just the bare average rank, you can bring in a keyword’s search volume and add some weighting to the rank. To do this, you estimate SEO traffic for a keyword by multiplying its current rank, by the estimated click-through rate at that position. It’s not meant to be extremely accurate, …

Building Your Own CTR Model from Search Console Data Read More »

Bulk Keyword Categorisation & Classification

Categorising a large keyword list in bulk takes hours to do, unless you do it a special way. Learn how to categorise thousands of keywords in seconds through the use of a magical Excel formula. You can categorise data in Excel with this formula, it doesn’t only work on keywords. Another popular use of mine …

Bulk Keyword Categorisation & Classification Read More »

Scroll to Top