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
-
How to choose a third party agency to help with linking building / SEO strategy?
Hi all, we've not been link building for some time now as we are a small team and been concentrating on other things, such as getting our new look site built and implementing Magento etc. We've historically used external companies to help with link building & SEO... some experience has been good, some bad. Does any one have any suggestions on how a small company can try to choose a decent external company that can help with SEO strategies? There are a lot of options, a LOT of rubbish and a lot of very expensive large agencies that are well out side of our budget (or for a "small" fee simply produce a standardised report on "how to improve your SEO" that can basically be read on the net). We've tried local, smaller companies in order to limit our options .... but that didn't go well either. Any suggestions welcomed. Next is where / how to weight our expenditure and / or our SEO time. Should it be 50% gaining external links (be it by what ever means such as social, checking out where competitiors have links and chasing those possibilities etc) and then 50% internal page SEO, blog content creation, internal linking etc? Thanks again.
Link Building | | jasef0 -
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 -
Why does my site only have 4 internal followed links/internal links?
When using Open Site Explorer my site is winning in many categories but lacking in others as compared to competitors. I intend to improve on this but am a little confused by the extremely low number of "internal followed links" and "internal links" at just 4. My competitors have much more than that. Does this mean links to the root domain? Total internal links? I have many internal links so I'm having a hard time figuring this one out. What four internal links are getting noticed? I just went through and changed all the links that went to index.html to link to the root domain at www.njlimocarservice.com as I just found a Q&A that indicates this was better. So as of Wed at 5:45 PM all my links to the homepage went to index.html and not the root which is no longer the case. Not sure if this matters. At the same time I also just put a 301 from index.html to redirect to www.njlimocarservice.com. Any help appreciated! h9QuF.png
Link Building | | kabledesigns0 -
Where/should I post my press release/articles on my own website?
I have started a long-term article marketing campaign and press release distribution. I will have about 4 articles and press releases in total every month. Although the press releases will not be self-promotional, sometimes they will be talking about a certain product that we unveil. The question is, due to the high quality of these press releases, should I put them on my website as well as publish them on third party websites? If so, because they target a specific service/product which we already have a dedicated page on our website, wouldn't that put Google in the position of choosing between the two pages? I was thinking to put them on my blog and link internally from there with the keywords that I target on those pages as anchor text. The same question for articles. Any suggestions?
Link Building | | echo10 -
How to track/find new organic backlinks to your domain
I use Google Alerts to track domain-level backlinks (via the link:http://www.example.com trick) but is there a way to track/be alerted of long urls, not just the domain, without having to set an alert for each specific url?
Link Building | | EricPacifico0 -
Should You Avoid Links from Sites with Big Difference Between PR and MozRank?
If a site has a Google toolbar PR of 2 and a Mozrank of 5, does that most likely mean that the site is penalized and a link would probably provide little value. I know that Google rarely updates toolbar PR so I suppose the site could have also earned a lot of quality links since the last update. Thanks Mozzers!
Link Building | | SparkplugDigital0 -
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 -
Do-Follow link from Linkedin/Facebook/Twitter/About/Google Profile, how to:
Tell us, a technician method of building do-follow link on high quality social websites. Thanks
Link Building | | leadsprofi0