Using excel to pull MOZ data about links
-
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!
-
-
Chris, does this help?
http://moz.com/ugc/updated-tool-seomoz-api-data-for-google-docs
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
-
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 -
Can the API give the same data as the UI?
What I mean is, I'm not that interested in counts. What I'd like to figure out is how to get the API to give me what the UI gives me , so that for a given target domain I can download a report with the following fields: URL
API | | StevePoul
Title
Anchor Text
Spam Score
PA
DA
Linking Domains to Page
Target URL
Link Type
Link State
Date First Seen
Date Last Seen
Date Lost
HTTP Status Code
Links to Page
Outbound Domains from Page
Outbound Links from Page
Operator profile That's essentially the same as a CSV report generated by clicking on the "Export CSV" button. I could ,I suppose, get someone to write something in Selenium to enter a domain, click on the button and hang around on the notifications page for the results but I'd really rather not.1 -
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 -
Is Moz Pro down?
This morning, just before trying to meet with a client, I cannot access Moz Pro. Here is the page I get: This XML file does not appear to have any style information associated with it. The document tree is shown below.
API | | jessential
<error>NoSuchBucket<message>The specified bucket does not exist</message><bucketname>analytics.moz.com</bucketname><requestid>DC68738B494D30A1</requestid><hostid>r13H1pVq04vKGcKkAD9AUCTRXNdZAhUOULNwv4/TB74e0utcat2mV3PT7dXOtnuG</hostid></error> What can I do to access my information?0 -
API - Internal Links to page and related metrics
Hi dear moz Team! Currently I´m building a Java application accessing your API. But there are some metrics I urgently need which I can´t get out of the API until now: The total number of internal links to a page The total number of internal links to a page with partial anchor text match MozRank passed by all internal links w. part. match anchor text (would be nice) For example, if I try this by your links endpoint, my idea was: http://lsapi.seomoz.com/linkscape/links/http%3A%2F%2Fwww.jetztspielen.de%2F?AccessID=..
API | | pollierer
&Expires=..
&Signature=..
&Scope=domain_to_page
&Filter=internal
&Sort=domain_authority
&SourceCols=4 (or any other value)
&SourceDomain=www.jetztspielen.de
&Offset=0
&Limit=50 If I try this, the API says: {"status": "400", "error_message": "Cannot set a source domain when filtering for internal links."} Is there any way to get the data I need by your API endpoints? I´m currently writing my master thesis and it is very important to me to solve this somehow. Thank you very much in advance! Best, Andreas Pollierer1 -
Is it true that google moved to ssl encrypted protocol and doesn't release keyword data anymore?
Hi,
API | | jjtech
I have a couple trivial questions regarding google search and the way Moz keyword reports are working. 1/ is it true that google moved to ssl encrypted protocol and doesn't release keyword data anymore? 2/ if so than how Moz still manages to collect this data? Is it because of api or some other “deal” with them? Or you're paying for it. 3/ Why is “traffic from organic search” only for one week? Or I am missing something . http://screencast.com/t/rslio5ZSKAx It would be great to:
a/ go month by month (my client is requiring monthly reports)
b/ compare one week/month with another to see if it's getting better or worse. Thanks in advance,
JJ0 -
Are EC2 servers blocked from using the Moz API?
Hi I've created a script that I'd like to use to check a list of domains using the Moz API. It works totally fine on my local machine. However, when I run it from my EC2 instance, it fails every time. To be specific, the response is always empty (the response is an empty json array) when the request is sent from EC2. Is, for some reason, EC2 blocked by the Moz API? Many thanks for your help, Andrew
API | | csandrew0