Post of the Week
Sponsored Link

ContentKing joins Conductor to Help Marketers Drive Digital Growth
Big news in the SEO industry: ContentKing has been acquired by Conductor, the leading enterprise Organic Marketing platform. The announcement highlights the importance of technical SEO in an ever-changing and increasingly complex search landscape, and is a transformative moment for the industry.
Tech
Python script for scoring internal links
Elias Dabbas with a great Python script to score internal links, including how critical and connected the links are, as well as a proxy for PageRank. 👏
Case Study
Real World SEO Analysis (Twitter Thread)
A thread of threads from Charles Floate with interesting analysis on the growth of niche sites.
Processes & Frameworks
How BERT helps Google Search understand language (Video)
Really enjoyed this short video from Google on what BERT is and how it's being used to help Google understand what you're truly asking.
Tools
Lost Google Impressions Index Check
Wow this is cool from Dave Smart. A tool for seeing URLs with lost impressions on Google and layering that with data from the new URL inspection API. 🔥
Unlimited Google Search Console Keywords Through BigQuery – Data Studio Template
A nice process from Mike Ginley on getting data out of Search Console into BigQuery and then visualised using Data Studio. Lots of guidance too! 🙌
How to use GPT3 to classify Keywords (Video)
Want to learn how to quickly classify keywords in Google Sheets using GPT-3? I absolutely love this video from Danny Richman (and it's something I've been playing with myself).
My Products 💡
Forecasting For SEO (Video Course)
Join over 250+ SEOs who have used my course 📊
Everything I’ve learned, tried and tested about SEO forecasting. Including a FREE Google Sheets template to help you build your own forecasts.
Hi there 👋,
Some big news last week in the SEO industry as our friends over at ContentKing got acquired by Conductor. 👏 👏
In some more personal news, I've now finished the core of the Keywords in Sheets add-on - and I'm hoping to release it in BETA in late March / April. It will be big, and I'm so excited! It will include all the data you need to power your SEO strategies, right inside of Google Sheets. 😬
This week's Post of the Week is from Adam Gent who is producing some knock out content at the moment on SEO product management.
This article is all about how to create outcome-driven SEO roadmaps, and connecting SEO opportunities with your vision. As usual, Adam has provided numerous examples and diagrams, alongside various other resources 🔥
Until next week!
Andrew Charlton