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 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

Post of the Week




Processes & Frameworks


My Products 💡