Comparing PPC & Organic Keyword Data: A Google Sheet Template

I’ve had a few instances in recent years where I’ve had to work closely with paid search teams to optimise processes and resources in chasing after particular keywords with a view to respective organic and paid success. This has come more quickly to the fray at in-house roles in smaller, non-enterprise businesses where marketing teams … Read more

BrightonSEO Autumn 2021 Talk/Fantasy Football SEO Reporting Update

I was recently lucky enough to be asked to speak at BrightonSEO’s fringe event MeasureFest this past September where I manifested my recent blog post on Fantasy Football stats for SEO reporting into something hopefully a little actionable. The talk, which was both in-person and online (indeed the first in-person BrightonSEO event since before covid … Read more

Using Fantasy Football Stats for SEO Reporting

On-off lockdowns throughout the 2020/2021 Premier League season allowed myself, like many others, more time on their hands than usual. While I tried to use the time productively where possible, this certainly wasn’t in a wholly consistent and logical manner. When the Premier League season kicked off again in September amidst rising coronavirus cases in … Read more

Exploring the Baidu Analytics Built-In SEO Tools

Baidu Analytics is a funny old tool. So is Baidu Webmaster Tools for that matter, though perhaps I’ll address that another time. For this post, I’m going to delve into some of the somewhat bizarre built-in SEO tools that exist within the Baidu Analytics (or Baidu Tongji/百度统计) suite. Are they helpful and insightful? To an … Read more

Measuring SEO ROI: A Google Sheet Reporting Template

Accurately measuring SEO ROI is arguably one of the more challenging aspects of the role. Reporting back on positive stories such as growth in organic traffic, keyword rankings and overall improvement in search visibility is often the go-to for SEO specialists justifying their existence. However, this alone won’t fly in the eyes of many stakeholders … Read more