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.
Here are my blogs that fall into the SEO reporting category.
A simple Google Sheets template for comparing PPC and organic keyword data, helping SEO and paid teams uncover insights around rankings and conversions.
A summary of a BrightonSEO talk on using fantasy football statistics as inspiration for building more insightful and flexible SEO reporting frameworks.
An exploration of how Fantasy Premier League data and pivot tables can inspire creative approaches to SEO reporting.
A practical look inside Baidu Analytics and the built-in SEO tools available for analysing performance in the Chinese search ecosystem.
A practical template for measuring SEO ROI by combining traffic, conversion and revenue data to better communicate the commercial impact of organic search.
Written in early 2020 amid the first covid lockdowns, a look at how SEO reporting can help diagnose performance issues.