Tools

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 »

Dynamic Content Generation with Google Sheets

If you haven’t been following along, I’ve been documenting my journey to a 1,000+ page programmatic site in WordPress using Google sheets. The build is heavily reliant on Google Sheets to generate dynamic content based on templates. The content there is a little more advanced, as it is leveraging rules to determine which content template …

Dynamic Content Generation with Google Sheets 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 »

Scroll to Top