Backlinks and Referring domains Number from Ahrefs

#1

Hi I was wondering how we can get the Backlinks and Referring domains number for a list of websites from Ahrefs.

ShareX_2019-08-09_14-28-40

I have a list of domains in excel column A
To get the Ahref URL Rank : I used this formula =Connector("Ahrefs.AhrefsRank",A2,"domain",1000,0,"AhrefsRank",TRUE)

but could not figure out how to get the Backlinks and Referring domains number

#2

Hi,

The endpoint you're using in that formula extracts the rank for one domain or many of the subdomains (if changing Mode). This may not be ideal if you're using it with formulas to parse a list.

To answer your question, you can do it with the Metrics view. [A2] is a technique to directly reference cell A2.

Let me know how it goes and if you have additional questions.