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
-
Best way to check/find lost links?
Hi all As everyone, we have seen a decrease of domain authority and external links during the last months. with open site Rand is explaining the reason in this in this post, but I still would like to have a look to the links that in theory I have lost during the last months. I thought Majestic was the best option but I have been trying to get the info and I see nothing clear. When I download the fresh or history links, I only see links that are live (in theory, because in history I get a lot not existing but I can not see it without a manual check). The option of lost links is just giving me 1000 links per day, but after downloading some and checking I see that this lost link report is showing me links that are working (but it looks that majestic couldn't access when they did the crawling and show them as lost). Also the numbers of lost links are totally different if you use fresh or historic... Anyone could recommend me a good way to find out links that I really lost? Thanks
Link Building | | AutoEurope1 -
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 -
Totally puzzled by link building/content marketing
Hey Mozzers! 🙂 I'm going to be starting link building for a website soon and I am having some trouble wrapping my head around a couple of things. First of all, in the current world of SEO, where should I be looking to generate links? Is it as simple as reaching out to bloggers and trawling through competitors links? Or is there something more? In relation to this, if I were to generate a good number of links from high authority sites, how would this effect my ranking for keywords (assuming the anchor text for those links is the website URL)? The other thing I'm a little puzzled by is, if I were to write a great article on the websites blog and it gains traction in social media circles, people would (I assume) only share a link to the blog post instead of the actual article itself. How would this effect the ranking of keywords that I have optomised (anchor text etc.) for in the article? I assume this is where guest blogging would come in? Any help would be HUGELY appreciated. I've been trying to logic this one out the last couple of days and just can't do it 😕 Thanks a lot to anyone who replies 🙂
Link Building | | CD_20161 -
How to check inbound link quality?
We're reaching out to various communities to do some link building at the moment and were wondering what people did to confirm that the links are from quality sources? We don't want links from bad neighbourhoods or sites which have had penalties applied against them etc... What tools can we use to find this out? Thanks in advance for any replies!
Link Building | | agencycentral0 -
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 -
Can high SERPS and/or social signals minimize Google penalties and a back linking removal question
As I am continually sizing up my competition in the SERPS I have scanned their sites with a fine tooth and comb. I have found that these sites practice in the very things that I have practiced in the past and have removed thinking that may be some of the reasons I was hit with Penguin. Some of these factors are: Link Scheme with sites they own (C Blocks) Content for Search Engines (Keyword rich text) Exact anchor text in back linking profile Yet even though my competition practices in these methods (One site even places exact anchor text in the footer and header of every page for one of their other forum site) they seem to have not even been touched with any of the recent updates. In fact it seems their ranking have increased. In scanning these sites the only major difference that I have been able to see between them and I is that their SERPS are higher than mine and they have way more social signals than me. One site has about 73k facebook likes where I only have about 300. My question is Can Google ignore penalties for sites that have higher SERPS and /or social signals that would effect another site that had lower ones? My other question is related to back links My main site has links from another site I built a long time ago (Pre SEO and not knowing what I was doing) somewhere in the 73k range. Obviously a HUGE signal to Google that this might be spam and I am aware. I have removed the links from that site but unfortunately the average crawl rate per day is very low so it is taking a very long time for Google to find those pages and re-crawl them to find the links gone. Since that site I have than has those links pointing to my main site has very low traffic I am totally willing to kill that entire site with a 404. Can this help speed up the removal of those links from that site? I figure since the site no longer exists all links from that site will be removed almost immediately from my main site. Any thoughts?
Link Building | | cbielich0 -
Http://fiverr.com is good for seo to buy services?
fiverr.com is good for seo to buy services? Can you recommend best seller?
Link Building | | surajrathore0 -
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