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
-
Googles stance on Back Links via a Badge/Form
Hey guys, Does anyone know what Google's stance is on backlinks that come via a form, WordPress theme or badge. For example if I offer website security and provide badges for websites that are malware clean (with a back link to my website) and 100 websites sign up to my website will this be deemed as bad practice in Google's eyes? Also if I create a free WordPress theme with a backlink to myself? The second question sounds like I'm providing content for a link which seems okay but the first one can go either way. Thanks
Link Building | | conversiontactics0 -
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 -
Best way to set up a support site - sub domain, separate site or com/support?
My company is setting up our support site. It has been suggested that we set it up as a separate domain - www.company-support.com, rather than setting it up as a sub-domain (www.support.company.com) or the usual www.company.com/support. The person who proposed this believes it wlll create link juice, but i wonder if splitting the traffic will create more harm than good? Opinions please!
Link Building | | googilvie0 -
How to Check the Amount of Deep Backlinks?
I'm thinking about checking the amount of deep backlinks on my site because I have a hunch that I don't have enough of them. Now, the problem is that I have no idea what tool (on-line or offline) I need to use. I did some Google research but it did not give me any results.
Link Building | | VinceWicks0 -
Helpful or Hurtfull / Distributor Links to Our site on every product page?
We have a distributor site with a page rank of 3 on its home page, and 0-1'ish on its product pages. While our manufacturing site is PR 4 getting close to 5... We are thinking about adding a link from our distributors product pages to our manufacturing appropriate material information page. This would be about 10k links spread out among 7 materials. We want to add these links to help our distributor sites customers, but we don't want to hurt our manufacturing site in the process. I personally don't know of any problem this would cause, but our manufacturing site is so important I need to verify adding this many links wouldn't hurt us. Your thoughts and knowledge is appreciated.
Link Building | | donford0 -
Submitting my URL on web/business/service directories
Does it make sense to submit a business URL in as many relevant web/business directories as possible when kicking off a link building campaign? Submitting a free listing is obviously better than nothing, but when does it make sense to pay extra for a premium listing profile on some of these directories? There are just so many and a lot of them appear spammy, even though some of my competitors are getting traffic from them. Any advice on this would be great!
Link Building | | TheSquareFoot1 -
Is there any tool in/or out of SEOMOZ where we can check anchor texts for internal/external links for a website?
I just want to check anchor text of all the links for a specific URL within a website
Link Building | | merkal20050 -
What is the length for Open Explorer and/or Google to pick up on Blogroll links?
I'm just a little curious about this and thought I would make use of the new Q&A system. This is my first open question. I recently acquired some blogroll links on 3 fairly popular and well trafficked sites, some with more authority and pages than mine (Get Right Music). I was wondering if anyone is familiar with the time frame in which I should start to see that affect my rankings in Google. Also, the time frame when I should start to see those domain links appear in Open Site Explorer. I'm just curious. Thanks everyone. Jesse
Link Building | | getrightmusic0