I have a task at hand where I have over 1000+ blog URLs and I need to fetch metrics for each URL from a site called Ahrefs.com (Paid Service) They do have a trial version that you can sign up to create the codes.
I Sheet 1 in my excel workbook, I have the URLs listed in Column A and needs the metrics entered in adjacent cells.
[TABLE="width: 1475"]
[tr][td]URL
[/td][td]URL rank
[/td][td]Domain rating
[/td][td]backlinks
[/td][td]Referring domains
[/td][td]Organic keywords
[/td][td]Est organic traffic
[/td][td]Paid keywords
[/td][/tr][tr][td]https://ahrefs.com/site-explorer/…=problogger.net
[/td]
[TD="align: right"]15[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"]35200[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]211[/TD]
[TD="align: right"]13[/TD]
https://ahrefs.com/site-explorer/…ilyblogtips.com
[/td]
[TD="align: right"]15[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"]35200[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]211[/TD]
[TD="align: right"]13[/TD]
https://ahrefs.com/site-explorer/…ssiveincome.com
[/td]
[TD="align: right"]15[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"]35200[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]211[/TD]
[TD="align: right"]13[/TD]
[/TABLE]
That is just a few of the items I have on my list.
Is there any way this can be automated so much so I don't have to go and extract the data manually for all the 1000+ blogs?
I've tried several codes from the web, but none of them seem to work, or at least to my knowledge of VBA.
Any help and support regarding this would be awesome.