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 -
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 -
Which tools/techniques do you use for backlink indexation?
Hello All, I was wondering if you have a list of sites, tools or best practices in order to get your new backlinks indexed sooner by Google. Thanks a lot in advance! Luis
Link Building | | Yeeply.com0 -
Can internal links cause Google to penalize me for key terms/phrases?
For example, having a link on many pages (so dozens of links in total) using a product name, all pointing to that product page. Could Google see that as "spammy" and penalize that product page in the SERP's? Note: My product page has been penalized for the search term "Product Name" and there are no external links pointing that page using the product name as a term. This is new with the latest Panda Updates.
Link Building | | absoauto0 -
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 -
Is there a software to help me check whether the sites that i give link to, also place my link on their site (reciprocal link)?
When i exchange links with others, i usually put their link on my site hoping that they'll do the same. Since it's impossible to check all sites whose link i have placed on my page to see if they have put a link back to me, i was wondering whether there is a kind of software to help me do that!
Link Building | | isidora0 -
About Paid Ads/links - Question
My name is Benny, i am writing here from account of my uncle, because he is a pro member, and i am a student dont have money to pay premium package. Now, I have placed some ads/links on a strong domains, for about 8 months, i paid always, but about 6 weeks i was sick, on hospital, and i have forget to renew the links, and now are removed, and ranking down too. My question is, can i restore the links with same anchors on the same places again on the same sites, or what to do? it's this danger if a link was for a 6 weeks down, and now again to re-place, some of them are 3-4 weeks,and some 6 weeks, it's this danger to replace again or not? What do you suggest me?
Link Building | | leadsprofi0 -
Are there content swap tools/forums for linkbuilding?
Anyone know any besides myblogguest? I have a pipeline of content at the moment and not enough distribution. I also have web properties that can take posts etc Cheers S
Link Building | | firstconversion0