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 new website / blogs can earn backlinks?
Hi, As link wheels, link pyramids and paid links are penalized by google and the only chance to get back links is to earn them. My Question is that with a new website / blog, how a newbie with no relationships with established bloggers, can earn links? Because writing quality contents and detailed posts (e.g. more than 3000 words posts twice a month) still would benefits for those blogs having already traffic to share these contents and in case of new blog, due to very low traffic, it would take months or years to enter in the game. Please propose step by step strategy / plan / footprint for newly born website and marketers. Thanks
Link Building | | Kashif-Amin0 -
Site scraped/Backlink problem?
Hi - I was looking in my Google webmaster tools because we saw a huge jump in backlinks last week. We found this one article with 84,475 total links, which obviously stands out as spam. All the links are from 1 page and 1 domain (financeai.com). This is the article on our website - http://loyalty360.org/resources/article/engaging-customer-atmosphere-at-pizza-patron and webmaster tools says all the links back to it come from this page http://financeai.com/forex/mxn/pkr/q/39665 My question is - should we/what can we do to clean this up? How does this impact our search ranking? We have had some issues with our website getting extremely slow overnight, and we believe the site scraping is really slowing down the site at points. Thanks.
Link Building | | carlystemmer1 -
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 -
The best way to spend 4 hours/day on offsite SEO?
I have an assistant who is able to do 4 hrs of SEO work for me every day. I don't have much onsite SEO work for him to do, and he's not skilled for social media management, so I'm thinking the best thing to have him do is manual link building. So far I've had him create a spreadsheet of more than 1,000 blogs and directories that relate to the subject matter of our websites, and had him include the domain authority of each and if they use the "nofollow" attribute on their links. Next I will have him start adding comments/submissions that include links back to our sites, starting with the highest DA sties and ones without the "nofollow" attributes. Do you agree this is the best way to have him spend his time? Are there other tasks you would highly recommend? Ryan
Link Building | | GreenHatWeb0 -
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 -
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 -
"gimme links" = easy to fill out profile/personal reputation links that offer a do-follow anchor text flexible link
I'm doing some SEO for small niche service sites...and aside from niche directories and some light article marketing and local search directories (yelp, etc) there really isn't a budget for content generation. I really only have a budget for profile/submission links. What are some sites where you can quite easily fill out a personal profile with an anchor text variable link that may not be THAT juicy but will stick (i.e. not a spam/fake profile type of link, but something like Linkedin). I'll start with giving away 1 www.istockphoto.com Any others that aren't obvious?
Link Building | | ilyaelbert0 -
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