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
-
Puzzled by high ranking page (#2 in SERPs) with zero/low page or domain authority
So, I get the smoothie that is page authority and domain authority and the link metrics that Moz uses to predict how well a page will rank for a certain keyword. I can look at a specific search term where we are on say, page 2 or 3, with a page authority of 1 and domain authority of 26, I get why competitors rank above us. But then I look at a keyword that is much more competitive, where we rank #2, which is awesome, where the landing page is also showing a page authority of 1, and domain authority of 26. How can we rank higher than competitors with a page authority of 56 and domain authority of 65? Their onpage optimization for the keyword is no worse, and sometimes better that ours but we maintain this ranking. By the way the competition also have hundreds if not thousands more linking root domains than our page. Any ideas why one keyword is a rockstar and one is a dud, with the same poor PA and DA?
Link Building | | seo-lab1 -
How to choose a third party agency to help with linking building / SEO strategy?
Hi all, we've not been link building for some time now as we are a small team and been concentrating on other things, such as getting our new look site built and implementing Magento etc. We've historically used external companies to help with link building & SEO... some experience has been good, some bad. Does any one have any suggestions on how a small company can try to choose a decent external company that can help with SEO strategies? There are a lot of options, a LOT of rubbish and a lot of very expensive large agencies that are well out side of our budget (or for a "small" fee simply produce a standardised report on "how to improve your SEO" that can basically be read on the net). We've tried local, smaller companies in order to limit our options .... but that didn't go well either. Any suggestions welcomed. Next is where / how to weight our expenditure and / or our SEO time. Should it be 50% gaining external links (be it by what ever means such as social, checking out where competitiors have links and chasing those possibilities etc) and then 50% internal page SEO, blog content creation, internal linking etc? Thanks again.
Link Building | | jasef0 -
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 -
My competitors all seem to use "junk" pages to rank / backlink, how to compete and not cheat
Hello, Page 1 of Google for the word "copier lease" and most other valuable copier leasing terms are dominated by the same 4-5 for organic (PPC too of course, but organic is what I want) They all use some SEO company, so when I go and look for good link oppertunities, most of the pages I find are just SEO companies who of couse would never be interested in a competitor's link. Examples: ajaxunion blogspot com or excellentpoly blogspot com and the list goes on, all just AjaxUnion "blog pages". blog homerenovationguide com /2011/06/15/repair-or-replace is just inhouse SEO making ranking pages for CostOwl. So, its hard NOT to want to throw up a blog farm and do as "the Romans do". What ideas do you all have to get backlinks in this market of Copier Leasing that would hold up. Thanks 6SW66.png 6SW66.png
Link Building | | einstein99992 -
How many days/hours a month should I dedicate to link building ?
I realise that the more time you dedicate to link building the better, but what would you say is the ideal amount of time that I should spend link building to see a significant improvement in rankings? The keywords I'm trying to target are medium to difficult. So far, I've been spending one day link building but since I'm making all link submissions manually, I haven't seen great results, even though I've been link building for a couple of months. How many days do you spend link building? Thank you in advance for your help! 🙂
Link Building | | SEOBunny_0 -
How do you check to see if your site (site A) has already been linked to by another site (site B) when you have a large site with lots of links
There are some basics in SEO relating to finding out about who has linked to whom that I could use some help with.
Link Building | | hughman0 -
How can I check a website to see if it is "nofollow"?
I'm a little new to SEO, so maybe this is obvious to some . . . I'm attempting to build backlinks by submitting articles, posting on forums etc. I just wrote my forst article for ezine and submitted it. I was feeling pretty good about myself until I mentioned it to someone trying to sell me their SEO services and he said that ezine articles are considered "nofollow" on all their links. Well, that was pretty frustrating to hear! It got me wondering, how many of these other sites have all their posts and blogs listed as "nofollow"? Is there a way for me to figure it out ahead of time? Obviously, there are only so many hours in the day and I would rather focus on posting on sites that will actually help me build backlinks! Thanks for your help in advance!
Link Building | | damon12120 -
Link building tools/sites
I am looking for a way to share my content in multiple locations to build back links without having to upload one at a time per location. For example- if i write an article and i upload it to ezine articles and then post it over on my blog- it will then post over on my twitter and facebook and linked in. However- how i can also get this article with back links into shared sites, bookmark sites, and other locations online to help build my inbound marketing for back links. I'm trying to find a way to save time while building out the links.
Link Building | | LauraThomas0