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
-
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 -
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 -
Multiply Sites / Back Links / i.p Address ?
Hi We are building a business that has multiple locations in multiple cities in the UK. We want to build a network of geographical based websites for each location / city we have a office in that we service. We are going to build about 50 sites (Standalone on their own domain) to cover all the main cities, and one main company site. The idea with the 50 x sites is to benefit from google local searches and a local location. With the 50 x sites they would all back link to the main website, so would they need to all be on seperate i.p address and hosting to get the back link to count? or can they be all hosted on the same i.p address? Obviously it would be useful to get 50 x back links from relevant sites we are just trying to work out the best to way to do this. Thanks for any advice
Link Building | | MikeIrwin0 -
Article Writing / Guest Post
Hi, What are the advantage of posting an article / Guest post which Doesn't have any links to my website (Just the name of my website) Links are no follow Links are do follow In advantages, I am talking mainly about SEO benefits and not referral traffic.
Link Building | | adiez12340 -
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 -
Can high SERPS and/or social signals minimize Google penalties and a back linking removal question
As I am continually sizing up my competition in the SERPS I have scanned their sites with a fine tooth and comb. I have found that these sites practice in the very things that I have practiced in the past and have removed thinking that may be some of the reasons I was hit with Penguin. Some of these factors are: Link Scheme with sites they own (C Blocks) Content for Search Engines (Keyword rich text) Exact anchor text in back linking profile Yet even though my competition practices in these methods (One site even places exact anchor text in the footer and header of every page for one of their other forum site) they seem to have not even been touched with any of the recent updates. In fact it seems their ranking have increased. In scanning these sites the only major difference that I have been able to see between them and I is that their SERPS are higher than mine and they have way more social signals than me. One site has about 73k facebook likes where I only have about 300. My question is Can Google ignore penalties for sites that have higher SERPS and /or social signals that would effect another site that had lower ones? My other question is related to back links My main site has links from another site I built a long time ago (Pre SEO and not knowing what I was doing) somewhere in the 73k range. Obviously a HUGE signal to Google that this might be spam and I am aware. I have removed the links from that site but unfortunately the average crawl rate per day is very low so it is taking a very long time for Google to find those pages and re-crawl them to find the links gone. Since that site I have than has those links pointing to my main site has very low traffic I am totally willing to kill that entire site with a 404. Can this help speed up the removal of those links from that site? I figure since the site no longer exists all links from that site will be removed almost immediately from my main site. Any thoughts?
Link Building | | cbielich0 -
Has anyone noticed no change is MOzRank since February?
When using Open Site Explorer, two of my clients have experienced no change in MozRank since February, but nothing has changed/stopped in their link building/optimisation programme. Has anyone else experienced a similar 'pause' - can anyone explain?
Link Building | | caroline19770 -
Good/Bad Backlinks - Penalties
Just a quick question from someone that is extremely new to this: If "G" penalizes sites for bad backlinks (low quality, spammy) then why are people not building these types of links towards the competitors that are currently outranking them? Or are they? and if they are, is it beneficial? (are your competitors dropping in rankings?) Seems like a fair question.... Any insight is appreciated
Link Building | | Prime850