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
-
Impact on backlinking with https://www.domain or https://domain
Hi, this questions have bugging me for a long time now; we check our website how is indexed on Google and we see that we have most of the backlinks for URL https://www.speedhub.eu , but 15% are linked to https://speedhub.eu , in the past we had our website for http requests redirected via 301 htaccess to https://speedhub.eu without giving it importance, now we have it with www included. Bottom line questions: Is it important if your links are with www or without www, do you lose "link juice" by splitting your backlinks via links with www or without www ? Does Google make a difference for domain positioning via this criteria ? Best regards,
Link Building | | SPEEDHUB_eu0 -
Can we use Free domains (like .cf / .tk / .gq / .ml / .ga) for backlinks?
many times I Noticed that most of the website use .cf / .tk / .gq / .ml / .ga this domain for backlinks but when I click on this it shows me the error I want to know that how they get a do follow backlink from the Different free domain can I get backlinks from my free domain? if this possible then How? This is my website Pakistan News kindly tell me how to rank.
Link Building | | Zaidazam0 -
On-Page / Site Optimization+Link Building -check help!
HI all, have also Question One, i don't understand how is this website : competitor website http://hack-clash-royale. com/ beter them my website i analze i have more more backlink and my website is strong have good seo but not on first position, you can tell me what is problem, my website is 4-5# and competitor 1-2# .. thanks
Link Building | | Fahad5Saleem0 -
Tools which automatically check anchor text
Tools which alert of low anchor text diversity Hey guys does anyone know of any tools which can alert you of low anchor text diversity across sites? Any backlink tools/data sources have alerts like this? Cheers.
Link Building | | jayoliverwright0 -
Article Writing / Guest Post
Hi, What are the advantage of posting an article / Guest post which Doesn't have any links to my website (Just the name of my website) Links are no follow Links are do follow In advantages, I am talking mainly about SEO benefits and not referral traffic.
Link Building | | adiez12340 -
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 -
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