Post of the Week
Sponsored Link

Detect and fix SEO issues proactively
Did you know that nearly 50% of SEO incidents take at least four to seven days to detect?
Don't wait until your next crawl to notice something is wrong. With ContentKing 24/7 monitoring and alerting, you'll have eyes on your site at all times so you can detect and fix SEO issues before search engines even notice.
News
October 2022 Spam Update
Google has just released a spam update which affects all countries and languages.
A deep dive into Search Console performance data filtering and limits
Google provides a deep dive into Google Search Console performance data, including API limits and a view on why some queries are redacted, and what it means for your data.
Content
Measuring E-A-T? — Whiteboard Friday
How do you go about measuring E-A-T and is it even possible? Lily Ray with an impressive Whiteboard Friday! 🙌
Case Study
The case of the stealth Google-bomb
This is super interesting from Chris Silver Smith. How can a page rank for a keyword not found on the website or in its backlink anchor text?
Processes & Frameworks
What Is Topical Authority in SEO & How to Build It
How does topical authority work? "No one really knows" in Jake Sheridan's own words.
Nevertheless, he does a brilliant job in describing how you might be able to measure it, and how you might build topical authority on your own website.
A visual introduction to probability and statistics
As an SEO you ought to know about probability. This is an amazing visual introduction!
Tools
Website Migration Mapping Tool
Lee Foot releases the migration mapping tool he's been using for over a year. Looks great! 🔥
My Products 💡
Forecasting For SEO (Video Course)
Join over 350+ 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.
Get rankings, related searches and more in our new search result functions
We’ve just released 5 new search result functions in Keywords in Sheets PRO, including:
- Get rankings
- Top search results
- Top search titles
- Related searches
- SERP similarity
It makes analysing search results so much faster! Near 70 countries supported 🌍
Hi there 👋,
I'm absolutely loving working on Keywords in Sheets at the moment. We just dropped a new update last week which makes it easy to get rankings across near 70 countries directly in Sheets.
You can see the video tutorial here.
In addition to that you can also get top search results, top search titles, related searches and SERP similarity scores in Sheets.
I'm now releasing updates almost every week, as we aim to create the building blocks for you to create your own SEO templates and tools in Google Sheets. I'd say around 80% of the stuff I release will ultimately be free and open source.
I'm launching a few free utility updates this week such as "row to col" which can take comma-separated values in a row and return a single column of values.
Please reach out if you have feature requests!
My Post of the Week is from Logan Bryant - fast becoming the SEO testing guru.
He describes 5 tests that might seem a bit 'untestworthy.' But just because you can't split-test in the typical sense with statistical significance, doesn't mean you can't garner leading signals. I also love how he visualises low -> high confident SEO experiments too - check it out here.
Until next week!
Andrew Charlton