Post of the Week
Sponsored Link
24/7 Monitoring with ContentKing
Search engines are constantly crawling your site, and you need an SEO platform that can do the same. That's where 24/7 ContentKing Monitoringâ„¢ comes in.
Teams using ContentKing were 3x more likely to say it's becoming much easier to detect incidents than non-ContentKing users.
News
Turn insights into ROI with Google Analytics
Big news! Google is moving the Universal Analytics 360 properties’ sunset date from October 1, 2023 to July 1, 2024
Content
The Future of AI in Content Marketing Survey
Is artificial intelligence the future of content marketing? Have your say in the Future of AI in Content Marketing survey from Aira and Verblio. 💡
Tech
Crawl efficacy: How to level up crawl optimization
This is a fantastic article by Jes Scholz on crawl optimisation. She starts with:
"Crawl budget is a vanity metric. Your goal should be to guide Googlebot in crawling important URLs fast once they are published or updated."
And provides a better way to implement and report on crawl on optimisation.
Processes & Frameworks
The Biggest Threat to SEO w/ AJ Kohn
AJ Kohn is one of my favourite SEOs. If you haven't visited his blog, you really ought to! In this conversation he's being interviewed by Ross Hudgens, CEO of Siege Media, and talks about everything from the threat to SEO to A/B testing and quantifying the impact of SEO for clients.
Tools
Mapping the Keywords to Your Website (for SEO)
This is pretty neat from Chris Green. His trusty keyword mapping spreadsheet. Super simple and effective - the best types of spreadsheets!
The Typing of the RegEX [Game]
Love this from Chris Johnson. He's made learning RegEX fun. I'll repeat, he's made learning RegEX fun! 🔥
My Products 💡
Forecasting For SEO (Video Course)
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.
4 new utility scripts to make your life easier in Google Sheets.
Keywords in Sheets is releasing free scripts almost every week. Here's 4 of our latest:
1. Transform a range with comma-separated values into a column
2. Group a range of URLs by domain
Hi there 👋,
Well, well, well, what a surprise...Google has delayed the sunsetting of Universal Analytics 360 to 2024 (called it!). I wonder what this means for Universal Analytics generally...my gut still says there's an inevitable delay coming. GA4 just doesn't feel ready. 🤔
I've been head down building new free tools every week to make Keywords in Sheets bigger and better. Last week I released 4 new 'utility' scripts that will make your life easier in Google Sheets. They're entirely open source, so you can either take/adapt the code yourself, or download our free add-on and use them in there.
Here are the new functions:
1. Transform a range with comma-separated values into a column
2. Group a range of URLs by domain
3. Extract the domain from a URL
4. Extract subfolders from URLs
And finally, my Post of the week is an awesome study from Semrush. They took an anonymous sample of 20,000 users from Clickstream data and analysed over 600,000 search actions.
There's some super interesting stuff in there, such as they found almost 30% of people are either refining or extending their searches in some way, and that the vast majority of people jump from the main search to an Image search. 🔥
Until next week!
P.s Crawl Consultancy, my SEO consultancy, has a rare opening in December for companies looking for an SEO Roadmap.
Andrew Charlton