Post of the Week
Sponsored Link
Insights made easy
Visualize your data in a way that is actionable, not overwhelming.
ContentKing makes your data manageable, so you can spend less time analyzing and more time optimizing. In fact, teams using ContentKing report a 30-50% reduction in time spent on auditing!
News
Introducing site names on Google Search
Interesting update from Google. They're introducing site names in mobile search results, and have provided guidance on how to use structured data to indicate your preferred site name.
Tech
Using Blended Data to Add Annotations onto Time Series in Google Looker (Data) Studio
Ahhh annotations in Data Studio (Looker Studio 😅). What an awesome solution by Chris Green 👏
How the Guardian approaches quote extraction with NLP
This isn't relevant to SEO but I thought it would be interesting to feature (as ML can be used in SEO in a broader sense). A fascinating way the Guardian data science team is approaching quote extraction with NLP.
Case Study
25 Best Examples Of Effective FAQ Pages
It's great to see examples of others doing good things. It's even better when someone else finds those examples. Lee Wilson has done just that, with 25 examples of effective FAQ pages.
Processes & Frameworks
The SEO Customer Funnel: KPIs & SEO Metrics Worth Monitoring
Awesome article Tory Gray and Sam Torres. They cover SEO metrics across each of the stages of the funnel and there's also some brilliant expert commentary. 🔥
How to Write Effective SEO Tickets
Adam pretty much has a weekly feature on here now as his content is so good.
This one is so, so useful! He shares a 6-step process to write SEO tickets/user stories for a new SEO project. 💡
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.
Keywords in Sheets (BETA): new $1 trial.
Try Keywords in Sheets for 7 days and get 500 credits for $1.
This includes:
- 500 search results (max.)
- 3,000 search volume keywords (max.)
- 2,000 related keywords (max.)
Hi there 👋,
Last week I finally got to release Keywords in Sheets $1 trial, new pricing and flexible credits. For a non-developer like me who's learning on the job, this has taken so long to implement!
(and actually when I pushed it live, there was a bug that affected 3,000+ users for days. DOH. 🤦♂️)
It now means I can carry on creating new functions and free tools - some of which are hopefully being released this week (including rank tracking in Sheets). 🙌
My Post of the Week is from Rand. He has talked frequently about 'hard-to-measure' channels and how business leaders typically refuse to invest in them because it's difficult to determine ROI. In this article he describes a framework for approximately measuring uplifts across the marketing funnel. There's also a detailed step-by-step guide on fitting the specifics into your organisation, which I think is pretty cool too!
As most channels become increasingly 'hard-to-measure' as analytics platforms make them so, I think Rand is ahead of the curve here. You ought to think about this stuff and build it into your thinking going-forward - there'll likely be a time in the near future you'll need to get buy-in on this activity.
Until next week!
Andrew Charlton