Sponsored Link
Experiencing chaos while working across multiple teams and sites?
ContentKing provides a real-time command center to power workflows across your organization.
Whether you're working on one site or across multiple sites, you'll have a single unified overview of your SEO performance accessible by anyone on your team. Keep everyone in sync with content changes, site updates, and any issues that occur in the process.
News
Spring cleaning: some sitemap extension tags are going away
Google has decided to officially deprecate some tags from sitemap extensions. See what they are!
What creators should know about Google's helpful content update
Some advice from Google on the helpful content update this week. "Avoid creating content for search engines first"..."Focus on people-first content". 🔎
Content
How to Build a Topic Cluster in 10 Minutes
Super content from Jake Sheridan (who is definitely worth following on Twitter) on how to build a topic cluster in 10 minutes. A huge 12,000 word guide, with examples 🔥
Tech
React SEO: Best Practices to Make It SEO-Friendly
A great article on React SEO by Sam Underwood. Everything you need to know from what React is, how to detect the library and many common issues with solutions! 💡
Processes & Frameworks
Google Sheets For SEO [Slides]
186 slides for Google Sheets of SEO goodies by Tom Pool. He walks you through various functions to take care of common SEO tasks, as well as tracking spreadsheet views in GA (which I had no idea you could do!) 🔥
6 Best Niches for Affiliate Marketing in 2022 (Profitable and Uncompetitive)
Great article by Joshua Hardwick on 6 best niches for affiliate marketing, and also the process he used to find them (using Ahref's Content Explorer) 👏
Tools
Awesome SEO & Digital Marketing Tools Made In Ukraine
Alexis Rylko has collated an excellent list of Ukrainian SEO tools 👏👏👏
Google Analytics 4 SEO Data Studio Dashboard
Christina LeVasseur has developed an awesome GA4 Data Studio dashboard. It should hopefully make that GA4 migration a little easier 😅
Connecting Search Console to Data Studio
A Google guide to bring your Search Console data into Google Data Studio. Some great tips in here 🙌
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 👋,
Thanks for all of your support in 2022. It's been a pleasure curating and writing the newsletter every week (now on 205 editions!). A big thank you to all of the SEOs who continue to produce amazing content and share their knowledge on regular basis - you make it easy for me to put this together.
This issue is a wrap up of 2022 - our most clicked links!
I hope you enjoy and have a lovely New Year 🎉
Until next year!
Andrew Charlton