Keyword Research

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 »

Extracting Keyword Templates/Patterns from a Keyword Set

When doing keyword research for programmatic sites, you shouldn’t be analysing each page individually. You especially can’t be optimising an entire programmatic build page by page. You should really be looking at the overall group, that each page falls into, and looking it as a whole. How do we do this though? How can we …

Extracting Keyword Templates/Patterns from a Keyword Set 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 »

Estimating SEO Traffic for a Keyword Set

Estimating your organic traffic will allow you better assess your current performance for a set of keywords, but also allows you to directly compare that performance with your competitors. In this video, I run through how to properly set up your data and run the formula across a set of categorised keywords. This will be …

Estimating SEO Traffic for a Keyword Set Read More »

Bulk Generating Keywords for SEO

Discover the easiest ways to generate keywords in bulk using Excel. These formulas are the basis of so much work, and keyword generation really will just give you a top-level understanding of the formula’s use.   Concatenate – Join as many cells together as needed =CONCATENATE(*First CELL to join*,*Second CELL to Join*) Concatenation is a …

Bulk Generating Keywords for SEO Read More »

Product Comparison Keywords: A foot-in-the-door SEO strategy

Comparison keywords are an awesome foot-in-the-door SEO targeting strategy if you’re kicking off any sort of product-based strategy. Many decent volume, low-comp keywords just sitting there for the picking and can be targetted individually, or in bulk. Many people won’t even consider many of them! My latest little project has even just cracked 270 clicks …

Product Comparison Keywords: A foot-in-the-door SEO strategy Read More »

Building a Keyword Research Dashboard in Excel

An extremely large table of all their keywords, isn’t going to give the insight some clients would want. Some would like more a bit more insight into the data they’ve paid thousands for. Building a keyword research dashboard in Excel is a great way to allow a client to interact with their keyword data. In …

Building a Keyword Research Dashboard in Excel Read More »

Scroll to Top