May 7, 2021

How To Weed Out Junk Sites On Outreach Sites

A process we use at our link-building agency to weed out junk websites(or super big websites that would definitely not give you a link) from a list of prospects is using this formula in google sheets.

=ARRAYFORMULA(QUERY(A:A,"select * where not ("&TEXTJOIN(" or ",TRUE,"A contains '"&IMPORTDATA("https://pastebin.com/raw/9K3zndkZ")&"'")&") label A'Filtered List'"))

Leave a Reply

Your email address will not be published. Required fields are marked *