Welcome to the Q&A Forum

Browse the forum for helpful insights and fresh discussions about all things SEO.

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Using excel to pull MOZ data about links

API

1783

ChrisClayts last edited by

I have a list of links 500 in excel that I would like to get the number of backlinks, PA and DA for the relevant link, is there a pre-built excel sheet that utilises the Moz Api that can pull this data easily?

Thanks!
1 Reply Last reply
Reply Quote 0
Chris.Menke @Chris.Menke last edited by

or maybe this:

http://www.aleydasolis.com/en/search-engine-optimization/seo-dashboard-google-docs-seomoz-analytics/
1 Reply Last reply
Reply Quote 1
Chris.Menke last edited by

Chris, does this help?

http://moz.com/ugc/updated-tool-seomoz-api-data-for-google-docs
1 Reply Last reply
Reply Quote 0

Got a burning SEO question?

Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.

Start my free trial

Browse Questions

View

From

Sorted by

With category

Explore more categories

Related Questions

Unsolved How to get Domain Authority using API ?

api domain authority

I wanted to test the API and while looking on the documentation urls, I cannot find details on how to get Domain Authority. is that not available to query ? was it replaced by Brand Authority ? is it only available for the paid API or for the free one too ? I looked at many documentation pages but I find it very confusing and frustrating, there are many versions of the documentation and various URLs and not clearly labeled, I understand some are V1, V2, V3, etc, but I didn't find sample API calls for Domain Authority. Thank you.
API | | adrianTNT

0
Can you tell me about the impact of Do-follow and No-follow backlinks for increasing Moz DA?

Have Do-follow backlinks and No-Follow backlinks same value to increase Domain Authority in Moz? Recently, I have created 290 profile backlinks which was do-follow. But from yesterday I have seen all backlinks are no-follow now according to the decision of sites' owners. My site's DA has already increased up to 35. Will this DA fall gradually from now? Apart from it, if I have created same backlinks for my another site; will my DA be 35? Please try to clarify it. My site is: https://kodnest.com Thanks. Waiting for your valuable answer from Moz official.
API | | FrankJOwens

0
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 | | Dotcomcontent

0
Alternatives to Supermetrics to get Moz metrics into Google Sheets?

Hi, Interested in getting Moz API metrics into Google Sheets on an automated scheduled. Supermetrics can do this, but I am curious to know if there are any alternatives, free or paid. Thanks! 🙂
API | | GOODSIR

1
Is There any API from FourSqaure that allow us directly feeding business listings into it , Moz is doing same , so there must be some API?

Hi, i have seen "Moz Local" , has a option , "FourSqaure". I just a curiosity to ask that , is there any tie-up between FourSqaure and Moz , coz Moz must be using its APIs to feeds its business listings into FS Database. When i have searched for FS APIs for direclty feeding business listings into it , i got nothing ? so i have got this question? if any one can help me out.
API | | Prodio

0
Is Url-Metrics Historical data available via API?

Hi, we're using Url Metrics API. We were wondering if we could access historical data. Like for example passing the date to query. Currently on the api docs this ability is not listed. Thanks!
API | | Haystak

0
Lost many links and keyword ranks since moz index update

Hi All, I came back from work today from a week off to find my site has gone from 681 external inbound links to 202. With this my domain authority, moz trust and moz rank have all also taken a slip. Compounding this, I am seeing a slip most of my keywords rankings. If i try to use the open site explorer to explore my links and see what going on i get the message It looks like we haven't discovered link data for this site or URL. If i check the just discovered links like it suggests I get It looks like there's no Just-Discovered Links data for this URL yet. I know these features worked before the index as i used them. Is this all attributable to the moz index issues that have been noted or could something have happened to my site? Since i started 2 months ago I have made many changes including... Updating the site map that was 4 years out of date and included 400 broken urls Removed blank pages and other useless webpages on the site that contained no content (from the previous administrator) Edited a few pages content from keyword spammy stuff to nicely written and relevant content Fixed url rewrites that made loops and un-accessible product pages All these changes should be for the better but the latest readings have me a little worried. Thanks.
API | | ATP

0
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 | | tsalatzi

0