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 »
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 »
Breaking down your GSC into brand vs generic keyword performance can give you a better insight into how an SEO campaign is going. Most SEO activity won’t be affecting the brand too much, as it will be more to drive performance increased within the generic keywords. Whilst you’ll get a flow-on effect, in that as
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
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
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
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 »
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
I’ve been doing SEO a little while now on and off over the years (but mostly on) and finally getting back into it full time now. Over time, I have learned quite a few little handy tricks doing keyword research that has helped me save countless hours… and many weeks! I figured it was about
10 Years of Keyword Research and What You Can Learn From It Read More »
