• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

Exporting back link data

Our search engine performance is poor, compared to competitors with similar services.  The competitors have invested time and energy in creating many hundreds of incoming links, and now I would like to try and catch up.  The links in question are legitimate and relevant -- not purchased.

I'm looking for a tool which will list the incoming links of my competitors, and allow that list to be exported to an Excel worksheet or a Windows CSV file, including the page rank.  I've found tools which accomplish everything except exporting the page rank.  If the page rank can be exported to a file, I'd sort the results by page rank and concentrate on adding links with the most value.
0
ddantes
Asked:
ddantes
  • 9
  • 6
  • 5
1 Solution
 
Joe Winograd, Fellow&MVEDeveloperCommented:
Hi David,
I've been experimenting with Majestic and so far like what I see, but I am by no means an expert — simply passing it along for your consideration:
https://majestic.com/

It used to be known as Majestic SEO, but they recently shortened it to just Majestic. They do have export to CSV, and even better, export straight into Excel, but I haven't tried it and don't know if it includes PageRank:
https://blog.majestic.com/development/new-improved-link-export/

Speaking of PageRank, here's an upcoming seminar that may interest you:

http://www.semrush.com/webinars/view/does-google-use-topical-pagerank-if-so-how-can-you-see-it-in-action/

Good luck! Regards, Joe
0
 
ddantesAuthor Commented:
Thanks Joe.  I registered for a free account and created a report for my own domain.  The report didn't include the page rank for incoming links, so I submitted a support ticket to ask if PR can be included, and whether it can be exported.
0
 
Joe Winograd, Fellow&MVEDeveloperCommented:
Thanks for the update. I'll be interested in hearing how responsive their tech supp is — I haven't tested it yet. :)
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Edwin HofferTechnical ExpertCommented:
Hello ddantes,

If you are looking for a online website, then i would suggest you to use: https://ahrefs.com.

This website will help you to export all the backlinks for your and your competitor backlinks.

or if you are looking for a software then i will suggest you to use SEO Spy Glass by Links Assistant: http://www.link-assistant.com/seo-spyglass/

Or if you are looking for a free then use http://linksphinx.com/ software, it will export the backlinks by using some websites and will export them into a Excel file or in a CSV format, as what you are looking for.

Thanks
Edwin
0
 
ddantesAuthor Commented:
Thank you Edwin.   There is a specific feature which I need, which is the ability to export those links with their page ranks.  Could you specify which (if any) of the solutions you suggested have that capacity?
0
 
Edwin HofferTechnical ExpertCommented:
I have tried ahrefs and linksphink software, both will export links with their domain PR and page PR.
0
 
ddantesAuthor Commented:
Very good!  I installed Link Sphinx, but when I enter a URL and try to fetch links from the web, a window opens with required fields, whose labels are illegible (screen shot).  I assume that doesn't happen with the version you installed?
Image2.jpg
0
 
Edwin HofferTechnical ExpertCommented:
You have to select the free service, choose website from the dropdown list.

drop down list
0
 
ddantesAuthor Commented:
Edwin:  Please see the screen shot I attached to my previous comment.  I cannot read the labels associated with the form fields, and can't open a drop-down list.

I have a free Ahfrefs acccount, but I don't see page rank in the reports.  Does that require a paid membership?

Joe:  Majestic SEO responded quickly to my service request.  They say that Page Rank is a proprietary function of Google and they cannot scrape that data.  This seems inconsistent with the performance of other rank checkers, which publish page rank.
0
 
Edwin HofferTechnical ExpertCommented:
Use only free services from the drop down list like: backlinkwatch etc.
0
 
ddantesAuthor Commented:
I cannot access the drop-down list.  Please see the screen shot.  The list labels are not visible, and there are "required" fields which can't be populated.   Perhaps this software has a bug on 64-bit Windows.
0
 
Joe Winograd, Fellow&MVEDeveloperCommented:
Hi David,

> Majestic SEO responded quickly to my service request.

Glad to hear that!

> They say that Page Rank is a proprietary function of Google and they cannot scrape that data.

My guess is that they mean "will not" rather than "cannot", and the reason is likely either a perceived or real copyright violation, since they deem it to be proprietary to Google. The fact that other rank checkers are willing to scrape it doesn't mean that they're on the right side of the law. I can't speak to that, as I'm not an attorney at all, let alone one who specializes in Internet law and/or Intellectual Property law. But I do know that some forms of website scraping are illegal and subject to copyright and DMCA laws. I've also read that such theft is common, as it is easy to do and hard to detect.

Probably not what you wanted to hear, but those are my thoughts from the cheap seats. :)  Regards, Joe
0
 
ddantesAuthor Commented:
Thanks Joe.  That's good input.   If other sites provide PR data, I feel that's between those sites and Google.  But, since that data is available, I'd prefer to have it.
0
 
ddantesAuthor Commented:
Edwin:  I'm focusing on Ahrefs now, instead of Majestic SEO.  Would you mind explaining how to view the page rank of the links which are detected?
0
 
Edwin HofferTechnical ExpertCommented:
Sorry by mistake I have added the ahrefs. Ahrefs don't provide page rank of the domain.

Also about the software, are you not able to click on the button beside service?
0
 
ddantesAuthor Commented:
There is a problem with that software, both on my 32-bit and 64-bit Windows machines.  However, Ahrefs will serve my purpose.  Although it doesn't have Google PR, it has a proprietary page rank which indicates the value/trustworthiness of the link.  Their page rank score can be exported to Excel.   I'll open a Lite account with them, and thank you for the suggestion.
0
 
Edwin HofferTechnical ExpertCommented:
You are most welcome :)
0
 
Joe Winograd, Fellow&MVEDeveloperCommented:
> Although it doesn't have Google PR

Hmmm, makes you wonder why. :)
0
 
ddantesAuthor Commented:
Joe:  Perhaps I should have divided points among the experts?
0
 
Joe Winograd, Fellow&MVEDeveloperCommented:
Nah, don't worry about it. Not a big deal. I'm just glad that you found a solution that achieves what you're looking for (even if it's not Google PR), and that suggestion was all Edwin's. Regards, Joe
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 9
  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now