Post of the Week
Level up Google Data Studio Reporting with ContentKing
Let's be real, no one really likes jumping through all the hoops of getting data together for monthly stakeholder and client reports. That's why it's great to see Google's helping out with the tedious reporting process through Data Studio. Now, to make life even easier, ContentKing just rolled out a massive update to their Google Data Studio connector.
Among other things, it allows you to:
- Pull in reported SEO issues.
- See how these issues progressed over time.
- Easily slice & dice your data based on any page property (for example indexability and status codes).
- See your pages' Lighthouse scores at a glance.
- Seamlessly switch all the sites in your account.
No need to build the report yourself — ContentKing has already done that for you!
Competitive SEO URL Analysis with Python
A fantastic script from Greg Bernhardt, with info on how to match your URLs with your competitors' to see any differences in page titles and keyword rankings and more. He's also built an app on Streamlit.
12 Experiments for Tabbed Content SEO
I love experiments like this! Ryan Siddle compares 12 experiments for tabbed content with his results from 2018.
Google’s July 2021 Broad Core Update – Rapid-fire Insights From The Summer of Two Core Algorithm Updates
As usual, a fantastic in-depth overview of the most recent core algorithm updates by Glenn Gabe.
Processes & Frameworks
User perception, organic search, and algorithm updates
This is a great growth memo from Kevin Indig as he makes the case that UX & design play a significant role in user perception, which ultimately impacts rankings. Several great case studies in here too!
Site Architecture: How To Build A Website That Ranks And Converts
Pretty solid intro into site architecture from the team at Onely 🔥
Google’s Inverted Index of the Web
An awesome read from Bill Slawski as always! Get some insight into the basics of Google's web indexing.
My Products 💡
Forecasting For SEO (Video Course)
Join over 200+ 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.
Wayback Machine in Sheets
Get old webpages for any domain from Wayback Machine in Google Sheets. 🚀
Hi there 👋,
Well isn't this is a late issue! Apologies, I'm taking a short vacation in the middle of nowhere and it's been a challenge to get online 😬😅
Anyways, better late than never! I've focused on July's core algorithm update in this issue with two outstanding pieces of research from Lily Ray and Glenn Gabe. Lily Ray and team collected Sistrix Visibility Index scores of over 2,300 domains within its U.S index and used that to support their analysis. It's super useful and has made my Post of the Week! 🔥
Until next week!Andrew Charlton