Post of the Week
Detect and fix SEO issues proactively
Search engines are constantly crawling your site, and you need an SEO platform that can do the same. That's where 24/7 ContentKing Monitoring™ comes in.
Teams using ContentKing were 3x more likely to say it's becoming much easier to detect incidents than non-ContentKing users.
Entity Building And Entity Models: Disambiguating Intents For Advanced SEO
This is awesome! Emilia Gjorgjevska walks through how building semantically enriched entity retrieval models is crucial for smart content optimisation, and why you should take your time with your content!
GA3 to GA4
Amazing work from the Locomotive team, JR Oakes, Joe Joiner, and Savannah Casto. This tool creates and fills a Bigquery table with available GA4 data and formats it to be compatible with historical data pulled from GA3. 🔥
Related Categories: A new SEO workflow for e-commerce sites
Great stuff again from Andrea Volpini. A Google Colab notebook that ultimately creates a related searches widget across product pages. His Twitter thread describes a case study done on fila.com. Cool!
Poundland has made a costly ecommerce mistake and here's why
I love these teardowns from Luke Carthy! This one looks at Poundland's ecommerce pilot and acquisition of poundshop.com. 💡
Processes & Frameworks
An SEO Process for Content Optimization
New to SEOTesting: Page Actions.
This allows you to add 1 of 5 statuses to URLs.
- Do Nothing
Awesome update! 🔥
How to sort Search Console data in Data Studio by the Delta
Great thread by Brie E Anderson on a solution to a Data Studio issue you may have come across, how on earth do you sort Search Console data by the delta?
When someone types “Neeva” into search, how do we know they mean “http://neeva.com”?
Have you heard of Neeva? They're an ad-free, private search engine, but they're also super transparent about their algorithms and regularly tweet the challenges that they face. In this one they talk about how they know people searching for "neeva" mean "neeva.com".
Keyword Difficulty Finder (Streamlit App)
Lee foot coded up Shane Jones' excellent keyword research process. Amazing for finding low difficulty keywords! 🔥
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.
Hi there 👋,
Big news for me last week as I eventually launched the Keywords in Sheets add-on in BETA. 🎉
It includes 4 PRO functions 👇
Search Volume - Get search volume for 1000s of keywords across any location, in seconds.
Related Keywords - Get up to 1,000 related keywords for a seed keyword.
Competitor Keywords - Get all of the keywords your competitors are ranking for.
Search Results - Get search results across multiple countries and languages.
And 6 FREE functions: Status Code Checker, Redirect Checker, Local Keywords, Link Checker & XML Sitemap.
The add-on has now been downloaded over 350 times from the Workspace store - and there are only 10 BETA spaces left. Sign up here.
I've also had a load of feedback already, so got lots of ideas on how to improve it in the BETA period. 🙌Andrew Charlton