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
-
Best Name for Business and Backlinks / SEO
Sorry if this is a basic question I should know the answer for. We have just acquired the .org for a moderately well searched keyword set. Our objective is to fight for rank specifically on this one set of two keywords. We want make sure our site is setup and business named optimally for this. Here is my question. What is the best business name for SEO and keyword rich backlinks, or anything else I'm not thinking of? KEYWORDS: Blue Widget DOMAIN: BlueWidget.org BUSINESS NAME OPTIONS: A) simply BlueWidget.org. We like this but do we lose some benefit of "Blue Widget" with a space on backlinks? **B) Blue Widget Foundation. Is this better because people will reference us by the keywords with a space "The Blue Widget Foundation", instead of "from the people at BLUEWIDGET.org"? ** Am I missing anything important here in the name? We just want to start everything off on the right foot. Thank you Moz. Just joined and my first post.
Link Building | | RetBit0 -
How can I tell if a site is trustworthy and is not / hasn't been penalized by Google?
Hello Moz Community, I'm looking to do some link building for a client and I would like to know if there's a way to find out if a website is trustworthy and is not or hasn't been penalised by Google. Thank you.
Link Building | | CosminC0 -
Beginners question about co-location/citation
Hi, could any fellow users lend me their experience please, I feel I may have confused myself!! Cut a long story short, one of the seo techniques I (like many here) employ is guest authority for sites. This is done through a manual process on quality sites. However, many sites are panicking now about Google and are nofollowing the author link back to my site. While the guest blogging wasn't done exclusively for links, a backlink is always nice. This got me onto the topic of co citation. From what I understand, it is essentially google rewarding you but without giving you back link credit. This is no the area where I have confused myself...am i right in thinking that if my brand is talked about in content on a quality site about Internet Security, then google can see the mention of my brand and will still award me some benefit from. To gain said benefit from the content is it enough that my brand is mentioned, for example 'Brand X published a paper about keeping kids safe online in 2013' or would the brand x thing need to be an active link to my site (no follow). Does this make sense? I did warn that i have managed to confuse myself hehe Many thanks for firstly talking the time to work out what on earth I have written and for any feedback offered.
Link Building | | carl_daedricdigital0 -
Thoughts on creating a resource/recommend links page in order to attain links?
Hey guys, Just wondering, how does Google view reciprocal link building nowadays? I've heard in the past that it's something that Google isn't particularly keen on. However, more recently, I've also read that - as long as the links are decent (and in moderation) - link exchanging is by no means a bad thing. The reason I ask is that I'm thinking of creating a "resource/recommended links page" for a client of mine. Because of their industry, it's really apparent that attaining links is often only possible if there is the opportunity of a reciprocal link in return. Therefore, I'd need to have a resource/recommend links page of my own. Is this something I should go ahead with to make it much easier to attain links? Or should I try to avoid reciprocal links and attempt to pinpoint one-way linking opportunities - even if they're thin on the ground? Any help much as appreciated as always. Cheers.
Link Building | | Webrevolve0 -
Does Google drop links from page rank N/A sources?
Hi Everyone,
Link Building | | AMA-DataSet
I've started doing some link analysis on one of my site that has over nearly 800 links in total (which I got from the webmaster tools downloading the latest links). When I go on to Google and use the "link:www.mysite.com" directive it will only display 12 links. Does this mean Google is only counting 12 links from the link profile? Iv checked the freshness of some the links it wasn't displaying within Google to check they hadn't all expired. Links from march 2013 still don't appear. This sites link profile has been untouched for at least a year now and is full of directories many of which have a page rank of N/A hence my question. (I'm surprised it hasn't been hit by penguin!) Thanks in advance.0 -
About Paid Ads/links - Question
My name is Benny, i am writing here from account of my uncle, because he is a pro member, and i am a student dont have money to pay premium package. Now, I have placed some ads/links on a strong domains, for about 8 months, i paid always, but about 6 weeks i was sick, on hospital, and i have forget to renew the links, and now are removed, and ranking down too. My question is, can i restore the links with same anchors on the same places again on the same sites, or what to do? it's this danger if a link was for a 6 weeks down, and now again to re-place, some of them are 3-4 weeks,and some 6 weeks, it's this danger to replace again or not? What do you suggest me?
Link Building | | leadsprofi0 -
How is it a root domain can have a high mozrank but a low DA?
I know a site that has a DA51 but the mozrank is like 5.95 I thought the same components made up those rankings? Can someone explain the difference?
Link Building | | joemas990