Tools needed: Ahrefs, Majestic, Search Console & Clusteric
In Ahrefs -> Go to backlinks (1 link per domain) & export all backlinks (full export)
In Majestic -> Go to backlinks & export in CSV
From Search Console -> Download the current Disavow file in txt format & Top Linking Sites in CSV
Open Clusteric -> New project -> Link profile /Disavow heavy
– Import from Search Console the Top Linking Sites in CSV format
– Load the text file of the current Disavow Links
– Load Ahrefs CSV
– Load Majestic CSV
state the website being analyzed, select a language, and in the expected page subject type in and select ‘yes’ for “casinos”, “sports betting” & “gambling” – then click analyze, click ok (to check domains with at least 10 links) & let it run
We are looking for harmful/toxic links.
(Click on headings to filter)
In Rel column, filter for DoFollow only and keep that filter throughout entirety of task
Attacks usually come in the form of Blogspot Images & Pharma Links.
In URL column, filter for “blogspot” & in Anchor column filter for “image” – right click and mark all visible domains with a user rating of BAD.
clear the blogspot & image filters but keep the dofollow filter engaged
Filter the Anchor column for “/?” in order to look for Pharma Links – manually open these links using Open Multiple URLs chrome extension – if they have any pharmaceutical terms such as Viagra, pills, mg (for milligrams) etc. right click and mark them off as user rating BAD.
Next we scroll to the right looking for the heading “”Words Blacklisted” – filter that column as greater than or = to 2.
Manually open those links using the Open Multiple URLs chrome extension and check them out – some of them even though there are bad words used aren’t always bad – use your discretion regarding the content & look at the metrics of the pages ie. DA, PA, UR & DR
Filter the URL column for “list” – you can right click and mark all visible domains as user rating BAD – unless it is for a Dutch (NL) site, manually check those ones as some of them will be like casino directories which tend to work in that region – just check the spam scores and ratings of the sites
Lastly & most tediously filter the Algo_Rating column for Bad and Average only; in conjunction with filtering the User_Rating as blank (null) – you will have to open and manually check those links one by one using Moz bar (for DA & PA) and Ahrefs (for DR & UR) – mark all poor links as User Rating BAD
Save the project
Click on Disavow File
Reload the list including only links explicitly marked by user (bottom left hand side of the window that opens)
And then Save to disavow file – Now you are ready to upload the disavow file to search console.
