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
-
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 -
Will links from startup/tech blogs help a site rank for *money* keywords?
If a startup has a tech blog (say, domain.com/tech) and a startup journey blog (on domain.com/journey — think groovehq.com/blog), will garnering high PA/DA links to those pages help the root domain rank for keywords related to the startup's services? For example, continuing the Groove example, will quality links to their aforementioned startup blog help them rank the homepage for Online Help Desk Software? Even when those links are from non-helpdesk content on non-helpdesk sites? My theory is that links from high DA sites won't be a bad thing — as long as they're not from spammy pages and done naturally. In some niches, where it's hard to get organic product-related links, this might be a worthwhile strategy. Am I right? Or sadly misguided...? 🙂 EDIT: BTW. The niche I have in mind is fairly uncompetitive, and it'd be easier to garner links from the startup/tech community than the niche community itself.
Link Building | | brandrsn1 -
Dead/Broken links on old blogs
Hi We are currently trying to update our blog page on our website but quickly realized there are numerous dead or broken 404 links after clicking on anchor text from past blog posts. Our blog is set up in WordPress and we recently installed an SEO plug in with it. Some of these anchor texts don't actually need links and I want to unlink them, is there a simple way to do this on WordPress? Other anchor text I would like to "301 redirect" to another page. Can i do this on WordPress or is this something my SEO plugin should be able to fix? Answers are much appreciated! Thanks
Link Building | | SapphireCo0 -
External Backlinks - Should I remove/disavow external blog posts done by SEO company?
Last year my company hired an SEO company to build backlinks for targeted achor text keywords. It turns out that they wrote average to below average blog posts that had content related to my business, but that were placed on odd websites, not related to my business. They did this for about one year before I fired them. Should I try to get each of those blog posts removed and then disavow them? If the external links back to my site are nofollow then it is my understanding that I don't really need to worry about them...is that accurate? Is it too risky to keep any external backlinked content alive when it is on a site that is unrelated to my business?
Link Building | | ajgrossman0 -
Totally puzzled by link building/content marketing
Hey Mozzers! 🙂 I'm going to be starting link building for a website soon and I am having some trouble wrapping my head around a couple of things. First of all, in the current world of SEO, where should I be looking to generate links? Is it as simple as reaching out to bloggers and trawling through competitors links? Or is there something more? In relation to this, if I were to generate a good number of links from high authority sites, how would this effect my ranking for keywords (assuming the anchor text for those links is the website URL)? The other thing I'm a little puzzled by is, if I were to write a great article on the websites blog and it gains traction in social media circles, people would (I assume) only share a link to the blog post instead of the actual article itself. How would this effect the ranking of keywords that I have optomised (anchor text etc.) for in the article? I assume this is where guest blogging would come in? Any help would be HUGELY appreciated. I've been trying to logic this one out the last couple of days and just can't do it 😕 Thanks a lot to anyone who replies 🙂
Link Building | | CD_20161 -
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 there any tool in/or out of SEOMOZ where we can check anchor texts for internal/external links for a website?
I just want to check anchor text of all the links for a specific URL within a website
Link Building | | merkal20050 -
Links from Nextag/PriceGrabber
I have a eCommerce store over BigCommerce platform. It is possible to sell via Shopping Comparison Sites like: Nextag, PriceGrabber, Bizrate, Shopping.com, If I decide to advertise my products over those sites, will it be consider a trust link for Google? Our store is new and we don't have links referring to us, I need solutions. Also, there is a yellow pages site, http://www.yellowpages.ca/ that ask for monthly fees to advertise on there web site, advertising will be business name, addressee, phone number and web site, will it be a positive link for Google or just a paid link? This is our store: Furnace Filters Canada Thank you for your help and support, BigBlaze
Link Building | | BigBlaze2050