Data Analysis

Estimating SEO Traffic for a Keyword Set

Estimating your organic traffic will allow you better assess your current performance for a set of keywords, but also allows you to directly compare that performance with your competitors. In this video, I run through how to properly set up your data and run the formula across a set of categorised keywords. This will be …

Estimating SEO Traffic for a Keyword Set Read More »

Categorise GSC Data into Site Sections in Data Studio

I’ve finally started playing in Google Data Studio, and obviously kicking off by messing around with my Search Console data. One of the initial things I wanted to do was categorise the landing page data into site sections, like I normally do in Google Sheets. Thought you would need to create a reference table of …

Categorise GSC Data into Site Sections in Data Studio Read More »

Building a Keyword Research Dashboard in Excel

An extremely large table of all their keywords, isn’t going to give the insight some clients would want. Some would like more a bit more insight into the data they’ve paid thousands for. Building a keyword research dashboard in Excel is a great way to allow a client to interact with their keyword data. In …

Building a Keyword Research Dashboard in Excel Read More »

Scroll to Top