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
-
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 -
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 -
My competitors all seem to use "junk" pages to rank / backlink, how to compete and not cheat
Hello, Page 1 of Google for the word "copier lease" and most other valuable copier leasing terms are dominated by the same 4-5 for organic (PPC too of course, but organic is what I want) They all use some SEO company, so when I go and look for good link oppertunities, most of the pages I find are just SEO companies who of couse would never be interested in a competitor's link. Examples: ajaxunion blogspot com or excellentpoly blogspot com and the list goes on, all just AjaxUnion "blog pages". blog homerenovationguide com /2011/06/15/repair-or-replace is just inhouse SEO making ranking pages for CostOwl. So, its hard NOT to want to throw up a blog farm and do as "the Romans do". What ideas do you all have to get backlinks in this market of Copier Leasing that would hold up. Thanks 6SW66.png 6SW66.png
Link Building | | einstein99992 -
How do you check to see if your site (site A) has already been linked to by another site (site B) when you have a large site with lots of links
There are some basics in SEO relating to finding out about who has linked to whom that I could use some help with.
Link Building | | hughman0 -
What Does Vary Anchor Text 80/20 Ration Mean - Have Idea But Only A Guess :(
What Does Vary Anchor Text 80/20 Ration Mean - Have Idea But Only A Guess 😞 If my anchor text is New York Real Estate - then it should vary using other words so what percentage should each page own anchor text vary ? Is it 80% anchor text and 20% non - anchor text EXAMPLE: 80%
Link Building | | helpwanted
NEW YORK REAL ESTATE 20%
XYC COMPANY
BUY A HOUSE
SELL A HOUSE
CLICK HERE0 -
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 -
Charity / Donation - Website and SEO
I have a prospective client looking to do SEO- they are a charity and have a fixed one time budget. (The budget is surprisingly high) They are looking to have their site ranked for "charities in (our city)" and "dental charities" and any keyword variations. Adwords shows significant search volume and ranking difficulty is moderate per SEOmoz keyword difficulty tool. On page will be fairly simple and well handled, but am looking more towards the authority and link building. I am going to tackle 3 top quality directories, Yahoo, BOTW, and Business.com (as well as DMOZ but i've never had luck). But was wondering if there were any other nationally recognized sources that mozzers know about that would be a good place to start to get some links to the site. The organization is a clinic that provides free dental work to veterans. I have never handled SEO for a charity before, and my first instinct is that getting a link to the site will be much easier to get than if I ask them to give money to the foundation, so they would be glad to do it. Any other guidance would be appreciated. And I can give more details if necessary. Any other tips and insight would be appreciated. Thank you! Ian
Link Building | | itrogers0 -
Should You Avoid Links from Sites with Big Difference Between PR and MozRank?
If a site has a Google toolbar PR of 2 and a Mozrank of 5, does that most likely mean that the site is penalized and a link would probably provide little value. I know that Google rarely updates toolbar PR so I suppose the site could have also earned a lot of quality links since the last update. Thanks Mozzers!
Link Building | | SparkplugDigital0