SEO Metric Amalgamation Sheet
Compare key SEO metrics against one another to better understand upper level opportunities / gaps – between word count and query count, internal / external links and more!
Posted by Daniel Foley Carter
SEO is so much more than just “face value metrics” I think I’ve made that clear in many of my LinkedIn posts over the years.
But – there is a key part of SEO that invovles decision making by comparing metrics and then looking for opportunities away from more complex items such as content topical association and alignment, BTF (brand trust factors) and more.
We can still whittle back to the basics – looking at the relationship between page content volume and query performance (counts), looking at how pages are supported by internal and external links etc.
So, I decided to put together a SUPER SIMPLE sheet that you can export your data in to for a consolidation analysis.
👉 Download the sheet here
You can access the sheet here – you’ll need to make a copy of it so you can edit it –
https://docs.google.com/spreadsheets/d/1D8SE5BqAPI5tWBesa8Hb22PR411L4DQuxYmTgKfQjb0/edit#gid=0
How do we fill / use the sheet?
Watch our quick video on how to utilise the sheet. It’s fairly straightforward – you need to make a copy of the SEO metric sheet for comparison purposes. You can then sequentially fill each tab and it’ll populate the main MASTERSHEET tab which combines key metrics together for analysis.
It should take no longer than a few minutes to do – although you’ll need to crawl your website with ScreamingFrog’s SEO spider – which, could take time depending on the volume of URLS your website has.
How do I Interpret Metrics?
The first thing to note is that we want to understand the relationship between the AMOUNT OF CONTENT we have and the AMOUNT OF TIMES a page generated an impression vs the AMOUNT OF QUERIES that yielded those impressions.
Typically – You’ll want to look for gaps where there’s a HIGH > LOW proportionality – i.e. LOTS of content (high word count) and a low volume of queries or vice versa.
Lots of content i.e. 3000 words and a low query count could be an indicator of “LACK OF VALUE” – but, you should cross check these against – how old is the page i.e. the page might have a low query count if its young – therefore you would ignore – if a page however is 300+ days old and it has 3000 words of content and a low query count i.e. 100 – then it’s clear the page LACKS value.
Our Clients Have Included
