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
-
Very old site wanting a revamp - how to handle all the redirects/URL changes
Hi all, I have a very very old site, that requires a facelift (going from an old clunky CMS to wordpress). A problem I know I am going to face is that this site has a very poor URL structure (www.site.com/section/1/section/ etc) which I plan on cleaning up. but how do I handle the 100+ backlinks this website has point to such links? If someone could point me in the direction of an article or such that would be great. Thanks,
Link Building | | Greenroads0 -
Exchanging Follow/No-Follow Links with Parnter Site
Hi all, Wondering how Google would interpret the exchange of a no-follow link for a follow link between partner websites. I have a potential referral relationship with a business in my niche and we are hoping to cross-market. The goal would be for my link on his page to be a follow link, while the link to his business on my page would be a no-follow. Would my site get the benefit of a natural link in that scenario or would the two essentially 'cancel each other out' regardless of the follow/no-follow nature of the link? Thanks in advance for any help! -Rich
Link Building | | KingAir900 -
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 -
What tools/techniques you use to check if a domain has been penalized?
If we think to buy expired or otherwise dropped domains, what tools or techniques you would recommend to check if there has bad SEO history? We could of course, check with Google itself if the site is indexed and ranks, but I am asking if there is a particular tool out there that would provide more information if a website had been shady. Thanks so much, guys! Lily
Link Building | | wspwsp0 -
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 -
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 -
I cannot get any links indexed to this website http://atglimo.com.
I have written nofollow, follow links, issued a press release, and submitted to the Universal Business Listing. None of these links are showing in the Yahoo index. I did a nofollow bookmark with delicious and it disappeared the next day. The people that built the website will not grant FTP access and modded the HTACCESS file incorrectly to point to a WWW. version of the site. I had them remove the index.html duplicate content problem. What is going on? Why are no links showing in the index for this site?
Link Building | | eddie404ATL0
