SEO Excel Tool: website linking metrics

We are always looking for ways in which we can save time and streamline processes.  With this in mind, we have created a nifty little tool that aids our link building process. The tool helps to ensure that we spend our time targeting the best possible prospects.

 

What Is The Tool?

The tool fundamentally helps to separate the wheat from the chaff, sorting the higher quality sites/blogs from those which are not so great; expediating our link building process by making targeting more focused and, in theory, more successful!

The tool comes in the form of an Excel spreadsheet and uses Niel's SEO Tools For Excel Plugin, which is great for gathering large amounts of data from a website quickly. Once we have a list of URL’s for potential sites we then dump all of the URL’s into the tool and let it do the hard work for us.

The tool uses APIs to bring back metrics such as - the age of the site, how many pages on the site have been indexed by Google, social interaction and the sites’ page rank.

As a result of this process, we then have a list of the top sites we want to target and can disregard the ones we don’t want based on the metrics returned, which allow us to make judgement on the quality of the site and whether or not it is an opportunity worth pursuing.

Due to the large amount of API’s, this process can take a little bit of time and does take a bit of patience – worth putting the kettle on whilst it’s doing it’s stuff!

 

What We Use The Tool For

We use the tool in conjunction with Dan Callis’s method for identifying guest posting opportunities through Blogger Link Up.

Dan’s recent blog post on How to get Value and Great Prospects Fast from Blogger Link Up, is a must read for those who use Blogger Link Up to source opportunities and are looking for ways to save time.  Dan has added our tool as an addition to his process and our Senior SEO Isaac, also further explains how our tool is put into action within this post.

This tool is designed to be versatile and can also be used for wider link building efforts.

To download a copy of this tool click here or please feel free to email us to find out more [email protected].

Related Posts

A marketer’s guide to mobile-first indexing

In Google’s ever-continuing efforts to follow user trends and make the web more mobile friendly, mobile-first indexing was rolled out. Read this guide to find out what it is and how you can use it to it’s best ability for marketing and website success.


6 months ago

The step-by-step guide on how to prepare for Google's Page Experience update

Having good user experience (UX) is something every webmaster should strive for. With Google's Page Experience update rolling out in May 2021, we’ve outlined what this is and how you can prepare for it.


7 months ago

Fine-tune your content in 2021 with these SEO tips and trends

As we take our first steps into 2021, now’s the time to identify the most effective ways to use content to connect your business with its audiences. Not only will this help you get ahead of the competition, but after a curveball year in 2020, it’ll ensure you’re on the right track if your audiences’ behaviours online have changed at all.


8 months ago

Inside Screaming Frog: Top Takeaways From The Workshop

Ensuring that your URLs can be crawled and indexed is a cornerstone of SEO. If Google can’t find that lovely content you want to get in front of your customers, what’s the point in writing it, right?


2 years ago

Our top takeaways from BrightonSEO

The SEO linking metrics tool for Excel has been created to help you sort the wheat from the chaff, helping you to quickly identify the best link prospects.


3 years ago

Google changes affecting local queries

As Google continuously updates in order to keep up with our ever-changing world of tech, we ask, what are the recent changes affecting local queries?


3 years ago

Drag