How to check Mozrank and/or Moztrrust in Bulk
-
Hi guys,
I've been scouting the web and the SEOmoz forum to look for a way to check the Mozrank and/or Moztrust of urls in Google docs or Excel. I know Chris Le wrote a post about this but I want to check ~ 2000 links. Is there a way to do this easily in a spreadsheet?
Regards.
-
Thanks guys, very helpful advice.
-
Thanks for your answers
It worked!
-
Hi,
Yeah I seem to not be able to get past 100 now for some reason. I remember I had some luck with this excel add-on in the past. I think it limits to 1 request every 10 seconds so if you have a big list better to leave it run over night, but it does the job and gets the data into excel so worth a shot!
http://www.businesshut.com/seo/seomoz-mozscape-add-in-for-excel/
You could also check out the seogadget excel for the moz api, I have not managed to give it a good go through, but it should also be able to do the job:
http://seogadget.com/mozscape-api-extension-for-excel/
Hope one of them helps!
-
Thanks for your help. It works but somehow I can't check it for more then 50+ links. So I manually copy paste all the urls. Is this because of my pro membership level? I have a normal PRO membership. I hope there is an other way because I want to check it for around 1980 links :-).
Thanks for your patience.
-
Hi,
So if you have a list of urls in the A column and the A1 field has a title 'urls' or similar then you select the B1 field and in the formula box (fx) up top you can put something like
=getLinkscape(A2:A92)
Which will pull the data for the urls listed from the fields A2 - A92.
I have found that you have to have a multiple of 10 so you don't get a timeout error, I think the script bunches the urls into groups of 10 and it seems to have an issue if there is an odd number. So if you have 99 urls, add another one to make a round multiple of 10!
You can see some more tips here: http://www.seomoz.org/ugc/updated-tool-seomoz-api-data-for-google-docs
Hope that helps! Its a really useful tool.
-
Hi Lynn,
I know how to add the Api credentials but how do I make a code that shows me the mozrank, DA, PA and moztrust in bulk?
-
In Google Docs you can do this using the (awesome) Seer Interactive Toolbox, check it out here:
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
-
Site received penalty, Traffic restricted to 3-4 visits/hour
Dear all We received a penalty notice at webmaster tools 2 months ago, in that stated "your pages violate our quality guidelines" and "contain some inorganic links to your site". Ours is a Coupon website and tried to follow all quality guidelines given in webmaster central. Also we tried to identify and remove spam kind of links and still we are working on that. Suddenly from yesterday website traffic restricted to 3-4 visits/hour, but website main keyword SERPs are not changed much and still ranking at good positions. my question if any website is under manual penalty, it's traffic will be restricted by Google???. Every link we build manually and not gone for any paid links or reciprocal links. But the sites given some links as sitewide, example we tried to get a back link & submitted url at once only, but it was showing in webmaster Total links 468 and linked pages 1. Can any one please explain, how it can happen?. We are trying to remove these spam kind of links, but from directory owners response is a bit disappointing, kindly any one suggest that, will Google Disavow tool help in this regard and how much time it will take to nullify the links?. Kindly help us..Thanking you all in advance
Link Building | | Shashidhar.SEO0 -
Is commenting on other peoples blogs / articles good for seo?
Hello everyone, Just a quick question, say if I find some websites which are relevant to my service and they have articles I can comment on and include my URL , will these help for SEO? The websites also have a good PR rating higher than 3 does this count towards anything? Would these links be classed 'follow' or 'nofollow' links - could something please explain what this means aswell. Thanks very much!
Link Building | | vanplus0 -
Bulk keywords is useful for website?
currently i saw a lot of website using tag or related function to add in bulk keyword to their site with unrelated keyword? will it useful? why they do like this? there have tons of keywords if you click in for e.g http://www.aliexpress.com/product.html there have tons of keywords if you click in Please give some suggestion if this way useful?
Link Building | | willy660 -
Best way to set up a support site - sub domain, separate site or com/support?
My company is setting up our support site. It has been suggested that we set it up as a separate domain - www.company-support.com, rather than setting it up as a sub-domain (www.support.company.com) or the usual www.company.com/support. The person who proposed this believes it wlll create link juice, but i wonder if splitting the traffic will create more harm than good? Opinions please!
Link Building | | googilvie0 -
Submitting my URL on web/business/service directories
Does it make sense to submit a business URL in as many relevant web/business directories as possible when kicking off a link building campaign? Submitting a free listing is obviously better than nothing, but when does it make sense to pay extra for a premium listing profile on some of these directories? There are just so many and a lot of them appear spammy, even though some of my competitors are getting traffic from them. Any advice on this would be great!
Link Building | | TheSquareFoot1 -
Link Analysis Quality Issues / Concerns?
I'm currently using OSE to find out where some of my competitors are getting links. The intention is to find new link opportunities. What i'm finding is A LOT of directories. It seems like for every 1 good link opportunity I'm getting 9 directories. These directories are easy links, but my main worry is quality. Should I be obtaining these links or skip over them?
Link Building | | Hyrule0 -
Is there way to identify all back links throughout a site or do I have to check one site page at a time? Thanks!
Sorry if it is obvious, but I can't seem to figure it out. I'd like to be able to run a report that will list all of the back links on every page of my site.
Link Building | | TRCCommunications0 -
Does getting reblogged on Tumblr offer any positive/powerful backlinks?
This would be under the assumption that our company blog was hosted on tumblr.
Link Building | | twin88850