Many of our clients are worried about managing their current link profile as having a bad backlink profile can lead to Google penalties, either manually or from Google algorithm updates such as Penguin. Managing a link profile is a simple and standard business risk assessment, and it should be managed weekly by every webmaster in order to ensure that their rankings do not slip.

Here at Blueclaw, we use several external software and collate this data into our own toolkit in order to manage our client’s profile quickly and effectively.

We use a variety of sites to pull this data due to the size of some of our client’s link profiles, however the majority of the website would be fine using Majestic and Google Search Console to quickly check for links which may have been removed or added to your disavow file.

For anyone wondering how to use Majestic for this process, we’ve included the step by step to checking for new links here.

Type in your domain in the Majestic Site Explorer Results bar under the option ‘Root Domain’ and select the ‘New’ tab.

This will return data from the last three months, thereby showing the latest links acquired.

Select the links which were acquired in the previous week (or from whenever your last check was done) and download the data into Excel.

This brings up an Excel sheet looking something like this:

To speed up the process, we can use some keyboard shortcuts.

Click on Column A and then use Control + F to find and replace data quickly.

We can now filter the results down to root domains and subfolders; simply ‘replace all’ http://, https:// and www. with nothing to remove these from the database.

Remove the sub folders by clicking on Column A and using Control F. Replace /* with nothing to remove everything after the domain.

Using this command will remove any of the sub folder pages, allowing us to look and disavow at the domain level.

Now that we are just left with the root domain, all we need to do is de-duplicate Column A. Highlight Column A and click Remove Duplicates.

Tick Continue with the current selection when Excel’s warning pops up.

Excel will return the following spreadsheet:

Column A now only shows unique referring domains from the last week, meaning we can quickly assess the domains and if needed, add any new potentially threatening domains to your disavow file.