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
-
Looking for a dedicated Backlinks/Disavow Platform
Hi Guys, Can anyone recommend a good backlinks program. One which is able to detect spammy backlinks and which has a disavow feature. I've tried Monitor Backlinks, Would appreciate any further suggestions. Priorities are ability to monitor new links and their value, loss of links, link opportunities, with the ability to create recommended opportunity lists and disavow files - ideal if can be used in some way for client reporting also - dashboard or pdf etc. Help with access to contract link builders (perhaps star rated for quality and efficacy) to go after the opportunity lists also a bonus etc. Basically what are people using out there and really liking!? NB: we use moz for some stuff and have a mix of other tools available but nothing seems to be really nailing this for us. Thanks!!
Link Building | | OnlineAssetPartners0 -
Can i create more blogs/websites for SEO?
Hello, Can i create more blogs/websites 2.0 for SEO? It is safe to get backlinks from that pages (5-10 diffrent domains)? Blogs/websites like: wordpress.com, webs.com, soup.io... Content: Only unique content related to my websites, new content every week. My website realy need fresh backlinks so i think these method are alright?
Link Building | | cerar0 -
Googles stance on Back Links via a Badge/Form
Hey guys, Does anyone know what Google's stance is on backlinks that come via a form, WordPress theme or badge. For example if I offer website security and provide badges for websites that are malware clean (with a back link to my website) and 100 websites sign up to my website will this be deemed as bad practice in Google's eyes? Also if I create a free WordPress theme with a backlink to myself? The second question sounds like I'm providing content for a link which seems okay but the first one can go either way. Thanks
Link Building | | conversiontactics0 -
5th failed Google reconsideration attempt, can you help? (are scraper/related news sites the issue?)
(sorry for the long question - I thought it would be useful to give the background!) I am really struggling a Google's reconsideration request for my site, and although we thought we had removed almost all the 'bad' backlinks I am still getting no-where... We are really wanting to focus on building our brand, and establishing our site as an authority but this penalty is really holding us back. The latest response from Google: There are still many inorganic links pointing to your site. At this point, we believe we’ve evaluated these links appropriately, and no further action from us is required. In order for your site to have a successful reconsideration request, we will need to see a substantial, good-faith effort to remove the links, and this effort should result in a significant decrease in the number of bad links that we see. We do not recommend that you submit another reconsideration request until you have been able to make a good amount of progress. Once you’ve been able to get the links removed, please reply to this email with the details of your clean-up effort. My Website: http://bit.ly/KXg8y1 History: This is a new domain - approx 6 months old Old domain received a Google links warning We decided to start a new website, launch a new brand and start from the beginning We 301 re-directed the old domain so we didnt lose customers We then got a Google links warning for the new site We assumed this was related to links from the old site and so removed the 301 redirect on the 20th August Our old sites links still show in Google webmaster tools Reconsideration History 1st re-consideration request: Explained the 301 redirect had been removed, assured we would now be focussing on high quality content/brand building and after 2 weeks received a standard message to say that still had inorganic links 2nd Request: Went through the new sites links (using open site explorer, AHREFs, SEO Majestic and GWM) and removed those we identified as low quality (mostly directories built by an SEO company we had started working with). We complied a spreadsheet with all the links in it (including 301 redirect links) and explained which had been removed, webmaster contact details etc. We also uploaded our template email and screenshots showing contact with webmasters. 3rd, 4th and 5th Request: We went through the new site links and were able to remove a few more links which were thin or could be seen as inorganic, and the end result is that apart from 6 links we have removed all those we have identified as inorganic. Links The old site had some pretty poor links We have done no paid linking, no blog networks, no spammy web 2.0 sites on this site. We've added good quality content to our blog, focussed on social media, published an infographic, and are committed to long-term brand building The links mostly come from guest blog posting. An SEO company (who told us they were 100% content based) built some directory links - but 99% of these have been removed There are some links from Scraper/related news sites (ones that have related blog posts or scrape images etc) Press releases which were picked up and re-published (some of these include anchor text) My Question/s: Do you think Google is still seeing the links from the previous 301 redirect in Google webmasters and including these still? Are these scraper/related post sites causing the issue? (organic links - but some dubious sites) Are sites re-publishing our press releases causing the issue? (organic links - but includes some anchor text I really appreciate your time on this one, I have tried really hard to identify and remove links, but am now struggling! Many Thanks
Link Building | | twhite0 -
How to Check if a Sites Backlink Profile is Penguin Friendly?
Post penguin I am of course very wary about which sites I proactively solicit links from. Here is the scenario. Let's say for example I found a blog relevant to my business sector, had good domain authority/moz rank and noticed that they accepted guest posts. Sounds great? Well on the surface it sounds like it would be worth reaching out to the blog owner - but what if that blog had been involved in some really shady link building practices in the past and the reality is that I could end up damaging my own site by association. Can anyone share any useful resources such as articles or tools that will help to understand how to qualify if a sites backlink profile is shady and should be avoided as a link prospect?
Link Building | | Luia0 -
Helpful or Hurtfull / Distributor Links to Our site on every product page?
We have a distributor site with a page rank of 3 on its home page, and 0-1'ish on its product pages. While our manufacturing site is PR 4 getting close to 5... We are thinking about adding a link from our distributors product pages to our manufacturing appropriate material information page. This would be about 10k links spread out among 7 materials. We want to add these links to help our distributor sites customers, but we don't want to hurt our manufacturing site in the process. I personally don't know of any problem this would cause, but our manufacturing site is so important I need to verify adding this many links wouldn't hurt us. Your thoughts and knowledge is appreciated.
Link Building | | donford0 -
One website with different niches/keywords.
Hello Mozzers! I am currently building a website, which basically contains information from different niches. Let's make it clear: My website is something like eHow. The idea is to write quality articles, written especially to give the searcher the right information, without any scam, product advertisement or etc. The incomes are from AdSense. Actually I got inspired for this website from the Google Panda update. So... my question is - would it be harder to rank with such a website(domain name) that contains different niches and keyword phrases? Lets change a lil bit the situation and show you an example - I am trying to rank with keyword "how to make nice cheezeburgers" with http://theanswer.org/how-to-make-nice-cheezeburgers/ . At the same time I am also trying to rank with "The best movies of all times" with http://theanswer.org/the-best-movies-of-all-times/ . Thank you, Ralchev 🙂
Link Building | | Ralchev0 -
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