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 -
Are charity/sponsorship links good, bad or just useless?
Some facts: We will probably only doe this 2-3 times a year (we have hundreds of links coming in each year from organic sources). This is for a really prestigious charity website with very nice link profile from other non-profits, news organizations, and even government websites. We will get a logo on their sponsorship page, with a link back to our site. Some articles say Google considers this "buying a link" and will therefore penalize you. Or at best, this will have no effect. And here's a Search Engine Land article saying the exact opposite. $1,500 is a lot of money. So I just want to make sure I'm not wasting it -- or worse -- getting penalized.
Link Building | | Brand_Psychic0 -
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 -
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 -
Puzzled by high ranking page (#2 in SERPs) with zero/low page or domain authority
So, I get the smoothie that is page authority and domain authority and the link metrics that Moz uses to predict how well a page will rank for a certain keyword. I can look at a specific search term where we are on say, page 2 or 3, with a page authority of 1 and domain authority of 26, I get why competitors rank above us. But then I look at a keyword that is much more competitive, where we rank #2, which is awesome, where the landing page is also showing a page authority of 1, and domain authority of 26. How can we rank higher than competitors with a page authority of 56 and domain authority of 65? Their onpage optimization for the keyword is no worse, and sometimes better that ours but we maintain this ranking. By the way the competition also have hundreds if not thousands more linking root domains than our page. Any ideas why one keyword is a rockstar and one is a dud, with the same poor PA and DA?
Link Building | | seo-lab1 -
When/ What Links to Disavow?
We have an older website started in 2000. We have thousands of backlinks which we believe are hurting us. Starting with Panda our site has been devastated, traffic wise, from a million + page views a month to 1/3 of that now. We've never solicited links, never paid for them, they just happened. It seems every "search engine" and spammy site on the web has links to us. Hundreds if not thousands from sites like , 29searchengines.com, 55 searchengines.net, and on and on.. 1. How does a site know when the links are harmful?
Link Building | | foodsleuth
2. How do you know which links should be disavowed? Thank you0 -
List of free directories for building / real estate website.
Hi Any suggestion where to source a list of free directories for a property / real estate company which gives reasonable linkback juice Thanks Peter
Link Building | | peterds0 -
Link Analysis Quality Issues / Concerns?
I'm currently using OSE to find out where some of my competitors are getting links. The intention is to find new link opportunities. What i'm finding is A LOT of directories. It seems like for every 1 good link opportunity I'm getting 9 directories. These directories are easy links, but my main worry is quality. Should I be obtaining these links or skip over them?
Link Building | | Hyrule0