Measurefest “Data Visualisation for SEO professionals” talk on Brighton SEO

Would you like to know why data visualisation is important and how you can create great visualisations for keyword rankings and organic search performance in PowerBI and Google Data Studio?

Find my slides here:

You can connect with me on Twitter or LinkedIn.


Google Data Studio

Copy from

You will find:

1. actionable keyword research from a Google sheet

2. Pixel rankings from a Google Sheet.

3. Google Search Console — custom fields.

Caution: You have to edit the custom field “branded” and “landing page group” in order to make this work as well as connect to the correct search console views.

You can’t edit the custom fields in the blended data though! So you need tochange this in the Google Search Console source datasets.


A python script in Google Colab:

This will look up result types and pixels for a list of keywords.

You need to have a account with API credits to use this. (You can get $1 dollar API credits free if you sign up).



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store