Tech
SEO Analytics in SQL for Beginners: A step-by-step tutorial
Trevor Fox shares his experience of using SQL for SEO analytics, which he finds more efficient, scalable, and less prone to errors than using a spreadsheet. He also mentions that Google Search Console data can now be imported into Google BigQuery, and shares some tips and tricks for beginners to run SQL queries for their keyword data. 🙌
Processes & Frameworks
The Current State of Google PageRank & How It Evolved
Want to know more about PageRank? The article by Patrick Stox explains that PageRank is a Google algorithm that measures a page's importance using links as votes. PageRank considers more links as a sign of importance, making it similar to the impact factor metric used by journals. This method, along with content, improved Google's search results and made links the currency of the web.
Marketplace SEO: 5 Pillars for Long-Term Success
Brodie Clark's article highlights the lack of high-quality Marketplace SEO guides and, given his wealth of experience in this area, provides an outline of the top 5 tips for SEOs. The guide covers topics such as user-generated content, localised content strategy, and informational content, with includes examples of online marketplaces. 🔥
How Search Works [Slides]
Another one by Patrick Stox as he smashes this presentation on an advanced look at what we know about a lot of Google's systems.
How to find your real SEO competitors
In this awesome article by Lidia Infante, she stresses the need to accurately identify competitors for effective SEO strategy. She suggests using data-led methods from manual analysis, bottom-up and top-down analysis, with features from many competitor research tools. 👏
ChatGPT (and other AI bots) as SEO Companions: How to leverage them through the SEO Process [Slides]
Wow, what an amazing deck by Aleyda Solis. It shows you the various ways you can integrate ChatGPT and other AI bots into your SEO processes. 👀
My Products 💡
Forecasting For SEO (Video Course)
Join over 400+ 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): Power your SEO in Google Sheets
Do keyword research, competitor research and more, all inside Google Sheets. It includes 5 PRO functions 👇
- Search Volume - Get search volume for 1000s of keywords across any location, in seconds.
- Related Keywords - Get 1,000s of related keywords for a seed keyword.
- Competitor Keywords - Get all of the keywords competitors are ranking for. Search Results - Get search results across multiple countries and languages.
- Questions - Get 1,000s of question keywords for a seed keyword. And 6 FREE functions: Status Code Checker, Redirect Checker, Local Keywords, Link Checker & XML Sitemap.
Hi there 👋,
Some awesome articles in the last two weeks. In this edition we've got some techy brilliance from Trevor Fox showing you step-by-step on how to create a database, import Semrush data into it, and query it using SQL (using examples). In addition to that we talk about how search works, the history of PageRank, and an amazing deck by Aleyda Solis showing you how to embed AI bots into your SEO processes.
Our Post of the Week is by Alex Johnson and Tory Gray. I stumbled upon their new, fantastic templates over the last week and I think you'll love them. They've created a keyword matrix and content planning template using Airtable - a powerful spreadsheet-database hybrid tool that'll streamline your content production and help you stay on top of your SEO strategy. They're letting you download the template and use it as a starting point for your projects. While it's currently mortgage lender-focused, you can easily adapt it to fit your needs. 🔥
Until next week!
Andrew Charlton