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
-
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 -
Hi I changed my site to https://www.cocaineteskit.co.uk - now unsure
Hi ALL, just changed over to https//.www.cocainetestkit.co.uk with the money being in wholesaling. However I am having my links poorly indexed - any suggestions?
Link Building | | AndreavanEugen0 -
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 -
Best Back Links (paid/unpaid) Real Estate
Where can I get the best backlinks for Real Estate? I don't care if it is paid/unpaid. As long as it's not the kind of paid link Google would go after. Paid directories are A OK. Please help 🙂 Keywords: property management, vacation rentals, real estate, real estate agent, realtors
Link Building | | JML11790 -
How do you check to see if your site (site A) has already been linked to by another site (site B) when you have a large site with lots of links
There are some basics in SEO relating to finding out about who has linked to whom that I could use some help with.
Link Building | | hughman0 -
Site-wide/Blogroll Anchor Text Linking
I have some blogs that I own with 10,000+ indexed pages of content. I have wondered for sometime if adding anchor text links for my clients on relevant blogs would be helpful or harmful. I realize that having an anchor text link on ONE article page in context is better than 10,000 anchor text links on my blog roll or footer, but I have been reluctant to use this strategy due to the bad press site wide and blogroll links have gotten, What has been YOUR experience with this method?
Link Building | | TheGrid0 -
Is the frontpage/deeplinking ratio of backlinks an important ranking factor?
Hi, i am asking me since a while, if the relation of the amount of frontpage backlinks divided through the amount of deeplinks pointing to a domain is an important ranking factor? In this area, i am not so much looking in the total numbers of backlinks, but more at the number of linking root domains. Do you have explore the ratio of frontpage/deeplinking as ranking factor reqarding the 100% of external backlinks? So for example, what do you consider better, asuming all root linking domains in theory are equal, for the SERP of the main keyword for which the frontpage is running on Google. Case A Frontpage = 80 Linking Domains
Link Building | | Braumueller
Subpages = 20 Linking Domains 80 / 20 = 4 / 1 (4 times more frontpage linking domains than deep linking domains to subpages) Case B Frontpage = 90 Linking Domains
Subpages = 10 Linking Domains 90 / 10 = 9 / 1 (9 times more frontpage linking domains than deep linking domains to subpages) Case C Frontpage = 95 Linking Domains
Subpages = 5 Linking Domains 95 / 5 = 19 / 1 (19 times more frontpage linking domains than deep linking domains to subpages) Greetings from Hamburg,
http://www.suchmaschinen-experte.de0 -
What are your views on link submitters / directory submitters?
I have no real opinion on them to be honest, I don't really have any experience with them personally: eg: http://www.fastdirectorysubmitter.com/downloads.html http://www.thelinksubmitter.com/ http://www.dumpblaster.com/ I presume they will be negative or a waste of time?
Link Building | | Benj250