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
-
Puzzled by high ranking page (#2 in SERPs) with zero/low page or domain authority
So, I get the smoothie that is page authority and domain authority and the link metrics that Moz uses to predict how well a page will rank for a certain keyword. I can look at a specific search term where we are on say, page 2 or 3, with a page authority of 1 and domain authority of 26, I get why competitors rank above us. But then I look at a keyword that is much more competitive, where we rank #2, which is awesome, where the landing page is also showing a page authority of 1, and domain authority of 26. How can we rank higher than competitors with a page authority of 56 and domain authority of 65? Their onpage optimization for the keyword is no worse, and sometimes better that ours but we maintain this ranking. By the way the competition also have hundreds if not thousands more linking root domains than our page. Any ideas why one keyword is a rockstar and one is a dud, with the same poor PA and DA?
Link Building | | seo-lab1 -
How can I tell if a site is trustworthy and is not / hasn't been penalized by Google?
Hello Moz Community, I'm looking to do some link building for a client and I would like to know if there's a way to find out if a website is trustworthy and is not or hasn't been penalised by Google. Thank you.
Link Building | | CosminC0 -
Can internal links cause Google to penalize me for key terms/phrases?
For example, having a link on many pages (so dozens of links in total) using a product name, all pointing to that product page. Could Google see that as "spammy" and penalize that product page in the SERP's? Note: My product page has been penalized for the search term "Product Name" and there are no external links pointing that page using the product name as a term. This is new with the latest Panda Updates.
Link Building | | absoauto0 -
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 -
Targeting City Geo-tags/Keywords for Clients with Multiple Locations
Hey everyone! What methods are best to use for SEO campaigns working with 1 website for a company which has 2, 3, 4, or more locations in order to get keywords for their services to rank well... in all their location cities? I feel we know the answer could be any one of the below notes, however, it's always nice to learn more about what all you other SEO's are doing or have done which saw success. Please note: We have heard about building microsites on sub-domains example city.domainname.com/keyword-or-service
Link Building | | WhiteboardCreations
We have heard about building sections off the root domain such as domainname.com/city/keyword-or-service
We have heard about just pushing more content to the blog which can target a wider range of keywords and cities
We have heard about building a new site for each city location replicating the main website and swapping out content for 100% originality
We have heard about just building more and more backlinks with different anchor text using the cities in the anchor text Thanks in advance and look forward to hearing from some other experts facing these same challenges!1 -
Linkbuilding to http/https
Hello, Last year we changed our domain name from http to https. In the .htaccess we included a 301 redirect from http to https. Nevertheless, some pages do not let you link to https, so for linkbuilding we sometimes need to use http://www.domain.ext in stead of https://www.domain.ext. Would this be a problem? I should expect with the 301 redirect that we don't have an issue here, but I would like to be sure. Although, I can make the site accessible without https too, but I don't think this is a good idea regarding duplicate content, is it? Thanks. Tom
Link Building | | Onlinq0 -
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 -
Backlinking / Link Building Services
Hello, Our site is struggling organically and one of the key factors (not surprisingly) is a lack of backlinks. We have hired a content writer and are working on a content strategy to generate quality, relevant backlinks. But this is more of a long term project. After reviewing backlinks to our competitors' sites, it seems clear that they are using agencies or services to generate backlinks (most coming from low quality sites). I'm aware that this isn't a good long term strategy (although it seems to be serving them well at the moment). I was hoping the community could provide some insight on products or services out there that provide "safe" backlinking strategies. I don't want to do anything that is going to harm us in the future. I've read a bit on the hoth, and it seems fairly safe and potentially effective, but it's hard find much objective advice on the topic. Any insight is much appreciated - thanks in advance! Jason
Link Building | | ba_seomoz0