Building Scalable SEO Project Backup Files
Let's download the Gdoc as a CSV file, and import into URL Profiler. Tick the checkboxes for 'Moz' and 'Em ail Addresses' in Domain level information and 'Ahrefs' in URL level information. Now click 'Run Profiler', and save the file. Import it into Gdocs again, and open the Combined Outcomes sheet.
As typical, freeze the 1st row and eliminate the undesirable columns as revealed below: Once you're done, choose column H (Mozscape Domain Authority) and Sort Z-A. Then get rid of all entries that have DA lower than 10 (you can opt for DA lower than 15 if you 'd like). Then choose column I (URL Ahrefs Ref Domains) and again sort Z-A.
GSA SER project in three steps
That gives me over 50 404 URLs with over 10 referring domains. Now you can proceed and drop each of these into Ahrefs, export their backlinks (1 backlink per domain), eliminate undesirable columns, and add those to the sheet too. This is why this procedure is uber-scalable. You're not just discovering damaged links on a domain, you're also discovering the links pointing to those broken links too! On any normal day, evaluating damaged links on any one domain yields about 500 broken link structure opportunities with this process.
GSA SER project in three steps
How to Streamline Project Building for 2026
We follow the very same process we followed with the guest blogging example. We use the email finding API formula for this: However for damaged link building, I have a few more pointers: Some emails might get invalid gradually. So constantly use an e-mail verification sheet like this one after you discover emails utilizing the Hunter formula You can utilize the contact page and contact page e-mail address we found utilizing URL Profiler if you're unable to discover e-mail addresses using the Hunter formula, or if the email is invalid If all else fails, use to look for the whois email of the domain Next is the outreach part.
