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
-
Confused over PRWeb and it's Moz PA/DA
Hi I was looking at using PRWeb for some link building, however I have read quite a few articles bemoaning it and saying it carries very little, if any weight with Google. I am therefore confused that in Moz it has a DA of 90 (!) and a PA of 38, with a spam score of 1%. Are these negative articles wrong...is Moz ranking it wrong...or have I got the wrong end of the stick somewhere along the line?! Thanks Bob
Link Building | | BobBawden10 -
Googles stance on Back Links via a Badge/Form
Hey guys, Does anyone know what Google's stance is on backlinks that come via a form, WordPress theme or badge. For example if I offer website security and provide badges for websites that are malware clean (with a back link to my website) and 100 websites sign up to my website will this be deemed as bad practice in Google's eyes? Also if I create a free WordPress theme with a backlink to myself? The second question sounds like I'm providing content for a link which seems okay but the first one can go either way. Thanks
Link Building | | conversiontactics0 -
How to check inbound link quality?
We're reaching out to various communities to do some link building at the moment and were wondering what people did to confirm that the links are from quality sources? We don't want links from bad neighbourhoods or sites which have had penalties applied against them etc... What tools can we use to find this out? Thanks in advance for any replies!
Link Building | | agencycentral0 -
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 -
Is a no-follow link/sponsored link a good editorial link?
Ok maybe this is a dumb question. I really need some better, more quality backlinks pointing to my site. There is a site that has domain authority of 72, page rank 5 that is offering me a sponsored blog post. Do sponsored posts count as a good editorial link? Also what if they are no-follow (and how would I find out ahead of time), does that still give me link juice?
Link Building | | tutugirl0 -
How do I get the most links out of one QUALITY article/post??
Basically we are a small business (2 employees) we don't have the time or resources to be writing hundreds of original quality articles each week (nor do we have the time to write endless guest blogs each week) how do we gain links from one article? (not including poor quality article submission sites) And how do SEO's write so many guest blogs? for the returns on time invested!!! Confused Newbie, thanks in advance!!!
Link Building | | Buzzwords0 -
Is it possible to check domain authority for a list of 100+ domains at once?
Well, as topic. I have a list wih a bunch of domains, I want to sort them by DA. Is this possible in some quick way?
Link Building | | ToiletFish0 -
About Paid Ads/links - Question
My name is Benny, i am writing here from account of my uncle, because he is a pro member, and i am a student dont have money to pay premium package. Now, I have placed some ads/links on a strong domains, for about 8 months, i paid always, but about 6 weeks i was sick, on hospital, and i have forget to renew the links, and now are removed, and ranking down too. My question is, can i restore the links with same anchors on the same places again on the same sites, or what to do? it's this danger if a link was for a 6 weeks down, and now again to re-place, some of them are 3-4 weeks,and some 6 weeks, it's this danger to replace again or not? What do you suggest me?
Link Building | | leadsprofi0