Linking Moz with Excel to compare links enmass
-
Hi all,
I'm looking for a solution which will allow me to sort a list of links by pagerank.
There seems to be a couple of solutions online but neither work for me due to various updates since they were created.
Can anyone give me a solution which will work today - Perhaps using Google Sheets/Excel?
I have a Moz Pro subscription.
Thanks,
Sam
-
Will this only work on a link by link basis?
To confirm I have a list of 300 links I've scraped from Google into Excel, how can I display the PA for all of these sites within Excel?
-
Exporting a search from Open Site Explorer by hitting "Request CSV" will do the trick!
-
Thanks James,
That's great. What's the best way to bring in my PA into Excel?
-
Hello there - is there a specific type of sort you are trying to perform? If not just by using the default Filter Icon in Excel/ Google Sheets will be fine:
http://screencast.com/t/BLnkZPUkrD3c
Hitting the sort button will allow you to manipulate the order which you see the PA displayed. In excel if you need to run a double sort simply hit Data -> Sort and enter the details in the dialog.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
When I click into the moz bar on our website www.essexparts.com it shows that the URL is Canadian and shows a Canada flag. The website and company are in the US. Can someone please explain this?
When I click into the moz bar on our website www.essexparts.com it shows that the URL is Canadian and shows a Canada flag. The website and company are in the US. Can someone please explain this? Also does the location have any bearing on how it shows up in google? XNQOQoJ
API | | Tindol0 -
Is the chat with Expertise option available in MOZ?
I dont find a chat option in the MOZ site. Is it available so i could chat with some expertise on MOZ API integration
API | | Dotcomcontent0 -
Is Anchor text metric is available for free MOZ API ?
I'm accessing anchor text metric using free MOZ API account which is for 30 days. is there is any way to get anchor text ?
API | | rogerdavid0 -
MOZ API - metadata permission error
Hi there, I have a small issue using MOZ API. I cannot make successful GET request for metadata (index stats). The request looks like this: http://lsapi.seomoz.com/linkscape/metadata/index_stats?AccessID=mozscape-XXXXXX&Expires=1497442682&Signature=XXXXXX. In my most recent request, I got an error message: "Permission denied: pckgmhkomakbnflgmckhobiiojjmomjpph". Did I forget something? Signed Authentication should be OK, because it works with other endpoints, such as "url-metrics", "links" etc. Thanks in advance! Kind regards, Zoran
API | | Databox-apps1 -
Is everybody seeing DA/PA-drops after last MOZ-api update?
Hi all, I was wondering what happend at the last MOZ-update. The MOZ-health page has no current errors and i've checked a lot of websites probably about 50 a 60 from our customers and from our competitiors and everybody seems to have a decrease in DA's / PA's. Not just a couple went up and down like normally would happen, but all seems to have dropped.... Is anyone seeing the same in their campaigns? Greetings,
API | | NielsVos
Niels3 -
MOZ Bar recognizes a link as No-Followed even when there's no evidence of nofollow nor external tag
Hi! I've seen that the Moz bar recognizes some links as NoFollowed, even when technically are followed.
API | | Gaston Riera
One example of that is this page: https://wiki.python.org/moin/PythonTraining I've attached an image to clarify.
The link is just: <a class="https" <span="">href="https://rmotr.com"> there is no evidence of no following tag (such as external, nofollow, etc). Thanks!
GR.</a> <a class="https" <span=""></a>2e3b9c02fe.png 1513d1b95d.png0 -
Is Moz's rank checker driving referals (and bounces) in my analytics?
I see 200+ referral visits per month from "rank-checker.online" and they all bounce with one second session durations. Are these bounces hurting my SEO? They are definitely distorting my referral metrics. Can I block them somehow?
API | | 10516VT1163000 -
Use of Moz with non-latin characters
Hey there, I am new member with Moz and i have to say that you are doing very good job. Three days ago, i have learnt that the On-page Grader and On-Page Optimization tools are useless for me because i am using no-latin keywords (greek characters) in order to optimize my SEO. From that moment i dont know how to properly use moz pro in order to optimize my SEO score (if this still can be done) so i would like to ask: Without these two powerfull tools how can i use the Moz Pro in order to optimize my (greek) website? Is this possible to do it with out these two tools? should i try to do it manually? if yes what i have to read/learn in order to do it manually? What other tools can i use in order to help me rank my website instead of On-Page grader and optimization? Thanks in advance
API | | tsalatzi0