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
-
SEO value of links from international TLDs to local (.be/.nl) TLDs
I'm linkbuilding for a couple of websitew of mine with TLD's of .be and .nl. When i look at my competitors, i see they also have backlinks from .com, .cz,... But do those international backlink account for any value (link juice) being past on?
Link Building | | RoderickG0 -
Dead/Broken links on old blogs
Hi We are currently trying to update our blog page on our website but quickly realized there are numerous dead or broken 404 links after clicking on anchor text from past blog posts. Our blog is set up in WordPress and we recently installed an SEO plug in with it. Some of these anchor texts don't actually need links and I want to unlink them, is there a simple way to do this on WordPress? Other anchor text I would like to "301 redirect" to another page. Can i do this on WordPress or is this something my SEO plugin should be able to fix? Answers are much appreciated! Thanks
Link Building | | SapphireCo0 -
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 -
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 -
Honest thoughts needed about link building / removal.
I have a small online business that has suffered through Google updates over the past year. Turns out that the links built by a previous SEO were harmful - yes, it's the usual story, I know. I've been in touch with an SEO about link removal/link building and have had a proposal. It's not cheap and I would need to dig deep, but it'll certainly be worth it if things work out. If it doesn't, it'll probably become impossible to continue the business. Personally speaking, it's a sorry situation. For link removal, the SEO's proposing to contact the webmasters followed by disavowing, if needed. There's 15k links, but I think a high percentage of these are from industry blogs that I sponsor that have site wide links. Have you heard many success stories about outsourced link removal? For link building, they will be targeting industry websites and blogs. The thing is, I know most of the industry bloggers anyway, and can probably reach out to them myself, if I can develop the right high quality content that they will want to feature. Call me a cynic, but I'm not sure how the SEO can do this. The quality of content on these blogs is extremely high as it's a very creative/visual industry that I'm involved in. I'm just not sure how much scope there is for a third party (with no knowledge of the industry) to do this effectively. That said, there's blogs that aren't directly related to my niche, and I suppose there's possible opportunity there. Maybe??! If the link removal is a good idea, am I better off trying to build links myself and combine that with the link removal service?
Link Building | | Coraltoes770 -
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 -
How to Check if a Sites Backlink Profile is Penguin Friendly?
Post penguin I am of course very wary about which sites I proactively solicit links from. Here is the scenario. Let's say for example I found a blog relevant to my business sector, had good domain authority/moz rank and noticed that they accepted guest posts. Sounds great? Well on the surface it sounds like it would be worth reaching out to the blog owner - but what if that blog had been involved in some really shady link building practices in the past and the reality is that I could end up damaging my own site by association. Can anyone share any useful resources such as articles or tools that will help to understand how to qualify if a sites backlink profile is shady and should be avoided as a link prospect?
Link Building | | Luia0 -
Google Webmaster Tools notice of detected unnatural links to http://www.loveandlucky.com/
On FEB I got a message on my Google Webmaster Tools saying "Google Webmaster Tools notice of detected unnatural links to http://www.loveandlucky.com/" How can I know what inbound links Google considered as unnatural? thanks.
Link Building | | cardif0