Building a dynamic SEO dashboard in Looker Studio
How to blend Search Console, Analytics, a Screaming Frog crawl and rankings in one Looker Studio dashboard. From my SEO Campus Paris 2022 talk.
Julie Chodorge
Log analysis: the 6 decisive SEO criteria
A study of 7 million Googlebot hits on 12 websites: how word count, load time, depth, internal links, backlinks and rankings influence crawling.
Excel basics for SEO: CONCATENATE, VLOOKUP and pivot tables
Three Excel functions that handle most crawl and rankings exports: CONCATENATE to rebuild URLs, VLOOKUP to merge sources, pivot tables to summarise.