Hi there ,
A bit of an AI themed issue today! Firstly, I’m super excited to announce I’m Co-Founding an AI product of my own; Formula God.
Using artificial intelligence, Formula God helps you do everything you need in Google Sheets with one single formula.
It’s not an SEO product, but it’s certainly going to help you with analysing SEO data in Sheets! I’ve been experimenting and using it for the past month and I’d struggle to go back to most standard formulas.
You use it by ‘talking to Sheets’. eg. “Extract the subfolder from each URL in Column 1”, or “Sum the values”, or “calculate the percentage difference from column 1 to column 2”). Check out my tweet with some examples.
My Post of the Week is also all about AI! Mike King has written an awesome article on “why AI content is not the SEO threat they want you to think it is“.
And I agree! His argument is that AI can beneficial to SEO when you’re smart about it, despite what Google’s policies say (and they’ve since clarified this, saying not all AI content is bad).
He also goes in deep on what large language models are, the challenges with them and which of them are good for SEO. A must read
Post of the Week
When your website suffers from a technical problem or an unexpected content change and you don’t react in time, you risk giving your search engine positions away to your competitors.
ContentKing keeps an eye on your site at all times and sends real-time alerts whenever something happens, so you have the opportunity to fix the problem before your rankings are impacted.
Crikey, an interesting one! Hackers conducted a black hat optimisation campaign at scale, hacking 15,000 sites and redirecting them to fake Q&A forums.
Love this experiment from Ziemek Bućko and the team at Onely.
They found that Googlebot needed 9x more time to crawl JS pages than HTML pages
Great thread and analysis by Alexis Rylko on the types of website impacted by the October 2022 Spam Update.
Processes & Frameworks
This is great from Cyrus Shepard
A cheat sheet with seven days of actions to check the SEO health of your site.
This was some great reading from Adam Gent! He shows how your SEO strategy needs to adapt with shipping frequency, alongside numerous examples of his past projects to back it up!
Sticking with the AI theme, Glenn Gabe has put together a list of AI content detection tools and how they work
You can now migrate your Universal Analytics audience over to GA4 using the Google Sheets Add-on released by Google.
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.
Do keyword research, competitor research and more, all inside Google Sheets.
It includes 5 PRO functions
- Search Volume – Get search volume for 1000s of keywords across any location, in seconds.
- Related Keywords – Get 1,000s of related keywords for a seed keyword.
- Competitor Keywords – Get all of the keywords competitors are ranking for.
- Search Results – Get search results across multiple countries and languages.
- Questions – Get 1,000s of question keywords for a seed keyword. And 6 FREE functions: Status Code Checker, Redirect Checker, Local Keywords, Link Checker & XML Sitemap.