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:
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
-
Are there any reputable & affordable blog/article submission services nowadays?
Since the calamity of Penguin I know several article submission websites got a really bad wrap (many deservedly so). However if done carefully and legitimately I believe article promotion can still be a bona fide SEO link building tool. I currently have a client that has hundreds of good blog posts. We have done some modest article promotions via local news websites. However I feel like this content could use more of a push. Does anybody know of any reputable article/blog post promotion websites?
Link Building | | RosemaryB0 -
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 -
Networking sites / paid links
A national networking company charges its members, say, a few of hundred pounds to become part of their network, which involves offline networking events and online in forums and a directory. All the links of the directory and forum sigs etc are all do-follow. While it's not just a directory, how beneficial a link is this likely to be? The site itself has a DA of 60 and a PR rank of 4. 1k likes on their cnnected FB page and 21 likes on the G+. At the networking meetings they tell new recruits that being a member gives them a very valuable backlink and everytime they participate in the forums they get another do follow backlink. Ive checked and they are dofollow. Is this likely to be a great value link?
Link Building | | littlesthobo0 -
Are Links/Resources pages considered spam?
I'm dabbling with link building in a non link-happy industry, traffic safety (IE Traffic cones, barricades, safety vests, etc...). We currently are doing #RCS in terms of giveaways for college students as well as discounts in a wider EDU Outreach campaign as well as legitimate guest posting. I have started to use Link Prospector, and got a list of links/resources pages that we can get info from. I found some great links through here, including ways to get links from higher-profile .gov domains, but was wondering if it is worth it to go after the high(er) quality links/resources pages. By higher quality, I usually set a floor of a DA 25-30 and have a limited amount of external links per page. These would be for branded keywords (IE the company name/domain) and not exact match anchor text. I'd really like to see how other SEOs feel about this. Thanks Zachary Russell President, ProTech Internet Group
Link Building | | Zachary_Russell1 -
Why does my site only have 4 internal followed links/internal links?
When using Open Site Explorer my site is winning in many categories but lacking in others as compared to competitors. I intend to improve on this but am a little confused by the extremely low number of "internal followed links" and "internal links" at just 4. My competitors have much more than that. Does this mean links to the root domain? Total internal links? I have many internal links so I'm having a hard time figuring this one out. What four internal links are getting noticed? I just went through and changed all the links that went to index.html to link to the root domain at www.njlimocarservice.com as I just found a Q&A that indicates this was better. So as of Wed at 5:45 PM all my links to the homepage went to index.html and not the root which is no longer the case. Not sure if this matters. At the same time I also just put a 301 from index.html to redirect to www.njlimocarservice.com. Any help appreciated! h9QuF.png
Link Building | | kabledesigns0 -
What's Angela/Paul link profile?
Hi, Very new to this and appreciate your time to read and answer my question. What's Angela/Paul link profile? and what should I look out for if someone is offering to provide this type of link building to me?
Link Building | | nojan0 -
Domain/page authority - how long does it take so see results ?
Im new to the SEO and link building world. I have been building on my link building campaign over the last month or two but I am yet to see any changes in my domain/page authority. Is it because of the quality of the links, the directories I have been submitting in, webmasters maybe using "nofollow" tag ect. Or it generally just takes time to see the results? Is this even how domain/page authority is built. lol Any information on the topic would be greatly appreciated. Regards, S&M
Link Building | | Sexandmetal0 -
Where/should I post my press release/articles on my own website?
I have started a long-term article marketing campaign and press release distribution. I will have about 4 articles and press releases in total every month. Although the press releases will not be self-promotional, sometimes they will be talking about a certain product that we unveil. The question is, due to the high quality of these press releases, should I put them on my website as well as publish them on third party websites? If so, because they target a specific service/product which we already have a dedicated page on our website, wouldn't that put Google in the position of choosing between the two pages? I was thinking to put them on my blog and link internally from there with the keywords that I target on those pages as anchor text. The same question for articles. Any suggestions?
Link Building | | echo10