Post of the Week
Sponsored Link

Case Study: How Seer Interactive avoided 100% of the traffic being removed from SERPs with ContentKing Alerts
Seer Interactive was performing weekly audits for their client's websites, but found this left them vulnerable to changes and issues that arose between scheduled crawls.
That's when they discovered ContentKing. With real-time alerts, the team could immediately detect issues that may have gone unaddressed.
Katelyn Sidley, Technical SEO Manager at Seer Interactive: "ContentKing has been great in giving us visibility into changes on our clients sites in real time! We are able to discover problems like noindex tags and others BEFORE experiencing the drop in our client's traffic."
News
Bing & Yandex initiative IndexNow highlights the value of treating βtime-to-indexβ as a KPI
IndexNow, an indexing initiative introduced by Bing and Yandex, is aiming to make the internet more efficient. Ryan Siddle provides a great summary of the initiative and describes the value of treating time-to-index as a KPI.
Processes & Frameworks
SEO Blueprint 2 - Exclusive Community & Online Training
If you want to learn from one of the best, Glen Allsopp, you should definitely check out SEO Blueprint 2 which includes 27+ hours of training!
Tools
Keywords grouping using Google Search Console data
An interesting way of grouping keywords using Search Console data by Mecagoenlos
Core Web Vitals: Customized guide to improve webpage speed
"Not just another website auditor"
This tool from Tim Bednar looks amazing! The waterfall layout with recommendations you can copy to Trello is probably one of the nicest views I've seen. π₯
Search Response - People Also Search For
Search Response by Abhinav has released a second tool for discovering keywords that appear when a user bounces back to search results. This looks super useful! π
How To Integrate Nightwatch API In Google Sheets And Data Studio Via Google Scripts
Nightwatch, an advanced SEO tool, doesn't support a full Data Studio integration. To get around this Lazarina Stoy shows you how you can use their API to visualise position changes of tracked keywords in Data Studio. Looks great π
Python Script: Automatically Cluster Keywords In Bulk For Actionable Insights V2
This looks so so cool from Lee Foot, and I know a Streamlit app is in the works too! π
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 π,
Last week I shared a sneak peek of one of my functions from the Keywords in Sheets add-on I'm hoping to release soon! Our search volume function will get you search volume and growth metrics for thousands of keywords in seconds, from any location. See the thread here.
I'll also be releasing a competitive analysis and related keywords function - you heard it here first π
My Post of the Week is by Cyrus Shepard who has shared an excellent guide on how Google could be using click-based signals. I love the research behind this article and the fact he outlines a huge list of resources, including other relevant articles and Google patents. Must read π₯
Until next week!
Andrew Charlton