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
-
How many links per week/month should a link building campaign acquire?
I am running a linkbuilding campaign for my company. I am mostly focusing on guest blogging opportunities and responding to emails from HARO. How many links would I have to acquire each week or month to be considered doing a good job over a 6 month or a year time period? Thank you,
Link Building | | fersu0 -
Do .ac.uk (UK education / university sites) count in the same way as .edu backlinks
With regards to link trust are backlinks from .ac.uk (wiki on .ac.uk) count in the same way as .edu backlinks ?
Link Building | | jpeg801 -
Are there any reputable & affordable blog/article submission services nowadays?
Since the calamity of Penguin I know several article submission websites got a really bad wrap (many deservedly so). However if done carefully and legitimately I believe article promotion can still be a bona fide SEO link building tool. I currently have a client that has hundreds of good blog posts. We have done some modest article promotions via local news websites. However I feel like this content could use more of a push. Does anybody know of any reputable article/blog post promotion websites?
Link Building | | RosemaryB0 -
How to check if the website effected from Penguin or not?
Hi, We collecting links from some directory and forums etc but i am not quite sure if they are effected from Penguin update. Would you please guide me how i could check this? Thank you
Link Building | | Rubix0 -
We have links from our page at .com and .com/. Should we be concerned about this and try to merge?
When running link reports for our page .com, it redirects to .com/. We do have links for both URLs, but .com/ is significantly more than the other. Should we be concerned by this? Are we losing some links because of this?
Link Building | | hanapin0 -
How to Check if The Content is Spinned
Hi guys, We run 5 ecomm sites in the fashion industry. We set up blogs for each one of them. Our regular writer cannot handle the job of posting 1-2 unique articles per day on 5 blogs plus the extra copy writing jobs he has. We want to involve freelancers in writing our articles. We do not want to spin content (due to low prices of real articles). The issue we have is that we want to be able to check if the articles our contractors deliver us are spinned content or not. We would not accept spinned articles if we pay for unique content 🙂 Do you know any good spinned content checker that we can use? If possible, please post 2-3 software, free or paid, so we can use them simultaneously to check the articles. Thanks in advance
Link Building | | tolik10 -
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 -
Is there way to identify all back links throughout a site or do I have to check one site page at a time? Thanks!
Sorry if it is obvious, but I can't seem to figure it out. I'd like to be able to run a report that will list all of the back links on every page of my site.
Link Building | | TRCCommunications0