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
-
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 -
Any successes getting SEO/link vendors clean up Penguin-related problems they helped create?
Hi all, I'm wondering if anyone's been able to get link vendors help clean up Penguin-related problems that they helped create? I have a client who was sold years and years of AWFUL link building work from a major and prominent SEO vendor, that we are now battling to de-toxify. There are no legal grounds for us as the ToS was watertight and the client is ultimately responsible (if naive), but has anyone been successful in getting vendors to cooperate with cleanups on ethical grounds? What's the best way to play that with a major vendor, I'm assuming they wouldn't want to be outed. Cheers all, Matt
Link Building | | MattBarker2 -
Is it recomended to block a page using the robots file if it has recieved a manual Pengiun/Panda Penalty ?
The whole idea is creating a new page altogther instead of the page that is performing poorly after the pengiun/panda update.
Link Building | | Gmorgan0 -
My competitors all seem to use "junk" pages to rank / backlink, how to compete and not cheat
Hello, Page 1 of Google for the word "copier lease" and most other valuable copier leasing terms are dominated by the same 4-5 for organic (PPC too of course, but organic is what I want) They all use some SEO company, so when I go and look for good link oppertunities, most of the pages I find are just SEO companies who of couse would never be interested in a competitor's link. Examples: ajaxunion blogspot com or excellentpoly blogspot com and the list goes on, all just AjaxUnion "blog pages". blog homerenovationguide com /2011/06/15/repair-or-replace is just inhouse SEO making ranking pages for CostOwl. So, its hard NOT to want to throw up a blog farm and do as "the Romans do". What ideas do you all have to get backlinks in this market of Copier Leasing that would hold up. Thanks 6SW66.png 6SW66.png
Link Building | | einstein99992 -
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 -
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 -
Domain/page authority - how long does it take so see results ?
Im new to the SEO and link building world. I have been building on my link building campaign over the last month or two but I am yet to see any changes in my domain/page authority. Is it because of the quality of the links, the directories I have been submitting in, webmasters maybe using "nofollow" tag ect. Or it generally just takes time to see the results? Is this even how domain/page authority is built. lol Any information on the topic would be greatly appreciated. Regards, S&M
Link Building | | Sexandmetal0 -
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