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
Google helpful content system update rolling out now (December 2022 update)
Google has begun to push out an update to its helpful content system. This global update is aimed at detecting more forms of low-quality content created for search engines and not for people, which will improve the quality of content seen in search results. The rollout of the update is expected to take up to two weeks to complete.
Content
Collaborative Creative Writing with OpenAI’s ChatGPT
This is super interesting for creative writing. Andrew Mayne bounces ideas off ChatGPT to plot a science fiction story together. Neat! 👏
Tech
Marketing Mix Modeling (MMM) Tutorial in Google Spreadsheets
Marketing Mix Modeling (MMM) is a technique that helps businesses optimize their advertising spend by providing insight into the amount of sales contribution each marketing channel makes. Recast has created a free template using Google Sheets' LINEST function to help businesses understand how to use MMM in their own analysis. The template can be accessed here.
Case Study
How Monday.com Wrote 1,000 Articles in 12 Months (and then IPO'd)
Monday.com saw a 1,570% increase in organic traffic in the first three months after heavily investing in content production. The team wrote 1,000 articles in 12 months and now receives more than 1 million monthly visitors. Well done to Brad and his team 🙌
Processes & Frameworks
How to use the ICE framework to prioritise technical tickets for SEO
You may have heard of it, but the ICE framework by Dan at Novos is a game-changer for prioritising technical SEO tickets!
It scores tickets on impact, confidence, and effort to determine prioritisation.
Super helpful for identifying the tasks that will have the biggest impact. 🚀
Tools
How to do log file analysis with Search Console data
Alice Roussel has created a great template to help you analyse crawl stats data in Looker Studio. This is an awesome resource if you want to get more out of the crawl stats report and understand how Googlebot is crawling your site. The template makes it easy to see important information at a glance, so you can make informed decisions about your site. 🔥
My Products 💡
Forecasting For SEO (Video Course)
Join over 400+ 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.
Keywords in Sheets (BETA): Power your SEO in Google Sheets
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.
Hi there 👋,
Google began to push out an update to its helpful content system last week with some new signals, while extending its reach globally across all languages. I do wonder if it was planned or reactive to the huge audience chatGPT has pulled in - and - what will now mean the proliferation of auto-generated content.
Speaking of AI, The TensorFlow team from Google, has made ML accessible in Google Sheets with their new Simple ML for Sheets add-on.
See how Cyrus used it to identify over/under-performing URLs using Google Search Console data, or checkout their tutorials. It looks ace!
Until next week!
Andrew Charlton