A guide explains a judgement. A workflow starts from a file that is already on your machine and finishes with a shortlist somebody can act on. Every step here is one you would do anyway; the point is the order, and which steps are worth automating.
- Turn an Ahrefs export into a shortlist
- Which report to pull, which columns to keep, the four cleaning passes that cost nothing, and where the page-level checks go. Ends with a file your outreach tool can read.
- Check a list you bought before you use it
- What to measure first, what a good list looks like against the one we published, and how to tell the seller something useful rather than just asking for a refund.
What they have in common
Both follow the same rule, which is the only one worth memorising: reject on the cheapest signal that can reject. Grouping by host costs a spreadsheet formula. Opening a page costs a request. Reading it costs a person. Do them in that order and most of the list never reaches the expensive step.
The reasoning behind the order, and what each stage removed on a real list, is in how to vet a link prospect list.