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 »
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 »
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 »
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 »
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 »
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 »
When you start doing SEO data analysis, one of the first things you’ll find out is that GSC only gives you 1,000 rows of data. So how do you extract the rest of the data? How do you get more keywords, and more landing pages downloaded from GSC? Search Analytics for Sheets Whilst there are
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
Data preparation is the base of any good analysis. Getting it right from the start will just ensure that any analysis you do in the future, will be nice and easy for you. It’s back to basics time! I run through a number of different basics, from file naming and why you should follow a
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
