How To Find All Active Inbound Links To A Website For Effective Link Cleanup
Picture this sad story: A non-tech savvy company hired an SEO firm to provide services. Without telling the site owner, the firm did the least amount of work that would garner the most results. What was provided was an SEO dis-service as the site is now plagued by boatloads of spammy links. This happens all the time - and it sucks for us reputable companies.
When plagued with this problem, our first course of action every time is to try and remove the "work" of the corrupt company - may times at 4-5x of the original cost. While this is a tough gig, it is the best method hands down. One of the issues surrounding this is finding out exactly which links are still active. The standard footprint of an SEO hack is that many of the sites and pages where links were "built" don't even exist anymore. We've come up with a solution that allows you to mix Google Webmaster Tools data with Screaming Frog SEO (pro) to quickly display all of the inbound links to your site.
Why Webmaster Tools? Well, we love Majestic SEO and Open Site Explorer, but Google WMT shows more results -- and the results are coming directly from the horse's mouth. The only issue is the over-reporting of Google.
Here's how to fix this and only display the active inbound links:
Run "Sample Links" Report
To do this, simply login to Webmaster Tools then head to Traffic -> Links To Your Site. You'll see the following:
Download the report.
Check .CSV & Convert to .TXT
Open up the report and view it in Excel. You should see all the URIs of the inbound links:
Save the spreadsheet as a .txt file.
Import into Screaming Frog
Once converted to .txt open up Screaming Frog and choose Mode -> List. Then click on Upload File:
Now hit start and let Screaming Frog do its magic. You'll begin seeing data on the various links that were uploaded:
Add Custom Filter
So we've now run all of Google's data into Screaming Frog. Great. It's time to start cleaning it up to ensure that the links are actually active. To do this, we want to search the source of the HTML pages for our sitename. To do this head to Configuration -> Custom:
In one of the filters, you'll want to add your domain and hit OK.
Save The Results
To see the custom filtered data, you'll need to head to the Custom tab on the far right:
Then you'll want to select the filter option where the site information was added to. For us, we used Filter 1. Then choose "Export."
View Results & Get To Work!
You'll now have a list of all links from Google Webmaster Tools that is cleaned and filtered to be only the active links:
You can now target these sites (and specific pages) for link removal if you've been tasked with a link cleanup gig.
If you liked this please follow us on Twitter, Instagram, Facebook & Google+ for more Search Knowledge. Still need help? Leave a comment below or fire us a message.
Meet the Author
Greg Finn
Greg is the Head of Performance and Innovation for Cypress North's digital marketing team and one of the founders of our agency. In 2010, he and Matt Mombrea started Cypress North in Buffalo. Greg oversaw the opening of our second office in 2022, located in his hometown of Rochester.
As Head of Performance and Innovation, Greg co-manages our digital marketing department and works closely with our team to ensure all our clients achieve the best possible results. He is always looking for ways to test new digital marketing techniques and technology, and oversees all teaching and training efforts to ensure our agency stays ahead of the curve.
Greg is also a co-host of our weekly Marketing O'Clock podcast, where he and the team provide updates, insights, and hot takes on the latest SEO, PPC, and social media marketing news. In addition to weekly news shows, Greg hosts our Marketing O'Torial digital marketing tutorials and often co-hosts bonus Marketing O'Talk episodes that bring together panels of digital marketing experts.
With nearly two decades of experience, Greg is a known and trusted voice in the digital marketing community. He’s a contributor for Search Engine Land, a member of the Search Marketing Expo (SMX) programming team, and has been a featured speaker at some of the largest search engine conferences, including SMX, eSummit, and Pubcon.
When he’s not working or staying updated on the latest trends, Greg enjoys watching his kids play sports and coaching their soccer team. He’s been named the runner-up “Greg of the Year” on Marketing O’Clock’s annual Clockscars Awards four years in a row. While the coveted award has evaded him for many years, Keanu Reeves has not. Greg once saw him at Gabriel's Gate tavern in Buffalo (and noted he was very tall.)
Related Resources
3 Options for Multilingual Website Translation
Managing multilingual web content is challenging, and there are plenty of options available. Learn more about the solutions and how to find the right one for you.
Google Launches AI Mode: What it Means for the Future of Search
Google’s new AI Mode marks a major shift in its search strategy. Here’s how we expect it to transform the user experience and future of search.
13 Digital Marketing Predictions for 2025
Top Industry Voices Share Their 2025 Digital Marketing Trend Predictions As digital marketers, we know a new year brings new goals, new opportunities for growth, and new challenges. But a new year also brings plenty of change. Whether it’s advancements […]
Let's Put a Stop to Google Page Annotations
Google's Page Annotations will direct some visitors away from sites and back to search. We’re calling for an end to this practice.
Choosing the Right Digital Marketing Career Path as a New Marketer
Learn more about the different career opportunities in digital marketing by exploring the roles of SEO and PPC specialists. Gain insights into key skills, tools, and strategies to help you determine the best path for your professional career.
6 SEO Tips & Tricks We Learned at WTSFest 2024 in Philadelphia
Three of our digital marketers recently picked up some new tips, tricks, and best practices at the 2024 Women in Tech SEO Festival. Learn more about what we learned and how we’re applying it to our work.
How to Create a Looker Studio SEO Report Without Paid Connectors or Expensive Subscriptions
Effectively Measure Organic Traffic Performance With an Easy-To-Create Dashboard Measuring organic traffic performance is a key part of SEO. But with so many different metrics available to track, it can be challenging to know what data to look at when […]
Testing Website Accessibility: Five Testing Tools & Methods To Identify Accessibility Issues
Is your site compatible with website accessibility guidelines? Use these tools to benchmark and identify improvement opportunities. Website accessibility is often overlooked, but it shouldn’t be. According to CDC estimates, 61 million adults in the United States alone live with […]
23 Of The Best Resources For Starting A Digital Marketing Career
The best social media communities, podcasts, newsletters, and certifications for new digital marketers I didn’t know anything about digital marketing when I started as an intern at Cypress North earlier this year. Acronyms like SEO, CPA, and ROAS meant nothing […]
A Marketer’s Website Launch Checklist
SEO, Google Tag Manager Tracking, & Content Planning for a New Website There’s nothing quite like launching a beautiful, brand new website, but it is something that can have ugly consequences if not performed correctly. While marketers aren’t typically responsible […]
SEO for PDFs - How To Optimize PDFs For The Web
Let’s face it, for some companies Portable Document Formats (PDFs) are an unfortunate necessity. From sell sheets and downloadable product flyers, to manuals and tutorials - PDFs have secured a spot in our lives, and there are some tips and […]
Updated: How To Exclude Mobile Apps From Google Ads Display Campaigns
If you’ve been following us for a while, you’ll know we generally don’t like running ads on mobile apps. Don’t get us wrong, we love apps! They’ve made it easier than ever before to get information and connect with each […]
Digital Marketing in 2019: What to Watch For
The Pros Rampant Responsive One of the biggest boons for advertisers in 2018 was the ability to optimize campaigns by moving away from standard banner sizes and utilizing responsive display ad formats. The proliferation of flexible ads such as Facebook […]
Firing Up Bing Ads? Crucial Differences Between Bing & AdWords To Consider When Setting Up Your Campaigns
Does Anyone Even Use Bing? As digital marketers we tend to hear this question on a weekly basis, if not more often. And while the mere idea that Bing exists is enough to shatter the worldview of many Google nerds/religious Chrome users, the […]
Getting Started With Google Tag Manager
What is Google Tag Manager? Google Tag Manager (GTM) is a tool that gives users a way to add code to a website without having to log in to the backend and manually add to the source code every time. […]
The Retargeting Playbook: The Ultimate Guide To Setting Up Successful Retargeted Ads
As an internet user, you’ve likely become accustomed to those ads that seem to follow you during all your digital travels. These ads are known as “retargeted” ads (or “remarketed” ads if you're using Google) and help to keep your […]
How to Connect Your Google+ Business Page to Your Local Places Listing
The time has come -- Google is finally allowing users with Google+ Business Pages to connect the page with the Google+ local listing (also known as Google Places) on Google Maps. Confused already? Yeah, us, too. But we'll save that […]
How To Link (Many) AdWords Accounts with Google Analytics Using The New Bulk Account Linking Option
All of you pro AdWords users who routinely take on clients with many AdWords accounts for different promotions can breathe a collective sigh of relief. This week Google came out with a simple way to connect AdWords and Analytics in bulk! […]
Keyword Research Tips: How To Use Bing Ads Editor To Estimate Positional Volume & Pricing
If you are a search pro using Bing, you'll likely spend a good chunk of time living in the Bing Ads Editor. Much like Google's AdWords Editor, this standalone desktop program saves advertisers time and energy by allowing for bulk […]
How To View Geographic & Location Data Directly Within Google AdWords
When it comes to AdWords, all locations are not created equal. It's important to track which locations are converting -- and which aren't. With AdWords, you can increase or decrease bids based on the location you're targeting, and diving into […]