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
-
Which one should I use...Google Analytics or AFS Analytics
Hi There, I am about to implement analytics for a customer site and I am wondering if I should use Google Analytics or https://www.afsanalytics.com ? I am leaning towards Google since it's pretty mainstream but I would love some feedback on the AFS ! Thanks everyone! Gary
Reporting & Analytics | | gdavey0 -
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 -
Can you use Google tag manager to manage rich snippets/schema mark up?
Hi,Does anyone know if you can use the new Google tag manager to manage rich snippets? I've seen that there is an HTML section where you can edit HTML that isn't shown on the site - do you think this field could be used to add schema data?Thanks,Karen
Reporting & Analytics | | Digirank0 -
Which one should I be using 301 redirects
Hiya guys, I have a little problem, not sure which one I should be using, for 301, be easy on me I've not dealt with this before. So we have http://www.talknightlife.co.uk and I've done redirects for http://talknightlife.co.uk to http://www.talknightlife.co.uk host http://www.talknightlife.sheffieldspeedcameras.co.uk to http://www.talknightlife.co.uk Because my website is purely a forum and in the canonical error from the optimisation tool is showing 301 canonical = http://www.talknightlife.co.uk/forum.php should I be redirecting that to http://www.talknightlife.co.uk or the other way round, or just leave it ? I'm a little confused Cheers in advanced for your help guys
Reporting & Analytics | | Lukescotty0 -
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 -
How do I unlink my Google Analytics Account from SEOmoz?
Hi, I am new to the community and have a very basic question concerning the internal settings for SEOmoz. How do I unlink the Google Analytics Account from SEOmoz. I am sure there is an easy answer to this. Thanks for helping!
Reporting & Analytics | | sandoery0 -
Disclaimer about using Google Analytic?
When using GA on my Website do I need to have a disclaimer that 'We are using Google Analtyic to Track information'?
Reporting & Analytics | | daracreative0 -
Unable to use Open Site Explorer
I have repeatedly tried to use Open Site Explorer on a site. I always get the same response:
Reporting & Analytics | | RyanKentNo Data Available for this URL The site is 4 months old. It is listed by Alexa in 1.3 million page category. The site ranks well on numerous key terms for the industry it covers. OSE offers 4 reasons for not having data: 1. Recency of page creation. In the explanation offered 45-60 days is the longest estimate it should take. The site has been live close to 120 days. 2. Deep down in the web. The tool doesn't even have any data for the site's home page. 3. Blocked pages. The site is listed in Google and these pages are not blocked. 4. No links. There are plenty of links. Site url is www.terapvp.com What can I do to fix this issue and get data?
0