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
-
In-depth/longform content DEFEAT backlink, DA/Trust score!
Hi all, There is a new way to defeat the big boys. Build a releated topic with minimum 4000 words and focus on in-depth content and use the target keywords more than 2,5% of each content. So its game over for linkbuilders and happy end for the copywriters? Ofcourse every factor of seo is important, but its better to focus on in-depth content. To score good with your target keywords in SERP. What are the challenges for a big webshop? Create a related deeply content? that separated from your webshop?
Link Building | | Dreamgame2016
Because it will be coatic with a lot of deeply contents on your webshop Is there more additional advice for a webshop with a big assortiment? Ps. Specifiec, the big webshops sells game/software keys.0 -
Why have I lost 1/3 of my backlinks (about 5,000) in 3 months?
In August, my client's site (I work at a marketing agency) had about 15,000 backlinks. Now they suddenly have about 10,000 backlinks. And their Domain Authority has dropped from 48 to 40! Can someone please help me understand what could've happened? At first I assumed this had something to do with the latest Penguin update, since I knew my client's site had some extremely spammy backlinks they hadn't cleaned up yet. (The site was hacked at some point and hidden pages were created as part of some kind of link-building scheme, and there were lots of links from sketchy sites to those pages. The hidden pages have been taken down and the URLs now redirect to my client's home page.) But that would only explain a sudden drop in Domain Authority, right? How could Penguin suddenly cause my client to lose 5,000 backlinks? And if it's not Penguin, what could it be? Thanks in advance for any insight that anyone can share!
Link Building | | matt-145670 -
External Backlinks - Should I remove/disavow external blog posts done by SEO company?
Last year my company hired an SEO company to build backlinks for targeted achor text keywords. It turns out that they wrote average to below average blog posts that had content related to my business, but that were placed on odd websites, not related to my business. They did this for about one year before I fired them. Should I try to get each of those blog posts removed and then disavow them? If the external links back to my site are nofollow then it is my understanding that I don't really need to worry about them...is that accurate? Is it too risky to keep any external backlinked content alive when it is on a site that is unrelated to my business?
Link Building | | ajgrossman0 -
How do I get the most links out of one QUALITY article/post??
Basically we are a small business (2 employees) we don't have the time or resources to be writing hundreds of original quality articles each week (nor do we have the time to write endless guest blogs each week) how do we gain links from one article? (not including poor quality article submission sites) And how do SEO's write so many guest blogs? for the returns on time invested!!! Confused Newbie, thanks in advance!!!
Link Building | | Buzzwords0 -
When searching for high quality links, in a niche area such as real estate, does page rank factor into a search or is page / domain authority the most important factor?
After having employed many different methods for finding good link partners I am now finding it more difficult to reach out and identify good quality links for a niche area such as real estate. Does page rank factor into the search much or is it better to focus on page / domain authority as a major factor?
Link Building | | casper4340 -
Http://angelasbacklinks.com/ can someone give me their take on this site and the packages? Thank you
http://angelasbacklinks.com/ can someone give me their take on this site and the packages? Thank you I am looking to get links to this url www.gunshotdigital.com
Link Building | | vijayvasu0 -
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 -
Link-building / panda update!
Hi Mozers. WHat do you think, after panda-update, which is the best strategy to build links on Content, or blogspots, and it to website with a minimum PA40 and DA30 . . in which place is better to place, at the begining of article, or at the end of article, tell us some tips, if you are experiences on this section! Thanks,
Link Building | | leadsprofi0