Serpstat.com
Log in
Email user = xxx
PW = xxx

In centre of screen there should be a search bar.

Put in the target domain.

On the left side, hit backlink analysis

After that, hit backlinks, on the left side.

Under the graph of "lost backlinks", on the right side, you should be able to hit export.

Export as CSV. Hit download on the popup that's on the top. If that doesn't work, go to https://serpstat.com/users/reports/

In google sheets, hit file, import, upload, drag/browse for the file.

Freeze the top row (click on number 1, hit view, freeze 1 row)

Delete the following columns:

"First" "Last" "Lost"

The second set of "Serpstat page rank" and "serpstat trust rank". The two on the most left should be kept as they are accurate to the source url. Add a column called Indexed? Add another one called Live? And 7 more for the Anchor types. EM, PM/LSI, Brand PM/LSI/Topic, Generic, Naked, Brand. Make the anchor type columns right next to the anchor column.

Open Greenlane Indexation Tester 1.24p

Copy and paste all source URLs to the greenlane indexation tester.

Once finished, open notepad, copy and paste the entire column of Indexed? Into notepad, there should be a lot of Yes and No

From notepad, paste the list into sheets, under the column that we created earlier, Indexed.

Right click on the index column, sort by A > Z

Hit hide on everything that isn't indexed.

Now take all of the target urls, and either put them into a 404 checker or just put them back into greenlane's index checker.

Repeat what we did for the entire index process.

By now, we've hidden a bunch of rows. Out of 100 links, I've hid 59 of them. The majority of the 59 are likely to be doing nothing.

To see real number of total RD, according to Majestic's index

Go here: http://www.seoweather.com/trim-urls-to-root-domain-standardise-urls-prefixes/

Paste all of the source links here, hit trim URL's to root

Then go here to remove duplicates: http://textmechanic.com/text-tools/basic-text-tools/remove-duplicate-lines/

Paste all of the root URLs here.

Save the results somewhere, add it to the report at the end. I started off with 68 referring domains. I finished with 16 that are doing anything of value.

Which makes sense because this domain only has 13% TF.

For determining the anchor text ratio for the entire domain, we will check all of the backlinks, if it's indexed by both majestic and google, they are going to count.

You will be able to use these anchors to check anchors to a specific, ranking page, later.

Using the 6 anchor type columns we made earlier, go through every anchor text, and just type "1" to the appropriate column.

Once you are finished, have all of the anchors add up, using something like =SUM(C61:C101)

Once done, we're going to display the site wide anchor text ratio. To the right side of below, Total links should have all of the anchors, for example: =SUM(C102:H102)

The rest should be showing the precentages. These percentages should add up to 100%. The formula should be Anchor type / Total links. I was left with the below:

Total links	41
EM	0.00%
PM/LSI/Topic	0.00%
Brand PM/LSI/Topic	2.44%
Generic	4.88%
Naked	39.02%
Brand	53.66%

If you're going after the same keywords as this website, then you will need to determine the anchor ratios of the ranking pages, as well as the overall domain anchors.

Even though some of these links are indexed, many are going to hold very little power.. and Majestic's TF score is amazing at evaluating this. Under the Serpstat Trust rank, sort it by Z > A, and make a note of how many links have 0 TF.

How many are between 0 and 10, 10 and 20, and what are 20+. Make a note of it next to the anchor types. In my case, only 8 links are higher than TF 10. Those 8 come from 5 domains. I went from a domain with 68 RD to a domain that's only getting links of worth from 5 domains.

Real referring domains	16


TF 20+	2
TF 10-20	6
TF <10	11
TF 0	21

The last step, is to do a breakdown of how the links are being distributed between the site. How many are to the support pages, to the ranking pages, and to the home page?

Right now, we only care about the home page, everything else we can call the support pages. Just sort by target_url, count all of the links going to the home page, and then check how many of those are unique domains, do the same for support pages. (Anything that isn't the home page). And if you have the ranking pages, those too.

I'm left with the below:

Home page links	13
Support pages links	27
Home page RD	7
Support pages RD	9

Do this for the other domains in the same niche that are ranking, make an average of the anchor text and link distribution.

In this case, the home page is the page that is ranking for a specific KW that I'm after, if the other websites that we'll be checking that are ranking have similar RD on their ranking page, I probably won't send more than 15 to the ranking page. And I would make sure to send atleast 50% to support pages.