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
-
Is there a way to connect Moz to Databox?
Is there a way to pull data from Moz into other applications, such as Databox? If possible, how do I set this up?
API | | jenmilehigh1 -
Is there an easy way to get MOZ data into Google Sheets?
Is there any way to pull data directly from MOZ to Google sheets, like a plug-in for sheets?
API | | Storfiskaren2 -
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 -
Can the API Filter Links with Certain Anchor Text?
I am trying to get all links that have a certain strings in their anchor text: I am using the python library: https://github.com/seomoz/SEOmozAPISamples/blob/master/python/lsapi.py Looking at the documentation, it says I can get the normalized anchor text by using the bit flag 8 for the LinkCols value: https://moz.com/help/guides/moz-api/mozscape/api-reference/link-metrics So I tried this: links = l.links('example.com', scope='page_to_domain', sort='domain_authority', filters=['external'], sourceCols = lsapi.UMCols.url, linkCols=8) But it doesn't return the expected 'lnt' response field or anything similar to the anchor text. How do I get the anchor text on the source URLs? I also tried 10 for the linkCols value, to get all the bit flags in the lf field as well as the anchor text. In both instances (and even with different variations of targetCols & sourceCols), this is all the fields that are returned: 'lrid', 'lsrc', 'luuu', 'uu', 'luupa', 'ltgt'
API | | nbyloff0 -
How much attention should I pay to Moz's DA/PA?
Hola! I've been optimising a site since October and our hard work has yielded a sizeable increase in organic traffic, revenue, quality, relevant links and Search Metrics scoring since commencing the campaign. After yesterday's Moz update, the DA has dropped slightly and a number of pages' PAs have dropped significantly (i.e. from 27 to 17). So here are my questions: My 'white hat' optimisation is clearly working. The site is enjoying more than 100% year-on-year increase in organic traffic and we're currently pulling in more organic visitors than ever before. Why is Moz's score not reflecting this? Some of the pages that have seen sizeable PA drops have had their URLs changed since the last Moz update. For example, I've optimised a URL from www.mysite.com/cases-covers to www.mysite.com/phone-cases to coincide with search volumes. I've added optimised content to this page too, but the PA has dipped from 27 to 17. A 301 redirect has been correctly added, and this is evident by a PA of 17 and not zero, which is what a brand new page would have. Am I paying too much attention to Moz's scores? It's a bit disheartening to see a drop after a lot of hard work. However, I guess the only thing that really counts is an increased volume of search traffic and revenue, right? Cheers, Lewis
API | | PeaSoupDigital0 -
Will the MOZ API display
will the MOZ API display rank, social and page data So I can create my own dashboard? We are looking to head off the 100% not provided and need to add to our reporting program. I was hoping the MOZ API would allow us to integrate the page views per url with ranking data that the campaigns provide. We are also interested in adding the social metrics for twitter and facebook to our client facing portal. any help or ideas would be greatly appreciated. Thanks
API | | OPM0