Comparing PPC & Organic Keyword Data: A Google Sheet Template
A simple Google Sheets template for comparing PPC and organic keyword data, helping SEO and paid teams uncover insights around rankings and conversions.
SEO Reporting
Here are my blogs that fall into the SEO reporting category.
BrightonSEO Autumn 2021 Talk/Fantasy Football SEO Reporting Update
A summary of a BrightonSEO talk on using fantasy football statistics as inspiration for building more insightful and flexible SEO reporting frameworks.
Using Fantasy Football Stats for SEO Reporting
An exploration of how Fantasy Premier League data and pivot tables can inspire creative approaches to SEO reporting.
Exploring the Baidu Analytics Built-In SEO Tools
A practical look inside Baidu Analytics and the built-in SEO tools available for analysing performance in the Chinese search ecosystem.
Measuring SEO ROI: A Google Sheet Reporting Template
A practical template for measuring SEO ROI by combining traffic, conversion and revenue data to better communicate the commercial impact of organic search.
SEO Reporting Tips for When the World Goes Wrong
Written in early 2020 amid the first covid lockdowns, a look at how SEO reporting can help diagnose performance issues.