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
-
Can we use Free domains (like .cf / .tk / .gq / .ml / .ga) for backlinks?
many times I Noticed that most of the website use .cf / .tk / .gq / .ml / .ga this domain for backlinks but when I click on this it shows me the error I want to know that how they get a do follow backlink from the Different free domain can I get backlinks from my free domain? if this possible then How? This is my website Pakistan News kindly tell me how to rank.
Link Building | | Zaidazam0 -
Best way to check/find lost links?
Hi all As everyone, we have seen a decrease of domain authority and external links during the last months. with open site Rand is explaining the reason in this in this post, but I still would like to have a look to the links that in theory I have lost during the last months. I thought Majestic was the best option but I have been trying to get the info and I see nothing clear. When I download the fresh or history links, I only see links that are live (in theory, because in history I get a lot not existing but I can not see it without a manual check). The option of lost links is just giving me 1000 links per day, but after downloading some and checking I see that this lost link report is showing me links that are working (but it looks that majestic couldn't access when they did the crawling and show them as lost). Also the numbers of lost links are totally different if you use fresh or historic... Anyone could recommend me a good way to find out links that I really lost? Thanks
Link Building | | AutoEurope1 -
Best way to regular check backlinks & identify low quality and spammy links?
Previously my site was under manual penalty and then 80% of the links i removed and my penalty lifted. ( I am talking about 1 year before) Now i have few queries - What is the best way to regular check backlinks? what to do if a spammy link appears What to do about directories that link to us What to do with old links that are not good quality Now I have to check number of links and quality of links of website so which is the best method check? Thanks! dev
Link Building | | devdan0 -
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 -
Google disavow DMOZ/ODP spam sites?
Hello Looking into links to my one of my sites (over 10 years old) I've found that along with some bad spammy links, around 80% of my inbound links are from directories that are exact copies of ODP. Should I be concerned about / asking for removal / disavowing these links? Normally I would be trying to get rid of low quality links like this, but since they are ODP clones I'm not sure it's worth the effort. The sites openly state that their data is from ODP (Open Directory Project), but does this mean Google ignores them? I could spend my whole life swatting these links. Thoughts? Edit: I'm hoping for suggestions that specifically reference the ODP clone site situation. I did not create these links, I guess I should have made that more clear.
Link Building | | droo0 -
One folder/keyword seems penalized.
Hi, One of the keywords i am optimizing for seems to be penalized. We are selling childrens clothes and we have 1 folder/url for each producer/designer. Main page is strong compared to competitors and we are ranging 1st for 2 most important keywords. Most of our other producer pages are ranking 2nd-4th. I took some time to rank and I had a some catalogues(hotvsnot, addsitelink, webzdirectory, 3 blogs) link into this specific folder some 3 months ago. It didnt seem to rise in ranks staying in range 12th-23rd spot. Which seemed sort of weird to me. 2 Days ago it dropped to around 120th spot. No other pages on site dropped. Looking at it now I do see that its almost 100% 'producername' in anchor text which i guess is the reason for the ranking problem and maybe the drop in rankings a couple of days ago. Blog links are completly natural, catalogues are not i guess. The total sum of links doesnt seem natural because the anchor text is same on all. Still its not that unnatural if you sell nike shoes to have a catalogue called nike and the anchor text to be pointing to it to be nike, but still. So my question is: do i try to change anchor text in catalogues or have them completely removed ? Do i get blogs etc to link to my site using an other word than the producer name that might seem less natural ?? Thanks for your help.
Link Building | | danlae0 -
Should I optimize/link build all my pages at once?
I'm currently starting to optimize about 30 area specific pages for a property maintenance company and was wondering, what's the best way to link build multiple pages at once? Should I link build for all of the 30 the pages at once, or maybe focus on 5 individual pages - get them ranking well, then focus on the next 5 and so on?
Link Building | | guy_andrews0 -
Do-Follow link from Linkedin/Facebook/Twitter/About/Google Profile, how to:
Tell us, a technician method of building do-follow link on high quality social websites. Thanks
Link Building | | leadsprofi0