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 -
Is it possible to un-disavow a link if we later decide that it isnt spammy / undesirable ?
Is it possible to un-disavow a link if we later decide that it isnt spammy / undesirable ? (i know best practice is to get it right first time, but worst comes to worst is it undo able ?)
Link Building | | jpeg800 -
Is there a tool I can use to check backlink profiles against each other
Hi, Does anyone know of a tool where I can compare 2 (or more) backlink profiles to check common linking domains. It is one of those things that I know I have seen somewhere before but cant remember for the life of me where! Thanks
Link Building | | rickv1010 -
Link building / baiting in the Google zoo
I work for a consultancy, and in the past most of our links have been acquired by giving away privacy statements etc for websites, including a link back in the body of the document, and making it a licensing requirement that the link be kept. We're launchinga new site. We want this one to be whiter-than-white, and would appreciate some advice on the following options. Option 1: no links Remove the links from the documents, and don't require links for the use of the documents. Leave a non-linking credit in the documents. Perhaps ask nicely for links from other pages. Option 2: links on other pages Remove the links from the documents, but make it a licensing requirement that users will link to our site from another page on their site. I appreciate that most won't, but some will. Option 3: retain the links Keep the links in the document, using domain name (with and without http and www) and business name anchor text. Option 4: script the links Use scripts to generate randomized links in the documents, so that no two are the same, but with relevant linking text for the most part. We're risk-adverse with the new site, and it will pick up some links "naturally". We're therefore tending toward option 1, on the basis that it may well generate as many links as option 2. Which of these options would you choose? Are there any other options we should be considering?
Link Building | | seqal0 -
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 -
Do http:// links to a http://www. site count the same to Google?
In terms of links to one's site helping your position on Google, if your site defaults to http://www.example.com (automatically adds "www." even if it isn't typed), does Google count links that appear as http://example.com (without the www.) with the same "weight"? Thanks.
Link Building | | celife0 -
Do you think it's a good idea to try to find synergy between clients for blog posts/citations/links, or should you keep clients away from each other?
Say you have for example three (in this case) clients, and: Client A sells red widgets Client B is a doctor Client C sellls blue widgets With some research, you find that: Red widgets (A) can make the process of blue widget creation (C) even more effective. Red widgets (A) can protect you from harmful things that doctors (B) are qualified to recommend that you stay away from. Furthermore, there are things that doctors (B) recommend that you do in order to maximize the benefits of red widgets (A) Blue widgets (C) carry with them certain potential health risks, which according to doctors (B) can be minimized using the following means Sometimes blue widgets (C) can be used to effectively repair red widget (A) factories ...and so forth. Sure you're really writing these articles to generate links and exchange authority, and frankly you started with "how can I find synergy between these clients?" rather than a with a great article subject that needed a citation which luckily happened to be another client, but the citations are legitimate and the clients are qualified to speak on the subjects where their expertise and interests overlap. Would you consider going ahead with this? Does anyone have any experience doing it? I could see potential pitfalls if clients were to interact with each other, but keeping yourself as the intermediary might well work and overall it seems like a decent way to grab low-hanging fruit as they say. What do you guys think?
Link Building | | PathMarketing0 -
Any Tips for Link Building for Boring Topics/Businesses?
I have a number of clients that own businesses in 'boring' sectors, such as: Toxic Waste Removal Steel Erecting Household Plumbing (Boilers, etc...) Link building for these sites is quite difficult. Creating compelling content and 'link bait' is particularly tricky. I found a good post from Michael Gray on the subject, but I don't think food (or McDonalds in this case)is a particularly difficult subject to write about. Any more tips on how to approach this would be appreciated. Thanks
Link Building | | cmaddison0