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:
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
-
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 -
Website/blog list to get quality backlinks?
Hi Everyone says quality backlinks increase ranking of your website. Can you please suggest a list of good websites and blogs from where I can get quality backlinks and how to do that. I have one person at my disposal full time to do manual commenting or any manual tasks for getting backlinks but how should i approach this problem (of getting backlinks). Where do I start. For information, my website provides online services (its an ecommerce site) and also has a blog in subdirectory. refer to www.geekwik.com www.geekwik.com/blog Would like to become top ranker on search for these services (eg 'logo design services', 'website programming', 'content writing', 'hire virtual assistant' etc) Also anyone interested to become our SEO consultant or SEO service provider (of course paid) is most welcome 🙂 Thanks in Advance!
Link Building | | geekwik0 -
GWT Best For Link Checking?
Even though GWT's Links to your site is about a month behind I am finding that it reports new links faster than either OSE or Majestic. Has anybody found anything more current than GWT?
Link Building | | waynekolenchuk0 -
What's a really good example of a linkbait-y Category / Subcategory hierarchy?
Rand makes a really great point in this 2009 post about the shape of crawl paths: "#4. Craft navigation / category pages that are worthy of links. If you can make these pages worthy of links and attention, you drive PageRank and crawl priority further down your site's architecture into the content (and signal the engine that ALL your pages are important." Which makes sense, intuitively, because you'd like link juice to flow directly and undiluted to your money pages. "Here's all my Green Widgets, Roger: they're all right here. While you're at it, here's a related blog post—'5 Ridiculously Awesome Things Every Green Widget Buyer Should Know'—and, oh look! Would you like to see my Blue Widgets as well?" In practice, though, the Home » Widgets » Green Widgets doesn't sound all that alluring. Useful, absolutely, for UX, but not for getting links. Anyone have some favorite examples of Category / Subcategory hierarchies that do well as link-bait? Client is a marketing agency dealing in the technical arcana of databases and ad serving, so their money pages won't be as specific as a Green Widget or a Miami Hotel. Their site isn't huge, and the pages will be extensively interlinked, so the emphasis has more to do with link juice / page authority than indexation. But I'm wondering if it could it be smart to replace a generic "Services" category with a KW-rich drop-down menu of "Marketing Solutions" (i.e. 'Increase Customer Retention') and link each landing page to a relevant charcuterie of services, white papers, webinars, case studies, etc., rather than keeping these pages in their respective silos—even as they link horizontally to related services?
Link Building | | sweetfancymoses2 -
"gimme links" = easy to fill out profile/personal reputation links that offer a do-follow anchor text flexible link
I'm doing some SEO for small niche service sites...and aside from niche directories and some light article marketing and local search directories (yelp, etc) there really isn't a budget for content generation. I really only have a budget for profile/submission links. What are some sites where you can quite easily fill out a personal profile with an anchor text variable link that may not be THAT juicy but will stick (i.e. not a spam/fake profile type of link, but something like Linkedin). I'll start with giving away 1 www.istockphoto.com Any others that aren't obvious?
Link Building | | ilyaelbert0 -
How can I check a website to see if it is "nofollow"?
I'm a little new to SEO, so maybe this is obvious to some . . . I'm attempting to build backlinks by submitting articles, posting on forums etc. I just wrote my forst article for ezine and submitted it. I was feeling pretty good about myself until I mentioned it to someone trying to sell me their SEO services and he said that ezine articles are considered "nofollow" on all their links. Well, that was pretty frustrating to hear! It got me wondering, how many of these other sites have all their posts and blogs listed as "nofollow"? Is there a way for me to figure it out ahead of time? Obviously, there are only so many hours in the day and I would rather focus on posting on sites that will actually help me build backlinks! Thanks for your help in advance!
Link Building | | damon12120 -
Link building tools/sites
I am looking for a way to share my content in multiple locations to build back links without having to upload one at a time per location. For example- if i write an article and i upload it to ezine articles and then post it over on my blog- it will then post over on my twitter and facebook and linked in. However- how i can also get this article with back links into shared sites, bookmark sites, and other locations online to help build my inbound marketing for back links. I'm trying to find a way to save time while building out the links.
Link Building | | LauraThomas0