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
-
Does Moz DotBor crawler is the slowest than earlier?
I have these websites https://www.interessanter.com/ and https://www.techniken.net/ I managed to create quality links and reach Ahrefs DR 46 and even TF 20 in a few months, but on my server logs, I haven´t seen any DOT bot logs. It only crawls you if you are linked to a very high DA site now? To be honest I placed here those links ask in order to see if that helps. I remember that last year it wasn't like that. If someone can point me in the right direction to increase DA and PA I will really appreciate it. THANKS!
API | | albertomr0 -
Location Data Batch Updates via the MOZ API
According to the MOZ API documentation, I am able to update multiple Locations in a batch in order to create or update their location data, currently 130 locations. I have successfully created a batch and the API returned the $id, as I expected. Yet, it doesn't make clear how the multiple locations I want to update are supposed to be sent back to the API. I was expecting an upload of a CSV file or JSON data, and not Query Parameter as noted in the docs. When including a JSON file, properly formatted, as a binary upload, the response is still expecting a locations parameter. See error here: { "status":"MISSING_PARAMETER", "message":"locations missing. ", "response": { "locations":"MISSING_PARAMETER" } } https://moz.com/developers/docs/local/api#_api_batch__id-PATCH
API | | yuca.pro1 -
How to cost is calculated in Moz API for fetching only backlinks
I am unable to understand which particular API used to get the backlinks. And how cost is calculated. Suppose I Hit the API one time it gave me 100 backlinks of a particular domain. Does that mean i used 100 rows?
API | | maxfun00070 -
Integrating Moz with DashThis
I'm trying out DashThis as a way to visualize data for clients with whom we do a combo of SEO, PPC, and SEM work. I like the main Moz Pro campaign dashboard page for distilling top-level information and the rankings page for tracking keyword ranks. In an ideal world, I'd love to be able to sort replicate these within DashThis. I see that DashThis does integrate with Moz but looking at the Mozscape API documentation I couldn't tell if this type of integration is possible in DashThis. I realize this is a super specific question, but I thought I'd ask the community if this integration is possible or if I have more limited range of options.
API | | TheKatzMeow0 -
Moz got problem crawling SquareSpace websites?
Moz sent us an email about our website https://www.openhill.com that they failed to crawl. I checked the forums with the same issues with mine and it looks like that Moz has problems with websites from Squarespace. I wonder if you do have a workaround on this. Let me know if you have instructions for me to fix this kind of issue. Thanks!
API | | leahdickey0 -
Can we get access to Moz's Rank Tracker via the API?
I'd like to be able to pull the results from Rank Tracker into my own application. Can I access it via an API? I don't see it anywhere in the Moz documentation, which is usually a clear answer. If not, how do you suggest to automate the inclusion of this data without, for example, being blacklisted?
API | | MB070 -
Moz Local, only did 3 listings...
I used Moz local and it only successfully created 3 listings.. the rest all require I manually add the information. Seems like a steep price for 3 listings. I was under the impression it would do more than that. And on top of that, it created a google+ page and I already have one which now I cannot find a way to update. Same for facebook. I have a page, I even had it in the CSV file, but it didn't load it. Some help would be appreciated.
API | | agirlcreative0 -
Suggestion - Should OSE include "citation links" within its index?
This is really a suggestion (and debate to see if people agree with me), with regard to including "citation links" within Moz tools, by default, as just another type of link NOTE: when I am talking about "citation links" I am talking about a link that is not wrapped in a link tag and is therefore non clickable, eg moz.com Obviously Moz have released the mentions tool, which is great, and also FWE which is also great. However, it would seem to me that they are missing a trick in that "citation links" don't feature in the main link index at all. We know that Google as a minimum uses them as an indicator to crawl a page ( http://ignitevisibility.com/google-confirms-url-citations-can-help-pages-get-indexed/ ), and also that they don't pass page rank - HOWEVER, you would assume that google does use then as part of their alogrithm in some manner as they do nofollow links. It would seem to me that a "Citation Link" could (possibly) be deemed more important than a no follow link in Googles alogrithm, as a "no follow" link is a clear indication by the site owner that they don't fully trust the link, but a citation link would neither indicate trust or non trust. So - my request is to get "citation links" into the main link index (and the Just Discovered index for that matter). Would others agree??
API | | James770