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
-
Is the meta referrer tag still used
Is the meta meta referrer tag still used and is it affective. I have an issue with traffic going from one of my sites to a client site and our referral is going into their direct traffic (in Googel Analytics) instead of being seen as a referral from our site. I saw that people were using the meta referral tag, but I can't find any MOZ info about it other than a blog article from 2015.
Reporting & Analytics | | dpsoftware1 -
How to filter out traffic from subdomain using regex?
Hi There, We have a test server that lives on a subdomain which we'd like to filter out in Google Analytics. We're using the hostname filter but are having trouble understanding the regex needed, we're using this as the filter pattern: .domain.com. Will that work? The profile is new so we can't test the pattern. Any pointers in the right direction would be much appreciated. Cheers Ben
Reporting & Analytics | | cmscss0 -
Page Tracking using Custom URLs - is this viable?
Hi Moz community! I’ll try to make this question as easy to understand as possible, but please excuse me if it isn’t clear. Just joined a new team a few months ago and found out that on some of our most popular pages we use “custom URLs” to track page metrics within Google Analytics. NOTE: I say “custom URLs” because that is the best way for me to describe them. As an example: This page exists to our users: http://usnews.rankingsandreviews.com/cars-trucks/Ram_HD/2012/photos-interior/ But this is the URL we have coded on the page: cars-trucks/used-cars/reviews/2012-Ram-HD/photos-interior/ (within the custom variance script labeled as “var l_tracker=” ) It is this custom URL that we use within GA to look up metrics about this page. This is just one example of many across our site setup to do the same thing Here is a second example: Available page to user: http://usnews.rankingsandreviews.com/cars-trucks/Cadillac_ATS/2015/ Custom “var l_tracker=” /cars-trucks/2015-Cadillac-ATS/overview/ NOTE: There is a small amount of fear that the above method was implemented years ago as a work-around to a poorly structured URL architecture. Not validated, but that is a question that arose. Main Questions: Is the above implementation a normal and often used method to track pages in GA? (coming from an Omniture company before – this would not be how we handled page level tracking) Team members at my current company are divided on this method. Some believe this is not a proper implementation and are concerned that trying to hide these from Google will raise red flags (i.e. fake URLs in general = bad) I cannot find any reference to this method anywhere on the InterWebs - If method is not normal: Any recommendations on a solution to address this? Potential Problems? GA is currently cataloguing these tracking URLs in the Crawl Error report. Any concerns about this? The team wants to hide the URLs in the Robots.txt file, but some team members are concerned this may raise a red flag with Google and hurt us more than help us. Thank you in advance for any insight and/or advice. Chris
Reporting & Analytics | | usnseomoz0 -
How to configure custom dimension and metric in UA using with and without GTM
In universal analytic we can use more than 20 dimension and metric so can anyone tell me how to configure such feature 1) with google tag manager 2) without google tag manager. Like i read to this level - http://imgur.com/kjA4I91 but dont know what to do further? Regards, Jackin
Reporting & Analytics | | jackinmathis10 -
Why seomoz shows me "missing meta discription" on this plugin: http://villasdiani.com/wp-content/plugins/dopbsp/frontend-ajax.php ? Should I edit? how?? IIs it posible??
Good day to all! I am very confuse about results on seomoz Crawl Diagnostics Summary, especially with 6 Crawl Warnings Found. It says title too short: http://villasdiani.com/category/mombasa/, http://villasdiani.com/category/watamu/ , http://villasdiani.com/sitemap/ why would Google punish me for this??? why should I make longer title for sitemap? or Watamu? It is the name of the place - Watamu or Mombasa. It is very confusing for me. I have very big mess with the website and it is not ranking:-( what I have done:-( and is it possible to meta description for this plugin: http://villasdiani.com/wp-content/plugins/dopbsp/frontend-ajax.php how?? I even do not know where is it.
Reporting & Analytics | | VillasDiani0 -
When i first add my url to seomoz then i had a general report of all the faults my website had in SEO and suggestions where can i find it now , i cant find it ?!
when i first add my url to seomoz then i had a general report of all the faults my website had in SEO and suggestions where can i find it now , i cant find it ?!
Reporting & Analytics | | fireproductsuk0 -
Blocking our IP's but wondering if Google still uses our search data?
The company owner here has our (company) website as his home page. I excluded our static IP’s on Google Analytics, but is that good enough to keep Google from using his search traffic as an indicator of anything negative. Does Google still take into account his activity, but simply block it from my reporting? Finally, does one person actually have that kind of influence as far as time on site, bounce rates, etc. Should I convince him to find a new home page?
Reporting & Analytics | | Ticket_King0 -
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