Using the SEOmoz API with SEOTools for Excel
-
Hi there,
I'm trying to use the SEOmoz API in Excel, to get the Domain Authority and MozRank for a bunch of URLs. I've tried multiple techniques, but I can't get it to work. The code I currently got is from SEOGadgets post, and I'm using the SEOTools for Excel plugin.
Here is what I got:
=JsonPathOnUrl("http://lsapi.seomoz.com/linkscape/url-metrics/"&A3&"?Cols=68719476736";"$..pda";"<httpdownloader cache="false" pause="1" authenticateuser="REDACTED" authenticatepassword="REDACTED" requestmethod="GET"></httpdownloader>")
The problem is, it always returns 1 for every URL. Can anyone explain what I'm doing wrong? Or show me an easier way to do this?
I have double checked the API keys and tested on multiple URLs.
-
Hey Qon,
If it can be of any help, the following post helps you find out the amount of backlinks (categorized by Domain Authority) that are pointing to a website.
http://www.johnfdoherty.com/three-phenomenal-excel-spreadsheets-for-link-analysis
I can't help you with the MozRank however.
Regards
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
-
I want to know how i use the new feature
i want to know how to use the feature for the www.alazharquranteaching.com learn Arabic online and Quran Online.
Reporting & Analytics | | saharali150 -
Can you tell MUV data on websites using MOZ?
I want to write reports on other websites and need to know MUV data on them
Reporting & Analytics | | WeAreVillage0 -
Best use of Keyword Rankings report
is there a guide for getting the most out of the keyword ranking tool? I currently have 250 or so keywords, some move up, some move down on a weekly basis but generally trend up. That's about as much info as I gain from it though. anyone got any good tips? thanks
Reporting & Analytics | | benj450 -
What tools are people using to analyse clicked links
Hi, What tools do you use/recommend to analyse what/where links are being clicked on a page. I have seen a few mentions about CrazyEgg but are there any free (but good) tools around worth using?
Reporting & Analytics | | NeilD0 -
Rank tracker tool - seomoz
Hi All, I have noticed that ranks in the tool -rank tracker are not correct for my keywords sometimes. Does anybody else has experienced this? Isn't it real time updated? What other free rank tracker tool you guys would suggest which can send you weekly accurate updates? Thanks
Reporting & Analytics | | EG0CENTRIX0 -
What does "on first page" mean in seomoz ranking reports?
Hi - When reports here show numbers of keywords appearing "on first page", there must be some implicit assumption made about the number of results listed per page. 1. Can anyone tell me what that assumption is? Is it 10? 20? 2. What about universal results Local links? If the answer to number one is, for instance, 20 results per page, then are there any assumptions made about the number of universal results Local links included? I'm just trying to understand what the reports mean. Thanks, Tim
Reporting & Analytics | | tcolling0 -
Get Stats on Search Box Usage, Using Google Analytics?
Let me preface this by first saying I am NOT using the Google Adsense Search feature. The question I am asking is pertaining to the standard search box that comes already coded in most .php blogs. In the Google Analytics, is there a way to tell how many people are searching using the search box? I've looked through the navigation and pathway options in analytics and I don't seem to see anything that definitively points to the number of people using the search box but, perhaps, I am overlooking it. Any insight?
Reporting & Analytics | | ChristineCadena0 -
Does Google Analytics use your data against you?
I couldn't find this question answered anywhere in Q&A, so I apologize if it's a duplicate of another post. I heard, about a year ago on either Web Pro World, or Warrior Forum that Google uses your visitor data in your Google Analytic account to rank your site. Someone said that when they took out the Google code, their site went from the third to the first page within 48 hours. That was then verified over the next couple of weeks by others. Their thought was that regardless of the optimized page and incoming link, if the site wasn't getting visitors, then it would be penalized. Since Google has the data, they would be able to use it. I then started using another, paid, solution - getclicky.com. While I like clicky, there is some info Google has that clicky doesn't, everyone integrates with Google analytics - like SEOmoz, and I'm paying a monthly fee. Now that I'm a part of a community of experts, what do you think? Have you noticed Google ranking you based on your analytics data? Has anyone experienced this, or heard about it before? Because I'd like to go back to using Google analytics. Thanks!
Reporting & Analytics | | DallasBonsai0