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
-
Why have I lost 1/3 of my backlinks (about 5,000) in 3 months?
In August, my client's site (I work at a marketing agency) had about 15,000 backlinks. Now they suddenly have about 10,000 backlinks. And their Domain Authority has dropped from 48 to 40! Can someone please help me understand what could've happened? At first I assumed this had something to do with the latest Penguin update, since I knew my client's site had some extremely spammy backlinks they hadn't cleaned up yet. (The site was hacked at some point and hidden pages were created as part of some kind of link-building scheme, and there were lots of links from sketchy sites to those pages. The hidden pages have been taken down and the URLs now redirect to my client's home page.) But that would only explain a sudden drop in Domain Authority, right? How could Penguin suddenly cause my client to lose 5,000 backlinks? And if it's not Penguin, what could it be? Thanks in advance for any insight that anyone can share!
Link Building | | matt-145670 -
Can internal links cause Google to penalize me for key terms/phrases?
For example, having a link on many pages (so dozens of links in total) using a product name, all pointing to that product page. Could Google see that as "spammy" and penalize that product page in the SERP's? Note: My product page has been penalized for the search term "Product Name" and there are no external links pointing that page using the product name as a term. This is new with the latest Panda Updates.
Link Building | | absoauto0 -
Site received penalty, Traffic restricted to 3-4 visits/hour
Dear all We received a penalty notice at webmaster tools 2 months ago, in that stated "your pages violate our quality guidelines" and "contain some inorganic links to your site". Ours is a Coupon website and tried to follow all quality guidelines given in webmaster central. Also we tried to identify and remove spam kind of links and still we are working on that. Suddenly from yesterday website traffic restricted to 3-4 visits/hour, but website main keyword SERPs are not changed much and still ranking at good positions. my question if any website is under manual penalty, it's traffic will be restricted by Google???. Every link we build manually and not gone for any paid links or reciprocal links. But the sites given some links as sitewide, example we tried to get a back link & submitted url at once only, but it was showing in webmaster Total links 468 and linked pages 1. Can any one please explain, how it can happen?. We are trying to remove these spam kind of links, but from directory owners response is a bit disappointing, kindly any one suggest that, will Google Disavow tool help in this regard and how much time it will take to nullify the links?. Kindly help us..Thanking you all in advance
Link Building | | Shashidhar.SEO0 -
Is there any good tools for toxic link checking.
I have done a manual link audit and made a good, bad and not sure list. Is there any tools I can run over the list to see if I missed anything and help me decide what to do with the not sure list?
Link Building | | mark_baird0 -
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 -
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 -
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 -
How do i create a link.i am not a developer/programmer
I am a business owner with multiple websites and have an SEO company doing my work for me, i am eager to learn how to help my websites myself also. i want to know how i can create a link my self in my blogs to other relevant content on our websites. i understand anchor text, i just dont know how to actually create the link????
Link Building | | corgi0