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
-
Impact on backlinking with https://www.domain or https://domain
Hi, this questions have bugging me for a long time now; we check our website how is indexed on Google and we see that we have most of the backlinks for URL https://www.speedhub.eu , but 15% are linked to https://speedhub.eu , in the past we had our website for http requests redirected via 301 htaccess to https://speedhub.eu without giving it importance, now we have it with www included. Bottom line questions: Is it important if your links are with www or without www, do you lose "link juice" by splitting your backlinks via links with www or without www ? Does Google make a difference for domain positioning via this criteria ? Best regards,
Link Building | | SPEEDHUB_eu0 -
Should blogger award badges/links be nofollowed?
I'm pretty sure the answer to this will be a big yes. Obviously this is a tactic that can be gamed quite easily, but I wanted to know if there are any clear guidelines on this. We've done a post about the most influential food bloggers using our own tool, so there's proper data behind the top ten. We wanted to reach out and let them know, give them a badge to include that might drive a bit of traffic and raise some brand awareness. That's why the question has come up as we want to make sure we advise the bloggers properly if a nofollow is best practice.
Link Building | | joshuaboyd0 -
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 -
List of PDF/Power Point publishing sites
Hi, I need advice on collecting links for PDFs/Power points docs. Apart from slideshare, can you please recommend places where I could collect links? Thank you!
Link Building | | Rubix0 -
Is commenting on other peoples blogs / articles good for seo?
Hello everyone, Just a quick question, say if I find some websites which are relevant to my service and they have articles I can comment on and include my URL , will these help for SEO? The websites also have a good PR rating higher than 3 does this count towards anything? Would these links be classed 'follow' or 'nofollow' links - could something please explain what this means aswell. Thanks very much!
Link Building | | vanplus0 -
The best way to spend 4 hours/day on offsite SEO?
I have an assistant who is able to do 4 hrs of SEO work for me every day. I don't have much onsite SEO work for him to do, and he's not skilled for social media management, so I'm thinking the best thing to have him do is manual link building. So far I've had him create a spreadsheet of more than 1,000 blogs and directories that relate to the subject matter of our websites, and had him include the domain authority of each and if they use the "nofollow" attribute on their links. Next I will have him start adding comments/submissions that include links back to our sites, starting with the highest DA sties and ones without the "nofollow" attributes. Do you agree this is the best way to have him spend his time? Are there other tasks you would highly recommend? Ryan
Link Building | | GreenHatWeb0 -
Http://fiverr.com is good for seo to buy services?
fiverr.com is good for seo to buy services? Can you recommend best seller?
Link Building | | surajrathore0 -
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