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
-
Using logical operators (AND / OR) in Google Analytics Goal Funnels
When setting up a Funnel within Google Analytics, is it possible to use logical operators (e.g. OR, AND) in the first (required) step of the funnel? For example, suppose I want to track users who visit page1.html AND page2.html before proceeding to the destination goal. I've entered two pages separated by the OR operator, and neither the "Verify this Goal" nor "Save" produces an error message - is it safe to assume that this is working as I intend? Thanks in advance!
Reporting & Analytics | | ahirai0 -
Using Canonicals on category or link pages
Hey, If a site has category or tag pages showing in search results for a particular keyword - sometimes higher than the page you would like to rank - could using canonical redirects on categories and tags be a solution? Thanks
Reporting & Analytics | | wearehappymedia0 -
Can you use an advance segment as a metric or dimension for another advance segment in GA?
I have 3 advanced segments set up: Branded keywords Non-branded keywords (all) irrelevant non-branded keywords. irrelevant non-branded keywords are keywords where the visitor is not ready to purchase. for example keywords including terms such as "ideas" or "how to".. these have generated 0 conversions for us, and I want to track these separately from keywords that have a chance in converting, since the conversion rate between the two groups vary a lot. for the advanced segment "branded" - i listed a listed of keywords pertaining to the company name - using includes, Matching regexp and | (pipe) between keywords for advanced segment "non-branded keywords" - i took the same list and excluded matching regexp | between keywords. **for advanced segments "irrelevant keywords" ** - i took one word as the keyword and used includes, contains, and the keywords.. using OR statement between keywords. pipe doesn't seem to work with the "contains", and only seems to work with "matching regexp". **What i want to do is excluded all items from "Irrelevant keywords" in advanced segment "Non-branded keywords". but i can't seem to exclude based on another custom segment. **nor can I list - [X statement OR (statement y OR statement Z OR statement AB)] any thoughts on handling this logic?
Reporting & Analytics | | S.S.N0 -
Anyone notice a drop in results using site operator?
I set our site's preferred domain back on January 28. We had a www and non www domain being indexed. Since then, I've seen the number or results for our site site operator (site:) decline dramatically. Not sure if this is a good thing or bad thing. So, I'm trying to see if it's unique to our site. My gut is that the numbers are probably leveling out to where they should be and the duplicates are falling out, but I would think that as I see number of results for non www decline, the number of results for www would increase. Any thoughts? Anyone else seeing fluctuations in results using site: ? Lisa
Reporting & Analytics | | Aggie0 -
What are the top free tools to use in SEO (apart from SeoMoz of course)
Hi guys, Can you point me the best free tools you're using for SEO (link building, etc.) - apart from SeoMoz - I'm kind of newbie in that area and in a discovering process. Thanks !
Reporting & Analytics | | zedisdead0 -
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 -
Using Clients GA account for their over all website to Optimize Their Blog? or is there a better way to compare apples to apples
I would like to optimize my clients blog. If I am using their GA account for their over all website but put in the sub folder for SEOMOz, will it detect that I only want to optimize the blog ex. http://xxx.com/blog or will I be seeing the GA for the entire site on SEOMOZ?
Reporting & Analytics | | CliffordC0 -
Why doesnt Seomoz give daily ranking updates
Although a little obsessive I can't be the only one checking rankings on a daily basis. Indeed if such a practice was not widespread then software such as linktracker wouldnt exist. It's a shame that Seomoz has the functionality to check rank, however chooses to only do so once per week. Therefore we pay for tools such as link tracker in addition to Seomoz. Here starts a petition for daily updates!!! 😉
Reporting & Analytics | | seanmccauley0