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
-
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 -
How many ways to use Event in Google Tag Manager for Event Tracking?
Hello Experts, How many ways to use Event in Google Tag Manager for Event Tracking? As per me there are 5 ways given below are they correct? 2nd thing if yes can you please please tell me procedure of using all or which is the best one to use? HTML 5 Data Attributes Classic Google Analytics Example: _gaq.push(['_trackPageview', '/downloads/pdfs/corporateBrief.pdf']);
Reporting & Analytics | | bkmitesh
3) Universal Analytics Example: ga(‘send’, ‘pageview’, ‘page path’); query string? or is it possible without any coding on website we can configure id's in google tag manager? Thanks! BK Mitesh0 -
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 -
Using advance segments or primary dimensions?
Hi guys, I haven't played around with advance segments enough to know the answer to this, so looking for some help. What I want to track is a keyword through the whole analytics, so I created an advance segment for "KEYWORD". This segment is Include - Keyword - "KEYWORD". Now when I remove the advance segment and do the following: Traffic Sources - Organic - Primary Dimension - Keyword - "KEYWORD" The amounts of visits differ a lot. I'm guessing this has to do with sessions? Looking for a clarification on this.
Reporting & Analytics | | William.Lau0 -
Using Regex for Goals in Google Analytics
I’ve got a website with 20 different forms; and I’d like to track all 20 form completions with one Goal in Google Analytics. The completion-page URLs follow the pattern below (the website uses Drupal CMS) Form One: www.acme.com/node/2990/done?sid=651 Form Two: www.acme.com /node/2991/done?sid=785 Form Three: www.acme.com /node/2992/done?sid=1021 Form Four: www.acme.com /node/2993/done?sid=459 I believe that there is a way I can use regex so Google Analytics will track if any of these completion URLs appears. Looking for guidance how to format the regex statement.
Reporting & Analytics | | TopFloor0 -
Do I need to turn off custom results or empty my cache before using the SEOMOZ Pro Rank checker?
I'm getting unusual swings in SERPS ranks from one day to another (I had several keywords ranked in top ten go to the the third or fourth page in a week). I knwo that there's always variation because of localized and custom search, but this seems to be something more.
Reporting & Analytics | | bbelgard0 -
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