Post of the Week
Case Study: How publisher Future avoids losing thousands of dollars per day across 200 sites
Future is the publisher behind over 200 brands, reaching more than 390 million people across the globe. With 2,000+ employees, the amount of changes across all of their sites is mind-boggling. Any issue or unwanted change has a direct impact on their bottom line. So they built a moat around it with ContentKing.
Simon Glanville, Head of SEO at Future: "If the errors ContentKing alerted us about had gone undetected, we could be looking at losing thousands of dollars. Daily."
Brand Sentiment Analysis in BigQuery ML
This is next level awesomeness. Some of the things JR Oakes does blows my tiny mind 🤯
After some clever use of BigQuery ML, he ultimately ends up with a Data Studio dashboard that tracks Apples brand sentiment over time using PAAs. Amazing stuff.
Processes & Frameworks
Maximize every click with search journeys
"The solution is to anticipate the users’ next step in their search journey. Every search is a journey that brings users from problem realization to solution. " - Kevin Indig 🔥
Deep Insight: SEO leader Orit Mutznik on eCommerce SEO, automation, and the future of search
Loved this interview with the mega talented Orit Mutznik. Some great questions from deepcrawl, which resulted in some very insightful answers! 👏
SEO is Hard
Across the A/B tests SearchPilot has published, on average only 35% of respondents guessed the right answer. SEO is hard. Will Critchlow eloquently describes why that is and what you can do about it.
The Ultimate SEO Glossary: Basic Terms You Should Know
A very comprehensive SEO glossary from the team at Serpstat 💡
Non-branded & Branded Traffic
A neat free tool from SiteGuru to segment brand and non-brand Search Console data and present it in a user-friendly report.
GSC Query Analysis Tool
Wow, this is great from Greg Bernhardt. Import your GSC keyword data and label intent, entities and count keyword frequency 🔥
My Products 💡
Forecasting For SEO (Video Course)
Join over 180+ 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 👋
Rarely do I feature any of my own stuff as my Post of the Week (because that would be pretty biased, right?) but today I'm making an exception for Keywords in Sheets because I'm pretty proud of it! 😅
It houses all of the Google Sheets scripts & templates I've been building in the last month or so, and I'm adding to it fairly regularly! 🚀
In addition to that, there are some fantastic articles in this issue. One that jumped out at me was "SEO is Hard" by Will Critchlow. The thing I've learned about SEO is that your intuition is often wrong, and subtle, seemingly positive changes can have the opposite effect.
What do you think?
Until next week!Andrew Charlton