Python SEO Script: Top Keyword Opportunities Within Striking Distance

Diagram of five underused ecommerce schema types: BreadcrumbList, Review and AggregateRating, VideoObject, richer Offer details, and vertical types for classifieds.

Top 5 Underutilized Schema Markups for E-commerce & Classifieds Websites

Learn what the 5 most underutilized markup schemes are and why you should apply them to…
Learn More
Diagram showing how to define redirects at scale: inputs, matching logic, a redirect map, and a QA gate before launch.

Migration nightmare: how to define redirects at scale? - Antoine Eripret

If you’ve been working in SEO for some times already, you must be familiar with web…
Learn More
Grid of six Google Sheets formulas SEOs use, VLOOKUP, REGEXEXTRACT, IMPORTXML, QUERY, SUBSTITUTE, and SPLIT, each with its purpose.

11 Google Sheets formulas SEOs should know

Sometimes the best SEO tools are free. Learn how to use these formulas to save time…
Learn More
The SEO skills maturity matrix as a colored grid of six disciplines against four capability levels from aware to leading, with the L2 to L3 hiring jump marked.

The SEO Skills Maturity Matrix

Charting a course for SEO careers (both agency & in-house)
Learn More
Diagram showing how running the Screaming Frog SEO Spider on a cloud virtual machine removes laptop RAM and uptime limits, with database storage mode, a headless command line example, and VM sizing tiers by crawl size.

How to Run the Screaming Frog SEO Spider in the Cloud

Our latest guide looks at running the Screaming Frog SEO Spider in the cloud using Google…
Learn More
Two panel graphic contrasting spreadsheet row and cell caps of 1,048,576 and 10 million with the four core SQL verbs SELECT, WHERE, GROUP BY, and JOIN that handle most SEO analysis.

Antoine Eripret on Twitter

“📈 SQL for SEO 📈 Since I joined my current employer, I've been using extensively SQL…
Learn More

Get new blog posts by email: